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);
}
