/// <summary>
/// 登录
/// </summary>
/// <returns></returns>
public static ReturnRet <Employee> Login(string username, string password)
{
ReturnRet <Employee> ret = new ReturnRet <Employee>();
ret.success = false;
using (BaseContext _db = new BaseContext())
{
var query = from s in _db.a_Emp
where s.EmpName == username
select s;
Employee user = query.FirstOrDefault();
if (user == null)
{
ret.message = "找不到账号";
return(ret);
}
if (user.Pwd != EncryptHelper.MD5Encrypt(password))
{
ret.message = "密码错误";
return(ret);
}
ret.success = true;
ret.message = "登录成功";
ret.data = user;
}
return(ret);
}
/// <summary>
/// 查询库存数量
/// </summary>
/// <returns></returns>
public static ReturnRet <int> QueryGoodsNum(int goodsId, int salesNum)
{
//获取商品的预警值
int warnNum = GoodsDAL.getEntryById <Goods, int>(goodsId).WarnNum;
ReturnRet <int> ret = new ReturnRet <int>();
//查询库存商品
int stocknums = getStockgoosNum(goodsId);
//统计销售记录
int salesnums = SalesDAL.getSalesNums(goodsId);
if (stocknums >= (salesnums + salesNum))
{
//库存足够
ret.success = true;
ret.data = stocknums - salesnums; //除去销售记录，返回库存剩余数量
//计算是否到达预警值
if ((stocknums - (salesnums + salesNum)) <= warnNum)
{
//需要预警,插入一条记录
WarnLogDAL.add(new WarnLog(0, goodsId, DateTime.Now, (stocknums - (salesnums + salesNum)), false));
}
}
else
{
ret.success = false;
ret.message = "库存数量不足";
ret.data = stocknums - salesnums; //除去销售记录，返回库存剩余数量
}
return(ret);
}
