public static bool DeleteUser(int id, out string errmsg)
{
bool bOk = false;
errmsg = string.Empty;
using (var mContext = new CommodityRecv_DashboardEntities())
{
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);
}
internal static bool SingleCondAdd(string txtCommodityCode,
string txtCostItemNumber,
string txtCommodityCodeDesc,
out string sErr)
{
sErr = string.Empty;
bool bOk = false;
using (var context = new CommodityRecv_DashboardEntities())
{
//insert
var entity = new tbl_cr_Condition()
{
CommodityCode = txtCommodityCode.Trim(),
CostItemNumber = txtCostItemNumber.Trim(),
CommodityCodeDescription = txtCommodityCodeDesc.Trim()
};
try
{
context.tbl_cr_Condition.Add(entity);
context.SaveChanges();
bOk = true;
}
catch (Exception ex)
{
//sErr = ex.Message
sErr = string.Format("{0} 可能已存在", txtCostItemNumber);
}
}
return(bOk);
}
internal static bool EnableUser(int id, bool enable, out string errmsg)
{
errmsg = string.Empty;
using (var context = new CommodityRecv_DashboardEntities())
{
var its = from p in context.tbl_cr_mailReceiver
where p.id == id
select p;
if (!its.Any())
{
errmsg = "用户不存在";
return(false);
}
var item = its.First();
item.isValid = enable;
try
{
context.SaveChanges();
}
catch (Exception ex)
{
LogHelper.WriteError(typeof(QueryHelper), ex);
errmsg = ex.Message;
return(false);
}
return(true);
}
}
internal static bool MailAdd(string txtEnName, string txtCnName, string txtMailAddr, TMailType eMailType, out string sErr)
{
sErr = string.Empty;
bool bOk = false;
using (var context = new CommodityRecv_DashboardEntities())
{
//insert
var entity = new tbl_cr_mailReceiver()
{
enName = txtEnName.Trim(),
cnName = txtCnName.Trim(),
mailAddr = txtMailAddr.Trim(),
mailAddrType = (int)eMailType,
isValid = true //true有效，false无效
};
try
{
context.tbl_cr_mailReceiver.Add(entity);
context.SaveChanges();
bOk = true;
}
catch (Exception ex)
{
//sErr = ex.Message
sErr = string.Format("{0} 可能已存在", txtMailAddr);
}
}
return(bOk);
}
public static bool EnableUser(int uid, bool bEnabled, out string errmsg)
{
bool bOk = false;
using (var context = new CommodityRecv_DashboardEntities())
{
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 void Update(sys_user user)
{
using (var context = new CommodityRecv_DashboardEntities())
{
//user.LastLogon = DateTime.Now;
context.Entry(user).State = EntityState.Modified;
context.SaveChanges();
}
}
internal static object GetAllMails()
{
using (var context = new CommodityRecv_DashboardEntities())
{
var qry = from c in context.tbl_cr_mailReceiver
orderby c.enName
select c;
return(qry.ToList());
}
}
internal static List <tbl_cr_Condition> GetConditions()
{
using (var context = new CommodityRecv_DashboardEntities())
{
var qry = from c in context.tbl_cr_Condition
orderby c.CostItemNumber
select c;
return(qry.ToList());
}
}
internal static List <v_CommodityRecvCmp> GetCompResult()
{
using (var context = new CommodityRecv_DashboardEntities())
{
var qry = from c in context.v_CommodityRecvCmp.AsNoTracking()
orderby c.ITEM, c.RECEIVEDATE
select c;
return(qry.ToList());
}
}
public static bool HasOtherUsers()
{
//sys_user user = null;
using (var context = new CommodityRecv_DashboardEntities())
{
var peoples = context.sys_user;
if (peoples.Any())
{
return(true);
}
}
return(false);
}
public static sys_user GetUserInfoByAd(string sAdName)
{
sys_user user = null;
using (var context = new CommodityRecv_DashboardEntities())
{
var people = from p in context.sys_user
where (0 == String.Compare(p.ADAccount, sAdName, StringComparison.InvariantCultureIgnoreCase))
select p;
if (people.Any())
{
user = people.First();
}
}
return(user);
}
internal static List <TSysUserInfo> LoadAll()
{
using (var context = new CommodityRecv_DashboardEntities())
{
var users = from x in context.sys_user
select new TSysUserInfo
{
id = x.id,
ADAccount = x.ADAccount,
FullName = x.FullName,
Email = x.Email,
IsValid = x.IsValid
};
return(users.ToList());
}
}
public static void UpdateUserLoginTimeByAd(string sAdName)
{
using (var context = new CommodityRecv_DashboardEntities())
{
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 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 CommodityRecv_DashboardEntities())
{
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);
}
internal static bool DelCondition(int id, string costItemNumber)
{
using (var context = new CommodityRecv_DashboardEntities())
{
var its = from p in context.tbl_cr_Condition
where p.CostItemNumber.Equals(costItemNumber)
select p;
if (!its.Any())
{
return(false);
}
context.tbl_cr_Condition.Remove(its.First());
try
{
context.SaveChanges();
}
catch (Exception ex)
{
LogHelper.WriteError(typeof(QueryHelper), ex);
return(false);
}
return(true);
}
}
