/// <summary> /// 获取图表年初余额 /// </summary> /// <returns></returns> public Dictionary <string, List <decimal> > getAccountingService() { //获取token string token = FinanceToken.getFinanceCheckToken().getToken(); //返回的map Dictionary <string, List <decimal> > result = null; if (account != null) { //创建实例 result = new Dictionary <string, List <decimal> >(); //获取集合 List <Charts> resultList = common.getAccounting(account.company); //年初借金数组 List <decimal> loadList = new List <decimal>(); //年初贷金数组 List <decimal> borrowedList = new List <decimal>(); //循环填入 foreach (Charts chart in resultList) { loadList.Add(chart.sum_load); borrowedList.Add(chart.sum_borrowed); } //return result.Add("sum_load", loadList); result.Add("sum_borrowed", borrowedList); } return(result); }
/// <summary> /// 获取图表利润合计 /// </summary> /// <returns></returns> public Dictionary <string, List <decimal> > getProfitService(string start_date, string stop_date) { //获取token string token = FinanceToken.getFinanceCheckToken().getToken(); //返回的map Dictionary <string, List <decimal> > result = null; if (account != null) { //创建实例 result = new Dictionary <string, List <decimal> >(); //获取集合 List <Charts> resultList = common.getProfit(account.company, start_date, stop_date); //年初借金数组 List <decimal> sumYear = new List <decimal>(); //年初贷金数组 List <decimal> sumMonth = new List <decimal>(); //循环填入 foreach (Charts chart in resultList) { sumYear.Add(chart.sum_year); sumMonth.Add(chart.sum_month); } //return result.Add("sumYear", sumYear); result.Add("sumMonth", sumMonth); } return(result); }
//构造方法 public FinancingService() { try { //获取token string token = FinanceToken.getFinanceCheckToken().getToken(); //获取对象 account = FinanceToken.getFinanceCheckToken().checkToken(token); //实例化model层 commonModel = new CommonModel(); }catch { throw new InvalidOperationException("身份验证不通过"); } }
//构造方法 public VoucherWordService() { try { //获取token string token = FinanceToken.getFinanceCheckToken().getToken(); //获取对象 account = FinanceToken.getFinanceCheckToken().checkToken(token); //实例化model层 voucherWordModel = new VoucherWordModel(); commonModel = new CommonModel(); }catch { throw new Exception("身份验证不通过"); } }
//构造方法 public User_ManagementService() { try { //获取token string token = FinanceToken.getFinanceCheckToken().getToken(); //获取对象 account = FinanceToken.getFinanceCheckToken().checkToken(token); //实例化model层 user_managementmodel = new User_ManagementModel(); } catch { throw new InvalidOperationException("身份验证不通过"); } }
public string examineVoucherSummary(string idsJson, string @do) { try { //创建service层实例 voucherSummaryService = new VoucherSummaryService(); //获取用户service层实例 AccountService accountService = new AccountService(true); Account account = new Account(); //处理json string token = FinanceToken.getFinanceCheckToken().getToken(); //获取对象 account = FinanceToken.getFinanceCheckToken().checkToken(token); string examineName = account.name; //检查操作密码 if (!accountService.checkDo(@do)) { return(FinanceResultData.getFinanceResultData().fail(402, null, "操作密码错误")); } //处理json int[] ids = FinanceJson.getFinanceJson().toObject <int[]>(idsJson); //审核 if (voucherSummaryService.examineVoucherSummary(ids, examineName)) { return(FinanceResultData.getFinanceResultData().success(200, null, "成功")); } else { return(FinanceResultData.getFinanceResultData().fail(500, null, "错误")); } } catch (InvalidOperationException ex) { //身份验证不通过 return(FinanceResultData.getFinanceResultData().fail(401, null, ex.Message)); } catch (Exception ex) { //未知的错误 return(FinanceResultData.getFinanceResultData().fail(500, null, "未知的错误")); } }
//实例化 public AccountService(Boolean isLogin) { //实例化model层 am = new AccountModel(); if (isLogin) { try { //获取token string token = FinanceToken.getFinanceCheckToken().getToken(); //获取对象 account = FinanceToken.getFinanceCheckToken().checkToken(token); } catch { throw new InvalidOperationException("身份验证不通过"); } } }
/// <summary> /// 获取图表凭证金额 /// </summary> /// <returns></returns> public Dictionary <string, decimal> getSummaryService(string start_date, string stop_date) { //获取token string token = FinanceToken.getFinanceCheckToken().getToken(); //返回的map Dictionary <string, decimal> result = null; if (account != null) { //创建实例 result = new Dictionary <string, decimal>(); //获取集合 List <Charts> resultList = common.getSummary(account.company, start_date, stop_date); //return if (resultList.Count == 2) { result.Add("sum_borrowed", resultList[1].sum); result.Add("sum_load", resultList[0].sum); } else { if (resultList.Count == 0) { result.Add("sum_borrowed", 0); result.Add("sum_load", 0); } else if (resultList[0].direction = true) { result.Add("sum_borrowed", resultList[0].sum); result.Add("sum_load", 0); } else { result.Add("sum_borrowed", 0); result.Add("sum_load", resultList[0].sum); } } } return(result); }
/// <summary> /// 获取图表资产负债 /// </summary> /// <returns></returns> public Dictionary <string, List <decimal> > getLiabilitiesService(string start_date, string stop_date) { //获取token string token = FinanceToken.getFinanceCheckToken().getToken(); //返回的map Dictionary <string, List <decimal> > result = null; if (account != null) { //创建实例 result = new Dictionary <string, List <decimal> >(); //获取集合 List <Charts> resultList = common.getLiabilities(account.company, start_date, stop_date); //年初借金数组 List <decimal> yearStart = new List <decimal>(); //年初贷金数组 List <decimal> yaerEnd = new List <decimal>(); //循环填入 Boolean isFirst = true; foreach (Charts chart in resultList) { if (isFirst) { yearStart.Add(chart.sum_load - chart.sum_borrowed); yaerEnd.Add(chart.sum_load - chart.sum_borrowed + chart.sum_money); isFirst = false; } else { yearStart.Add(chart.sum_borrowed - chart.sum_load); yaerEnd.Add(chart.sum_borrowed - chart.sum_load + chart.sum_money); } } //return result.Add("yearStart", yearStart); result.Add("yearEnd", yaerEnd); } return(result); }
public string quanxianGet() { try { Account account = new Account(); //创建service层实例 user_managementservice = new User_ManagementService(); //处理json string token = FinanceToken.getFinanceCheckToken().getToken(); //获取对象 account = FinanceToken.getFinanceCheckToken().checkToken(token); string bianhao = account.bianhao; quanxian quanxianitem = user_managementservice.quanxianGetService(bianhao); if (quanxianitem != null) { return(FinanceResultData.getFinanceResultData().success(200, quanxianitem, "成功")); } else { return(FinanceResultData.getFinanceResultData().fail(500, null, "删除失败")); } } catch (InvalidOperationException ex) { //身份验证不通过 return(FinanceResultData.getFinanceResultData().fail(401, null, ex.Message)); } catch (Exception ex) { //未知的错误 return(FinanceResultData.getFinanceResultData().fail(500, null, "未知的错误")); } }
/// <summary> /// 获取图表现金流量 /// </summary> /// <returns></returns> public Dictionary <string, List <decimal> > getFlowService(string start_date, string stop_date) { //获取token string token = FinanceToken.getFinanceCheckToken().getToken(); //返回的map Dictionary <string, List <decimal> > result = null; if (account != null) { //创建实例 result = new Dictionary <string, List <decimal> >(); //年初借金数组 List <decimal> sumYear = new List <decimal>(); //年初贷金数组 List <decimal> sumMonth = new List <decimal>(); //投资结余 ManagementModel management = new ManagementModel(); //筹资结余 InvestmentModel investment = new InvestmentModel(); //经营结余 FinancingModel financing = new FinancingModel(); //今年结余 sumYear.Add(management.getManagementYear(account.company, start_date, stop_date)); sumYear.Add(investment.getInvestmentYear(account.company, start_date, stop_date)); sumYear.Add(financing.getFinancingYear(account.company, start_date, stop_date)); //当月结余 sumMonth.Add(management.getManagementMonth(account.company, start_date, stop_date)); sumMonth.Add(investment.getInvestmentMonth(account.company, start_date, stop_date)); sumMonth.Add(financing.getFinancingMonth(account.company, start_date, stop_date)); //return result.Add("sumYear", sumYear); result.Add("sumMonth", sumMonth); } return(result); }
protected void HtmlBtn_Click(object sender, EventArgs e) { string servename = DropDownList1.SelectedItem.Text;//这是获取选中的文本值 string gs_name = DropDownList2.SelectedItem.Text; string username = Request.Form["username"]; string txtSAPPassword = Request.Form["password"]; if (servename.ToString() == "云合人事管理系统") { Session.Timeout = 10000; Session["username"] = username; Session["gs_name"] = gs_name; if (gs_name != null || username != null || txtSAPPassword != null) { if (gs_name != null && username != null && txtSAPPassword != null) { string connStr = ConfigurationManager.AppSettings["yao"]; conn = new SqlConnection(connStr); //conn = new SqlConnection(connStr); if (conn.State == ConnectionState.Closed) { conn.Open(); } //str = conn.BeginTransaction(); string sqlStr = "select id from gongzi_renyuan where L='" + gs_name + "' and I='" + username + "' and J='" + txtSAPPassword + "';"; cmd = new SqlCommand(sqlStr, conn); int id = Convert.ToInt32(cmd.ExecuteScalar()); if (id != 0) { string[] a = gs_name.Split('_'); Session["gongsi"] = a[0]; Session["id1"] = id; Server.Transfer("../Personnel/index.aspx"); } else { Response.Write("<script id='alert'>alert('输入密码有误,请重试')</script>"); } conn.Close(); } } } else if (servename.ToString() == "云合未来进销存系统") { UserModel userModel = new UserModel(); string msg = ""; yh_jinxiaocun_user user; try { user = userModel.login(gs_name.Trim(), username.Trim(), txtSAPPassword.Trim()); } catch { Response.Write("<script>alert('网络超时,请稍后再试。')</script>"); return; } if (user != null) { if (user.Btype.Equals("锁定")) { msg = "用户已被锁定!"; } else { Session.Timeout = 10000; Session["user"] = user; Response.Redirect("~/frmMain.aspx"); return; } } else { msg = "用户名密码错误!"; } Response.Write("<script id='alert'>alert('" + msg + "')</script>"); } else if (servename.ToString() == "云合未来财务系统") { AccountService accountService = new AccountService(false); string token = accountService.login(gs_name.Trim(), username.Trim(), txtSAPPassword.Trim()); if (token.Equals("")) { ScriptManager.RegisterStartupScript(this, this.GetType(), "提示", "alert('用户名密码错误!')", true); } else { FinanceToken.getFinanceCheckToken().setToken(token); Response.Redirect("../finance/web/view/index.aspx"); } } else if (servename.ToString().Equals("云合排产管理系统")) { try { if (!UserInfoService.login(username.Trim(), txtSAPPassword.Trim(), gs_name.Trim())) { ScriptManager.RegisterStartupScript(this, this.GetType(), "提示", "alert('用户名密码错误!')", true); } else { Response.Redirect("../scheduling/web/index.html"); } } catch (Exception ex) { Response.Write(ex.Message); } } }