/// <summary>
/// 修改商品采购设置变更信息
/// </summary>
/// <param name="info"></param>
public void UpdatePurchaseSetLog(PurchaseSetLogInfo info)
{
SqlParameter[] parms = GetPurchaseSetLogParameters();
parms[0].Value = info.LogId;
parms[1].Value = info.GoodsId;
parms[2].Value = info.GoodsName;
parms[3].Value = info.WarehouseId;
parms[4].Value = Convert.ToDouble(info.OldValue);
parms[5].Value = Convert.ToDouble(info.ChangeValue);
parms[6].Value = Convert.ToDouble(info.NewValue);
parms[7].Value = info.ChangeReason;
parms[8].Value = info.ChangeDate;
parms[9].Value = info.Applicant;
parms[10].Value = info.Auditor;
parms[11].Value = info.Statue;
parms[12].Value = info.LogType;
try
{
SqlHelper.ExecuteNonQuery(GlobalConfig.ERP_DB_NAME, false, SQL_UPDATE_PURCHASESETLOG, parms);
}
catch (Exception ex)
{
throw new ApplicationException(ex.Message);
}
}
/// <summary>
/// 获取商品采购设置变更信息
/// </summary>
/// <param name="logId">日志ID</param>
/// <returns></returns>
public PurchaseSetLogInfo GetPurchaseSetLogInfo(Guid logId)
{
const string SQL = SQL_SELECT_PURCHASESETLOG + " WHERE LogId=@LogId";
var parm = new SqlParameter(PARM_LOGID, SqlDbType.UniqueIdentifier)
{
Value = logId
};
var info = new PurchaseSetLogInfo();
using (var dr = SqlHelper.ExecuteReader(GlobalConfig.ERP_DB_NAME, true, SQL, parm))
{
if (dr.Read())
{
info = ReaderPurchaseSetLog(dr);
}
}
return(info);
}
private PurchaseSetLogInfo ReaderPurchaseSetLog(IDataReader dr)
{
var info = new PurchaseSetLogInfo
{
LogId = dr["LogId"] == DBNull.Value ? Guid.Empty : new Guid(dr["LogId"].ToString()),
GoodsId = dr["GoodsId"] == DBNull.Value ? Guid.Empty : new Guid(dr["GoodsId"].ToString()),
GoodsName = dr["GoodsName"] == DBNull.Value ? string.Empty : dr["GoodsName"].ToString(),
WarehouseId = dr["WarehouseId"] == DBNull.Value ? Guid.Empty : new Guid(dr["WarehouseId"].ToString()),
OldValue = dr["OldValue"] == DBNull.Value ? 0 : decimal.Parse(dr["OldValue"].ToString()),
ChangeValue = dr["ChangeValue"] == DBNull.Value ? 0 : decimal.Parse(dr["ChangeValue"].ToString()),
NewValue = dr["NewValue"] == DBNull.Value ? 0 : decimal.Parse(dr["NewValue"].ToString()),
ChangeReason = dr["ChangeReason"] == DBNull.Value ? string.Empty : dr["ChangeReason"].ToString(),
ChangeDate = dr["ChangeDate"] == DBNull.Value ? DateTime.MinValue : DateTime.Parse(dr["ChangeDate"].ToString()),
Applicant = dr["Applicant"] == DBNull.Value ? Guid.Empty : new Guid(dr["Applicant"].ToString()),
Auditor = dr["Auditor"] == DBNull.Value ? Guid.Empty : new Guid(dr["Auditor"].ToString()),
Statue = dr["Statue"] == DBNull.Value ? 0 : int.Parse(dr["Statue"].ToString()),
LogType = dr["LogType"] == DBNull.Value ? 0 : int.Parse(dr["LogType"].ToString()),
HostingFilialeId = dr["HostingFilialeId"] == DBNull.Value ? Guid.Empty : new Guid(dr["HostingFilialeId"].ToString()),
};
return(info);
}
