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)); }
/// <summary> /// 更新收/付款纪录 /// </summary> /// <param name="rec">收付款纪录对象</param> /// <returns></returns> private bool UpdRecPayRecord(T_RecPayRecord rec) { DBHelper dh = new DBHelper(); dh.strCmd = "SP_UpdRecPayRecord"; dh.AddPare("@ID", SqlDbType.NVarChar, 40, rec.RP_GUID); dh.AddPare("@Flag", SqlDbType.NVarChar, 1, rec.RP_Flag); dh.AddPare("@InvType", SqlDbType.NVarChar, 20, rec.InvType); dh.AddPare("@InvTypeDts", SqlDbType.NVarChar, 50, rec.InvTypeDts); dh.AddPare("@InvNo", SqlDbType.NVarChar, 20, rec.InvNo); dh.AddPare("@R_Per", SqlDbType.NVarChar, 40, rec.RPer); dh.AddPare("@DLA", SqlDbType.NVarChar, 40, rec.DebitLedgerAccount); dh.AddPare("@DDA", SqlDbType.NVarChar, 40, rec.DebitDetailsAccount); dh.AddPare("@CLA", SqlDbType.NVarChar, 40, rec.CreditLedgerAccount); dh.AddPare("@CDA", SqlDbType.NVarChar, 40, rec.CreditDetailsAccount); dh.AddPare("@Amount", SqlDbType.Decimal, 0, rec.SumAmount); dh.AddPare("@Date", SqlDbType.Date, 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, rec.CreateDate); dh.AddPare("@C_GUID", SqlDbType.NVarChar, 50, rec.C_GUID); dh.AddPare("@RPable", SqlDbType.NVarChar, 40, rec.RPable); dh.AddPare("@Currency", SqlDbType.NVarChar, 5, rec.Currency); dh.AddPare("@CFItemGuid", SqlDbType.NVarChar, 40, rec.CFItemGuid); dh.AddPare("@CFPItemGuid", SqlDbType.NVarChar, 40, rec.CFPItemGuid); dh.AddPare("@B_GUID", SqlDbType.NVarChar, 40, rec.B_GUID); dh.AddPare("@BA_GUID", SqlDbType.NVarChar, 40, rec.BA_GUID); dh.AddPare("@IE_GUID", SqlDbType.NVarChar, 40, rec.IE_GUID); try { dh.NonQuery(); return true; } catch { return false; } }
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 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="rec">付款纪录对象</param> /// <returns></returns> public string UpdReceivablesRecordDts(string id, string name, DateTime date, decimal money, string remark, string currency, string bank, string bankaccount, string ieguid, string addstyle) { bool result = false; string msg = string.Empty; T_RecPayRecord recPayRecord = new T_RecPayRecord(); recPayRecord.Creator = base.userData.LoginFullName; recPayRecord.C_GUID = Session["CurrentCompany"].ToString(); recPayRecord.RP_GUID = id; //recPayRecord.RPer = (new BusinessPartnerSvc().GetPartnersDts(Session["CurrentCompany"].ToString(), name)).ToString(); recPayRecord.RPer = name; recPayRecord.Date = date.Date; recPayRecord.SumAmount = money; recPayRecord.Remark = remark; recPayRecord.Currency = currency; recPayRecord.B_GUID = bank; recPayRecord.BA_GUID = bankaccount; if (addstyle == "收入获取" || addstyle == "收入计入收款") { recPayRecord.IE_GUID = ieguid; recPayRecord.InvType = "经营活动收款"; recPayRecord.InvTypeDts = "销售商品/提供服务的收款"; recPayRecord.CFItemGuid = "97B181C8-D807-4BF0-8D8D-B23273E7FEFE"; } if (addstyle == "直接新增") { recPayRecord.IE_GUID = null; recPayRecord.InvType = "未归账"; } if (addstyle == "预收客户款") { recPayRecord.IE_GUID = ieguid; recPayRecord.InvType = "经营活动收款"; recPayRecord.InvTypeDts = "收到的其他与经营活动有关的款客户预付、押金返还、暂支还款等;预付客户款"; recPayRecord.CFItemGuid = "F6330595-F588-46B0-8998-752C7A1D774B"; } if (addstyle == "押金与暂支付款") { recPayRecord.IE_GUID = ieguid; recPayRecord.InvType = "经营活动收款"; recPayRecord.InvTypeDts = "收到的其他与经营活动有关的款客户预付、押金返还、暂支还款等;押金与暂支付款"; recPayRecord.CFItemGuid = "F6330595-F588-46B0-8998-752C7A1D774B"; } if (addstyle == "吸取投资") { recPayRecord.IE_GUID = ieguid; recPayRecord.InvType = "筹资活动收款"; recPayRecord.InvTypeDts = "吸取投资的收款"; recPayRecord.CFItemGuid = "77A24D5F-3E0C-4211-A552-191FEE0E06FD"; } if (addstyle == "借款") { recPayRecord.IE_GUID = ieguid; recPayRecord.InvType = "筹资活动收款"; recPayRecord.InvTypeDts = "借款所获得的收款"; recPayRecord.CFItemGuid = "AD2E5437-0917-43E1-807C-41CA6751360F"; } if (addstyle == "其他与筹资活动有关的收款") { recPayRecord.IE_GUID = ieguid; recPayRecord.InvType = "筹资活动收款"; recPayRecord.InvTypeDts = "收到的其他与筹资活动有关的款"; recPayRecord.CFItemGuid = "106B9F2C-24A5-48B5-9621-418D00A7A75A"; } recPayRecord.CreateDate = DateTime.Now; DateTime EditThreshold = DateTime.Parse(Session["EditThreshold"].ToString()); if (recPayRecord.Date <= DateTime.Now && recPayRecord.Date >= EditThreshold) { result = new RecPayRecordSvc().UpdReceivablesRecord(recPayRecord); 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 UpdPaymentRecord(T_RecPayRecord rec) { rec.RP_Flag = "P"; return UpdRecPayRecord(rec); }
/// <summary> /// 更新收款纪录 /// </summary> /// <param name="rec">收付款纪录对象</param> /// <returns></returns> public bool UpdReceivablesRecord(T_RecPayRecord rec) { rec.RP_Flag = "R"; return UpdRecPayRecord(rec); }
public ActionResult ImportExecl(HttpPostedFileBase fileData, string guid, string number = null) { List <T_RecPayRecord> payList = new List <T_RecPayRecord>(); T_RecPayRecord rec = new T_RecPayRecord(); ExceResult res = new ExceResult(); res.success = true; var files = Request.Files; string result = string.Empty; JsonResult json = new JsonResult(); if (files == null && files.Count == 0) { res.success = false; res.msg = "无有效文件"; } Workbook workbook = new Workbook(Request.Files[0].InputStream); Cells cells = workbook.Worksheets[0].Cells; DataTable tab = cells.ExportDataTable(0, 0, cells.Rows.Count, cells.MaxDisplayRange.ColumnCount); int rowsnum = tab.Rows.Count; if (rowsnum == 0) { res.success = false; result = "Excel表为空!请重新导入!";//当Excel表为空时,对用户进行提示 } //数据表一共多少行! DataRow[] dr = tab.Select(); //按行进行数据存储操作! for (int i = 1; i < dr.Length; i++) { T_BankAccount ba = new T_BankAccount(); string rper; //RPer,B_Guid,BA_Guid数据需要比对! try { ba = new BankAccountSvc().GetBankDt(Session["CurrentCompanyGuid"].ToString(), dr[i][0].ToString()); } catch { result = "导入失败,无此银行账号"; break; } //string baguid = (new BankAccountSvc().GetBankAccountDts(Session["CurrentCompanyGuid"].ToString(), bguid, dr[i][5].ToString())).ToString(); try { rper = (new BusinessPartnerSvc().GetPartnersDts(Session["CurrentCompanyGuid"].ToString(), dr[i][2].ToString())).ToString(); } catch { result = "导入失败,无此客户"; break; } try { string currency = (new CurrencySvc().GetCurrency(dr[i][1].ToString())).ToString(); } catch (Exception) { result = "导入失败,无此货币"; break; } if (dr[i][4].ToString().CompareTo(GetNowDate()) > 0) { result = "导入失败,时间错误"; break; } //rec.RP_GUID = Guid.NewGuid().ToString(); //rec.RP_Flag = "P"; //rec.R_PerName = dr[i][2].ToString(); //rec.B_GUID = dr[i][0].ToString(); //rec.C_GUID = Session["CurrentCompanyGuid"].ToString(); //rec.InvType = dr[i][5].ToString(); //rec.InvTypeDts = dr[i][6].ToString(); //rec.CreateDate = GetDetailDate(); //rec.Creator = base.userData.LoginFullName; //rec.Currency = dr[i][1].ToString(); //rec.Record = "未归账"; //payList.Add(rec); //ViewBag.payList = payList; //result = "导入成功!"; string CFItemGuid = null; string cguid = Session["CurrentCompanyGuid"].ToString(); string creator = base.userData.LoginFullName; DateTime createdate = DateTime.Now; switch (dr[i][6].ToString()) { case "销售商品/提供服务的收款": CFItemGuid = "97B181C8-D807-4BF0-8D8D-B23273E7FEFE"; break; case "押金返还、暂支还款": CFItemGuid = "F6330595-F588-46B0-8998-752C7A1D735A"; break; case "收到经营活动有关的客户预付款": CFItemGuid = "F6330595-F588-46B0-8998-752C7A1D774B"; break; case "收到的税费返还": CFItemGuid = "E90ABB77-27D2-48D7-9A20-6F8862F0BE11"; break; case "收回投资所收到的款": CFItemGuid = "496F9D4D-F71B-437A-9EA0-26107D3449C3"; break; case "取得投资收益的收款": CFItemGuid = "C55B2A4E-129B-407B-AC0B-14C091587D45"; break; case "处置固定资产、无形资产和其他长期资产所收回的款": CFItemGuid = "56B5FE80-EE8D-4E52-A2E8-8EE9A5F5BB73"; 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; } DBHelper dh = new DBHelper(); dh.strCmd = "SP_UpdRecPayRecord"; dh.AddPare("@ID", SqlDbType.NVarChar, 40, Guid.NewGuid().ToString()); dh.AddPare("@Flag", SqlDbType.NVarChar, 1, "R"); dh.AddPare("@R_Per", SqlDbType.NVarChar, 40, rper); dh.AddPare("@Date", SqlDbType.Date, 0, dr[i][4].ToString()); dh.AddPare("@Amount", SqlDbType.Decimal, 0, dr[i][3].ToString()); dh.AddPare("@Currency", SqlDbType.NVarChar, 40, dr[i][1].ToString()); dh.AddPare("@B_Guid", SqlDbType.NVarChar, 40, ba.B_GUID); dh.AddPare("@BA_Guid", SqlDbType.NVarChar, 40, ba.BA_GUID); dh.AddPare("@Remark", SqlDbType.NVarChar, 40, null); dh.AddPare("@CFItemGuid", SqlDbType.NVarChar, 40, CFItemGuid); dh.AddPare("@Creator", SqlDbType.NVarChar, 40, creator); dh.AddPare("@CreateDate", SqlDbType.DateTime, 0, createdate); dh.AddPare("@C_GUID", SqlDbType.NVarChar, 50, cguid); dh.AddPare("@InvType", SqlDbType.NVarChar, 20, dr[i][5].ToString()); dh.AddPare("@InvTypeDts", SqlDbType.NVarChar, 50, dr[i][6].ToString()); dh.AddPare("@Record", SqlDbType.NVarChar, 50, "未销账"); try { dh.NonQuery(); result = "导入成功!"; } catch (Exception) { result = "导入失败,请检查EXCEL格式是否错误!"; } } string pay = new JavaScriptSerializer().Serialize(payList); json.Data = result; return(json); }
/// <summary> /// 更新付款纪录 /// </summary> /// <param name="rec">付款纪录对象</param> /// <returns></returns> public string UpdPaymentRecordDts(string id, string name, DateTime date, decimal money, string remark, string currency, string bank, string bankaccount, string ieguid, string addstyle) { bool result = false; string msg = string.Empty; T_RecPayRecord recPayRecord = new T_RecPayRecord(); recPayRecord.Creator = base.userData.LoginFullName; recPayRecord.C_GUID = Session["CurrentCompany"].ToString(); recPayRecord.RP_GUID = id; //recPayRecord.RPer = (new BusinessPartnerSvc().GetPartnersDts(Session["CurrentCompany"].ToString(), name)).ToString(); recPayRecord.RPer = name; recPayRecord.Date = date.Date; recPayRecord.SumAmount = money; recPayRecord.Remark = remark; recPayRecord.Currency = currency; recPayRecord.B_GUID = bank; recPayRecord.BA_GUID = bankaccount; if (addstyle == "费用获取") { recPayRecord.IE_GUID = ieguid; recPayRecord.InvType = "经营活动付款"; recPayRecord.InvTypeDts = "购买商品、接受服务所支付的款"; recPayRecord.CFItemGuid = "0526C862-F238-4301-A198-E7EC83A645D5"; } if (addstyle == "工资表获取") { recPayRecord.IE_GUID = ieguid; recPayRecord.InvType = "经营活动付款"; recPayRecord.InvTypeDts = "支付职工或为职工支付的款"; recPayRecord.CFItemGuid = "70765251-FA58-432F-BCC5-122EF3581102"; } if (addstyle == "直接新增") { recPayRecord.IE_GUID = null; recPayRecord.InvType = "未归账"; } if (addstyle == "预付供应商" || addstyle == "支付押金和暂支借款") { recPayRecord.IE_GUID = ieguid; recPayRecord.InvType = "经营活动付款"; recPayRecord.InvTypeDts = "支付的其他与经营活动有关的款预付供应商、支付押金、暂支款等"; recPayRecord.CFItemGuid = "DE7D81B9-680B-4011-A771-C8B327A549E7"; } if (addstyle == "投资支出") { recPayRecord.IE_GUID = ieguid; recPayRecord.InvType = "投资活动付款"; recPayRecord.InvTypeDts = "投资所支付的款"; recPayRecord.CFItemGuid = "049F1C6D-49EA-4E2D-93FD-2DABEBED666C"; } if (addstyle == "直接物料采购" || addstyle == "间接物料采购" || addstyle == "资产采购") { recPayRecord.IE_GUID = ieguid; recPayRecord.InvType = "投资活动付款"; recPayRecord.InvTypeDts = "购买固定资产、无形资产和其他长期资产所支付的款"; recPayRecord.CFItemGuid = "EA46CFA0-5D41-4FF1-9BF8-9A36CB8F1F11"; } recPayRecord.CreateDate = DateTime.Now; DateTime EditThreshold = DateTime.Parse(Session["EditThreshold"].ToString()); if (recPayRecord.Date <= DateTime.Now && recPayRecord.Date >= EditThreshold) { result = new RecPayRecordSvc().UpdPaymentRecord(recPayRecord); 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)); }