public static ReturnValue Login(string userId, string passWord)
{
var userDao = SqlSugarDB.Instance <tbl_HSCUSER>();
ReturnValue rv = new ReturnValue();
MD5 d5 = MD5.Create();
byte[] buffer = Encoding.Default.GetBytes(passWord);
byte[] md5buffer = d5.ComputeHash(buffer);
string str = null;
foreach (byte b in md5buffer)
{
//得到的字符串使用十六进制类型格式。格式后的字符是小写的字母，如果使用大写（X）则格式后的字符是大写字符
//但是在和对方测试过程中，发现我这边的MD5加密编码，经常出现少一位或几位的问题；
//后来分析发现是 字符串格式符的问题， X 表示大写， x 表示小写，
//X2和x2表示不省略首位为0的十六进制数字；
str += b.ToString("x2");
}
try
{
tbl_HSCUSER user = userDao.Query().First(p => p.UserID == userId && p.UserPwd == str);
if (user == null)
{
return(rv.Fail("用户名或者密码错误！"));
}
userInfo = user;
return(rv.Success("登录成功！"));
}
catch (Exception e)
{
return(rv.Fail(e.Message));
}
}
/// <summary>
/// 编辑物料对应关系
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ReturnValue UpdateMatMapingInfo(MatMaping model)
{
ReturnValue rv = new ReturnValue();
var matDao = SqlSugarDB.Instance <MatMaping>();
try
{
int result = matDao.Update(model).ExecuteCommand();
if (result > 0)
{
return(rv.Success("更新成功！"));
}
else
{
return(rv.Fail("物料对应关系更新失败！"));
}
}
catch (Exception e)
{
return(rv.Fail(e.Message));
}
}
/// <summary>
/// 批量删除物料关系
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ReturnValue DelMatMapingInfo(string[] batArrays)
{
ReturnValue rv = new ReturnValue();
var matMapingDao = SqlSugarDB.Instance <MatMaping>();
try
{
int result = matMapingDao.Delete(batArrays).ExecuteCommand();
if (result > 0)
{
return(rv.Success("删除成功！"));
}
else
{
return(rv.Fail("物料对应关系删除失败！"));
}
}
catch (Exception e)
{
return(rv.Fail(e.Message));
}
}
public ReturnValue AddPackageInfo(packageInfo packageModel)
{
ReturnValue rv = new ReturnValue();
var packageDao = SqlSugarDB.Instance <packageInfo>();
//var packageDao = new DBHelper<packageInfo>();
try
{
if (AfterPrinted != null)
{
var package = packageDao.Query().First(p => p.seriesNo.Equals(packageModel.seriesNo));
if (package != null)
{
throw new Exception(string.Format("箱号：{0}已经存在，可能已经打印过了，请检查！", packageModel.seriesNo));
}
var result = packageDao.Insert(packageModel).ExecuteCommand();
if (result > 0)
{
string sdt = packageModel.seriesNo.Substring(0, packageModel.seriesNo.Length - 5);
int nextSnPre = packageModel.seriesNo.Substring(packageModel.seriesNo.Length - 5, 5).ObjToInt() + 1;
string nextSeriesNo = sdt + nextSnPre.ToString().PadLeft(5, '0');
this.AfterPrinted(true, nextSeriesNo);
return(rv.Success(""));
}
else
{
return(rv.Fail("打印记录添加失败！"));
}
}
else
{
return(rv.Fail("打印后续执行委托时异常！"));
}
}
catch (Exception e)
{
return(rv.Fail(e.Message));
}
}
/// <summary>
/// 打印记录批量删除
/// </summary>
/// <param name="idArrays"></param>
/// <returns></returns>
public ReturnValue DeletePrintInfo(List <packageInfo> list)
{
ReturnValue rv = new ReturnValue();
var packageDao = SqlSugarDB.Instance <packageInfo>();
try
{
int result = packageDao.Update(list).ExecuteCommand();
if (result > 0)
{
return(rv.Success("删除成功！"));
}
else
{
return(rv.Fail("标签记录删除失败！"));
}
}
catch (Exception e)
{
return(rv.Fail(e.Message));
}
}
/// <summary>
/// 新增物料
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ReturnValue AddMatInfo(tblMaterial model)
{
ReturnValue rv = new ReturnValue();
var matDao = SqlSugarDB.Instance <tblMaterial>();
try
{
int result = matDao.Insert(model).ExecuteCommand();
if (result > 0)
{
return(rv.Success("添加成功！"));
}
else
{
return(rv.Fail("物料添加失败！"));
}
}
catch (Exception e)
{
return(rv.Fail(e.Message));
}
}
