public string GetBankInformation() { List <T_BankAccount> bankAccount2 = new BankAccountSvc().GetBankAccount(Session["CurrentCompanyGuid"].ToString()); string json = new JavaScriptSerializer().Serialize(bankAccount2); return(json); }
/// <summary> /// 更新银行信息 /// </summary> /// <param name="Company">银行对象</param> /// <returns></returns> public string UpdBankInformation(List <T_BankAccount> bankItems) { string msg = string.Empty; bool result = false; BankAccountSvc bankAccount = new BankAccountSvc(); foreach (T_BankAccount account in bankItems) { if (string.IsNullOrEmpty(account.BA_GUID)) { account.BA_GUID = Guid.NewGuid().ToString(); } account.C_GUID = Session["CurrentCompanyGuid"].ToString(); account.AccountType = string.Empty; result = bankAccount.UpdBankAccount(account); } msg = General.Resource.Common.Success; return(string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}" , result.ToString().ToLower(), msg)); }
/// <summary> /// 更新商业伙伴信息 /// </summary> /// <param name="Company">商业伙伴对象</param> /// <returns></returns> public string UpdCompanyInformation(T_Company information, List <T_BankAccount> bankItems) { information.C_GUID = Session["CurrentCompanyGuid"].ToString(); bool result = new CompanySvc().UpdCompanyInformation(information); string msg = string.Empty; if (result) { Session["Taxpayer"] = information.Taxpayer; BankAccountSvc bankAccount = new BankAccountSvc(); if (bankItems != null) { foreach (T_BankAccount account in bankItems) { if (string.IsNullOrEmpty(account.BA_GUID)) { account.BA_GUID = Guid.NewGuid().ToString(); } account.C_GUID = Session["CurrentCompanyGuid"].ToString(); //account.AccountType = string.Empty; bankAccount.UpdBankAccount(account); } } 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> public string GetBankAccountCurrency(string id) { string C_GUID = Session["CurrentCompanyGuid"].ToString(); List <T_BankAccount> Record = new List <T_BankAccount>(); Record = new BankAccountSvc().GetBankCurreny(id, C_GUID); return(new JavaScriptSerializer().Serialize(Record)); }
/// <summary> /// 列表页 /// </summary> /// <returns></returns> public ActionResult Index() { //new BalanceSvc().GetInitialBalanceRecord(Session["CurrentCompanyGuid"].ToString()).FirstOrDefault(); List <T_BankAccount> bankAccount2 = new BankAccountSvc().GetBankAccount(Session["CurrentCompanyGuid"].ToString()); ViewBag.BankList2 = bankAccount2; List <T_BeginningBalance> balanceList = new BalanceSvc().GetInitialBalanceRecord(Session["CurrentCompanyGuid"].ToString(), null); ViewBag.balanceList = balanceList; return(View()); }
/// <summary> /// 列表页 /// </summary> /// <returns></returns> public ActionResult Index() { List <T_BankAccount> bankAccount1 = new BankAccountSvc().GetBankAccount(Session["CurrentCompanyGuid"].ToString()); ViewBag.BankList1 = bankAccount1; ViewBag.CompanyInfo = new CompanySvc().GetCompanyInformation(Session["CurrentCompanyGuid"].ToString()).FirstOrDefault(); ViewData["CompanyName"] = (new CompanySvc().GetCompanyInformation(Session["CurrentCompanyGuid"].ToString()).FirstOrDefault()).Name; ViewData["C_GUID"] = Session["CurrentCompanyGuid"].ToString(); ViewData["LoginName"] = Session["LoginName"]; return(View(new CompanySvc().GetCompanyInformation(Session["CurrentCompanyGuid"].ToString()).FirstOrDefault())); }
/// <summary> /// 删除账号信息 /// </summary> /// <param name="id">账号标识</param> /// <returns></returns> public string DelBankAccount(string id) { bool result = new BankAccountSvc().DelBankAccount(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="bankAccount">账号信息对象</param> /// <returns></returns> public string UpdBankAccount(T_BankAccount bankAccount) { bankAccount.C_GUID = Session["CurrentCompany"].ToString(); bool result = new BankAccountSvc().UpdBankAccount(bankAccount); 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="partner">商业伙伴对象</param> /// <returns></returns> public string UpdPartner(T_BusinessPartner partner, List <T_BankAccount> bankItems) { partner.C_GUID = Session["CurrentCompanyGuid"].ToString(); if (string.IsNullOrEmpty(partner.BP_GUID)) { partner.BP_GUID = Guid.NewGuid().ToString(); } bool result = new BusinessPartnerSvc().UpdPartner(partner); string msg = string.Empty; if (result) { //增加银行信息 BankAccountSvc bankAccount = new BankAccountSvc(); if (bankItems != null) { foreach (T_BankAccount account in bankItems) { if (string.IsNullOrEmpty(account.BA_GUID)) { account.BA_GUID = Guid.NewGuid().ToString(); } account.C_GUID = partner.BP_GUID; account.AccountType = string.Empty; bankAccount.UpdBankAccount(account); } } msg = General.Resource.Common.Success; } else { msg = General.Resource.Common.Failed; } ResultModel rs = new ResultModel(); rs.Result = result.ToString(); rs.Msg = msg; rs.guid = partner.BP_GUID; return(Newtonsoft.Json.JsonConvert.SerializeObject(rs)); //return string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}" // , result.ToString().ToLower(), msg); }
/// <summary> /// 商业伙伴信息页 /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult BusinessPartner(string id) { T_BusinessPartner partner; if (string.IsNullOrEmpty(id)) { partner = new T_BusinessPartner() { BP_GUID = string.Empty }; } else { string C_GUID = Session["CurrentCompanyGuid"].ToString(); partner = new BusinessPartnerSvc().GetPartners(C_GUID, id).FirstOrDefault(); Session["IndustryInvolved"] = partner.IndustryInvolved; //查询往来公司的银行信息 List <T_BankAccount> bankAccount = new BankAccountSvc().GetBankAccount(id); ViewBag.BankList = bankAccount; } return(View(partner)); }
public string UpdInitialBalanceRecord(List <T_BeginningBalance> list, List <T_BankAccount> bankItems) { bool result = false; string msg = string.Empty; foreach (T_BeginningBalance balence in list) { balence.R_GUID = Guid.NewGuid().ToString(); balence.C_GUID = Session["CurrentCompanyGuid"].ToString(); result = new BalanceSvc().UpdateInitialBalanceRecord(balence); } if (result) { BankAccountSvc bankAccount = new BankAccountSvc(); try { foreach (T_BankAccount account in bankItems) { result = bankAccount.UpdBankAmount(account); if (result == false) { return("银行账号期初添加失败"); } } } catch (NullReferenceException) { return("请添加银行账号"); } return("提交成功"); } else { return("提交失败"); } }
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)); }
/// <summary> /// 更新付款纪录 /// </summary> /// <param name="rec">付款纪录对象</param> /// <returns></returns> public string UpdReceivablesRecordDts(List <T_RecPayRecord> payList, string addstyle) { bool result = false; string msg = string.Empty; foreach (T_RecPayRecord recPayRecord in payList) { if (recPayRecord.BA_GUID == null) { recPayRecord.Creator = base.userData.LoginFullName; recPayRecord.C_GUID = Session["CurrentCompanyGuid"].ToString(); recPayRecord.B_GUID = ""; recPayRecord.BA_GUID = ""; recPayRecord.RP_Flag = "R"; } else { recPayRecord.Creator = base.userData.LoginFullName; recPayRecord.C_GUID = Session["CurrentCompanyGuid"].ToString(); T_BankAccount ba = new BankAccountSvc().GetBank(Session["CurrentCompanyGuid"].ToString(), null, recPayRecord.BA_GUID, null); recPayRecord.B_GUID = ba.B_GUID; recPayRecord.BA_GUID = ba.BA_GUID; recPayRecord.RP_Flag = "R"; } //if (recPayRecord.RPType == "0F15C212-A858-4AD5-9B13-E51502994818") //{ // recPayRecord.RPType = "库存现金"; //} //else if (recPayRecord.RPType == "6704EDDF-9D23-41FC-A870-827CE2F4D5DB") //{ // recPayRecord.RPType = "银行存款"; //} //else //{ // recPayRecord.RPType = "其他货币资金"; //} //归账和销账 if (addstyle == "直接新增") { switch (recPayRecord.InvTypeDts) { case "销售商品/提供服务的收款": recPayRecord.CFItemGuid = "97B181C8-D807-4BF0-8D8D-B23273E7FEFE"; switch (recPayRecord.PayCategory) { case "银行存款": recPayRecord.SubjectName = "应收账款"; break; case "库存现金": recPayRecord.SubjectName = "应收账款"; break; case "其他货币资金": recPayRecord.SubjectName = "应收票据"; break; case "": break; } 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 = "F6330595-F588-46B0-8998-752C7A1D774B"; recPayRecord.SubjectName = "其他应付款"; break; case "收到的其它公司支付的押金": recPayRecord.CFItemGuid = "F6330595-F588-46B0-8998-752C7A1D774B"; 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.CFItemGuid = "106B9F2C-24A5-48B5-9621-418D00A7A75A"; recPayRecord.SubjectName = ""; break; case "营业外收入的收款": recPayRecord.CFItemGuid = "F6330595-F588-46B0-8998-752C7A1D774B"; switch (recPayRecord.PayCategory) { case "银行存款": recPayRecord.SubjectName = "应收账款"; break; case "库存现金": recPayRecord.SubjectName = "应收账款"; break; case "其他货币资金": recPayRecord.SubjectName = "应收票据"; break; case "": break; } break; case "其他业务收入的收款": recPayRecord.CFItemGuid = "F6330595-F588-46B0-8998-752C7A1D774B"; switch (recPayRecord.PayCategory) { case "银行存款": recPayRecord.SubjectName = "应收账款"; break; case "库存现金": recPayRecord.SubjectName = "应收账款"; break; case "其他货币资金": recPayRecord.SubjectName = "应收票据"; break; case "": break; } break; case "收到的税费返还": recPayRecord.CFItemGuid = "E90ABB77-27D2-48D7-9A20-6F8862F0BE11"; //recPayRecord.SubjectName = "应收账款"; switch (recPayRecord.PayCategory) { case "银行存款": recPayRecord.SubjectName = "应收账款"; break; case "库存现金": recPayRecord.SubjectName = "应收账款"; break; case "其他货币资金": recPayRecord.SubjectName = "应收票据"; break; case "": break; } break; case "": break; } } if (addstyle == "收入获取") { switch (recPayRecord.InvTypeDts) { case "销售商品/提供服务的收款": recPayRecord.CFItemGuid = "97B181C8-D807-4BF0-8D8D-B23273E7FEFE"; switch (recPayRecord.PayCategory) { case "银行存款": recPayRecord.SubjectName = "应收账款"; break; case "库存现金": recPayRecord.SubjectName = "应收账款"; break; case "其他货币资金": recPayRecord.SubjectName = "应收票据"; break; case "": break; } break; case "营业外收入的收款": recPayRecord.CFItemGuid = "F6330595-F588-46B0-8998-752C7A1D774B"; switch (recPayRecord.PayCategory) { case "银行存款": recPayRecord.SubjectName = "应收账款"; break; case "库存现金": recPayRecord.SubjectName = "应收账款"; break; case "其他货币资金": recPayRecord.SubjectName = "应收票据"; break; case "": break; } break; case "其他业务收入的收款": recPayRecord.CFItemGuid = "F6330595-F588-46B0-8998-752C7A1D774B"; switch (recPayRecord.PayCategory) { case "银行存款": recPayRecord.SubjectName = "应收账款"; break; case "库存现金": recPayRecord.SubjectName = "应收账款"; break; case "其他货币资金": recPayRecord.SubjectName = "应收票据"; break; case "": break; } 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 = "E90ABB77-27D2-48D7-9A20-6F8862F0BE11"; switch (recPayRecord.PayCategory) { case "银行存款": recPayRecord.SubjectName = "应收账款"; break; case "库存现金": recPayRecord.SubjectName = "应收账款"; break; case "其他货币资金": recPayRecord.SubjectName = "应收票据"; break; case "": break; } break; } } if (addstyle == "收入计入收款") { recPayRecord.InvType = "经营活动收款"; recPayRecord.InvTypeDts = "销售商品/提供服务的收款"; recPayRecord.CFItemGuid = "97B181C8-D807-4BF0-8D8D-B23273E7FEFE"; switch (recPayRecord.PayCategory) { case "银行存款": recPayRecord.SubjectName = "应收账款"; break; case "库存现金": recPayRecord.SubjectName = "应收账款"; break; case "其他货币资金": recPayRecord.SubjectName = "应收票据"; break; case "": break; } } if (addstyle == "预收客户账款") { recPayRecord.SubjectName = "预收账款"; recPayRecord.CFItemGuid = "F6330595-F588-46B0-8998-752C7A1D774B"; } if (addstyle == "收取投资款(注册资本金额以内部分)" || addstyle == "收取投资的收款(超出注册资本金额部分)") { recPayRecord.CFItemGuid = "77A24D5F-3E0C-4211-A552-191FEE0E06FD"; switch (addstyle) { case "收取投资款(注册资本金额以内部分)": recPayRecord.SubjectName = "实收资本"; break; case "收取投资的收款(超出注册资本金额部分)": recPayRecord.SubjectName = "资本公积"; break; } } if (addstyle == "收回短期投资的本金金额内的款" || addstyle == "收回长期债券投资的本金金额内的款" || addstyle == "收回长期股权投资的本金金额内的款") { recPayRecord.CFItemGuid = "496F9D4D-F71B-437A-9EA0-26107D3449C3"; switch (addstyle) { case "收回短期投资的本金金额内的款": recPayRecord.SubjectName = "短期投资"; break; case "收回长期债券投资的本金金额内的款": recPayRecord.SubjectName = "长期债券投资"; break; case "收回长期股权投资的本金金额内的款": recPayRecord.SubjectName = "长期股权投资"; break; } } if (addstyle == "收回公司支出的押金" || addstyle == "收到的其他公司支付的押金" || addstyle == "收回公司支出的暂支借款") { recPayRecord.CFItemGuid = "F6330595-F588-46B0-8998-752C7A1D774B"; switch (addstyle) { case "收回公司支出的押金": recPayRecord.SubjectName = "其他应收款"; break; case "收到的其他公司支付的押金": recPayRecord.SubjectName = "其他应付款"; break; case "收回公司支出的暂支借款": recPayRecord.SubjectName = "备用金"; break; } } if (addstyle == "短期借款所获得的收款" || addstyle == "长期借款所获得的收款") { switch (addstyle) { case "短期借款所获得的收款": recPayRecord.SubjectName = "短期借款"; break; case "长期借款所获得的收款": recPayRecord.SubjectName = "长期借款"; break; } recPayRecord.CFItemGuid = "AD2E5437-0917-43E1-807C-41CA6751360F"; } //if (addstyle == "吸取投资") //{ // recPayRecord.CFItemGuid = "77A24D5F-3E0C-4211-A552-191FEE0E06FD"; //} //if (addstyle == "借款") //{ // recPayRecord.CFItemGuid = "AD2E5437-0917-43E1-807C-41CA6751360F"; //} if (addstyle == "其他与筹资活动有关的收款") { recPayRecord.CFItemGuid = "106B9F2C-24A5-48B5-9621-418D00A7A75A"; } recPayRecord.CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); DateTime EditThreshold = DateTime.Parse(Session["EditThreshold"].ToString()); DateTime checkDate; DateTime.TryParse(recPayRecord.Date, out checkDate); if (checkDate <= DateTime.Now && checkDate >= EditThreshold) { string check = null; if (recPayRecord.IE_GUID != null) { string[] temp = recPayRecord.IE_GUID.Split(new char[] { ',' }); if (recPayRecord.SumAmount == recPayRecord.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 (recPayRecord.SumAmount > recPayRecord.DisAmount) { recPayRecord.Record = "未销账"; recPayRecord.DisAmount1 = recPayRecord.SumAmount - recPayRecord.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 (recPayRecord.SumAmount < recPayRecord.DisAmount) { recPayRecord.Record = "已销账"; recPayRecord.RP_Flag = "R"; check = "MORE"; recPayRecord.DisAmount1 = 0; 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); } } if (result) { result = new RecPayRecordSvc().UpdReceivablesRecord(recPayRecord); } } else { recPayRecord.DisAmount1 = recPayRecord.SumAmount; result = new RecPayRecordSvc().UpdReceivablesRecord(recPayRecord); } if (result) { msg = General.Resource.Common.Success; //if (addstyle == "收入获取") //{ // UpdIncomeState(recPayRecord.IE_GUID); //} //else { // UpdState(recPayRecord.IE_GUID); //} } 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 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); }