/// <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; }
private void toolSave_Click(object sender, EventArgs e) { if (getIntCount() == 1) { if (intFalg == 1) { try { ReturnRet <int> result = StockDAL.QueryGoodsNum(sales.GoodsId, sales.Num); if (result.success) { if (SalesDAL.add(sales)) { LogInfoDAL.add(new LogInfo(0, 2, currentUser.EmpId, 1, sales.Num, sales.AddTime)); MessageBox.Show("添加成功", "提示"); BinddgvData(); intFalg = 0; ClearControl(); ControlStaus(); } else { MessageBox.Show("添加失败", "提示"); } } else { MessageBox.Show(result.message); intFalg = 1; txtSellGoodsNum.Text = result.data.ToString(); return; } } catch (Exception ex) { MessageBox.Show("添加失败," + ex.Message, "提示"); } } if (intFalg == 2) { //修改 Sales model = SalesDAL.getEntryById <Sales, DateTime>(addtime); if (model == null) { MessageBox.Show("记录不存在", "提示"); } else { ReturnRet <int> result = StockDAL.QueryGoodsNum(sales.GoodsId, sales.Num); if (result.success) { sales.AddTime = model.AddTime; SalesDAL.EditEntry <Sales>(sales, "AddTime"); LogInfoDAL.add(new LogInfo(0, 2, currentUser.EmpId, 2, sales.Num - model.Num, DateTime.Now)); MessageBox.Show("修改成功", "提示"); BinddgvData(); } else { MessageBox.Show(result.message); txtSellGoodsNum.Text = result.data.ToString(); intFalg = 2; return; } } intFalg = 0; ClearControl(); ControlStaus(); } if (intFalg == 3) { Sales model = SalesDAL.getEntryById <Sales, DateTime>(addtime); if (model == null) { MessageBox.Show("记录不存在", "提示"); } else { if (MessageBox.Show("确定删除吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { LogInfoDAL.add(new LogInfo(0, 2, currentUser.EmpId, 3, model.Num, DateTime.Now)); SalesDAL.DeleteEntry <Sales, DateTime>(model.AddTime); MessageBox.Show("删除成功", "提示"); BinddgvData(); } } intFalg = 0; ClearControl(); ControlStaus(); } } }
/// <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; }