asp.net 读取文本文件并插入数据库的实现代码

答案：由此，需要操作以下几个步骤 
1，上传txt文件至公司系统 
2，读取需要的内容 
3，将内容插入到数据库中（需要判断重复） 
4，与现有订单数据进行对比 
本程序只研究读取需要的内容和插入数据库 
复制代码 代码如下:
 
using System; 
using System.Data; 
using System.Collections.Generic; 
using System.Web; 
using System.Web.UI; 
using System.Web.UI.WebControls; 
using System.IO; 
using System.Text; 
using System.Text.RegularExpressions; 
using service.DAL; 
using System.Reflection; 
namespace service.fin 
{ 
[Serializable] 
public class SettlementCmbModel 
{ 
public SettlementCmbModel() { } 
#region Model 
private int _id; 
private string _terminalno; 
private DateTime? _tradetime; 
private string _batchno; 
private string _channel; 
private string _empowerno; 
private string _orderno; 
private string _cardno; 
private string _cardmark; 
private string _tradetype; 
private string _businesstype; 
private string _goodsno; 
private string _stages; 
private decimal? _tradeamount; 
private decimal? _commissionamount; 
private decimal? _returnfee; 
private decimal? _memberspoint1; 
private decimal? _memberspoint2; 
private decimal? _mpcmbpercent; 
private decimal? _mpvalue; 
private decimal? _realamount; 
/// <summary> 
/// 
/// </summary> 
public int Id 
{ 
set { _id = value; } 
get { return _id; } 
} 
/// <summary> 
/// 
/// </summary> 
public string TerminalNo 
{ 
set { _terminalno = value; } 
get { return _terminalno; } 
} 
/// <summary> 
/// 
/// </summary> 
public DateTime? TradeTime 
{ 
set { _tradetime = value; } 
get { return _tradetime; } 
} 
/// <summary> 
/// 
/// </summary> 
public string BatchNo 
{ 
set { _batchno = value; } 
get { return _batchno; } 
} 
/// <summary> 
/// 
/// </summary> 
public string Channel 
{ 
set { _channel = value; } 
get { return _channel; } 
} 
/// <summary> 
/// 
/// </summary> 
public string EmpowerNo 
{ 
set { _empowerno = value; } 
get { return _empowerno; } 
} 
/// <summary> 
/// 
/// </summary> 
public string OrderNo 
{ 
set { _orderno = value; } 
get { return _orderno; } 
} 
/// <summary> 
/// 
/// </summary> 
public string CardNo 
{ 
set { _cardno = value; } 
get { return _cardno; } 
} 
/// <summary> 
/// 
/// </summary> 
public string CardMark 
{ 
set { _cardmark = value; } 
get { return _cardmark; } 
} 
/// <summary> 
/// 
/// </summary> 
public string TradeType 
{ 
set { _tradetype = value; } 
get { return _tradetype; } 
} 
/// <summary> 
/// 
/// </summary> 
public string BusinessType 
{ 
set { _businesstype = value; } 
get { return _businesstype; } 
} 
/// <summary> 
/// 
/// </summary> 
public string GoodsNo 
{ 
set { _goodsno = value; } 
get { return _goodsno; } 
} 
/// <summary> 
/// 
/// </summary> 
public string Stages 
{ 
set { _stages = value; } 
get { return _stages; } 
} 
/// <summary> 
/// 
/// </summary> 
public decimal? TradeAmount 
{ 
set { _tradeamount = value; } 
get { return _tradeamount; } 
} 
/// <summary> 
/// 
/// </summary> 
public decimal? CommissionAmount 
{ 
set { _commissionamount = value; } 
get { return _commissionamount; } 
} 
/// <summary> 
/// 
/// </summary> 
public decimal? ReturnFee 
{ 
set { _returnfee = value; } 
get { return _returnfee; } 
} 
/// <summary> 
/// 
/// </summary> 
public decimal? MembersPoint1 
{ 
set { _memberspoint1 = value; } 
get { return _memberspoint1; } 
} 
/// <summary> 
/// 
/// </summary> 
public decimal? MembersPoint2 
{ 
set { _memberspoint2 = value; } 
get { return _memberspoint2; } 
} 
/// <summary> 
/// 
/// </summary> 
public decimal? MPCmbPercent 
{ 
set { _mpcmbpercent = value; } 
get { return _mpcmbpercent; } 
} 
/// <summary> 
/// 
/// </summary> 
public decimal? MPValue 
{ 
set { _mpvalue = value; } 
get { return _mpvalue; } 
} 
/// <summary> 
/// 
/// </summary> 
public decimal? RealAmount 
{ 
set { _realamount = value; } 
get { return _realamount; } 
} 
#endregion Model 
} 
public class SettlementCmbDal 
{ 
public SettlementCmbDal() { } 
#region 增加数据 
public static int Add(SettlementCmbModel model) 
{ 
StringBuilder strSql = new StringBuilder(); 
StringBuilder strSql1 = new StringBuilder(); 
StringBuilder strSql2 = new StringBuilder(); 
if (model.TerminalNo != null) 
{ 
strSql1.Append("TerminalNo,"); 
strSql2.Append("'" + model.TerminalNo + "',"); 
} 
if (model.TradeTime != null) 
{ 
strSql1.Append("TradeTime,"); 
strSql2.Append("'" + model.TradeTime + "',"); 
} 
if (model.BatchNo != null) 
{ 
strSql1.Append("BatchNo,"); 
strSql2.Append("'" + model.BatchNo + "',"); 
} 
if (model.Channel != null) 
{ 
strSql1.Append("Channel,"); 
strSql2.Append("'" + model.Channel + "',"); 
} 
if (model.EmpowerNo != null) 
{ 
strSql1.Append("EmpowerNo,"); 
strSql2.Append("'" + model.EmpowerNo + "',"); 
} 
if (model.OrderNo != null) 
{ 
strSql1.Append("OrderNo,"); 
strSql2.Append("'" + model.OrderNo + "',"); 
} 
if (model.CardNo != null) 
{ 
strSql1.Append("CardNo,"); 
strSql2.Append("'" + model.CardNo + "',"); 
} 
if (model.CardMark != null) 
{ 
strSql1.Append("CardMark,"); 
strSql2.Append("'" + model.CardMark + "',"); 
} 
if (model.TradeType != null) 
{ 
strSql1.Append("TradeType,"); 
strSql2.Append("'" + model.TradeType + "',"); 
} 
if (model.BusinessType != null) 
{ 
strSql1.Append("BusinessType,"); 
strSql2.Append("'" + model.BusinessType + "',"); 
} 
if (model.GoodsNo != null) 
{ 
strSql1.Append("GoodsNo,"); 
strSql2.Append("'" + model.GoodsNo + "',"); 
} 
if (model.Stages != null) 
{ 
strSql1.Append("Stages,"); 
strSql2.Append("'" + model.Stages + "',"); 
} 
if (model.TradeAmount != null) 
{ 
strSql1.Append("TradeAmount,"); 
strSql2.Append("" + model.TradeAmount + ","); 
} 
if (model.CommissionAmount != null) 
{ 
strSql1.Append("CommissionAmount,"); 
strSql2.Append("" + model.CommissionAmount + ","); 
} 
if (model.ReturnFee != null) 
{ 
strSql1.Append("ReturnFee,"); 
strSql2.Append("" + model.ReturnFee + ","); 
} 
if (model.MembersPoint1 != null) 
{ 
strSql1.Append("MembersPoint1,"); 
strSql2.Append("" + model.MembersPoint1 + ","); 
} 
if (model.MembersPoint2 != null) 
{ 
strSql1.Append("MembersPoint2,"); 
strSql2.Append("" + model.MembersPoint2 + ","); 
} 
if (model.MPCmbPercent != null) 
{ 
strSql1.Append("MPCmbPercent,"); 
strSql2.Append("" + model.MPCmbPercent + ","); 
} 
if (model.MPValue != null) 
{ 
strSql1.Append("MPValue,"); 
strSql2.Append("" + model.MPValue + ","); 
} 
if (model.RealAmount != null) 
{ 
strSql1.Append("RealAmount,"); 
strSql2.Append("" + model.RealAmount + ","); 
} 
strSql.Append("insert into CRM_Settlement_CMB("); 
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1)); 
strSql.Append(")"); 
strSql.Append(" values ("); 
strSql.Append(strSql2.ToString().Remove(strSql2.Leng

上一个：.Net平台开发实践的一些点滴总结(技术规范与实践精华)第1/2页
下一个：微软 Visual Studio 2010官方下载地址给大家