public CheckDataRecordInfo GetCheckDataInfoById(Guid id) { var recordInfo = new CheckDataRecordInfo(); using (var dr = SqlHelper.ExecuteReader(GlobalConfig.ERP_DB_NAME, true, SQL_SELECT_CHECKDATAINFO, new SqlParameter(PARM_CHECKID, id))) { if (dr != null) { while (dr.Read()) { recordInfo = new CheckDataRecordInfo { CheckId = dr.GetGuid(0), OriginalFilePath = dr.GetString(1), CheckType = dr.GetInt32(2), CheckDataState = dr.GetInt32(3), CheckCompanyId = dr.GetGuid(4), CompanyName = dr.GetString(5), CheckCreateDate = dr.GetDateTime(6), CheckFilialeId = dr.GetGuid(7), CheckPersonnelId = dr.GetGuid(8), CheckUser = dr.GetString(9), ContrastFilePath = dr[10] == DBNull.Value ? string.Empty : dr.GetString(10), ConfirmFilePath = dr[11] == DBNull.Value ? string.Empty : dr.GetString(11), FinishFilePath = dr[12] == DBNull.Value ? string.Empty : dr.GetString(12), CheckDescription = dr[13] == DBNull.Value ? string.Empty : dr.GetString(13) }; } } } return(recordInfo); }
public void InsertData(CheckDataRecordInfo dataInfo) { SqlParameter[] parms = GetCheckDataRecordParameters(); parms[0].Value = dataInfo.CheckId; parms[1].Value = dataInfo.OriginalFilePath; parms[2].Value = dataInfo.CheckType; parms[3].Value = dataInfo.CheckDataState; parms[4].Value = dataInfo.CheckCompanyId; parms[5].Value = dataInfo.CheckCreateDate; parms[6].Value = dataInfo.CheckFilialeId; parms[7].Value = dataInfo.CheckPersonnelId; parms[8].Value = dataInfo.CheckUser; parms[9].Value = string.IsNullOrEmpty(dataInfo.ContrastFilePath) ? string.Empty : dataInfo.ContrastFilePath; parms[10].Value = string.IsNullOrEmpty(dataInfo.ConfirmFilePath) ? string.Empty : dataInfo.ConfirmFilePath; parms[11].Value = string.IsNullOrEmpty(dataInfo.FinishFilePath) ? string.Empty : dataInfo.FinishFilePath; parms[12].Value = dataInfo.CheckDescription; try { SqlHelper.ExecuteNonQuery(GlobalConfig.ERP_DB_NAME, false, SQL_INSERT, parms); } catch (Exception ex) { throw new ApplicationException("对账记录插入失败!", ex); } }
/// <summary>获取对比数据 2015-04-03 陈重文 /// </summary> /// <param name="recordInfo"></param> /// <param name="startTime"></param> /// <param name="endTime"></param> /// <param name="checkType">对账状态</param> /// <returns></returns> public IList <CheckDataDetailInfo> GetContrastDataList(CheckDataRecordInfo recordInfo, DateTime startTime, DateTime endTime, CheckType checkType) { var list = new List <CheckDataDetailInfo>(); var builder = new StringBuilder(SQL_GETCONTRASTDATALIST); var sqlparams = new[] { new SqlParameter("@CompanyId", recordInfo.CheckCompanyId), new SqlParameter("@StartTime", startTime), new SqlParameter("@EndTime", endTime), new SqlParameter("@IsChecked", (int)checkType), new SqlParameter("@ReckoningCheckType", recordInfo.CheckType), new SqlParameter("@CheckId", recordInfo.CheckId) }; using (var dr = SqlHelper.ExecuteReader(GlobalConfig.ERP_DB_NAME, true, builder.ToString(), sqlparams)) { if (dr == null) { return(list); } while (dr.Read()) { var errmsg = String.Empty; if (dr["ServerMoney"] == DBNull.Value && dr["ServerWeight"] == DBNull.Value) { errmsg = "未找到往来帐记录!"; } list.Add(new CheckDataDetailInfo { CheckId = recordInfo.CheckId, ExpressNo = dr["ExpressNo"] == DBNull.Value ? String.Empty : dr["ExpressNo"].ToString(), PostMoney = dr["PostMoney"] == DBNull.Value ? 0 : Convert.ToDecimal(dr["PostMoney"]), PostWeight = dr["PostWeight"] == DBNull.Value ? 0 : Convert.ToDouble(dr["PostWeight"]), ServerMoney = dr["ServerMoney"] == DBNull.Value ? 0 : Convert.ToDecimal(dr["ServerMoney"]), ServerWeight = dr["ServerWeight"] == DBNull.Value ? 0 : Convert.ToDouble(dr["ServerWeight"]), DiffMoney = dr["DiffMoney"] == DBNull.Value ? 0 : Convert.ToDecimal(dr["DiffMoney"]), DataState = (int)DataState.Contrasted, SystemConfirmMoney = dr["ServerMoney"] == DBNull.Value ? 0 : Convert.ToDecimal(dr["ServerMoney"]), FinanceConfirmMoney = dr["PostMoney"] == DBNull.Value ? 0 : Convert.ToDecimal(dr["PostMoney"]), ExceptionMessage = String.Empty, ErrorMessage = errmsg, ProvinceName = dr["Province"] == DBNull.Value ? String.Empty : dr["Province"].ToString(), CityName = dr["City"] == DBNull.Value ? String.Empty : dr["City"].ToString(), }); } } return(list); }
public void UpdateResult(CheckDataRecordInfo dataInfo) { var parms = new[] { new SqlParameter(PARM_CHECKDATASTATE, dataInfo.CheckDataState), new SqlParameter(PARM_CONTRASTFILEPATH, string.IsNullOrEmpty(dataInfo.ContrastFilePath)?string.Empty:dataInfo.ContrastFilePath), new SqlParameter(PARM_CONFIRMFILEPATH, string.IsNullOrEmpty(dataInfo.ConfirmFilePath)?string.Empty:dataInfo.ConfirmFilePath), new SqlParameter(PARM_FINISHFILEPATH, string.IsNullOrEmpty(dataInfo.FinishFilePath)?string.Empty:dataInfo.FinishFilePath), new SqlParameter(PARM_CHECKDESCRIPTION, dataInfo.CheckDescription), new SqlParameter(PARM_CHECKID, dataInfo.CheckId) }; try { SqlHelper.ExecuteNonQuery(GlobalConfig.ERP_DB_NAME, false, SQL_UPDATE_RESULT, parms); } catch (Exception ex) { throw new ApplicationException("更新对账记录相关文件路径失败!", ex); } }
public void UpdateResult(CheckDataRecordInfo dataInfo) { _checkDataRecordDao.UpdateResult(dataInfo); }
public void InsertData(CheckDataRecordInfo dataInfo) { _checkDataRecordDao.InsertData(dataInfo); }
/// <summary>获取对比数据 2015-04-03 陈重文 /// </summary> /// <param name="recordInfo"></param> /// <param name="startTime"></param> /// <param name="endTime"></param> /// <param name="checkType">对账状态</param> /// <returns></returns> public IList <CheckDataDetailInfo> GetContrastDataList(CheckDataRecordInfo recordInfo, DateTime startTime, DateTime endTime, CheckType checkType) { return(_checkDataRecordDao.GetContrastDataList(recordInfo, startTime, endTime, checkType)); }