void IBLL.IBranch.Add(Model.bi_t_branch_info item) { item.update_time = System.DateTime.Now; string sql = "select * from bi_t_branch_info where branch_no='" + item.branch_no + "'"; if (item.branch_no.Length == 4) { string par_code = item.branch_no.Substring(0, 2); IBLL.IBranch ins = this; item.branch_no = ins.MaxCode(par_code); } else if (item.branch_no.Length == 2) { string par_code = item.branch_no.Substring(0, 2); IBLL.IBranch ins = this; item.branch_no = ins.MaxCode(""); } DB.IDB db = new DB.DBByAutoClose(Appsetting.conn); var tb = db.ExecuteToTable(sql, null); if (tb.Rows.Count != 0) { throw new Exception("已存在机构号" + item.branch_no); } db.Insert(item); }
void IServiceBase.Request(string t, string pars, out string res) { try { ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(pars); var kv = r.ToDictionary(); IBLL.IBranch bll = new BLL.Branch(); if (t == "get_list") { int code_len = Helper.Conv.ToInt32(r.Read("code_len")); var tb = bll.GetList(code_len); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); res = w.ToString(); } else if (t == "get_list_by_par_code") { string par_code = r.Read("par_code"); var tb = bll.GetListByParCode(par_code); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); res = w.ToString(); } else if (t == "get_item") { string branch_no = r.Read("branch_no"); var tb = bll.GetItem(branch_no); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); w.Append("data", tb); res = w.ToString(); } else if (t == "max_code") { string par_code = r.Read("par_code"); string code = bll.MaxCode(par_code); 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.bi_t_branch_info item = new Model.bi_t_branch_info(); item.branch_no = r.Read("branch_no"); item.branch_name = r.Read("branch_name"); item.branch_man = r.Read("branch_man"); item.address = r.Read("address"); item.display_flag = r.Read("display_flag"); bll.Add(item); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "change") { Model.bi_t_branch_info item = new Model.bi_t_branch_info(); item.branch_no = r.Read("branch_no"); item.branch_name = r.Read("branch_name"); item.branch_man = r.Read("branch_man"); item.address = r.Read("address"); item.display_flag = r.Read("display_flag"); bll.Change(item); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "delete") { string branch_no = r.Read("branch_no"); bll.Delete(branch_no); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else { WebHelper w = new WebHelper(pars); w.ReflectionMethod(bll, t); res = w.NmJson(); } } catch (Exception ex) { ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "-1"); w.Append("errMsg", ex.Message); res = w.ToString(); } }
void IBLL.IBranch.Change(Model.bi_t_branch_info item) { item.update_time = System.DateTime.Now; DB.IDB db = new DB.DBByAutoClose(Appsetting.conn); db.Update(item, "branch_no"); }
public void change(WebHelper w, Dictionary <string, object> kv) { Model.bi_t_branch_info item = w.GetObject <Model.bi_t_branch_info>(); bll.Change(item); }