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