public static bool DeleteUser(int id, out string errmsg)
{
bool bOk = false;
errmsg = string.Empty;
using (var mContext = new WarehouseLaborEffEntities())
{
var persons = from p in mContext.sys_user
where p.id == id
select p;
if (persons.Any())
{
var obj = persons.First();
mContext.sys_user.Remove(obj);
try
{
mContext.SaveChanges();
bOk = true;
}
catch (Exception ex)
{
errmsg = ex.Message;
}
}
}
return(bOk);
}
public static bool EnableUser(int uid, bool bEnabled, out string errmsg)
{
bool bOk = false;
using (var context = new WarehouseLaborEffEntities())
{
var persons = from p in context.sys_user
where p.id == uid
select p;
foreach (var obj in persons)
{
obj.IsValid = bEnabled;
}
try
{
context.SaveChanges();
bOk = true;
errmsg = string.Empty;
}
catch (Exception ex)
{
errmsg = ex.Message;
}
}
return(bOk);
}
public static bool DeleteHCData(IEnumerable <int> ids, out string sErr)
{
sErr = string.Empty;
var bOk = false;
using (var mContext = new WarehouseLaborEffEntities())
{
var items = from p in mContext.tbl_hcdata
where ids.Contains(p.id)
select p;
if (items.Any())
{
mContext.tbl_hcdata.RemoveRange(items);
try
{
mContext.SaveChanges();
bOk = true;
}
catch (Exception ex)
{
sErr = ex.Message;
}
}
else
{
sErr = "数据已删除";
}
}
return(bOk);
}
public static void Update(sys_user user)
{
using (var context = new WarehouseLaborEffEntities())
{
//user.LastLogon = DateTime.Now;
context.Entry(user).State = EntityState.Modified;
context.SaveChanges();
}
}
public static void UpdateUserLoginTimeByAd(string sAdName)
{
using (var context = new WarehouseLaborEffEntities())
{
var people = from p in context.sys_user
where (0 == String.Compare(p.ADAccount, sAdName, StringComparison.InvariantCultureIgnoreCase))
select p;
if (people.Any())
{
var user = people.First();
user.LastLogon = DateTime.Now;
context.Entry(user).State = EntityState.Modified;
context.SaveChanges();
}
}
}
public static bool ChangeRole(string userAD, string[] roleIDs, out string sErr)
{
sErr = string.Empty;
using (var context = new WarehouseLaborEffEntities())
{
var userID = (from u in context.sys_user
where (0 == String.Compare(u.ADAccount, userAD, StringComparison.InvariantCultureIgnoreCase))
select u.id).FirstOrDefault();
if (0 == userID)
{
return(false);
}
//先删后加
var bOk = false;
try
{
var qry = from x in context.sys_user_role_conn
where x.RefUserID == userID
select x;
context.sys_user_role_conn.RemoveRange(qry);
var lst = new List <sys_user_role_conn>();
foreach (var rid in roleIDs)
{
lst.Add(new sys_user_role_conn
{
RefRoleID = rid,
RefUserID = userID
});
}
context.sys_user_role_conn.AddRange(lst);
context.SaveChanges();
bOk = true;
sErr = string.Empty;
}
catch (Exception ex)
{
sErr = ex.Message;
}
return(bOk);
}
}
public static bool InsertUserInfo(string inputad, ref string errmsg)
{
bool bOk = false;
var adUser = GetAdInfo(inputad, out errmsg);
if (adUser == null)
{
errmsg = "AD login failed!";
return(false);
}
var adInfo = GetUserInfoByAd(inputad);
if (adInfo != null)
{
errmsg = "You had been registered!";
return(false);
}
using (var context = new WarehouseLaborEffEntities())
{
var entity = new sys_user()
{
ADAccount = adUser.ADAccount,
Email = adUser.Email,
FullName = adUser.FirstName + ' ' + adUser.LastName,
IsAdmin = false,
IsValid = true
};
try
{
context.sys_user.Add(entity);
context.SaveChanges();
bOk = true;
errmsg = string.Empty;
}
catch (Exception ex)
{
errmsg = ex.Message;
}
}
return(bOk);
}
