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