void IBLL.IPeople.Add(Model.bi_t_people_info item)
{
string sql = "select * from bi_t_people_info where oper_id='" + item.oper_id + "'";
DB.IDB db = new DB.DBByAutoClose(Appsetting.conn);
var tb = db.ExecuteToTable(sql, null);
if (tb.Rows.Count != 0)
{
throw new Exception("已经存在职员编号" + item.oper_id);
}
db.Insert(item);
}
public void change(WebHelper w, Dictionary <string, object> kv)
{
Model.bi_t_people_info item = w.GetObject <Model.bi_t_people_info>();
if (w.Read("birthday") != "")
{
item.birthday = Helper.Conv.ToDateTime(w.Read("birthday"));
}
if (w.Read("in_date") != "")
{
item.in_date = Helper.Conv.ToDateTime(w.Read("in_date"));
}
bll.Change(item);
}
void IBLL.IPeople.Change(Model.bi_t_people_info item)
{
DB.IDB db = new DB.DBByAutoClose(Appsetting.conn);
db.Update(item, "oper_id");
}
void IServiceBase.Request(string t, string pars, out string res)
{
try
{
WebHelper web = new WebHelper(pars);
ReadWriteContext.IReadContext r = new ReadWriteContext.ReadContextByJson(pars);
var kv = r.ToDictionary();
IBLL.IPeople bll = new BLL.People();
if (t == "get_list")
{
string dep_no = r.Read("dep_no");
string keyword = r.Read("keyword");
int show_stop = Helper.Conv.ToInt32(r.Read("show_stop"));
int page_index = Helper.Conv.ToInt32(r.Read("page_index"));
int page_size = Helper.Conv.ToInt32(r.Read("page_size"));
int total_count = 0;
var tb = bll.GetList(dep_no, keyword, show_stop, page_index, page_size, out total_count);
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
w.Append("data", tb);
w.Append("total_count", total_count.ToString());
res = w.ToString();
}
else if (t == "get_item")
{
string oper_id = r.Read("oper_id");
var tb = bll.GetItem(oper_id);
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_people_info item = new Model.bi_t_people_info();
item.oper_id = r.Read("oper_id");
item.oper_name = r.Read("oper_name");
item.oper_status = r.Read("oper_status");
item.dept_no = r.Read("dept_no");
if (r.Read("birthday") != "")
{
item.birthday = Helper.Conv.ToDateTime(r.Read("birthday"));
}
item.tel = r.Read("tel");
if (r.Read("in_date") != "")
{
item.in_date = Helper.Conv.ToDateTime(r.Read("in_date"));
}
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_people_info item = new Model.bi_t_people_info();
item.oper_id = r.Read("oper_id");
item.oper_name = r.Read("oper_name");
item.oper_status = r.Read("oper_status");
item.dept_no = r.Read("dept_no");
if (r.Read("birthday") != "")
{
item.birthday = Helper.Conv.ToDateTime(r.Read("birthday"));
}
item.tel = r.Read("tel");
if (r.Read("in_date") != "")
{
item.in_date = Helper.Conv.ToDateTime(r.Read("in_date"));
}
bll.Change(item);
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
res = w.ToString();
}
else if (t == "delete")
{
string oper_id = r.Read("oper_id");
bll.Delete(oper_id);
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "0");
w.Append("errMsg", "");
res = w.ToString();
}
else
{
web.ReflectionMethod(bll, t);
res = web.NmJson();
}
}
catch (Exception ex)
{
ReadWriteContext.IWriteContext w = new ReadWriteContext.WriteContextByJson();
w.Append("errId", "-1");
w.Append("errMsg", ex.Message);
res = w.ToString();
}
}