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