/// <summary>
/// 更新应付记录
/// </summary>
/// <param name="rec">应付记录对象</param>
/// <returns></returns>
public string UpdPayablesRecord(T_Receivables rec)
{
bool result = false;
string msg = string.Empty;
rec.IE_Flag = "E";
rec.Creator = base.userData.LoginFullName;
rec.C_GUID = Session["CurrentCompany"].ToString();
DateTime now = DateTime.Now;
if (rec.Date <= now)
{
result = new WriteOffSvc().UpdWriteOffRecord(rec);
if (result)
{
msg = General.Resource.Common.Success;
}
else
{
msg = General.Resource.Common.Failed;
}
}
else
{
result = false;
msg = FMS.Resource.Finance.Finance.DateError;
}
return(string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}"
, result.ToString().ToLower(), msg));
}
/// <summary>
/// 更新核销纪录
/// </summary>
/// <param name="rec">核销纪录对象</param>
/// <returns></returns>
public bool UpdWriteOffRecord(T_Receivables rec)
{
DBHelper dh = new DBHelper();
dh.strCmd = "SP_UpdWriteOffRecord";
dh.AddPare("@R_GUID", SqlDbType.NVarChar, 40, rec.R_GUID);
dh.AddPare("@C_GUID", SqlDbType.NVarChar, 40, rec.C_GUID);
dh.AddPare("@IE_Flag", SqlDbType.NVarChar, 4, rec.IE_Flag);
dh.AddPare("@DebitLedgerAccount", SqlDbType.NVarChar, 40, rec.DebitLedgerAccount);
dh.AddPare("@DebitDetailsAccount", SqlDbType.NVarChar, 40, rec.DebitDetailsAccount);
dh.AddPare("@CreditLedgerAccount", SqlDbType.NVarChar, 40, rec.CreditLedgerAccount);
dh.AddPare("@CreditDetailsAccount", SqlDbType.NVarChar, 40, rec.CreditDetailsAccount);
dh.AddPare("@Amount", SqlDbType.Decimal, 0, rec.Money);
dh.AddPare("@Date", SqlDbType.DateTime, 0, rec.Date);
dh.AddPare("@Remark", SqlDbType.NVarChar, 200, rec.Remark);
dh.AddPare("@Creator", SqlDbType.NVarChar, 40, rec.Creator);
dh.AddPare("@CreateDate", SqlDbType.DateTime, 0, DateTime.Now);
dh.AddPare("@Currency", SqlDbType.NVarChar, 5, rec.Currency);
try
{
dh.NonQuery();
return(true);
}
catch
{
return(false);
}
}
