/// <summary>
/// 更新银行账户信息
/// </summary>
/// <param name="bankAcc">银行账户对象</param>
/// <returns></returns>
public bool UpdBankAccount(T_BankAccount bankAcc)
{
DBHelper dh = new DBHelper();
dh.strCmd = "SP_UpdBankAccount";
dh.AddPare("@BA_GUID", SqlDbType.NVarChar, 40, bankAcc.BA_GUID);
dh.AddPare("@B_GUID", SqlDbType.NVarChar, 40, bankAcc.B_GUID);
dh.AddPare("@C_GUID", SqlDbType.NVarChar, 40, bankAcc.C_GUID);
dh.AddPare("@Account", SqlDbType.NVarChar, 100, bankAcc.Account);
dh.AddPare("@AccountName", SqlDbType.NVarChar, 40, bankAcc.AccountName);
dh.AddPare("@AccountCurrency", SqlDbType.NVarChar, 40, bankAcc.AccountCurrency);
dh.AddPare("@AccountAbbreviation", SqlDbType.NVarChar, 40, bankAcc.AccountAbbreviation);
dh.AddPare("@AccountType", SqlDbType.NVarChar, 40, bankAcc.AccountType);
dh.AddPare("@BankAddress", SqlDbType.NVarChar, 100, bankAcc.BankAddress);
dh.AddPare("@SwiftCode", SqlDbType.NVarChar, 40, bankAcc.SwiftCode);
try
{
dh.NonQuery();
return(true);
}
catch (Exception)
{
return(false);
}
}
/// <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));
}
public bool UpdBankAmount(T_BankAccount bankAmount)
{
DBHelper dh = new DBHelper();
dh.strCmd = "SP_UpdBankAmount";
dh.AddPare("@BA_GUID", SqlDbType.NVarChar, 40, bankAmount.BA_GUID);
dh.AddPare("@InitialAmount", SqlDbType.Decimal, 0, bankAmount.InitialAmount);
//dh.AddPare("@AccountCurrency", SqlDbType.NVarChar, 40, bankAmount.AccountCurrency);
try
{
dh.NonQuery();
return(true);
}
catch (Exception)
{
return(false);
}
}
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);
}
