public void UpdateDeliveryManArrearageLog(DeliveryManArrearageLogInfo oParam)
{
new DeliveryManArrearageLogDac().Update(oParam);
}
private void map(DeliveryManArrearageLogInfo oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.UserSysNo = Util.TrimIntNull(tempdr["UserSysNo"]);
oParam.DSSysNo = Util.TrimIntNull(tempdr["DSSysNo"]);
oParam.Arrearage = Util.TrimDecimalNull(tempdr["Arrearage"]);
oParam.ArrearageLogType = Util.TrimIntNull(tempdr["ArrearageLogType"]);
oParam.ArrearageChange = Util.TrimDecimalNull(tempdr["ArrearageChange"]);
oParam.Memo = Util.TrimNull(tempdr["Memo"]);
oParam.CreateTime = Util.TrimDateNull(tempdr["CreateTime"]);
oParam.CreateUserSysNo = Util.TrimIntNull(tempdr["CreateUserSysNo"]);
}
public DeliveryManArrearageLogInfo LoadDMALog(int SysNo)
{
string sql = "select * from DeliveryMan_ArrearageLog where sysno=" + SysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
DeliveryManArrearageLogInfo oInfo = new DeliveryManArrearageLogInfo();
if (Util.HasMoreRow(ds))
map(oInfo, ds.Tables[0].Rows[0]);
else
oInfo = null;
return oInfo;
}
public void InsertDeliveryManArrearageLog(DeliveryManArrearageLogInfo oParam)
{
new DeliveryManArrearageLogDac().Insert(oParam);
}
public int Update(DeliveryManArrearageLogInfo oParam)
{
string sql = @"UPDATE DeliveryMan_ArrearageLog SET
UserSysNo=@UserSysNo, DSSysNo=@DSSysNo,
Arrearage=@Arrearage, ArrearageLogType=@ArrearageLogType,
ArrearageChange=@ArrearageChange, Memo=@Memo,
CreateTime=@CreateTime, CreateUserSysNo=@CreateUserSysNo
WHERE SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramUserSysNo = new SqlParameter("@UserSysNo", SqlDbType.Int, 4);
SqlParameter paramDSSysNo = new SqlParameter("@DSSysNo", SqlDbType.Int, 4);
SqlParameter paramArrearage = new SqlParameter("@Arrearage", SqlDbType.Decimal, 9);
SqlParameter paramArrearageLogType = new SqlParameter("@ArrearageLogType", SqlDbType.Int, 4);
SqlParameter paramArrearageChange = new SqlParameter("@ArrearageChange", SqlDbType.Decimal, 9);
SqlParameter paramMemo = new SqlParameter("@Memo", SqlDbType.NVarChar, 300);
SqlParameter paramCreateTime = new SqlParameter("@CreateTime", SqlDbType.DateTime);
SqlParameter paramCreateUserSysNo = new SqlParameter("@CreateUserSysNo", SqlDbType.Int, 4);
if (oParam.SysNo != AppConst.IntNull)
paramSysNo.Value = oParam.SysNo;
else
paramSysNo.Value = System.DBNull.Value;
if (oParam.UserSysNo != AppConst.IntNull)
paramUserSysNo.Value = oParam.UserSysNo;
else
paramUserSysNo.Value = System.DBNull.Value;
if (oParam.DSSysNo != AppConst.IntNull)
paramDSSysNo.Value = oParam.DSSysNo;
else
paramDSSysNo.Value = System.DBNull.Value;
if (oParam.Arrearage != AppConst.DecimalNull)
paramArrearage.Value = oParam.Arrearage;
else
paramArrearage.Value = System.DBNull.Value;
if (oParam.ArrearageLogType != AppConst.IntNull)
paramArrearageLogType.Value = oParam.ArrearageLogType;
else
paramArrearageLogType.Value = System.DBNull.Value;
if (oParam.ArrearageChange != AppConst.DecimalNull)
paramArrearageChange.Value = oParam.ArrearageChange;
else
paramArrearageChange.Value = System.DBNull.Value;
if (oParam.Memo != AppConst.StringNull)
paramMemo.Value = oParam.Memo;
else
paramMemo.Value = System.DBNull.Value;
if (oParam.CreateTime != AppConst.DateTimeNull)
paramCreateTime.Value = oParam.CreateTime;
else
paramCreateTime.Value = System.DBNull.Value;
if (oParam.CreateUserSysNo != AppConst.IntNull)
paramCreateUserSysNo.Value = oParam.CreateUserSysNo;
else
paramCreateUserSysNo.Value = System.DBNull.Value;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramUserSysNo);
cmd.Parameters.Add(paramDSSysNo);
cmd.Parameters.Add(paramArrearage);
cmd.Parameters.Add(paramArrearageLogType);
cmd.Parameters.Add(paramArrearageChange);
cmd.Parameters.Add(paramMemo);
cmd.Parameters.Add(paramCreateTime);
cmd.Parameters.Add(paramCreateUserSysNo);
return SqlHelper.ExecuteNonQuery(cmd);
}
public int Insert(DeliveryManArrearageLogInfo oParam)
{
string sql = @"INSERT INTO DeliveryMan_ArrearageLog
(
UserSysNo, DSSysNo, Arrearage, ArrearageLogType,
ArrearageChange, Memo, CreateTime, CreateUserSysNo
)
VALUES (
@UserSysNo, @DSSysNo, @Arrearage, @ArrearageLogType,
@ArrearageChange, @Memo, @CreateTime, @CreateUserSysNo
);set @SysNo = SCOPE_IDENTITY();";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramUserSysNo = new SqlParameter("@UserSysNo", SqlDbType.Int, 4);
SqlParameter paramDSSysNo = new SqlParameter("@DSSysNo", SqlDbType.Int, 4);
SqlParameter paramArrearage = new SqlParameter("@Arrearage", SqlDbType.Decimal, 9);
SqlParameter paramArrearageLogType = new SqlParameter("@ArrearageLogType", SqlDbType.Int, 4);
SqlParameter paramArrearageChange = new SqlParameter("@ArrearageChange", SqlDbType.Decimal, 9);
SqlParameter paramMemo = new SqlParameter("@Memo", SqlDbType.NVarChar, 300);
SqlParameter paramCreateTime = new SqlParameter("@CreateTime", SqlDbType.DateTime);
SqlParameter paramCreateUserSysNo = new SqlParameter("@CreateUserSysNo", SqlDbType.Int, 4);
paramSysNo.Direction = ParameterDirection.Output;
if (oParam.UserSysNo != AppConst.IntNull)
paramUserSysNo.Value = oParam.UserSysNo;
else
paramUserSysNo.Value = System.DBNull.Value;
if (oParam.DSSysNo != AppConst.IntNull)
paramDSSysNo.Value = oParam.DSSysNo;
else
paramDSSysNo.Value = System.DBNull.Value;
if (oParam.Arrearage != AppConst.DecimalNull)
paramArrearage.Value = oParam.Arrearage;
else
paramArrearage.Value = System.DBNull.Value;
if (oParam.ArrearageLogType != AppConst.IntNull)
paramArrearageLogType.Value = oParam.ArrearageLogType;
else
paramArrearageLogType.Value = System.DBNull.Value;
if (oParam.ArrearageChange != AppConst.DecimalNull)
paramArrearageChange.Value = oParam.ArrearageChange;
else
paramArrearageChange.Value = System.DBNull.Value;
if (oParam.Memo != AppConst.StringNull)
paramMemo.Value = oParam.Memo;
else
paramMemo.Value = System.DBNull.Value;
if (oParam.CreateTime != AppConst.DateTimeNull)
paramCreateTime.Value = oParam.CreateTime;
else
paramCreateTime.Value = System.DBNull.Value;
if (oParam.CreateUserSysNo != AppConst.IntNull)
paramCreateUserSysNo.Value = oParam.CreateUserSysNo;
else
paramCreateUserSysNo.Value = System.DBNull.Value;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramUserSysNo);
cmd.Parameters.Add(paramDSSysNo);
cmd.Parameters.Add(paramArrearage);
cmd.Parameters.Add(paramArrearageLogType);
cmd.Parameters.Add(paramArrearageChange);
cmd.Parameters.Add(paramMemo);
cmd.Parameters.Add(paramCreateTime);
cmd.Parameters.Add(paramCreateUserSysNo);
return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo);
}
/// <summary>
/// ��˽��㵥
/// </summary>
/// <param name="oDSInfo"></param>
public void AuditDS(DSInfo oDSInfo)
{
try
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
string sql = "select * from DS_Item where DSSysNo=" + oDSInfo.SysNo + " and IsPos=" + (int)AppEnum.YNStatus.Yes + " and (PosNo is null or PosDate is null)";
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (Util.HasMoreRow(ds))
throw new BizException("ˢ���ն˺ż�ˢ������û����д������");
UpdateDSMaster(oDSInfo);
decimal Remittance = 0;
decimal PosGoods = 0;
decimal Cheque = 0;
decimal PosGoodsCash = 0;
if (oDSInfo.Remittance != AppConst.DecimalNull)
Remittance = oDSInfo.Remittance;
if (oDSInfo.PosGoods != AppConst.DecimalNull)
PosGoods = oDSInfo.PosGoods;
if (oDSInfo.Cheque != AppConst.DecimalNull)
Cheque = oDSInfo.Cheque;
if (oDSInfo.PosGoodsCash != AppConst.DecimalNull)
PosGoodsCash = oDSInfo.PosGoodsCash;
decimal Arrearage = Remittance + PosGoods - PosGoodsCash + Cheque - oDSInfo.ARAmt;
if (Arrearage != 0)
{
DeliveryManArrearageLogInfo oDMArrearageLog = new DeliveryManArrearageLogInfo();
oDMArrearageLog.UserSysNo = oDSInfo.FreightUserSysNo;
oDMArrearageLog.DSSysNo = oDSInfo.SysNo;
oDMArrearageLog.Arrearage = Arrearage;
oDMArrearageLog.ArrearageChange = Arrearage;
oDMArrearageLog.CreateTime = DateTime.Now;
oDMArrearageLog.CreateUserSysNo = oDSInfo.AuditUserSysNo;
if (Arrearage < 0)
oDMArrearageLog.ArrearageLogType = (int)AppEnum.DeliveryManArrearageLogType.PayMentOfGoodsLack;
else if (Arrearage > 0)
oDMArrearageLog.ArrearageLogType = (int)AppEnum.DeliveryManArrearageLogType.PayMentofGoodsExcessive;
DeliveryManager.GetInstance().InsertDeliveryManArrearageLog(oDMArrearageLog);
}
scope.Complete();
}
}
catch (Exception ex)
{
throw ex;
}
}