public string GetRPVoucherByRpID(string RP_GUID)
{
List <RPVoucherInfo> List = new RecPayRecordSvc().GetRPVoucherInfo(RP_GUID);
string json = new JavaScriptSerializer().Serialize(List);
return(json);
}
public string UpEditPayRecord(T_RecPayRecord rec)
{
bool result = false;
string msg = string.Empty;
rec.Creator = base.userData.LoginFullName;
rec.C_GUID = Session["CurrentCompanyGuid"].ToString();
rec.CreateDate = DateTime.Now.ToString("yyyy-MM-dd");
DateTime EditThreshold = DateTime.Parse(Session["EditThreshold"].ToString());
DateTime checkDate;
DateTime.TryParse(rec.Date, out checkDate);
if (checkDate <= DateTime.Now && checkDate >= EditThreshold)
{
result = new RecPayRecordSvc().UpEditPayRecord(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));
}
public string GetRPVoucherNew(string rows, string page, string RP_GUID)
{
int count = 0;
List <T_RecPayRecord> List = new RecPayRecordSvc().GetRPVoucherNew(1, -1, out count, RP_GUID, "P");
string json = new JavaScriptSerializer().Serialize(List);
return(json);
}
/// <summary>
//查询现金流比较（返回月份，金额）
/// </summary>
/// <param>hdy 17.3.31</param>
/// <returns></returns>
public string CashInFlowsCompareRecordQuery(string BA_GUID, string dateBegin, string dateEnd)
{
string C_GUID = Session["CurrentCompanyGuid"].ToString();
List <T_RecPayRecord> Record = new List <T_RecPayRecord>();
Record = new RecPayRecordSvc().GetCashFlowsCompareRecordList(BA_GUID, C_GUID, dateBegin, dateEnd);
return(new JavaScriptSerializer().Serialize(Record));
}
/// <summary>
/// 查询账户下现金流列表(统计货币汇总)
/// </summary>
/// <param>hdy 17.3.28</param>
/// <returns></returns>
public string GetNetCashStatisticalCurrencyList(string dateBegin, string dateEnd, int pageIndex = 1, int pageSize = 10)
{
int count = 0;
string C_GUID = Session["CurrentCompanyGuid"].ToString();
List <T_RecPayRecord> Record = new List <T_RecPayRecord>();
Record = new RecPayRecordSvc().GetNetCashStatisticalCurrencyList(C_GUID, pageIndex, -1, out count,
dateBegin, dateEnd);
return(new JavaScriptSerializer().Serialize(Record));
}
/// <summary>
/// 主营业务收入、非主营业务收入的应收款列表
/// </summary>
/// <param name="rows">页大小</param>
/// <param name="page">页索引</param>
/// <param name="id">收款方标识</param>
/// <returns></returns>
public string GetUnionList(string rows, string page, string customer, string main, string nomain, string other, string investment)
{
int count = 0;
string C_GUID = Session["CurrentCompanyGuid"].ToString();
StringBuilder strJson = new StringBuilder();
List <T_IERecord> List = new List <T_IERecord>();
List = new RecPayRecordSvc().GetUnionDRec(C_GUID, 1, -1, out count, customer, main, nomain, other, investment);
return(new JavaScriptSerializer().Serialize(List));
}
public string GetIEUsed(string rows, string page, string id)
{
int count = 0;
string C_GUID = Session["CurrentCompanyGuid"].ToString();
StringBuilder strJson = new StringBuilder();
List <T_RecPayRecord> List = new List <T_RecPayRecord>();
List = new RecPayRecordSvc().GetIEUsed(C_GUID, 1, -1, out count, id);
return(new JavaScriptSerializer().Serialize(List));
}
public string GetPaymentRecord(string id)
{
string C_GUID = Session["CurrentCompanyGuid"].ToString();
string strFormatter = "{{\"total\":\"{0}\",\"rows\":{1}}}";
StringBuilder strJson = new StringBuilder();
List <T_RecPayRecord> RecPayRecord = new List <T_RecPayRecord>();
RecPayRecord = new RecPayRecordSvc().GetRecPayRecordD(id, C_GUID);
strJson.AppendFormat(strFormatter, 1, new JavaScriptSerializer().Serialize(RecPayRecord));
return(strJson.ToString());
}
public string GetReceivablesDeclareCustomerList(string page, string rows)
{
int count = 0;
string C_GUID = Session["CurrentCompanyGuid"].ToString();
string strFormatter = "{{\"total\":\"{0}\",\"rows\":{1}}}";
StringBuilder strJson = new StringBuilder();
List <T_RecPayRecord> RecPayRecord = new List <T_RecPayRecord>();
RecPayRecord = new RecPayRecordSvc().GetDeclareCustomer("R", C_GUID, int.Parse(page), int.Parse(rows), out count, "收到的其他与经营活动有关的款客户预付、押金返还、暂支还款等;预付客户款");
strJson.AppendFormat(strFormatter, count, new JavaScriptSerializer().Serialize(RecPayRecord));
return(strJson.ToString());
}
/// <summary>
/// 获取收款纪录列表
/// </summary>
/// <param name="rows">页大小</param>
/// <param name="page">页索引</param>
/// <returns></returns>
public string GetReceivablesList(string rows, string page)
{
int count = 0;
string C_GUID = Session["CurrentCompany"].ToString();
string strFormatter = "{{\"total\":\"{0}\",\"rows\":{1}}}";
StringBuilder strJson = new StringBuilder();
List <T_RecPayRecord> RecPayRecord = new List <T_RecPayRecord>();
RecPayRecord = new RecPayRecordSvc().GetReceivablesRecord(C_GUID, int.Parse(page), int.Parse(rows), out count);
strJson.AppendFormat(strFormatter, count, new JavaScriptSerializer().Serialize(RecPayRecord));
return(strJson.ToString());
}
/// <summary>
/// 应付纪录列表
/// </summary>
/// <param name="rows">页大小</param>
/// <param name="page">页索引</param>
/// <param name="id">收款方标识</param>
/// <returns></returns>
public string GetChoosePayablesRecord(string rows, string page, string id, string iegroup = null)
{
int count = 0;
string C_GUID = Session["CurrentCompany"].ToString();
string strFormatter = "{{\"total\":\"{0}\",\"rows\":{1}}}";
StringBuilder strJson = new StringBuilder();
List <T_Payables> Payables = new List <T_Payables>();
Payables = new RecPayRecordSvc().GetChoosePayablesRecord(id, C_GUID, int.Parse(page), int.Parse(rows), out count, iegroup);
strJson.AppendFormat(strFormatter, count, new JavaScriptSerializer().Serialize(Payables));
return(strJson.ToString());
}
public string GetPaymentDeclareCostSpendingList(string page, string rows)
{
int count = 0;
string C_GUID = Session["CurrentCompanyGuid"].ToString();
string strFormatter = "{{\"total\":\"{0}\",\"rows\":{1}}}";
StringBuilder strJson = new StringBuilder();
List <T_RecPayRecord> RecPayRecord = new List <T_RecPayRecord>();
RecPayRecord = new RecPayRecordSvc().GetPaymentDeclareCostSpending("P", C_GUID, int.Parse(page), int.Parse(rows), out count, "支付的其他与经营活动有关的款预付供应商、支付押金、暂支款等;预付供应商");
strJson.AppendFormat(strFormatter, count, new JavaScriptSerializer().Serialize(RecPayRecord));
return(strJson.ToString());
}
public string GetPaymentSelfList(string page, string rows, string dateBegin, string dateEnd, string customer, string incomeGrp, string incomeGrpDts)
{
int count = 0;
string C_GUID = Session["CurrentCompanyGuid"].ToString();
string strFormatter = "{{\"total\":\"{0}\",\"rows\":{1}}}";
StringBuilder strJson = new StringBuilder();
List <T_RecPayRecord> RecPayRecord = new List <T_RecPayRecord>();
RecPayRecord = new RecPayRecordSvc().GetPaymentSelfListTwo(C_GUID, int.Parse(page), int.Parse(rows), out count,
dateBegin, dateEnd, customer, incomeGrp, incomeGrpDts);
strJson.AppendFormat(strFormatter, count, new JavaScriptSerializer().Serialize(RecPayRecord));
return(strJson.ToString());
}
/// <summary>
/// 获取收款纪录列表
/// </summary>
/// <returns></returns>
public string GetCustomerCashInFlowsRecordList(string rows, string page, string dateBegin, string dateEnd, string BA_GUID)
{
int count = 0;
string C_GUID = Session["CurrentCompanyGuid"].ToString();
StringBuilder strJson = new StringBuilder();
List <T_RecPayRecord> RecPayRecord = new List <T_RecPayRecord>();
RecPayRecord = new RecPayRecordSvc().GetCustomerCashInFlowsRecordList(C_GUID, 1, -1, out count,
dateBegin, dateEnd, BA_GUID);
string json = new JavaScriptSerializer().Serialize(RecPayRecord);
return(json);
}
/// <summary>
/// 未归档付款纪录列表
/// </summary>
/// <param name="pageSize">页大小</param>
/// <param name="pageIndex">页索引</param>
/// <returns></returns>
public string GetPaymentList(string rows, string page, string record, string dateBegin, string dateEnd, string customer, string incomeGrp, string InvTypeDts)
{
int count = 0;
string C_GUID = Session["CurrentCompanyGuid"].ToString();
//string strFormatter = "{{\"total\":\"{0}\",\"rows\":{1}}}";
//StringBuilder strJson = new StringBuilder();
List <T_RecPayRecord> RecPayRecord = new List <T_RecPayRecord>();
RecPayRecord = new RecPayRecordSvc().GetPaymentRecord(C_GUID, 1, -1, out count, record,
dateBegin, dateEnd, customer, incomeGrp, InvTypeDts);
//strJson.AppendFormat(strFormatter, count, new JavaScriptSerializer().Serialize(RecPayRecord));
return(new JavaScriptSerializer().Serialize(RecPayRecord));
}
/// <summary>
/// 获取应收款列表
/// </summary>
/// <param name="id">付款方标识</param>
/// <returns></returns>
public string GetChooseReceivablesRecord(string id)
{
//int count = 0;
string C_GUID = Session["CurrentCompanyGuid"].ToString();
//string strFormatter = "{{\"total\":\"{0}\",\"rows\":{1}}}";
StringBuilder strJson = new StringBuilder();
List <T_Receivables> Receivables = new List <T_Receivables>();
Receivables = new RecPayRecordSvc().GetChooseReceivablesRecord(id, C_GUID);
string json = new JavaScriptSerializer().Serialize(Receivables);
return(json);
}
/// <summary>
/// 将收入列表以Excel形式导出
/// </summary>
/// <returns></returns>
public FileResult ExportXls()
{
//int count = 0;
List <T_RecPayRecord> ds = new RecPayRecordSvc().GetAllPaymentRecord(Session["CurrentCompanyGuid"].ToString());
Dictionary <string, string> cfg = new Dictionary <string, string>();
cfg.Add("Date", "付款日期");
cfg.Add("R_PerName", "收款方");
cfg.Add("SumAmount", "总金额");
cfg.Add("Currency", "货币");
cfg.Add("InvType", "付款类别");
cfg.Add("BankAccount", "付款账户");
cfg.Add("Remark", "备注");
return(File(new GenerateXls().GenXls <T_RecPayRecord>("P", ds, cfg), "application/vnd.ms-excel", "付款列表.xls"));
}
/// <summary>
/// 删除付款纪录
/// </summary>
/// <param name="id">付款纪录标识</param>
/// <returns></returns>
public string DelPaymentRecord(string id)
{
bool result = new RecPayRecordSvc().DelPaymentRecord(id);
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="id"></param>
/// <param name="ieguid"></param>
/// <returns></returns>
public string UpdPR(string id, string ieguid)
{
bool result = new RecPayRecordSvc().UpdRR("P", id, ieguid, "经营活动付款", "销售商品/提供服务的收款", "97B181C8-D807-4BF0-8D8D-B23273E7FEFE");
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));
}
public string UpdInyType(string id, string invtype, string typedts, string cfitemguid, string ieguid, string record)
{
bool result = new RecPayRecordSvc().UpdInvType("P", id, invtype, typedts, cfitemguid, ieguid, record);
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));
}
public string UpdIncomeState(string id)
{
bool result = new RecPayRecordSvc().UpdIEState("I", id, "已收");
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="id"></param>
/// <param name="ieguid"></param>
/// <returns></returns>
public string UpdRR1(string id, string ieguid)
{
bool result = new RecPayRecordSvc().UpdRR("R", id, ieguid, "未归账", null, null);
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>
/// <returns></returns>
/// <remarks>
/// 2017/4/3 sunp update
/// </remarks>
public string backCancelAccount(string id, string flag)
{
ExceResult res = new ExceResult();
string CId = CompanyId();
bool result = new RecPayRecordSvc().backCancelAccount(id, flag);
string msg = string.Empty;
if (result)
{
msg = General.Resource.Common.Success;
result = true;
}
else
{
msg = General.Resource.Common.Failed;
result = false;
}
return(string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}"
, result.ToString().ToLower(), msg));
}
/// <summary>
/// 查询账户下净现金流帐
/// </summary>
/// <param>hdy 17.3.31</param>
/// <returns></returns>
public string GetCashInFlowsAccountRecordList(string BA_GUID, string dateBegin, string dateEnd, int pageIndex = 1, int pageSize = 10)
{
int count = 0;
string C_GUID = Session["CurrentCompanyGuid"].ToString();
List <T_RecPayRecord> Record = new List <T_RecPayRecord>();
Record = new RecPayRecordSvc().GetCashInFlowsAccountRecordList(BA_GUID, C_GUID, pageIndex, -1, out count,
dateBegin, dateEnd);
for (int i = 0; i < Record.Count; i++)
{
if (i == 0)
{
Record[i].BalanceSumAmount = Record[i].InitialAmount + Record[i].RecSumAmountZ - Record[i].PaySumAmountZ;
}
else
{
Record[i].BalanceSumAmount = Record[i - 1].BalanceSumAmount + Record[i].RecSumAmountZ - Record[i].PaySumAmountZ;
}
}
return(new JavaScriptSerializer().Serialize(Record));
}
public string UpdPayInyType(List <T_RecPayRecord> payList, string SumAmount, string DisAmount)
{
//typedts = typedts + ";" + typedtsdts;
bool result = false;
string msg = string.Empty;
foreach (T_RecPayRecord recPayRecord in payList)
{
recPayRecord.RP_Flag = "P";
switch (recPayRecord.InvTypeDts)
{
case "购买商品、接受服务所支付的款":
recPayRecord.CFItemGuid = "0526C862-F238-4301-A198-E7EC83A645D5";
break;
case "支付销售费用":
recPayRecord.CFItemGuid = "DE7D81B9-680B-4011-A771-C8B327A549E7";
break;
case "支付管理费用":
recPayRecord.CFItemGuid = "DE7D81B9-680B-4011-A771-C8B327A549E7";
break;
case "支付财务费用":
recPayRecord.CFItemGuid = "DE7D81B9-680B-4011-A771-C8B327A549E7";
break;
case "预付供应商账款":
recPayRecord.CFItemGuid = "DE7D81B9-680B-4011-A771-C8B327A549E7";
break;
case "支付其他业务成本":
recPayRecord.CFItemGuid = "DE7D81B9-680B-4011-A771-C8B327A549E7";
break;
case "支付营业外支出":
recPayRecord.CFItemGuid = "DE7D81B9-680B-4011-A771-C8B327A549E7";
break;
case "支付暂支借款":
recPayRecord.CFItemGuid = "DE7D81B9-680B-4011-A771-C8B327A549E7";
break;
case "支付押金":
recPayRecord.CFItemGuid = "DE7D81B9-680B-4011-A771-C8B327A549E7";
break;
case "归还其它公司支付的押金":
recPayRecord.CFItemGuid = "DE7D81B9-680B-4011-A771-C8B327A549E7";
break;
case "短期投资支出":
recPayRecord.CFItemGuid = "049F1C6D-49EA-4E2D-93FD-2DABEBED666C";
break;
case "长期债券投资支出":
recPayRecord.CFItemGuid = "049F1C6D-49EA-4E2D-93FD-2DABEBED666C";
break;
case "长期股权投资支出":
recPayRecord.CFItemGuid = "049F1C6D-49EA-4E2D-93FD-2DABEBED666C";
break;
case "购买固定资产所支付的款":
recPayRecord.CFItemGuid = "EA46CFA0-5D41-4FF1-9BF8-9A36CB8F1F11";
break;
case "购买无形资产所支付的款":
recPayRecord.CFItemGuid = "EA46CFA0-5D41-4FF1-9BF8-9A36CB8F1F11";
break;
case "购买其他长期资产所支付的款":
recPayRecord.CFItemGuid = "EA46CFA0-5D41-4FF1-9BF8-9A36CB8F1F11";
break;
case "归还短期借款所支付的款":
recPayRecord.CFItemGuid = "DD7BCD86-150E-4E62-B6CC-21EF341B41F1";
break;
case "归还长期借款所支付的款":
recPayRecord.CFItemGuid = "DD7BCD86-150E-4E62-B6CC-21EF341B41F1";
break;
case "分配利润、股利所支付的款":
recPayRecord.CFItemGuid = "5BDE7476-F268-4A62-8CC3-D426D51E253D";
break;
case "偿付利息所支付的款":
recPayRecord.CFItemGuid = "5BDE7476-F268-4A62-8CC3-D426D51E253D";
break;
case "支付职工薪酬":
recPayRecord.CFItemGuid = "70765251-FA58-432F-BCC5-122EF3581102";
break;
case "支付的各项税费":
recPayRecord.CFItemGuid = "E4F16AB4-8DFE-42E1-8A7F-0CB342CF9C73";
break;
case "支付其他与筹资活动有关的款":
recPayRecord.CFItemGuid = "8254B1DA-91CC-4CA5-B7F0-9AC5D2653865";
break;
case "暂支借款":
recPayRecord.CFItemGuid = "DE7D81B9-680B-4011-A771-C8B327A549E7";
break;
case "":
break;
}
string check = null;
string[] temp = recPayRecord.IE_GUID.Split(new char[] { ',' });
if (Convert.ToDecimal(SumAmount) == Convert.ToDecimal(DisAmount))
{
recPayRecord.Record = "已销账";
recPayRecord.DisAmount1 = 0;
check = "EQ";
foreach (var a in temp)
{
result = new RecPayRecordSvc().UpdIERP(a, recPayRecord.RP_GUID, check, recPayRecord.Mark, recPayRecord.RP_Flag, recPayRecord.InvTypeDts);
}
}
if (Convert.ToDecimal(SumAmount) > Convert.ToDecimal(DisAmount))
{
recPayRecord.Record = "未销账";
recPayRecord.DisAmount1 = Convert.ToDecimal(SumAmount) - Convert.ToDecimal(DisAmount);;
check = "LESS";
foreach (var a in temp)
{
result = new RecPayRecordSvc().UpdIERP(a, recPayRecord.RP_GUID, check, recPayRecord.Mark, recPayRecord.RP_Flag, recPayRecord.InvTypeDts);
}
}
if (Convert.ToDecimal(SumAmount) < Convert.ToDecimal(DisAmount))
{
recPayRecord.Record = "已销账";
recPayRecord.DisAmount1 = 0;
check = "MORE";
foreach (var a in temp)
{
result = new RecPayRecordSvc().UpdIERP(a, recPayRecord.RP_GUID, check, recPayRecord.Mark, recPayRecord.RP_Flag, recPayRecord.InvTypeDts);
}
if (result)
{
result = new RecPayRecordSvc().UpdIERPMore(recPayRecord, SumAmount, DisAmount);
}
}
result = new RecPayRecordSvc().UpdRecpayType(recPayRecord);
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 UpRecPayType(string id, string ieguid, string type, Decimal SumAmount)
{
bool result = false;
ExceResult res = new ExceResult();
string msg = string.Empty;
T_RecPayRecord rec = new T_RecPayRecord();
rec.Record = "已销账";
rec.RP_Flag = "P";
rec.IE_GUID = ieguid;
rec.RP_GUID = id;
rec.SumAmount = SumAmount;
rec.C_GUID = Session["CurrentCompanyGuid"].ToString();
switch (type)
{
case "归还短期借款所支付的款":
rec.InvType = "筹资活动付款";
rec.InvTypeDts = "归还短期借款所支付的款";
rec.CFItemGuid = "DD7BCD86-150E-4E62-B6CC-21EF341B41F1";
break;
case "归还长期借款所支付的款":
rec.InvType = "筹资活动付款";
rec.InvTypeDts = "归还长期借款所支付的款";
rec.CFItemGuid = "DD7BCD86-150E-4E62-B6CC-21EF341B41F1";
break;
case "营业成本":
rec.InvType = "经营活动付款";
rec.InvTypeDts = "购买商品、接受服务所支付的款";
rec.CFItemGuid = "0526C862-F238-4301-A198-E7EC83A645D5";
break;
case "销售费用":
rec.InvType = "经营活动付款";
rec.InvTypeDts = "支付销售费用";
rec.CFItemGuid = "DE7D81B9-680B-4011-A771-C8B327A549E7";
break;
case "管理费用":
rec.InvType = "经营活动付款";
rec.InvTypeDts = "支付管理费用";
rec.CFItemGuid = "DE7D81B9-680B-4011-A771-C8B327A549E7";
break;
case "财务费用":
rec.InvType = "经营活动付款";
rec.InvTypeDts = "支付财务费用";
rec.CFItemGuid = "DE7D81B9-680B-4011-A771-C8B327A549E7";
break;
case "工资成本":
rec.InvType = "经营活动付款";
rec.InvTypeDts = "支付职工或为职工支付的款";
rec.CFItemGuid = "70765251-FA58-432F-BCC5-122EF3581102";
break;
case "税费":
rec.InvType = "经营活动付款";
rec.InvTypeDts = "支付的各项税费";
rec.CFItemGuid = "E4F16AB4-8DFE-42E1-8A7F-0CB342CF9C73";
break;
case "预付供应商账款":
rec.InvType = "经营活动付款";
rec.InvTypeDts = "预付供应商账款";
rec.CFItemGuid = "DE7D81B9-680B-4011-A771-C8B327A549E7";
break;
case "支付押金":
rec.InvType = "经营活动付款";
rec.InvTypeDts = "支付押金";
rec.CFItemGuid = "DE7D81B9-680B-4011-A771-C8B327A549E7";
break;
case "支付暂支借款":
rec.InvType = "经营活动付款";
rec.InvTypeDts = "支付暂支借款";
rec.CFItemGuid = "DE7D81B9-680B-4011-A771-C8B327A549E7";
break;
case "短期投资支出":
rec.InvType = "投资活动付款";
rec.InvTypeDts = "短期投资支出";
rec.CFItemGuid = "049F1C6D-49EA-4E2D-93FD-2DABEBED666C";
break;
case "长期债券投资支出":
rec.InvType = "投资活动付款";
rec.InvTypeDts = "长期债券投资支出";
rec.CFItemGuid = "049F1C6D-49EA-4E2D-93FD-2DABEBED666C";
break;
case "长期股权投资支出":
rec.InvType = "投资活动付款";
rec.InvTypeDts = "长期股权投资支出";
rec.CFItemGuid = "049F1C6D-49EA-4E2D-93FD-2DABEBED666C";
break;
case "购买固定资产所支付的款":
rec.InvType = "投资活动付款";
rec.InvTypeDts = "购买固定资产所支付的款";
rec.CFItemGuid = "EA46CFA0-5D41-4FF1-9BF8-9A36CB8F1F11";
break;
case "购买无形资产所支付的款":
rec.InvType = "投资活动付款";
rec.InvTypeDts = "购买无形资产所支付的款";
rec.CFItemGuid = "EA46CFA0-5D41-4FF1-9BF8-9A36CB8F1F11";
break;
case "购买其他长期资产所支付的款":
rec.InvType = "投资活动付款";
rec.InvTypeDts = "购买其他长期资产所支付的款";
rec.CFItemGuid = "EA46CFA0-5D41-4FF1-9BF8-9A36CB8F1F11";
break;
case "直接物料采购":
rec.InvType = "经营活动付款";
rec.InvTypeDts = "购买商品、接受服务所支付的款";
rec.CFItemGuid = "0526C862-F238-4301-A198-E7EC83A645D5";
break;
case "间接物料采购":
rec.InvType = "经营活动付款";
rec.InvTypeDts = "购买商品、接受服务所支付的款";
rec.CFItemGuid = "0526C862-F238-4301-A198-E7EC83A645D5";
break;
case "分配股利、利润":
rec.InvType = "筹资活动付款";
rec.InvTypeDts = "分配股利、利润的款";
rec.CFItemGuid = "5BDE7476-F268-4A62-8CC3-D426D51E253D";
break;
default:
break;
}
//if (type == "税费") {
// result = new RecPayRecordSvc().UpdRecpayType(rec);
//}
result = new RecPayRecordSvc().UpRecPayType(rec);
if (result)
{
res.success = true;
msg = General.Resource.Common.Success;
}
else
{
res.success = false;
msg = General.Resource.Common.Failed;
}
return(JsonConvert.SerializeObject(res));
}
public string UpdPayInyType(List <T_RecPayRecord> payList, string SumAmount, string DisAmount)
{
//typedts = typedts + ";" + typedtsdts;
bool result = false;
string msg = string.Empty;
foreach (T_RecPayRecord recPayRecord in payList)
{
recPayRecord.RP_Flag = "R";
switch (recPayRecord.InvTypeDts)
{
case "销售商品/提供服务的收款":
recPayRecord.CFItemGuid = "97B181C8-D807-4BF0-8D8D-B23273E7FEFE";
recPayRecord.SubjectName = "应收账款";
break;
case "预收客户账款":
recPayRecord.CFItemGuid = "F6330595-F588-46B0-8998-752C7A1D774B";
recPayRecord.SubjectName = "预收账款";
break;
case "收回公司支出的暂支借款":
recPayRecord.CFItemGuid = "F6330595-F588-46B0-8998-752C7A1D774B";
recPayRecord.SubjectName = "备用金";
break;
case "收回公司支出的押金":
recPayRecord.CFItemGuid = "97B181C8-D807-4BF0-8D8D-B23273E7FEFE";
recPayRecord.SubjectName = "其他应付款";
break;
case "收到的其它公司支付的押金":
recPayRecord.CFItemGuid = "97B181C8-D807-4BF0-8D8D-B23273E7FEFE";
recPayRecord.SubjectName = "其他应付款";
break;
case "取得投资收益的利息的收款":
recPayRecord.CFItemGuid = "C55B2A4E-129B-407B-AC0B-14C091587D45";
recPayRecord.SubjectName = "应收利息";
break;
case "取得投资收益的股利的收款":
recPayRecord.CFItemGuid = "C55B2A4E-129B-407B-AC0B-14C091587D45";
recPayRecord.SubjectName = "应收股利";
break;
case "收回短期投资的本金金额内的款":
recPayRecord.CFItemGuid = "496F9D4D-F71B-437A-9EA0-26107D3449C3";
recPayRecord.SubjectName = "短期投资";
break;
case "收回长期债券投资的本金金额内的款":
recPayRecord.CFItemGuid = "496F9D4D-F71B-437A-9EA0-26107D3449C3";
recPayRecord.SubjectName = "长期债券投资";
break;
case "收回长期股权投资的本金金额内的款":
recPayRecord.CFItemGuid = "496F9D4D-F71B-437A-9EA0-26107D3449C3";
recPayRecord.SubjectName = "长期股权投资";
break;
case "处置固定资产所收回的款":
recPayRecord.CFItemGuid = "56B5FE80-EE8D-4E52-A2E8-8EE9A5F5BB73";
recPayRecord.SubjectName = "固定资产";
break;
case "处置无形资产所收回的款":
recPayRecord.CFItemGuid = "56B5FE80-EE8D-4E52-A2E8-8EE9A5F5BB73";
recPayRecord.SubjectName = "无形资产";
break;
case "处置其他长期资产所收回的款":
recPayRecord.CFItemGuid = "56B5FE80-EE8D-4E52-A2E8-8EE9A5F5BB73";
recPayRecord.SubjectName = "其他长期资产";
break;
case "收到的其他与投资活动有关的款":
recPayRecord.CFItemGuid = "0D3AED4A-0904-450B-9919-A952CD2E9534";
recPayRecord.SubjectName = "";
break;
case "吸收投资的收款(注册资本金额以内部分)":
recPayRecord.CFItemGuid = "77A24D5F-3E0C-4211-A552-191FEE0E06FD";
recPayRecord.SubjectName = "实收资本";
break;
case "吸收投资的收款(超出注册资本金额部分)":
recPayRecord.CFItemGuid = "77A24D5F-3E0C-4211-A552-191FEE0E06FD";
recPayRecord.SubjectName = "资本公积";
break;
case "短期借款所获得的收款":
recPayRecord.CFItemGuid = "AD2E5437-0917-43E1-807C-41CA6751360F";
recPayRecord.SubjectName = "短期借款";
break;
case "长期借款所获得的收款":
recPayRecord.CFItemGuid = "AD2E5437-0917-43E1-807C-41CA6751360F";
recPayRecord.SubjectName = "长期借款";
break;
case "收到的其他与筹资活动有关的款":
recPayRecord.CFItemGuid = "97B181C8-D807-4BF0-8D8D-B23273E7FEFE";
recPayRecord.SubjectName = "";
break;
case "营业外收入的收款":
recPayRecord.CFItemGuid = "F6330595-F588-46B0-8998-752C7A1D774B";
recPayRecord.SubjectName = "应收账款";
break;
case "其他业务收入的收款":
recPayRecord.CFItemGuid = "F6330595-F588-46B0-8998-752C7A1D774B";
recPayRecord.SubjectName = "应收账款";
break;
case "收到的税费返还":
recPayRecord.CFItemGuid = "E90ABB77-27D2-48D7-9A20-6F8862F0BE11";
recPayRecord.SubjectName = "应收账款";
break;
case "":
break;
}
string check = null;
string[] temp = recPayRecord.IE_GUID.Split(new char[] { ',' });
if (Convert.ToDecimal(SumAmount) == Convert.ToDecimal(DisAmount))
{
recPayRecord.Record = "已销账";
recPayRecord.DisAmount1 = 0;
check = "EQ";
foreach (var a in temp)
{
result = new RecPayRecordSvc().UpdIERP(a, recPayRecord.RP_GUID, check, recPayRecord.Mark, recPayRecord.RP_Flag, recPayRecord.InvTypeDts);
}
}
if (Convert.ToDecimal(SumAmount) > Convert.ToDecimal(DisAmount))
{
recPayRecord.Record = "未销账";
recPayRecord.DisAmount1 = Convert.ToDecimal(SumAmount) - Convert.ToDecimal(DisAmount);
check = "LESS";
foreach (var a in temp)
{
result = new RecPayRecordSvc().UpdIERP(a, recPayRecord.RP_GUID, check, recPayRecord.Mark, recPayRecord.RP_Flag, recPayRecord.InvTypeDts);
}
}
if (Convert.ToDecimal(SumAmount) < Convert.ToDecimal(DisAmount))
{
recPayRecord.Record = "已销账";
recPayRecord.DisAmount1 = 0;
recPayRecord.RP_Flag = "R";
check = "MORE";
foreach (var a in temp)
{
result = new RecPayRecordSvc().UpdIERP(a, recPayRecord.RP_GUID, check, recPayRecord.Mark, recPayRecord.RP_Flag, recPayRecord.InvTypeDts);
}
if (result)
{
result = new RecPayRecordSvc().UpdIERPMore(recPayRecord, SumAmount, DisAmount);
}
}
result = new RecPayRecordSvc().UpdRecpayType(recPayRecord);
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 UpRecPayType(string id, string ieguid, string type, Decimal Amount, string detailType)
{
bool result = false;
ExceResult res = new ExceResult();
string msg = string.Empty;
T_RecPayRecord rec = new T_RecPayRecord();
rec.Record = "已销账";
rec.RP_Flag = "R";
rec.IE_GUID = ieguid;
rec.RP_GUID = id;
rec.SumAmount = Amount;
switch (type)
{
case "主营业务收入":
rec.InvType = "经营活动收款";
rec.InvTypeDts = "销售商品/提供服务的收款";
rec.CFItemGuid = "97B181C8-D807-4BF0-8D8D-B23273E7FEFE";
break;
case "营业外收入":
rec.InvType = "经营活动收款";
rec.InvTypeDts = "营业外收入的收款";
rec.CFItemGuid = "E90ABB77-27D2-48D7-9A20-6F8862F0BE11";
break;
case "其他业务收入":
rec.InvType = "经营活动收款";
rec.InvTypeDts = "其他业务收入的收款";
rec.CFItemGuid = "E90ABB77-27D2-48D7-9A20-6F8862F0BE11";
break;
case "投资收益 ":
switch (detailType)
{
case "利息":
rec.InvType = "投资活动收款";
rec.InvTypeDts = "取得投资收益的利息的收款";
rec.CFItemGuid = "C55B2A4E-129B-407B-AC0B-14C091587D45";
break;
case "股利":
rec.InvType = "投资活动收款";
rec.InvTypeDts = "取得投资收益的股利的收款";
rec.CFItemGuid = "C55B2A4E-129B-407B-AC0B-14C091587D45";
break;
default:
break;
}
break;
case "收回公司支出的暂支借款":
rec.InvType = "经营活动收款";
rec.InvTypeDts = "收回公司支出的暂支借款";
rec.CFItemGuid = "F6330595-F588-46B0-8998-752C7A1D774B";
break;
case "预收客户账款":
rec.InvType = "经营活动收款";
rec.InvTypeDts = "预收客户账款";
rec.CFItemGuid = "F6330595-F588-46B0-8998-752C7A1D774B";
break;
case "收回公司支出的押金":
rec.InvType = "经营活动收款";
rec.InvTypeDts = "收回公司支出的押金";
rec.CFItemGuid = "97B181C8-D807-4BF0-8D8D-B23273E7FEFE";
break;
case "收到的其他公司支付的押金":
rec.InvType = "经营活动收款";
rec.InvTypeDts = "收到的其它公司支付的押金";
rec.CFItemGuid = "97B181C8-D807-4BF0-8D8D-B23273E7FEFE";
break;
case "收取投资款(注册资本金额以内部分)":
rec.InvType = "筹资活动收款";
rec.InvTypeDts = "吸收投资的收款(注册资本金额以内部分)";
rec.CFItemGuid = "77A24D5F-3E0C-4211-A552-191FEE0E06FD";
break;
case "收取投资款(超出注册资本金额部分)":
rec.InvType = "筹资活动收款";
rec.InvTypeDts = "吸收投资的收款(超出注册资本金额部分)";
rec.CFItemGuid = "77A24D5F-3E0C-4211-A552-191FEE0E06FD";
break;
case "短期借款所获得的收款":
rec.InvType = "筹资活动收款";
rec.InvTypeDts = "短期借款所获得的收款";
rec.CFItemGuid = "AD2E5437-0917-43E1-807C-41CA6751360F";
break;
case "长期借款所获得的收款":
rec.InvType = "筹资活动收款";
rec.InvTypeDts = "长期借款所获得的收款";
rec.CFItemGuid = "AD2E5437-0917-43E1-807C-41CA6751360F";
break;
case "收回短期投资的本金金额内的款":
rec.InvType = "投资活动收款";
rec.InvTypeDts = "收回短期投资的本金金额内的款";
rec.CFItemGuid = "496F9D4D-F71B-437A-9EA0-26107D3449C3";
break;
case "收回长期债券投资的本金金额内的款":
rec.InvType = "投资活动收款";
rec.InvTypeDts = "收回长期债券投资的本金金额内的款";
rec.CFItemGuid = "496F9D4D-F71B-437A-9EA0-26107D3449C3";
break;
case "收回长期股权投资的本金金额内的款":
rec.InvType = "投资活动收款";
rec.InvTypeDts = "收回长期股权投资的本金金额内的款";
rec.CFItemGuid = "496F9D4D-F71B-437A-9EA0-26107D3449C3";
break;
default:
break;
}
result = new RecPayRecordSvc().UpRecPayType(rec);
if (result)
{
res.success = true;
msg = General.Resource.Common.Success;
}
else
{
res.success = false;
msg = General.Resource.Common.Failed;
}
return(JsonConvert.SerializeObject(res));
}
/// <summary>
/// 归类
/// </summary>
/// <param name="id">付款纪录标识</param>
/// <param name="invtype">归类类型</param>
/// <returns></returns>
public string UpdPayInyType(string id, string invtype, string typedts, string cfitemguid, string ieguid, string record)
{
//typedts = typedts + ";" + typedtsdts;
switch (typedts)
{
case "销售商品/提供服务的收款":
cfitemguid = "97B181C8-D807-4BF0-8D8D-B23273E7FEFE";
break;
case "押金返还、暂支还款":
cfitemguid = "F6330595-F588-46B0-8998-752C7A1D774B";
break;
case "收到经营活动有关的客户预付款":
cfitemguid = "F6330595-F588-46B0-8998-752C7A1D774B";
break;
case "收到的税费返还":
cfitemguid = "0526C862-F238-4301-A198-E7EC83A6445B";
break;
case "收回投资所收到的款":
cfitemguid = "2B86C862-F238-4301-A198-E7EC83A645D5";
break;
case "取得投资收益的收款":
cfitemguid = "0526C862-F238-4301-A198-E7EC83A66b8C";
break;
case "处置固定资产、无形资产和其他长期资产所收回的款":
cfitemguid = "0526C862-F238-4301-A198-E7EC83A645D5";
break;
case "吸取投资的收款":
cfitemguid = "77A24D5F-3E0C-4211-A552-191FEE0E06FD";
break;
case "借款所获得的收款":
cfitemguid = "AD2E5437-0917-43E1-807C-41CA6751360F";
break;
case "其他与筹资活动有关的收款":
cfitemguid = "106B9F2C-24A5-48B5-9621-418D00A7A75A";
break;
case "":
break;
}
bool result = new RecPayRecordSvc().UpdInvType("R", id, invtype, typedts, cfitemguid, ieguid, record);
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));
}
