/// <summary>
/// 插入数据导入日志
/// </summary>
public int InsertReceiveLog(BllReceiveLogTable receiveLogTable)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Bll_Import_Log(");
strSql.Append("AUTO_MODE,SOURCE_FILE,SUCCESS_NUMBER,FAILURE_NUMBER,BACK_FILE,ERROR_FILE,STATUS_FLAG,CREATE_DATE,CREATE_USER_ID,LAST_UPDATE_DATE,LAST_UPDATE_USER_ID)");
strSql.Append(" values (");
strSql.Append("@AUTO_MODE,@SOURCE_FILE,@SUCCESS_NUMBER,@FAILURE_NUMBER,@BACK_FILE,@ERROR_FILE,@STATUS_FLAG,getdate(),@CREATE_USER_ID,getdate(),@LAST_UPDATE_USER_ID)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@AUTO_MODE", SqlDbType.Bit, 1),
new SqlParameter("@SOURCE_FILE", SqlDbType.NVarChar, 255),
new SqlParameter("@SUCCESS_NUMBER", SqlDbType.Int, 4),
new SqlParameter("@FAILURE_NUMBER", SqlDbType.Int, 4),
new SqlParameter("@BACK_FILE", SqlDbType.NVarChar, 255),
new SqlParameter("@ERROR_FILE", SqlDbType.NVarChar, 255),
new SqlParameter("@STATUS_FLAG", SqlDbType.Int, 4),
new SqlParameter("@CREATE_USER_ID", SqlDbType.Decimal, 9),
new SqlParameter("@LAST_UPDATE_USER_ID", SqlDbType.Decimal, 9)
};
parameters[0].Value = receiveLogTable.AUTO_MODE;
parameters[1].Value = receiveLogTable.SOURCE_FILE;
parameters[2].Value = receiveLogTable.SUCCESS_NUMBER;
parameters[3].Value = receiveLogTable.FAILURE_NUMBER;
parameters[4].Value = receiveLogTable.BACK_FILE;
parameters[5].Value = receiveLogTable.ERROR_FILE;
parameters[6].Value = receiveLogTable.STATUS_FLAG;
parameters[7].Value = receiveLogTable.CREATE_USER_ID;
parameters[8].Value = receiveLogTable.LAST_UPDATE_USER_ID;
int rInt = DbHelperSQL.ExecuteSqlScalar(strSql.ToString(), parameters);
return(rInt);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public string[] DoReceiveJob()
{
//读取CSV文件，并保存到DATATABLE
ReadCsv();
//内容check`
doCheckError();
//DB更新
string[] importInfo = doUpdateDB();
try
{
BllReceiveLogTable receiveLogTable = new BllReceiveLogTable();
receiveLogTable.AUTO_MODE = this._autoMode;
receiveLogTable.SOURCE_FILE = this._fileName;
receiveLogTable.SUCCESS_NUMBER = int.Parse(importInfo[0]);
receiveLogTable.FAILURE_NUMBER = int.Parse(importInfo[1]);
receiveLogTable.ERROR_FILE = importInfo[2];
receiveLogTable.BACK_FILE = importInfo[3];
if (receiveLogTable.ERROR_FILE == "")
{
receiveLogTable.STATUS_FLAG = CConstant.INIT_STATUS;
}
//new BCommon().InsertReceiveLog(receiveLogTable);
}
catch (Exception ex) { }
return(importInfo);
}
/// <summary>
/// 插入数据导入日志
/// </summary>
public int InsertReceiveLog(BllReceiveLogTable receiveLogTable)
{
return(dal.InsertReceiveLog(receiveLogTable));
}
