/// <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;
}
