/// <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)); }