public HandlingResult Import(DataTable source)
{
//机器SN号 交易时间 交易流水号 交易来源 实付金额 应付金额 手续费 状态 银行流水单
HandlingResult result = new HandlingResult();
SchemaAction action = new SchemaAction();
DataTable dt = action.GetSchema("BUSINESS_TRANSFLOWCP");
Guid id = Guid.NewGuid();
DateTime t = DateTime.Now;
foreach (DataRow sdr in source.Rows)
{
try
{
DataRow dr = dt.NewRow();
dr["ID"] = Guid.NewGuid();
dr["SN"] = sdr["机器SN号"];
dr["RunningNo"] = sdr["交易流水号"];
dr["ExcTime"] = sdr["交易时间"];
dr["ExcSource"] = Encoding.UTF8.GetString(Encoding.UTF8.GetBytes(sdr["交易来源"].ToString()));
dr["NetPay"] = sdr["实付金额"];
dr["Payable"] = sdr["应付金额"];
dr["Handling"] = sdr["手续费"];
dr["Statue"] = sdr["状态"];
dr["BankRunningNo"] = sdr["银行流水单"];
dr["BID"] = id;
dr["Creator"] = UserInformationContext.LoginName;
dr["CreatorID"] = UserInformationContext.ID;
dr["CreatedTime"] = t;
dt.Rows.Add(dr);
}
catch (Exception ex)
{
continue;
}
}
String sql = "SELECT * FROM BUSINESS_TRANSFLOWCP WHERE 1=2";
String insertsql = String.Format(
"INSERT INTO BUSINESS_TRANSFLOW " +
"SELECT C.ID,C.SN,C.RUNNINGNO,C.EXCTIME,C.EXCSOURCE,C.NETPAY,C.PAYABLE,C.HANDLING, " +
"C.STATUE,C.BANKRUNNINGNO,C.CREATOR, C.CREATORID, C.CREATEDTIME " +
"FROM BUSINESS_TRANSFLOWCP C LEFT OUTER JOIN BUSINESS_TRANSFLOW S ON C.RUNNINGNO = S.RUNNINGNO " +
"WHERE C.BID='{0}' AND S.RUNNINGNO IS NULL", id);
String delsql = String.Format("delete from business_transflowcp where bid='{0}'", id);
using (DataBaseProcess process =new DataBaseProcess())
{
try
{
Boolean upresult = process.Update(dt, sql);
if (upresult)
{
process.Exec(insertsql);
process.Exec(delsql);
result.Message = "导入成功";
}
}
catch (Exception ex)
{
result.Successed = false;
result.Message = "数据存储异常";
}
}
return result;
}
public HandlingResult Import(DataTable source)
{
//机器SN号 交易时间 交易流水号 交易来源 实付金额 应付金额 手续费 状态 银行流水单
HandlingResult result = new HandlingResult();
SchemaAction action = new SchemaAction();
DataTable dt = action.GetSchema("BUSINESS_TRANSFLOWCP");
Guid id = Guid.NewGuid();
DateTime t = DateTime.Now;
foreach (DataRow sdr in source.Rows)
{
try
{
DataRow dr = dt.NewRow();
dr["ID"] = Guid.NewGuid();
dr["SN"] = sdr["机器SN号"];
dr["RunningNo"] = sdr["交易流水号"];
dr["ExcTime"] = sdr["交易时间"];
dr["ExcSource"] = Encoding.UTF8.GetString(Encoding.UTF8.GetBytes(sdr["交易来源"].ToString()));
dr["NetPay"] = sdr["实付金额"];
dr["Payable"] = sdr["应付金额"];
dr["Handling"] = sdr["手续费"];
dr["Statue"] = sdr["状态"];
dr["BankRunningNo"] = sdr["银行流水单"];
dr["BID"] = id;
dr["Creator"] = UserInformationContext.LoginName;
dr["CreatorID"] = UserInformationContext.ID;
dr["CreatedTime"] = t;
dt.Rows.Add(dr);
}
catch (Exception ex)
{
continue;
}
}
String sql = "SELECT * FROM BUSINESS_TRANSFLOWCP WHERE 1=2";
String insertsql = String.Format(
"INSERT INTO BUSINESS_TRANSFLOW " +
"SELECT C.ID,C.SN,C.RUNNINGNO,C.EXCTIME,C.EXCSOURCE,C.NETPAY,C.PAYABLE,C.HANDLING, " +
"C.STATUE,C.BANKRUNNINGNO,C.CREATOR, C.CREATORID, C.CREATEDTIME " +
"FROM BUSINESS_TRANSFLOWCP C LEFT OUTER JOIN BUSINESS_TRANSFLOW S ON C.RUNNINGNO = S.RUNNINGNO " +
"WHERE C.BID='{0}' AND S.RUNNINGNO IS NULL", id);
String delsql = String.Format("delete from business_transflowcp where bid='{0}'", id);
using (DataBaseProcess process = new DataBaseProcess())
{
try
{
Boolean upresult = process.Update(dt, sql);
if (upresult)
{
process.Exec(insertsql);
process.Exec(delsql);
result.Message = "导入成功";
}
}
catch (Exception ex)
{
result.Successed = false;
result.Message = "数据存储异常";
}
}
return(result);
}