void IBLL.IRegion.Add(Model.bi_t_region_info item) { string sql = "select * from bi_t_region_info where region_no='" + item.region_no + "'"; DB.IDB db = new DB.DBByAutoClose(Appsetting.conn); var tb = db.ExecuteToTable(sql, null); if (tb.Rows.Count != 0) { throw new Exception("已经存在地区编号" + item.region_no); } db.Insert(item); }
public void change(WebHelper w, Dictionary <string, object> kv) { Model.bi_t_region_info item = w.GetObject <Model.bi_t_region_info>(); item.update_time = DateTime.Now; bll.Change(item); }
void IBLL.IRegion.Change(Model.bi_t_region_info item) { DB.IDB db = new DB.DBByAutoClose(Appsetting.conn); db.Update(item, "region_no"); }
void IServiceBase.Request(string t, string pars, out string res) { try { ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(pars); var kv = r.ToDictionary(); IBLL.IRegion bll = new BLL.Region(); if (t == "get_list") { var tb = bll.GetList(); 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 region_no = r.Read("region_no"); var tb = bll.GetItem(region_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 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.bi_t_region_info item = new Model.bi_t_region_info(); item.region_no = r.Read("region_no"); item.region_name = r.Read("region_name"); item.display_flag = r.Read("display_flag"); item.region_parent = r.Read("region_parent"); item.update_time = DateTime.Now; 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_region_info item = new Model.bi_t_region_info(); item.region_no = r.Read("region_no"); item.region_name = r.Read("region_name"); item.display_flag = r.Read("display_flag"); item.region_parent = r.Read("region_parent"); item.update_time = DateTime.Now; bll.Change(item); ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson(); w.Append("errId", "0"); w.Append("errMsg", ""); res = w.ToString(); } else if (t == "delete") { string region_no = r.Read("region_no"); bll.Delete(region_no); 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); res = w.ToString(); } }