public string GetDSVoucher(string rows, string page, string GUID)
{
int count = 0;
List <T_DeclareCostSpending> List = new DeclareCostSpendingSvc().GetDSVoucher(1, -1, out count, GUID);
string json = new JavaScriptSerializer().Serialize(List);
return(json);
}
public string GetPaymentDeclareCostSpending(string id)
{
string C_GUID = Session["CurrentCompanyGuid"].ToString();
T_DeclareCostSpending rev = new DeclareCostSpendingSvc().GetPaymentDeclareCostSpending(C_GUID, id);
string json = new JavaScriptSerializer().Serialize(rev);
return(json);
}
public string ChoosePaymentDeclareSupplierList(string rows, string page, string invtype)
{
int count = 0;
string C_GUID = Session["CurrentCompany"].ToString();
string strFormatter = "{{\"total\":\"{0}\",\"rows\":{1}}}";
StringBuilder strJson = new StringBuilder();
List <T_DeclareCostSpending> List = new List <T_DeclareCostSpending>();
List = new DeclareCostSpendingSvc().ChoosePaymentDeclare(C_GUID, int.Parse(page), int.Parse(rows), out count, invtype);
strJson.AppendFormat(strFormatter, count, new JavaScriptSerializer().Serialize(List));
return(strJson.ToString());
}
public string GetList(string rows, string page, string dateBegin, string dateEnd, string paymentGrp, string state = null)
{
int count = 0;
string C_GUID = Session["CurrentCompany"].ToString();
string strFormatter = "{{\"total\":\"{0}\",\"rows\":{1}}}";
StringBuilder strJson = new StringBuilder();
List <T_DeclareCostSpending> List = new List <T_DeclareCostSpending>();
List = new DeclareCostSpendingSvc().GetList(int.Parse(page), int.Parse(rows), C_GUID, dateBegin, dateEnd, paymentGrp, state, out count);
strJson.AppendFormat(strFormatter, count, new JavaScriptSerializer().Serialize(List));
return(strJson.ToString());
}
/// <summary>
/// 获取费用列表
/// </summary>
/// <param name="rows">页大小</param>
/// <param name="page">页索引</param>
/// <returns></returns>
public string GetPaymentDeclareCostSpendingList(string rows, string page, string dateBegin, string dateEnd, string customer, string incomeGrp, string currency, string state, string invtype, string record, string business_GUID, string subBusiness_GUID, string remark)
{
int count = 0;
string C_GUID = Session["CurrentCompanyGuid"].ToString();
// string strFormatter = "{{\"total\":\"{0}\",\"rows\":{1}}}";
StringBuilder strJson = new StringBuilder();
List <T_DeclareCostSpending> List = new List <T_DeclareCostSpending>();
List = new DeclareCostSpendingSvc().GetPaymentDeclareCostSpendingList(C_GUID, 1, -1, out count, dateBegin, dateEnd, customer, incomeGrp, currency, state, invtype, record, business_GUID, subBusiness_GUID, remark);
strJson.Append(new JavaScriptSerializer().Serialize(List));
return(strJson.ToString());
}
/// <summary>
/// 获取收款纪录列表
/// </summary>
/// <returns></returns>
public string GetDeclareCostSpendingRecordList(string rows, string page, string BA_GUID)
{
int count = 0;
string C_GUID = Session["CurrentCompanyGuid"].ToString();
StringBuilder strJson = new StringBuilder();
List <T_DeclareCostSpending> RecPayRecord = new List <T_DeclareCostSpending>();
RecPayRecord = new DeclareCostSpendingSvc().GetDeclareCostSpendingRecordList(C_GUID, 1, -1, out count, BA_GUID);
string json = new JavaScriptSerializer().Serialize(RecPayRecord);
return(json);
}
/// <summary>
/// 更改状态
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public string UpdState(string id, string state)
{
bool result = new DeclareCostSpendingSvc().UpdState(id, state);
string msg = string.Empty;
if (result)
{
msg = General.Resource.Common.Success;
}
else
{
msg = General.Resource.Common.Failed;
}
return(string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}"
, result.ToString().ToLower(), msg));
}
/// <summary>
/// 新增申报预收客户款记录
/// </summary>
/// <param name="form"></param>
/// <returns></returns>
public string UpdPaymentDeclareCostSpending(T_DeclareCostSpending form)
{
bool result = false;
string msg = string.Empty;
form.C_GUID = Session["CurrentCompany"].ToString();
result = new DeclareCostSpendingSvc().UpdPaymentDeclareCostSpending(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));
}
/// <summary>
/// 修改申报成本外支出记录
/// </summary>
/// <param name="form"></param>
/// <returns></returns>
public string UpdaDeclareCostSpending(T_DeclareCostSpending form)
{
bool result = false;
string msg = string.Empty;
if (form.InvType == "预付供应商")
{
form.Profit_GUID = "88C60FC8-2FCB-41CD-B721-C58A981961B0";
}
if (form.InvType == "支付押金和暂支借款")
{
form.Profit_GUID = "4F380EB2-C1BC-483C-B229-A7FAEA03D054";
}
if (form.InvType == "分配股利、利润")
{
form.Profit_GUID = "1F500FDD-1460-45DC-BE8F-39F5ACCE5D95";
}
if (form.InvType == "投资支出")
{
form.Profit_GUID = "6AE7EF4C-1E46-4839-951A-6514CAF6F6A1";
}
if (form.InvType == "直接物料采购" || form.InvType == "间接物料采购")
{
form.Profit_GUID = "41C968F2-7D51-4F9F-83B6-EC0F4381ECD0";
}
if (form.InvType == "资产采购")
{
form.Profit_GUID = "B1F44906-51D6-47F4-B6EC-7B678B5E7CD5";
}
result = new DeclareCostSpendingSvc().UpdaDeclareCostSpending(form);
if (result)
{
msg = General.Resource.Common.Success;
}
else
{
msg = General.Resource.Common.Failed;
}
return(msg);
}
public string CreateIntRecord(List <T_DeclareCostSpending> DeclareCostList)
{
bool result = false;
string msg = string.Empty;
foreach (T_DeclareCostSpending form in DeclareCostList)
{
form.C_GUID = Session["CurrentCompanyGuid"].ToString();
form.Currency = Session["Currency"].ToString();
result = new DeclareCostSpendingSvc().UpdPayDSFL(form, "NV");
}
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 string UpdInCome(List <T_IERecord> IEList)
{
bool result = false;
string msg = string.Empty;
foreach (T_IERecord ieRecord in IEList)
{
ieRecord.C_GUID = Session["CurrentCompanyGuid"].ToString();
ieRecord.Creator = base.userData.LoginFullName;
ieRecord.Currency = Session["Currency"].ToString();
switch (ieRecord.InvType)
{
case "主营业务收入":
ieRecord.Profit_Name = "主营业务收入";
ieRecord.RPInvType = "经营活动收款";
ieRecord.InvTypeDts = "销售商品/提供服务的收款";
ieRecord.CFItemGuid = "97B181C8-D807-4BF0-8D8D-B23273E7FEFE";
break;
case "其他业务收入":
ieRecord.Profit_Name = "其他业务收入";
ieRecord.RPInvType = "经营活动收款";
ieRecord.InvTypeDts = "其他业务收入的收款";
ieRecord.CFItemGuid = "F6330595-F588-46B0-8998-752C7A1D774B";
break;
case "营业外收入":
ieRecord.Profit_Name = "营业外收入";
ieRecord.RPInvType = "经营活动收款";
ieRecord.InvTypeDts = "营业外收入的收款";
ieRecord.CFItemGuid = "F6330595-F588-46B0-8998-752C7A1D774B";
break;
case "预收客户款":
ieRecord.Profit_Name = "预收账款";
ieRecord.RPInvType = "经营活动收款";
ieRecord.InvTypeDts = "预收客户账款";
ieRecord.CFItemGuid = "F6330595-F588-46B0-8998-752C7A1D774B";
break;
case "收回公司支出的暂支借款":
ieRecord.Profit_Name = "备用金";
ieRecord.RPInvType = "经营活动收款";
ieRecord.InvTypeDts = "收回公司支出的暂支借款";
ieRecord.CFItemGuid = "F6330595-F588-46B0-8998-752C7A1D774B";
break;
case "收回公司支出的押金":
ieRecord.Profit_Name = "其他应收款";
ieRecord.RPInvType = "经营活动收款";
ieRecord.InvTypeDts = "收回公司支出的押金";
ieRecord.CFItemGuid = "F6330595-F588-46B0-8998-752C7A1D774B";
break;
case "收到的其它公司支付的押金":
ieRecord.Profit_Name = "其他应付款";
ieRecord.RPInvType = "经营活动收款";
ieRecord.InvTypeDts = "收到的其它公司支付的押金";
ieRecord.CFItemGuid = "F6330595-F588-46B0-8998-752C7A1D774B";
break;
case "投资收益":
ieRecord.Profit_Name = "投资收益";
ieRecord.RPInvType = "投资活动收款";
if (ieRecord.DetailInvtype == "利息")
{
ieRecord.InvTypeDts = "取得投资收益的利息的收款";
}
if (ieRecord.DetailInvtype == "股利")
{
ieRecord.InvTypeDts = "取得投资收益的股利的收款";
}
ieRecord.CFItemGuid = "C55B2A4E-129B-407B-AC0B-14C091587D45";
break;
case "主营业务成本":
ieRecord.Profit_Name = "主营业务成本";
ieRecord.InvType = "营业成本";
ieRecord.RPInvType = "经营活动付款";
ieRecord.InvTypeDts = "购买商品、接受服务所支付的款";
ieRecord.CFItemGuid = "0526C862-F238-4301-A198-E7EC83A645D5";
break;
case "销售费用":
ieRecord.Profit_Name = "销售费用";
ieRecord.RPInvType = "经营活动付款";
ieRecord.InvTypeDts = "支付销售费用";
ieRecord.CFItemGuid = "DE7D81B9-680B-4011-A771-C8B327A549E7";
break;
case "财务费用":
ieRecord.Profit_Name = "财务费用";
ieRecord.RPInvType = "经营活动付款";
ieRecord.InvTypeDts = "支付财务费用";
ieRecord.CFItemGuid = "DE7D81B9-680B-4011-A771-C8B327A549E7";
break;
case "管理费用":
ieRecord.Profit_Name = "管理费用";
ieRecord.RPInvType = "经营活动付款";
ieRecord.InvTypeDts = "支付管理费用";
ieRecord.CFItemGuid = "DE7D81B9-680B-4011-A771-C8B327A549E7";
break;
case "其他业务成本":
ieRecord.Profit_Name = "其他业务成本";
ieRecord.RPInvType = "经营活动付款";
ieRecord.InvTypeDts = "支付其他业务成本";
ieRecord.CFItemGuid = "DE7D81B9-680B-4011-A771-C8B327A549E7";
break;
case "营业外支出":
ieRecord.Profit_Name = "营业外支出";
ieRecord.RPInvType = "经营活动付款";
ieRecord.InvTypeDts = "支付营业外支出";
ieRecord.CFItemGuid = "DE7D81B9-680B-4011-A771-C8B327A549E7";
break;
case "预付供应商":
ieRecord.Profit_Name = "预付账款";
ieRecord.RPInvType = "经营活动付款";
ieRecord.InvTypeDts = "预付供应商账款";
ieRecord.CFItemGuid = "DE7D81B9-680B-4011-A771-C8B327A549E7";
break;
case "支付押金":
ieRecord.Profit_Name = "其他应收款";
ieRecord.RPInvType = "经营活动付款";
ieRecord.InvTypeDts = "支付押金";
ieRecord.CFItemGuid = "DE7D81B9-680B-4011-A771-C8B327A549E7";
break;
case "支付暂支借款":
ieRecord.Profit_Name = "备用金";
ieRecord.RPInvType = "经营活动付款";
ieRecord.InvTypeDts = "支付暂支借款";
ieRecord.CFItemGuid = "DE7D81B9-680B-4011-A771-C8B327A549E7";
break;
case "归还其它公司支付的押金":
ieRecord.Profit_Name = "其他应付款";
ieRecord.RPInvType = "经营活动付款";
ieRecord.InvTypeDts = "归还其它公司支付的押金";
ieRecord.CFItemGuid = "DE7D81B9-680B-4011-A771-C8B327A549E7";
break;
case "分配股利、利润":
ieRecord.Profit_Name = "预付账款";
ieRecord.RPInvType = "经营活动付款";
ieRecord.InvTypeDts = "支付其他与经营活动有关的款";
ieRecord.CFItemGuid = "DE7D81B9-680B-4011-A771-C8B327A549E7";
break;
case "短期投资支出":
ieRecord.Profit_Name = "短期投资";
ieRecord.RPInvType = "投资活动付款";
ieRecord.InvTypeDts = "短期投资支出";
ieRecord.CFItemGuid = "049F1C6D-49EA-4E2D-93FD-2DABEBED666C";
break;
case "收回短期投资的本金金额内的款":
ieRecord.Profit_Name = "短期投资";
ieRecord.RPInvType = "投资活动收款";
ieRecord.InvTypeDts = "收回短期投资的本金金额内的款";
ieRecord.CFItemGuid = "496F9D4D-F71B-437A-9EA0-26107D3449C3";
break;
case "长期股权投资支出":
ieRecord.Profit_Name = "长期股权投资";
ieRecord.RPInvType = "投资活动付款";
ieRecord.InvTypeDts = "投资所支付款";
ieRecord.CFItemGuid = "049F1C6D-49EA-4E2D-93FD-2DABEBED666C";
break;
case "长期债权投资支出":
ieRecord.Profit_Name = "长期债权投资";
ieRecord.RPInvType = "投资活动付款";
ieRecord.InvTypeDts = "长期债权投资支出";
ieRecord.CFItemGuid = "049F1C6D-49EA-4E2D-93FD-2DABEBED666C";
break;
case "收回长期债券投资的本金金额内的款":
ieRecord.Profit_Name = "长期债权投资";
ieRecord.RPInvType = "投资活动收款款";
ieRecord.InvTypeDts = "收回长期债券投资的本金金额内的款";
ieRecord.CFItemGuid = "496F9D4D-F71B-437A-9EA0-26107D3449C3";
break;
case "归还短期借款所支付的款":
ieRecord.Profit_Name = "短期借款";
ieRecord.RPInvType = "筹资活动付款";
ieRecord.InvTypeDts = "归还短期借款所支付的款";
ieRecord.CFItemGuid = "DD7BCD86-150E-4E62-B6CC-21EF341B41F1";
break;
case "归还长期借款所支付的款":
ieRecord.Profit_Name = "长期借款";
ieRecord.RPInvType = "筹资活动付款";
ieRecord.InvTypeDts = "归还长期借款所支付的款";
ieRecord.CFItemGuid = "DD7BCD86-150E-4E62-B6CC-21EF341B41F1";
break;
case "收取投资款(注册资本金额以内部分)":
ieRecord.Profit_Name = "实收资本";
ieRecord.RPInvType = "筹资活动收款";
ieRecord.InvTypeDts = "吸收投资的收款(注册资本金额以内部分)";
ieRecord.CFItemGuid = "77A24D5F-3E0C-4211-A552-191FEE0E06FD";
break;
case "收取投资款(超出注册资本金额部分)":
ieRecord.Profit_Name = "资本公积";
ieRecord.RPInvType = "筹资活动收款";
ieRecord.InvTypeDts = "吸收投资的收款(超出注册资本金额部分)";
ieRecord.CFItemGuid = "77A24D5F-3E0C-4211-A552-191FEE0E06FD";
break;
case "短期借款所获得的收款":
ieRecord.Profit_Name = "短期借款";
ieRecord.RPInvType = "筹资活动收款";
ieRecord.InvTypeDts = "短期借款所获得的收款";
ieRecord.CFItemGuid = "AD2E5437-0917-43E1-807C-41CA6751360F";
break;
case "长期借款所获得的收款":
ieRecord.Profit_Name = "长期借款";
ieRecord.RPInvType = "筹资活动收款";
ieRecord.InvTypeDts = "长期借款所获得的收款";
ieRecord.CFItemGuid = "AD2E5437-0917-43E1-807C-41CA6751360F";
break;
case "其他与筹资活动有关的收款":
ieRecord.Profit_Name = "其他应付款";
ieRecord.RPInvType = "筹资活动收款";
ieRecord.InvTypeDts = "其他与筹资活动有关的收款";
ieRecord.CFItemGuid = "106B9F2C-24A5-48B5-9621-418D00A7A75A";
break;
default:
break;
}
if (string.IsNullOrEmpty(ieRecord.RP_GUID))
{
if (ieRecord.IE_Flag == "I")
{
result = new IESvc().UpdIncomeRecord(ieRecord);
}
if (ieRecord.IE_Flag == "E")
{
result = new IESvc().UpdExpenseRecord(ieRecord);
}
if (ieRecord.IE_Flag == "DS")
{
ieRecord.Record = "未记录";
result = new DeclareCostSpendingSvc().UpdV(ieRecord);
}
if (ieRecord.IE_Flag == "DC")
{
if (ieRecord.Profit_Name == "长期借款" || ieRecord.Profit_Name == "短期借款")
{
ieRecord.Record = "未还款";
}
else
{
ieRecord.Record = "未记录";
}
result = new DeclareCustomerSvc().UpdV(ieRecord);
}
if (result)
{
msg = General.Resource.Common.Success;
}
else
{
msg = General.Resource.Common.Failed;
}
}
else
{
if (ieRecord.IE_Flag == "I")
{
result = new IESvc().UpdIncomeRecord(ieRecord);
}
if (ieRecord.IE_Flag == "E")
{
result = new IESvc().UpdExpenseRecord(ieRecord);
}
if (ieRecord.IE_Flag == "DS")
{
result = new DeclareCostSpendingSvc().UpdV(ieRecord);
}
if (ieRecord.IE_Flag == "DC")
{
result = new DeclareCustomerSvc().UpdV(ieRecord);
}
if (result)
{
ieRecord.Record = "已销账";
ieRecord.DisAmount = 0;
if (ieRecord.IE_Flag == "I" || ieRecord.IE_Flag == "DC")
{
ieRecord.RP_Flag = "R";
}
if (ieRecord.IE_Flag == "E" || ieRecord.IE_Flag == "DS")
{
ieRecord.RP_Flag = "P";
}
ieRecord.Creator = base.userData.LoginFullName;
ieRecord.C_GUID = Session["CurrentCompanyGuid"].ToString();
if (!string.IsNullOrEmpty(ieRecord.BA_GUID))
{
if (ieRecord.BA_GUID != "1")
{
T_BankAccount ba = new BankAccountSvc().GetBank(Session["CurrentCompanyGuid"].ToString(), null, ieRecord.BA_GUID, null);
ieRecord.B_GUID = ba.B_GUID;
ieRecord.BA_GUID = ba.BA_GUID;
}
}
result = new RecPayRecordSvc().UpdVoucherIERP(ieRecord.IE_GUID, ieRecord.RP_GUID, ieRecord.bankAmount, ieRecord.RP_Flag, ieRecord.IE_Flag, ieRecord.RPLA_GUID.Trim(), ieRecord.IELA_GUID, ieRecord.C_GUID);
if (result)
{
result = new IESvc().UpdRecPayRecord(ieRecord);
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 string CreatPDRecord(List <T_DeclareCostSpending> payList)
{
bool result = false;
string msg = string.Empty;
foreach (T_DeclareCostSpending dc in payList)
{
dc.C_GUID = Session["CurrentCompanyGuid"].ToString();
if (dc.InvType == "预付供应商账款")
{
dc.Profit_Name = "预付账款";
}
if (dc.InvType == "支付押金")
{
dc.Profit_Name = "其他应收款";
}
if (dc.InvType == "支付暂支借款")
{
dc.Profit_GUID = "备用金";
}
if (dc.InvType == "归还短期借款所支付的款")
{
dc.Profit_Name = "短期借款";
}
if (dc.InvType == "归还长期借款所支付的款")
{
dc.Profit_Name = "长期借款";
}
if (dc.InvType == "归还其它公司支付的押金")
{
dc.Profit_Name = "其他应付款";
}
if (dc.InvType == "分配利润、股利所支付的款")
{
dc.Profit_Name = "应付利润";
}
if (dc.InvType == "短期投资支出")
{
dc.Profit_Name = "短期投资支出";
}
if (dc.InvType == "长期股权投资支出")
{
dc.Profit_Name = "长期股权投资支出";
}
if (dc.InvType == "长期债券投资支出")
{
dc.Profit_Name = "长期债券投资支出";
}
if (dc.InvType == "直接物料采购" || dc.InvType == "间接物料采购")
{
dc.Profit_GUID = "41C968F2-7D51-4F9F-83B6-EC0F4381ECD0";
}
if (dc.InvType == "资产采购")
{
dc.Profit_GUID = "B1F44906-51D6-47F4-B6EC-7B678B5E7CD5";
}
DateTime EditThreshold = DateTime.Parse(Session["EditThreshold"].ToString());
if (DateTime.Parse(dc.Date) <= DateTime.Now && DateTime.Parse(dc.Date) >= EditThreshold)
{
result = new DeclareCostSpendingSvc().UpdPaymentDeclareCostSpending(dc);
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="form"></param>
/// <returns></returns>
public string UpdPaymentDeclareCostSpending(T_DeclareCostSpending 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.InvType == "间接物料采购")
{
form.Profit_Name = "41C968F2-7D51-4F9F-83B6-EC0F4381ECD0";
}
if (form.InvType == "资产采购")
{
form.Profit_Name = "B1F44906-51D6-47F4-B6EC-7B678B5E7CD5";
}
result = new DeclareCostSpendingSvc().UpdPaymentDeclareCostSpending(form);
if (result)
{
msg = General.Resource.Common.Success;
}
else
{
msg = General.Resource.Common.Failed;
}
return(msg);
}