/// <summary> /// 添加子公司的方法 /// </summary> /// <param name="data"></param> /// <returns></returns> public HttpResponseMessage AddCompany(dynamic data) { Entity.user_detail com = user.Value.SetData(data); string sql = "insert into company(com_name,com_size,work_address,head_id) values(" + "'" + com.com_name + "','" + com.com_size + "','" + com.work_address + "'," + com.head_id + ")"; int i = help.Count(sql); if (i > 0) { obj = new { code = "A0000", msg = "添加成功" }; } else { obj = new { code = "A0001", msg = "添加失败" }; } return(help.ToJson(obj)); }
/// <summary> /// 修改子公司信息 /// </summary> /// <param name="data"></param> /// <param name="com_id"></param> /// <returns></returns> public HttpResponseMessage UpdateCompany(dynamic data, int com_id) { Entity.user_detail com = user.Value.SetData(data); string sql = "update company set com_name='" + com.com_name + "',com_size='" + com.com_size + "'," + "work_address='" + com.work_address + "' where com_id=" + com_id; int i = help.Count(sql); if (i > 0) { obj = new { code = "A0000", msg = "修改成功" }; } else { obj = new { code = "A0001", msg = "修改失败" }; } return(help.ToJson(obj)); }
/// <summary> /// 修改总部信息 包括公司logo /// </summary> /// <param name="data"></param> /// <param name="head_id"></param> /// <returns></returns> public HttpResponseMessage UpdateHead_office(dynamic data, int head_id) { Entity.user_detail d = user.Value.SetData(data); string sql = "update head_office set head_name=@head_name,head_size=@head_size," + "head_address=@head_address,head_logo=@head_logo where head_id=" + head_id; SqlParameter[] sp = { new SqlParameter("@head_name", d.head_name), new SqlParameter("@head_size", d.head_size), new SqlParameter("@head_address", d.head_address), new SqlParameter("@head_logo", d.head_logo), }; int i = help.Count(sql, sp); if (i > 0) { obj = new { code = "A0000", msg = "修改成功" }; } else { obj = new { code = "A0001", msg = "修改失败" }; } return(help.ToJson(obj)); }
/// <summary> /// 添加班组信息 /// </summary> /// <param name="data"></param> /// <returns></returns> public HttpResponseMessage AddClass(dynamic data) { Entity.user_detail us = user.Value.SetData(data); string sql = "insert into classes(c_name,c_work_name,c_work_desc,b_id) " + "values('" + us.c_name + "','" + us.c_work_name + "','" + us.c_work_desc + "'," + us.b_id + ")"; int i = help.Count(sql); if (i > 0) { obj = new { code = 0, msg = "添加班组成功" }; } else { obj = new { code = 1, msg = "添加班组失败" }; } return(Zh.Tool.Json.GetJson(obj)); }
/// <summary> /// 修改班组信息 /// </summary> /// <param name="data"></param> /// <param name="c_id"></param> /// <returns></returns> public HttpResponseMessage UpdateClass(dynamic data, int c_id) { Entity.user_detail us = user.Value.SetData(data); string sql = "update classes set c_name='" + us.c_name + "',c_work_name='" + us.c_work_name + "'," + "c_work_desc='" + us.c_work_desc + "',b_id=" + us.b_id + " where c_id=" + c_id; int i = help.Count(sql); if (i > 0) { obj = new { code = 0, msg = "修改班组信息成功" }; } else { obj = new { code = 1, msg = "修改班组信息失败" }; } return(Zh.Tool.Json.GetJson(obj)); }
/// <summary> /// 修改所在子公司的公司信息 /// </summary> /// <param name="data"></param> /// <param name="com_id"></param> /// <returns></returns> public HttpResponseMessage Update_company(dynamic data, int com_id) { Entity.user_detail d = user.Value.SetData(data); string sql = "update company set com_name=@com_name,com_size=@com_size,work_address=@work_address " + "where com_id=" + com_id + ""; SqlParameter[] sp = { new SqlParameter("@com_name", d.com_name), new SqlParameter("@com_size", d.com_size), new SqlParameter("@work_address", d.work_address) }; int i = help.Count(sql, sp); if (i > 0) { obj = new { code = "A0000", msg = "修改成功" }; } else { obj = new { code = "A0001", msg = "修改失败" }; } return(help.ToJson(obj)); }
/// <summary> /// 添加我所在子公司中的部门信息 /// </summary> /// <param name="data"></param> /// <returns></returns> public HttpResponseMessage Add_deparment(dynamic data) { Entity.user_detail d = user.Value.SetData(data); string sql = "insert into deparment(b_name,b_work_name,b_work_desc,com_id) " + "values(@b_name,@b_work_name,@b_work_desc," + d.com_id + ")"; SqlParameter[] sp = { new SqlParameter("@b_name", d.b_name), new SqlParameter("@b_work_name", d.b_work_name), new SqlParameter("@b_work_desc", d.b_work_desc) }; int i = help.Count(sql, sp); if (i > 0) { obj = new { code = "A0000", msg = "部门添加成功" }; } else { obj = new { code = "A0001", msg = "部门添加失败" }; } return(help.ToJson(obj)); }
/// <summary> /// 根据总部ID修改部门信息 /// </summary> /// <param name="data"></param> /// <param name="b_id"></param> /// <returns></returns> public HttpResponseMessage Update_deparment(dynamic data, int b_id) { Entity.user_detail d = user.Value.SetData(data); string sql = "update deparment set b_name=@b_name,b_work_name=@b_work_name,b_work_desc=@b_work_desc " + "where b_id=" + b_id; SqlParameter[] sp = { new SqlParameter("@b_name", d.b_name), new SqlParameter("@b_work_name", d.b_work_name), new SqlParameter("@b_work_desc", d.b_work_desc) }; int i = help.Count(sql, sp); if (i > 0) { obj = new { code = "A0000", msg = "部门修改成功" }; } else { obj = new { code = "A0001", msg = "部门修改失败" }; } return(help.ToJson(obj)); }
/// <summary> /// 上传用户权限及详情信息 /// </summary> /// <param name="data"></param> /// <param name="usid"></param> /// <returns></returns> public HttpResponseMessage AddUser_detail(dynamic data, int usid) { Entity.user_detail ud = detail.Value.SetData(data); //添加用户详情表 string sql2 = "insert into user_detail(us_id,gender,age,us_no,mobile,tel,work_state,position,head_id,com_id,b_id," + "c_id,verify) values(" + usid + "," + ud.gender + "," + ud.age + ",'" + ud.us_no + "','" + ud.mobile + "','" + ud.tel + "'," + "" + ud.work_state + ",'" + ud.position + "'," + ud.head_id + "," + ud.com_id + "," + ud.b_id + "," + ud.c_id + "," + "" + ud.verify + ")"; int i = help.Count(sql2); object obj = null; if (i > 0) { obj = new { code = "0", msg = "添加成功" }; } else { obj = new { code = "1", msg = "添加失败" }; } return(help.ToJson(obj)); }
/// <summary> /// 修改用户的权限、详情等信息 /// </summary> /// <param name="data"></param> /// <param name="us_id"></param> /// <returns></returns> public HttpResponseMessage ChangeUser_detail(dynamic data, int us_id) { Entity.user_detail ud = detail.Value.SetData(data); string sql = "update user_detail set gender=" + ud.gender + ",age=" + ud.age + ",us_no='" + ud.us_no + "',mobile='" + ud.mobile + "'," + "tel='" + ud.tel + "',work_state=" + ud.work_state + ",position='" + ud.position + "',head_id=" + ud.head_id + "," + "com_id=" + ud.com_id + ",b_id=" + ud.b_id + ",c_id=" + ud.c_id + ",verify=" + ud.verify + " where us_id=" + us_id; int i = help.Count(sql); object obj = null; if (i > 0) { obj = new { code = "0", msg = "修改成功" }; } else { obj = new { code = "1", msg = "修改失败" }; } return(help.ToJson(obj)); }
/// <summary> /// 修改登录信息 /// </summary> /// <param name="data"></param> /// <param name="us_id"></param> /// <returns></returns> public HttpResponseMessage ChangeUsers(dynamic data, int us_id) { Entity.user_detail ud = detail.Value.SetData(data); string sql = "update users set login_name=@login_name,login_pwd=@login_pwd,real_name=@real_name where us_id=" + us_id + ";"; SqlParameter[] sp = { new SqlParameter("@login_name", ud.login_name), new SqlParameter("@login_pwd", ud.login_pwd), new SqlParameter("@real_name", ud.real_name) }; int i = help.Count(sql, sp); object obj = null; if (i > 0) { obj = new { code = "0", msg = "修改成功" }; } else { obj = new { code = "1", msg = "修改失败" }; } return(help.ToJson(obj)); }
/// <summary> /// 上传用户登录信息 返回刚添加用户的id 该方法将同时向用户详情信息表添加一条带有用户ID的空记录 /// </summary> /// <param name="data"></param> /// <returns></returns> public HttpResponseMessage AddUser(dynamic data) { object objs = null; Entity.user_detail ud = detail.Value.SetData(data); if (Count(ud.login_name)) { objs = new { code = "1", msg = "该用户已存在" }; return(Zh.Tool.Json.GetJson(objs)); } //添加用户表 string sql1 = "insert into users(login_name,login_pwd,real_name) values(@login_name,@login_pwd,@real_name) select @@IDENTITY"; SqlParameter[] sp = { new SqlParameter("@login_name", ud.login_name), new SqlParameter("@login_pwd", ud.login_pwd), new SqlParameter("@real_name", ud.real_name) }; object obj = help.FirstRow(sql1, sp); if (obj != null) { int u_id = Convert.ToInt32(obj); ///为用户添加三级教育卡 int markcard = Convert.ToInt32(data.markcard); if (markcard == 1) { Card_Sign sign = new Card_Sign(); string end_time = data.end_time; sign.Add(end_time, u_id); } objs = new { usid = u_id, code = "0", msg = "添加管理员成功" }; } else { objs = new { usid = 0, code = "2", msg = "上传时出现错误" }; } string s = JsonConvert.SerializeObject(objs); HttpResponseMessage m = new HttpResponseMessage(); m.Content = new StringContent(s, System.Text.Encoding.GetEncoding("UTF-8"), "application/json"); return(m); }
/// <summary> /// 添加集团信息 成功返回最新的集团ID /// </summary> /// <param name="data"></param> /// <returns></returns> public int AddHead(dynamic data) { Entity.user_detail d = user.Value.SetData(data); string sql = "insert into head_office(head_name,head_size,head_address,head_logo) values(" + "@head_name,@head_size,@head_address,@head_logo) select @@IDENTITY"; SqlParameter[] sp = { new SqlParameter("@head_name", d.head_name) , new SqlParameter("@head_size", d.head_size) , new SqlParameter("@head_address", d.head_address) , new SqlParameter("@head_logo", d.head_logo) }; return(Convert.ToInt32(help.FirstRow(sql, sp))); }
/// <summary> /// 添加集团信息 成功返回受影响的行数 /// </summary> /// <param name="data"></param> /// <returns></returns> public int AddHeadOffice(dynamic data) { Entity.user_detail d = user.Value.SetData(data); string sql = "insert into head_office(head_name,head_size,head_address,head_logo) values(" + "@head_name,@head_size,@head_address,@head_logo)"; SqlParameter[] sp = { new SqlParameter("@head_name", d.head_name) , new SqlParameter("@head_size", d.head_size) , new SqlParameter("@head_address", d.head_address) , new SqlParameter("@head_logo", d.head_logo) }; return(help.Count(sql, sp)); }