/// <summary>
/// 将用户插入到数据库中
/// </summary>
/// <returns></returns>
public JsonResult SaveUsersToDb()
{
var response = DingDingServices.GetAllUserList();
if (response.ErroCode == 0 && response.Userlist != null && response.Userlist.Count > 0)
{
response.Userlist.ForEach(u => { if (u.Department != null)
{
u.Department.ToString();
}
});
string sqlStr = @"insert into DDUsers(
userid
,unionid
,[order]
,isAdmin
,isBoss
,isHide
,isLeader
,name
,active
,department
,position
,avatar
,jobnumber
) values(
@userid
,@unionid
,@order
,@isAdmin
,@isBoss
,@isHide
,@isLeader
,@name
,@active
,@department
,@position
,@avatar
,@jobnumber)";
int m = DbHelper.Insert(sqlStr, response.Userlist);
if (m > 0)
{
return(Json(new
{
code = 0,
msg = "保存数据成功，共" + m + "条",
data = m
}, JsonRequestBehavior.AllowGet));
}
}
return(Json(new
{
code = -1,
msg = "保存数据失败"
}, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 从服务端更新数据库，有修改无插入
/// </summary>
/// <returns></returns>
public JsonResult InsertOrUpdateUsersByUserId()
{
int mup = 0, min = 0;
var response = DingDingServices.GetAllUserList();
if (response.ErroCode == 0 && response.Userlist != null && response.Userlist.Count > 0)
{
response.Userlist.ForEach(u =>
{
var user = DbHelper.QueryByUserId(u);
if (user != null)
{
mup += DbHelper.UpdateByUserId(u);
}
else
{
min += DbHelper.Insert(@"insert into DDUsers(
userid
,unionid
,[order]
,isAdmin
,isBoss
,isHide
,isLeader
,name
,active
,department
,position
,avatar
,jobnumber
) values(
@userid
,@unionid
,@order
,@isAdmin
,@isBoss
,@isHide
,@isLeader
,@name
,@active
,@department
,@position
,@avatar
,@jobnumber)", u);
}
});
if (mup > 0)
{
return(Json(new
{
code = 0,
msg = "操作成功，共修改" + mup + "条,插入" + min + "条,更新完成",
data = mup + min
}, JsonRequestBehavior.AllowGet));
}
}
return(Json(new
{
code = -1,
msg = "更新失败"
}, JsonRequestBehavior.AllowGet));
}