public HttpResponseMessage InsertRealm(dynamic para)
{
var le = EFClass.GetEF();
int type = Convert.ToInt32(para.type);
if (type == 1)
{
String RealmDes = Convert.ToString(para.RealmDes);
long Sequence = Convert.ToInt64(para.Sequence);
String Uri = Convert.ToString(para.Uri);
//String ParentID = Convert.ToString(para.ParentID);
String AppID = Guid.NewGuid().ToString();
String Security = Guid.NewGuid().ToString();
Realms r = new Realms();
r.RealmID = Guid.NewGuid().ToString();
r.RealmDes = RealmDes;
r.Uri = Uri;
r.AppID = AppID;
r.Sequence = Sequence;
r.Security = Security;
r.CreatedDate = DateTime.Now;
le.Realms.Add(r);
return(ToJson.toJson(le.SaveChanges()));
}
else if (type == 2)
{
Thread.Sleep(2000);
String RealmID = Convert.ToString(para.id);
var r = le.Realms.Where(p => p.RealmID == RealmID).FirstOrDefault();
r.Forzen = 1;
return(ToJson.toJson(le.SaveChanges()));
}
return(ToJson.toJson(""));
}
public HttpResponseMessage GetDicRegionList(int page, int limit)
{
var le = EFClass.GetEF();
var list = le.Dic_Regions.OrderBy(p => p.UpdatedDate).Skip((page - 1) * limit).Take(limit).ToList();
object o = new { code = 0, msg = "", count = list.Count, data = list };
return(ToJson.toJson(o));
}
public HttpResponseMessage UpdateRoles(dynamic ro)
{
var le = EFClass.GetEF();
String rn = Convert.ToString(ro.rolename);
String rd = Convert.ToString(ro.roledes);
String rid = Convert.ToString(ro.roleid);
var roled = le.Roles.Where(p => p.RoleID == rid).FirstOrDefault();
roled.RoleName = rn;
roled.RoleDes = rd;
return(ToJson.toJson(le.SaveChanges()));
}
public HttpResponseMessage DeleteUserToRole(String guid)
{
//从用户角色表中删除改用户与改角色的联系
var le = EFClass.GetEF();
UserRoles ur = le.UserRoles.Where(p => p.GUID == guid).FirstOrDefault();
if (ur != null)
{
le.UserRoles.Remove(ur);
return(ToJson.toJson(le.SaveChanges()));
}
return(ToJson.toJson("-1"));
}
public HttpResponseMessage InsertRole(dynamic ro)
{
var le = EFClass.GetEF();
String rn = Convert.ToString(ro.rolename);
String rd = Convert.ToString(ro.roledes);
Roles roled = new Roles();
roled.RoleName = rn;
roled.RoleDes = rd;
roled.RoleID = Guid.NewGuid().ToString().ToUpper();
roled.CreatedDate = DateTime.Now;
le.Roles.Add(roled);
return(ToJson.toJson(le.SaveChanges()));
}
public HttpResponseMessage UpdateRealm(dynamic para)
{
var le = EFClass.GetEF();
String RealmID = Convert.ToString(para.RealmID);
String RealmDes = Convert.ToString(para.RealmDes);
long Sequence = Convert.ToInt64(para.Sequence);
String Uri = Convert.ToString(para.Uri);
//String ParentID = Convert.ToString(para.ParentID);
var r = le.Realms.Where(p => p.RealmID == RealmID).FirstOrDefault();
r.Sequence = Sequence;
r.RealmDes = RealmDes;
r.Uri = Uri;
return(ToJson.toJson(le.SaveChanges()));
}
public HttpResponseMessage UpdateRegion(dynamic ro)
{
var le = EFClass.GetEF();
String RegionName = Convert.ToString(ro.RegionName);
String RegionDes = Convert.ToString(ro.RegionDes);
String GUID = Convert.ToString(ro.GUID);
String Alias = Convert.ToString(ro.Alias);
var roled = le.Dic_Regions.Where(p => p.GUID == GUID).FirstOrDefault();
roled.RegionDes = RegionDes;
roled.RegionName = RegionName;
roled.Alias = Alias;
roled.UpdatedDate = DateTime.Now;
return(ToJson.toJson(le.SaveChanges()));
}
public HttpResponseMessage GetUserList(dynamic para)
{
var le = EFClass.GetEF();
if (para.type == 1)
{
//获得工厂列表
return(ToJson.toJson(le.Dic_Regions.ToList()));
}
else if (para.type == 2)
{
//通过初始化数据
String guid = Convert.ToString(para.guid); //当前角色的roleid
String cqid = Convert.ToString(para.cqid); //下拉列表框中的选择项
String txt = Convert.ToString(para.txt); //用户编号 或者 姓名
int page = Convert.ToInt32(para.page);
int pagesize = Convert.ToInt32(para.pagesize);
//在用户角色表中 获得有guid 角色的用户id ，存在UserIDList中
List <String> UserIDList = (from ur in le.UserRoles where ur.RoleID == guid select ur.UserID).ToList();
//通过用户表，厂区表 联合查询，查出 用户id不在UserIDList 中，且厂区编号为cqid 的用户
var EndList = (from ui in le.UserInfo where ui.Region.Contains(cqid) && !UserIDList.Contains(ui.UserID) && (ui.UserName.Contains(txt) || ui.UserID.Contains(txt)) select ui).ToList();
return(ToJson.toJson(EndList));
}
else if (para.type == 3)
{
//查询不分页
String guid = Convert.ToString(para.guid); //当前角色的roleid
String cqid = Convert.ToString(para.cqid); //下拉列表框中的选择项
String txt = Convert.ToString(para.txt); //用户编号 或者 姓名
int page = Convert.ToInt32(para.page);
int pagesize = Convert.ToInt32(para.pagesize);
//在用户角色表中 获得有guid 角色的用户id ，存在UserIDList中
List <String> UserIDList = (from ur in le.UserRoles where ur.RoleID == guid select ur.UserID).ToList();
//通过用户表，厂区表 联合查询，查出 用户id不在UserIDList 中，且厂区编号为cqid 的用户
var EndList = (from ui in le.UserInfo where ui.Region.Contains(cqid) && !UserIDList.Contains(ui.UserID) && (ui.UserName.Contains(txt) || ui.UserID.Contains(txt)) select ui).ToList();
return(ToJson.toJson(EndList));
}
return(ToJson.toJson("-1"));
}
public HttpResponseMessage InsertRegion(dynamic para)
{
var le = EFClass.GetEF();
String RegionID = Convert.ToString(para.RegionID);
String RegionName = Convert.ToString(para.RegionName);
String RegionDes = Convert.ToString(para.RegionDes);
String Alias = Convert.ToString(para.Alias);
var re = le.Dic_Regions.Where(p => p.RegionID == RegionID).FirstOrDefault();
if (re != null)
{
return(ToJson.toJson("-9999"));
}
Dic_Regions dr = new Dic_Regions();
dr.RegionDes = RegionDes;
dr.GUID = Guid.NewGuid().ToString();
dr.RegionName = RegionName;
dr.UpdatedDate = DateTime.Now;
dr.Alias = Alias;
dr.RegionID = RegionID;
le.Dic_Regions.Add(dr);
return(ToJson.toJson(le.SaveChanges()));
}
public HttpResponseMessage Login(dynamic para)
{
String userid = para.userid;
String inputPwd = para.pwd;
//[email protected] 模式只取@前面的不带点的
if (userid.Contains("@"))
{
int @index = userid.IndexOf('@');
userid = userid.Remove(@index);
userid = userid.Replace(".", "");
ReturnLiteonUser rlu = LiteonMethod.MobilePortal_GetEmpInfoViaAccount(userid);
if (rlu != null)
{
//用户号验证成功
LiteonMethod.RegsiterAction(rlu, userid);
rm.ResponseState = ResponseState.Successed;
rm.ResponseMessage = "登录成功";
rm.ResponseData = JsonConvert.SerializeObject(rlu);
return(ToJson.toJson(rm));
}
else
{
//用户不存在
rm.ResponseState = ResponseState.Failed;
rm.ResponseMessage = "登录失败";
return(ToJson.toJson(rm));
}
}
else if (userid.Contains("\\"))
{
//liteon\trevorchang 模式只取\后面的
int @index = userid.IndexOf('\\');
userid = userid.Remove(0, @index + 1);
ReturnLiteonUser rlu = LiteonMethod.MobilePortal_GetEmpInfoViaAccount(userid);
if (rlu != null)
{
rm.ResponseState = ResponseState.Successed;
rm.ResponseMessage = "登录成功";
rm.ResponseData = JsonConvert.SerializeObject(rlu);
return(ToJson.toJson(rm));
}
else
{
rm.ResponseState = ResponseState.Failed;
rm.ResponseMessage = "登录失败";
return(ToJson.toJson(rm));
}
}
else
{
var le = EFClass.GetEF();
var userList = le.Users.Where(p => p.UserID == userid.ToUpper() && p.Password == inputPwd).ToList();
if (userList.Count == 1)
{
Users us = userList[0];
var urList = le.UserRoles.Where(p => p.UserID == us.UserID).ToList();
rm.ResponseState = ResponseState.Successed;
rm.ResponseMessage = "登录成功";
rm.ResponseData = us.UserID;
}
else
{
rm.ResponseState = ResponseState.Failed;
rm.ResponseMessage = "用户名或密码错误";
}
return(ToJson.toJson(rm));
}
}
public HttpResponseMessage Regsiters(dynamic para)
{
LiteonUser lu = new LiteonUser();
String cq = para.cq;
String xm = para.xm;
String sfz = para.sfz;
String gh = para.gh;
String sr = para.sr;
String mm = para.mm;
String userid = cq.ToUpper() + gh;
lu.Birthdate = Convert.ToDateTime(sr);
lu.IDNumber = sfz;
lu.SiteCode = cq;
lu.UserName = xm;
lu.EmployeeID = gh;
String loginid = LiteonMethod.MobilePortal_NoEmailEmployeeCheck(lu);
if (!String.IsNullOrEmpty(loginid))
{
var le = EFClass.GetEF();
var uilist = le.UserInfo.Where(p => p.UserID == userid).ToList();
if (uilist.Count == 0)
{
//该帐号没有被注册
UserInfo ui = new UserInfo();
ui.UserID = userid;
ui.Region = cq;
ui.UserName = xm;
ui.RegisterDate = DateTime.Now;
ui.GUID = Guid.NewGuid().ToString();
ui.EmployeeID = gh;
le.UserInfo.Add(ui);
Users u = new Users();
u.Password = mm;
u.GUID = Guid.NewGuid().ToString();
u.UserID = userid;
u.LoginDate = DateTime.Now;
le.Users.Add(u);
int result = le.SaveChanges();
if (result > 0)
{
rm.ResponseState = ResponseState.Successed;
rm.ResponseMessage = "添加成功！";
rm.ResponseData = userid;
}
else
{
rm.ResponseState = ResponseState.Failed;
rm.ResponseMessage = "添加失败！";
}
return(ToJson.toJson(rm));
}
else
{
rm.ResponseState = ResponseState.Failed;
rm.ResponseMessage = "该帐号已被注册";
return(ToJson.toJson(rm));
}
}
else
{
rm.ResponseState = ResponseState.Failed;
rm.ResponseMessage = "您不是光宝员工！";
return(ToJson.toJson(rm));
}
}
public HttpResponseMessage GetUserInfoList(dynamic other)
{
var le = EFClass.GetEF();
if (other.type == 1)
{
//初次加载或者空条件查询用户列表
//不需要条件 有分页
//String text = Convert.ToString(other.txt).Trim();
String guid = Convert.ToString(other.guid);
int page = Convert.ToInt32(other.page);
int limit = Convert.ToInt32(other.limit);
var ss = from ui in le.UserInfo join ur in le.UserRoles on ui.UserID equals ur.UserID where ur.RoleID == guid select new UserToRoles {
UserName = ui.UserName, UserID = ui.UserID, GUID = ur.GUID
};
List <UserToRoles> list = new List <UserToRoles>(ss);
var list1 = list.OrderBy(p => p.GUID).Skip((page - 1) * limit).Take(limit).Select(p => new { GUID = p.GUID, UserID = p.UserID, UserName = p.UserName }).ToList();
return(ToJson.toJson(list1));
}
else if (other.type == 2)
{
//获得有该角色的用户总数
String text = Convert.ToString(other.txt).Trim();
String guid = Convert.ToString(other.guid);
var userIDList = le.UserRoles.Where(p => p.RoleID == guid).ToList();
List <UserInfo> userInfoList = new List <UserInfo>();
var ss = from ui in le.UserInfo join ur in le.UserRoles on ui.UserID equals ur.UserID where ur.RoleID == guid && (ui.UserID.Contains(text) || ui.UserName.Contains(text))select new { UserName = ui.UserName, UserID = ui.UserID, GUID = ur.GUID };
List <object> list = new List <object>(ss);
return(ToJson.toJson(list.Count));
}
else if (other.type == 4)
{
//根据条件查询 无分页
String text = Convert.ToString(other.txt).Trim();
String guid = Convert.ToString(other.guid);
var ss = from ui in le.UserInfo join ur in le.UserRoles on ui.UserID equals ur.UserID where ur.RoleID == guid && (ui.UserID.Contains(text) || ui.UserName.Contains(text))select new UserToRoles {
UserName = ui.UserName, UserID = ui.UserID, GUID = ur.GUID
};
List <UserToRoles> list = new List <UserToRoles>(ss);
var list1 = list.Select(p => new { GUID = p.GUID, UserID = p.UserID, UserName = p.UserName }).ToList();
return(ToJson.toJson(list1));
}
else if (other.type == 3)
{
//添加用户给该角色
String userids = Convert.ToString(other.userids);
String guid = Convert.ToString(other.guid);
String[] idList = userids.Trim(',').Split(',');
for (int i = 0; i < idList.Length; i++)
{
UserRoles ur = new UserRoles();
ur.GUID = Guid.NewGuid().ToString().ToUpper();
ur.CreatedDate = DateTime.Now;
ur.RoleID = guid;
ur.UserID = idList[i];
le.UserRoles.Add(ur);
}
return(ToJson.toJson(le.SaveChanges()));
}
return(ToJson.toJson(""));
}
