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