/// <summary>
/// 新增操作
/// </summary>
/// <param name="rec"></param>
/// <returns></returns>
public bool UpdaDeclareCustomer(T_DeclareCustomer rec)
{
DBHelper dh = new DBHelper();
dh.BeginTran();
try
{
dh.strCmd = "SP_UpdaDeclareCustomer";
dh.AddPare("@GUID", SqlDbType.NVarChar, 40, rec.GUID);
dh.AddPare("@InvType", SqlDbType.NVarChar, 40, rec.InvType);
dh.AddPare("@RPer", SqlDbType.NVarChar, 40, rec.RPer);
if (!rec.Date.Equals(DateTime.MinValue))
{
dh.AddPare("@Date", SqlDbType.DateTime, 0, rec.Date);
}
dh.AddPare("@Amount", SqlDbType.Decimal, 0, rec.Amount);
dh.AddPare("@Currency", SqlDbType.NVarChar, 20, rec.Currency);
dh.AddPare("@State", SqlDbType.NVarChar, 40, rec.State);
dh.NonQuery();
dh.CleanPara();
dh.CommitTran();
return true;
}
catch
{
dh.RollBackTran();
return false;
}
}
public bool UpdDCostSpending(T_DeclareCustomer rec)
{
DBHelper dh = new DBHelper();
dh.BeginTran();
try
{
dh.strCmd = "SP_UpdPaymentDCostSpending";
dh.AddPare("@GUID", SqlDbType.NVarChar, 40, rec.GUID);
dh.AddPare("@InvType", SqlDbType.NVarChar, 40, rec.InvType);
dh.AddPare("@RPer", SqlDbType.NVarChar, 40, rec.RPer);
if (!rec.Date.Equals(DateTime.MinValue))
{
dh.AddPare("@Date", SqlDbType.DateTime, 0, rec.Date);
}
dh.AddPare("@Amount", SqlDbType.Decimal, 0, rec.Amount);
dh.AddPare("@Remark", SqlDbType.NVarChar, 200, rec.Record);
dh.AddPare("@Currency", SqlDbType.NVarChar, 20, rec.Currency);
dh.AddPare("@State", SqlDbType.NVarChar, 40, rec.State);
dh.AddPare("@Record", SqlDbType.NVarChar, 40, rec.Record);
dh.AddPare("@C_GUID", SqlDbType.NVarChar, 40, rec.C_GUID);
dh.AddPare("@VoucherNo", SqlDbType.NVarChar, 40, rec.VoucherNo);
dh.AddPare("@Profit_GUID", SqlDbType.NVarChar, 40, rec.Profit_GUID);
dh.NonQuery();
dh.CleanPara();
dh.CommitTran();
return true;
}
catch
{
dh.RollBackTran();
return false;
}
}
/// <summary>
/// 修改申报收入外收款记录
/// </summary>
/// <param name="form"></param>
/// <returns></returns>
public string UpdaDeclareCustomer(T_DeclareCustomer form)
{
bool result = false;
string msg = string.Empty;
result = new DeclareCustomerSvc().UpdaDeclareCustomer(form);
if (result)
{
msg = General.Resource.Common.Success;
}
else
{
msg = General.Resource.Common.Failed;
}
return(msg);
}
/// <summary>
/// 新增申报预收客户款记录
/// </summary>
/// <param name="form"></param>
/// <returns></returns>
public string UpdReceivablesDeclareCustomer(T_DeclareCustomer form)
{
bool result = false;
string msg = string.Empty;
form.C_GUID = Session["CurrentCompany"].ToString();
result = new DeclareCustomerSvc().UpdReceivablesDeclareCustomer(form);
if (result)
{
msg = General.Resource.Common.Success;
}
else
{
msg = General.Resource.Common.Failed;
}
return(string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}"
, result.ToString().ToLower(), msg));
}
public bool UpdReceivablesDeclareCustomer(T_DeclareCustomer rec)
{
DBHelper dh = new DBHelper();
dh.BeginTran();
try
{
dh.strCmd = "SP_UpdReceivablesDeclareCustomer";
dh.AddPare("@GUID", SqlDbType.NVarChar, 40, rec.GUID);
dh.AddPare("@VoucherNo", SqlDbType.NVarChar, 40, rec.VoucherNo);
dh.AddPare("@Business_GUID", SqlDbType.NVarChar, 40, rec.Business_GUID);
dh.AddPare("@SubBusiness_GUID", SqlDbType.NVarChar, 40, rec.SubBusiness_GUID);
dh.AddPare("@RPType", SqlDbType.NVarChar, 50, rec.RPType);
dh.AddPare("@DetailRPType", SqlDbType.NVarChar, 50, rec.DetailRPType);
dh.AddPare("@InvType", SqlDbType.NVarChar, 40, rec.InvType);
dh.AddPare("@RPer", SqlDbType.NVarChar, 40, rec.RPer);
dh.AddPare("@Date", SqlDbType.DateTime, 0, rec.Date);
dh.AddPare("@Amount", SqlDbType.Decimal, 0, rec.Amount);
dh.AddPare("@Remark", SqlDbType.NVarChar, 200, rec.Remark);
dh.AddPare("@Currency", SqlDbType.NVarChar, 20, rec.Currency);
dh.AddPare("@Profit_Name", SqlDbType.NVarChar, 40, rec.Profit_Name);
dh.AddPare("@DisAmount", SqlDbType.Decimal, 0, rec.Amount);
dh.AddPare("@State", SqlDbType.NVarChar, 40, rec.State);
if (rec.InvType == "短期借款" || rec.InvType == "长期借款")
{
dh.AddPare("@Record", SqlDbType.NVarChar, 40, "未还款");
}
else
{
dh.AddPare("@Record", SqlDbType.NVarChar, 40, "未记录");
}
dh.AddPare("@C_GUID", SqlDbType.NVarChar, 40, rec.C_GUID);
dh.NonQuery();
dh.CleanPara();
dh.CommitTran();
return true;
}
catch
{
dh.RollBackTran();
return false;
}
}
/// <summary>
/// 新增申报预收客户款记录
/// </summary>
/// <param name="form"></param>
/// <returns></returns>
public string UpdReceivablesDeclareCustomer(T_DeclareCustomer form)
{
bool result = false;
string msg = string.Empty;
form.C_GUID = Session["CurrentCompanyGuid"].ToString();
if (form.InvType == "预收客户账款")
{
form.Profit_Name = "预收账款";
}
if (form.InvType == "收取投资款(注册资本金额以内部分)")
{
form.Profit_Name = "实收资本";
}
if (form.InvType == "收取投资款(超出注册资本金额部分)")
{
form.Profit_Name = "资本公积";
}
if (form.InvType == "收回短期投资的本金金额内的款")
{
form.Profit_Name = "短期投资";
}
if (form.InvType == "收回长期债券投资的本金金额内的款")
{
form.Profit_Name = "长期债券投资";
}
if (form.InvType == "收回长期股权投资的本金金额内的款")
{
form.Profit_Name = "长期股权投资";
}
if (form.InvType == "收回公司支出的押金")
{
form.Profit_Name = "其他应付款";
}
if (form.InvType == "收到的其他公司支付的押金")
{
form.Profit_Name = "其他应付款";
}
if (form.InvType == "收回公司支出的暂支借款")
{
form.Profit_Name = "备用金";
}
if (form.InvType == "短期借款所获得的收款")
{
form.Profit_Name = "短期借款";
}
if (form.InvType == "长期借款所获得的收款")
{
form.Profit_Name = "长期借款";
}
if (form.InvType == "其他与筹资活动有关的收款")
{
form.Profit_Name = "其他应付款";
}
result = new DeclareCustomerSvc().UpdReceivablesDeclareCustomer(form);
if (result)
{
msg = General.Resource.Common.Success;
}
else
{
msg = General.Resource.Common.Failed;
}
return(string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}"
, result.ToString().ToLower(), msg));
}
