void IServiceBase.Request(string t, string pars, out string res) { try { ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(pars); var kv = r.ToDictionary(); IBLL.ICusFY bll = new BLL.CusFY(); if (t == "get_list") { DateTime date1 = Helper.Conv.ToDateTime(r.Read("date1")); DateTime date2 = Helper.Conv.ToDateTime(r.Read("date2")); string cus_no = r.Read("cus_no"); var tb = bll.GetList(date1, date2, cus_no); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); res = w.ToString(); } else if (t == "get_order") { string sheet_no = r.Read("sheet_no"); System.Data.DataTable tb1; System.Data.DataTable tb2; bll.GetOrder(sheet_no, out tb1, out tb2); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("tb1", tb1); w.Append("tb2", tb2); res = w.ToString(); } else if (t == "max_code") { string code = bll.MaxCode(); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("code", code); res = w.ToString(); } else if (t == "add") { Model.rp_t_supcust_fy_master ord = new Model.rp_t_supcust_fy_master(); ord.sheet_no = r.Read("sheet_no"); ord.supcust_no = r.Read("supcust_no"); ord.supcust_flag = r.Read("supcust_flag"); ord.pay_type = r.Read("pay_type"); ord.pay_date = System.DateTime.Now; ord.old_no = r.Read("old_no"); ord.oper_id = r.Read("oper_id"); ord.oper_date = Helper.Conv.ToDateTime(r.Read("oper_date")); ord.approve_flag = "0"; ord.approve_man = ""; ord.approve_date = System.DateTime.MinValue; ord.is_payed = r.Read("is_payed"); ord.sale_man = r.Read("sale_man"); ord.branch_no = r.Read("branch_no"); ord.cm_branch = r.Read("cm_branch"); ord.other1 = r.Read("other1"); ord.other2 = r.Read("other2"); ord.other3 = r.Read("other3"); ord.num1 = Helper.Conv.ToDecimal(r.Read("num1")); ord.num2 = Helper.Conv.ToDecimal(r.Read("num2")); ord.num3 = Helper.Conv.ToDecimal(r.Read("num3")); ord.visa_id = r.Read("visa_id"); ord.is_over = r.Read("is_over"); ord.total_amount = Helper.Conv.ToDecimal(r.Read("total_amount")); ord.paid_amount = Helper.Conv.ToDecimal(r.Read("paid_amount")); ord.pay_way = r.Read("pay_way"); ord.pay_name = r.Read("pay_name"); List <Model.rp_t_supcust_fy_detail> lines = new List <Model.rp_t_supcust_fy_detail>(); foreach (ReadWriteContext.IReadContext r2 in r.ReadList("lines")) { Model.rp_t_supcust_fy_detail line = new Model.rp_t_supcust_fy_detail(); lines.Add(line); line.sheet_no = ord.sheet_no; line.kk_no = r2.Read("kk_no"); line.kk_cash = Helper.Conv.ToDecimal(r2.Read("kk_cash")); line.other1 = r2.Read("other1"); line.other2 = r2.Read("other2"); line.other3 = r2.Read("other3"); line.num1 = Helper.Conv.ToDecimal(r2.Read("num1")); line.num2 = Helper.Conv.ToDecimal(r2.Read("num2")); line.num3 = Helper.Conv.ToDecimal(r2.Read("num3")); } string sheet_no; bll.Add(ord, lines, out sheet_no); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("sheet_no", sheet_no); res = w.ToString(); } else if (t == "change") { Model.rp_t_supcust_fy_master ord = new Model.rp_t_supcust_fy_master(); ord.sheet_no = r.Read("sheet_no"); ord.supcust_no = r.Read("supcust_no"); ord.supcust_flag = r.Read("supcust_flag"); ord.pay_type = r.Read("pay_type"); ord.pay_date = System.DateTime.Now; ord.old_no = r.Read("old_no"); ord.oper_id = r.Read("oper_id"); ord.oper_date = Helper.Conv.ToDateTime(r.Read("oper_date")); ord.approve_flag = "0"; ord.approve_man = ""; ord.approve_date = System.DateTime.MinValue; ord.is_payed = r.Read("is_payed"); ord.sale_man = r.Read("sale_man"); ord.branch_no = r.Read("branch_no"); ord.cm_branch = r.Read("cm_branch"); ord.other1 = r.Read("other1"); ord.other2 = r.Read("other2"); ord.other3 = r.Read("other3"); ord.num1 = Helper.Conv.ToDecimal(r.Read("num1")); ord.num2 = Helper.Conv.ToDecimal(r.Read("num2")); ord.num3 = Helper.Conv.ToDecimal(r.Read("num3")); ord.visa_id = r.Read("visa_id"); ord.is_over = r.Read("is_over"); ord.total_amount = Helper.Conv.ToDecimal(r.Read("total_amount")); ord.paid_amount = Helper.Conv.ToDecimal(r.Read("paid_amount")); ord.pay_way = r.Read("pay_way"); ord.pay_name = r.Read("pay_name"); List <Model.rp_t_supcust_fy_detail> lines = new List <Model.rp_t_supcust_fy_detail>(); foreach (ReadWriteContext.IReadContext r2 in r.ReadList("lines")) { Model.rp_t_supcust_fy_detail line = new Model.rp_t_supcust_fy_detail(); lines.Add(line); line.sheet_no = ord.sheet_no; line.kk_no = r2.Read("kk_no"); line.kk_cash = Helper.Conv.ToDecimal(r2.Read("kk_cash")); line.other1 = r2.Read("other1"); line.other2 = r2.Read("other2"); line.other3 = r2.Read("other3"); line.num1 = Helper.Conv.ToDecimal(r2.Read("num1")); line.num2 = Helper.Conv.ToDecimal(r2.Read("num2")); line.num3 = Helper.Conv.ToDecimal(r2.Read("num3")); } bll.Change(ord, lines); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "delete") { string sheet_no = r.Read("sheet_no"); bll.Delete(sheet_no); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "check") { string sheet_no = r.Read("sheet_no"); string approve_man = r.Read("approve_man"); bll.Check(sheet_no, approve_man); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else { throw new Exception("未找到方法" + t); } } catch (Exception ex) { ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "-1"); w.Append("errMsg", ex.Message); LogHelper.writeLog("", ex.ToString()); res = w.ToString(); } }
private void refreshData() { try { System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor; // DateTime date1; DateTime date2; DateTime.TryParse(dateTextBox1.Text.Trim(), out date1); DateTime.TryParse(dateTextBox2.Text.Trim(), out date2); string text = myTextBox1.Text.Split('/')[0]; System.Threading.Thread th = new System.Threading.Thread(() => { Cursor.Current = Cursors.WaitCursor; Helper.GlobalData.windows.ShowLoad(this); try { IBLL.ICusFY bll = new BLL.CusFY(); if (date1 == DateTime.MinValue) { throw new Exception("期间不正确"); } if (date2 == DateTime.MinValue) { throw new Exception("期间不正确"); } DataTable tb = bll.GetList(date1, date2, text); this.dataGrid1.Invoke((MethodInvoker) delegate { this.dataGrid1.DataSource = tb; if (tb.Rows.Count > 0) { sheet_no = tb.Rows[0]["sheet_no"].ToString(); System.Data.DataTable tb1; System.Data.DataTable tb2; bll.GetOrder(sheet_no, out tb1, out tb2); this.dataGrid2.DataSource = tb2; } }); } catch (Exception ex) { IvyBack.Helper.LogHelper.writeLog("refreshData", ex.ToString()); MsgForm.ShowFrom(ex); } Cursor.Current = Cursors.Default; Helper.GlobalData.windows.CloseLoad(this); }); th.Start(); } catch (Exception ex) { MsgForm.ShowFrom(ex); } finally { System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default; } }