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="material"></param>
/// <returns></returns>
public ReturnValue <packageInfo> GetPackageInfo(string material)
{
ReturnValue <packageInfo> rv = new ReturnValue <packageInfo>();
var packageDao = SqlSugarDB.Instance <packageInfo>();
var packageModel = packageDao.Query().Where(p => p.mNo.Equals(material) && p.STATE != 9).OrderBy(p => p.id, SqlSugar.OrderByType.Desc).First();
return(rv.Success(packageModel, ""));
}
public ReturnValue <tblMaterial> GetMatInfo(string material)
{
ReturnValue <tblMaterial> rv = new ReturnValue <tblMaterial>();
var matDao = SqlSugarDB.Instance <tblMaterial>();
var matModel = matDao.Query().First(p => p.MAT_ID.Equals(material));
return(rv.Success(matModel, ""));
}
public ReturnValue <List <MatMaping> > GetMatMapingInfo(string customMat, string hscMat_ID, Page page)
{
ReturnValue <List <MatMaping> > rv = new ReturnValue <List <MatMaping> >();
var matDao = SqlSugarDB.Instance <MatMaping>();
List <MatMaping> matList = matDao.Query()
.WhereIF(!string.IsNullOrEmpty(customMat), p => p.CustomMat.Equals(customMat))
.WhereIF(!string.IsNullOrEmpty(hscMat_ID), p => p.Mat_ID.Equals(hscMat_ID))
.OrderBy(p => p.modifyDate, OrderByType.Desc).ToPageList(page.pageIndex, page.pageSize, ref page.totalCount)
.ToList();
return(rv.Success(matList, ""));
}
/// <summary>
/// 物料主数据分页查询
/// </summary>
/// <param name="model"></param>
/// <param name="page"></param>
/// <returns></returns>
public ReturnValue <List <tblMaterial> > GetMatInfo(MatModel model, Page page)
{
ReturnValue <List <tblMaterial> > rv = new ReturnValue <List <tblMaterial> >();
var matDao = SqlSugarDB.Instance <tblMaterial>();
List <tblMaterial> matList = matDao.Query()
.WhereIF(!string.IsNullOrEmpty(model.MAT_ID), p => p.MAT_ID.Equals(model.MAT_ID))
.WhereIF(!string.IsNullOrEmpty(model.MAT_SPECI), p => p.MAT_SPECI.Equals(model.MAT_SPECI))
.WhereIF(!string.IsNullOrEmpty(model.MAT_SNCONTROL), p => p.MAT_SNCONTROL.Equals(model.MAT_SNCONTROL))
.WhereIF(!string.IsNullOrEmpty(model.MAT_OLD), p => p.MAT_OLD.Equals(model.MAT_OLD))
.WhereIF(!string.IsNullOrEmpty(model.MAT_BATCHMODE), p => p.MAT_BATCHMODE.Equals(model.MAT_BATCHMODE))
.WhereIF(!string.IsNullOrEmpty(model.MAT_STATUS), p => p.MAT_STATUS == Convert.ToInt32(model.MAT_STATUS))
.OrderBy(p => p.MAT_ID, OrderByType.Asc).ToPageList(page.pageIndex, page.pageSize, ref page.totalCount)
.ToList();
return(rv.Success(matList, ""));
}
/// <summary>
/// 获取当天最大箱号
/// </summary>
/// <param name="wksplit"></param>
/// <param name="siloNum">料仓号编号</param>
/// <param name="PorcessNum">工艺号</param>
/// <returns></returns>
public ReturnValue <string> GetSNInfo(string wksplit, string siloNum = "", string PorcessNum = "")
{
ReturnValue <string> rv = new ReturnValue <string>();
var packageDao = SqlSugarDB.Instance <packageInfo>();
var packageModel = packageDao.Query().Where(p => p.wksplit.Equals(wksplit) && SqlFunc.DateIsSame(p.timestamps, DateTime.Now)).OrderBy(p => p.id, OrderByType.Desc).First();
string date = DateTime.Now.ToString("yyMMdd");
if (packageModel != null)
{
string snCode = rv.Success(packageModel.seriesNo.Substring(packageModel.seriesNo.Length - 3)).Value;
return(rv.Success(UserBLL.userInfo.SeriesHead + siloNum + (!string.IsNullOrEmpty(PorcessNum) ? PorcessNum : "00") + date + (Convert.ToInt32(snCode) + 1).ToString().PadLeft(3, '0')));
}
else
{
return(rv.Success(UserBLL.userInfo.SeriesHead + siloNum + (!string.IsNullOrEmpty(PorcessNum) ? PorcessNum : "00") + date + "001"));
}
}
/// <summary>
/// 打印记录查询
/// </summary>
/// <param name="model"></param>
/// <param name="page"></param>
/// <returns></returns>
public ReturnValue <List <packageInfo> > GetPrintInfo(PintInfoModel model, Page page)
{
var packageDao = SqlSugarDB.Instance <packageInfo>();
List <packageInfo> packageList = packageDao.Query()
.WhereIF(!string.IsNullOrEmpty(model.material), p => p.mNo.Equals(model.material))
.WhereIF(!string.IsNullOrEmpty(model.status), p => p.STATE == model.status.ObjToInt())
.WhereIF(!string.IsNullOrEmpty(model.seriesNo), p => p.seriesNo.Equals(model.seriesNo))
.WhereIF(!string.IsNullOrEmpty(model.oldMatNo), p => p.newNo.Equals(model.oldMatNo))
.WhereIF(!string.IsNullOrEmpty(model.isPackage), p => p.packageType == model.isPackage.ObjToInt())
.WhereIF(!string.IsNullOrEmpty(model.spackageDate), p => p.packageDate >= Convert.ToDateTime(model.spackageDate))
.WhereIF(!string.IsNullOrEmpty(model.epackageDate), p => p.packageDate <= Convert.ToDateTime(model.epackageDate))
.WhereIF(!string.IsNullOrEmpty(model.printDate), p => SqlFunc.DateIsSame(p.timestamps, Convert.ToDateTime(model.printDate)))
.WhereIF(!string.IsNullOrEmpty(UserBLL.userInfo.WorkLine), p => p.workShop == UserBLL.userInfo.WorkLine)
.OrderBy(p => p.id, OrderByType.Desc).ToPageList(page.pageIndex, page.pageSize, ref page.totalCount)
.ToList();
return(new ReturnValue <List <packageInfo> >().Success(packageList));
}
/// <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>
/// <param name="page"></param>
/// <returns></returns>
public ReturnValue <List <PackageInfoSum> > GetPrintInfoSum(PintInfoModel model, Page page)
{
#region 弃用
//var packageDao = SqlSugarDB.Instance<PackageInfoSum>();
//StringBuilder sql = new StringBuilder();
//sql.Append("select top 1000 productDesc as 规格,(case when inner_key=1 or inner_key=0 and (innerMatNo='' or innerMatNo is null) then newNo else innerMatNo end )as 旧物料号,mNo as 物料号,bNo as 批次,grade as 等级,workLine as 线别,convert(char(10),packageDate,120) as 包装日期,count(*) as 袋数,CONVERT(decimal(18, 2), sum(nbtWeight)) as 净重小计 from packageInfo");
//sql.Append(" where state<>9 and workShop = '申远聚合'");
//if (!string.IsNullOrEmpty(model.spackageDate))
//{
// sql.Append(" and packageDate >= '" + model.spackageDate + "'");
//}
//if (!string.IsNullOrEmpty(model.epackageDate))
//{
// sql.Append(" and packageDate <= '" + model.epackageDate + "'");
//}
//if (!string.IsNullOrEmpty(model.isPackage))
//{
// sql.Append(" and packagetype = " + Convert.ToInt32(model.isPackage));
//}
//if (!string.IsNullOrEmpty(model.grade))
//{
// sql.Append(" and grade = '" + model.grade + "'");
//}
//sql.Append(" group by productDesc, newNo ,grade,workline,packageDate,mNo,bNo,case when inner_key=1 or inner_key=0 and (innerMatNo='' or innerMatNo is null) then newNo else innerMatNo end");
//sql.Append(" order by packageDate desc");
//var sumPackageInfo = packageDao.Query(sql.ToString()).ToPageList(page.pageIndex, page.pageSize, ref page.totalCount).ToList();
#endregion
DBHelper <packageInfo> pdao = SqlSugarDB.Instance <packageInfo>();
List <PackageInfoSum> sum = pdao.Query().WhereIF(!string.IsNullOrEmpty(model.spackageDate), p => p.packageDate >= Convert.ToDateTime(model.spackageDate))
.WhereIF(!string.IsNullOrEmpty(model.epackageDate), p => p.packageDate <= Convert.ToDateTime(model.epackageDate))
.WhereIF(!string.IsNullOrEmpty(model.isPackage), p => p.packageType == Convert.ToInt32(model.isPackage))
.WhereIF(!string.IsNullOrEmpty(model.grade), p => p.grade == model.grade)
.Where(p => p.STATE != 9 && p.workShop == UserBLL.userInfo.WorkLine)
.Select <PackageInfoSum>(@"productDesc as 规格,(case when inner_key=1 or inner_key=0 and (innerMatNo='' or innerMatNo is null) then newNo else innerMatNo end )as 旧物料号,mNo as 物料号,bNo as 批次,grade as 等级,workLine as 线别,convert(char(10),packageDate,120) as 包装日期,count(*) as 袋数,CONVERT(decimal(18, 2), sum(nbtWeight)) as 净重小计")
.GroupBy(@"productDesc, newNo ,grade,workline,packageDate,mNo,bNo,case when inner_key=1 or inner_key=0 and (innerMatNo='' or innerMatNo is null) then newNo else innerMatNo end")
.OrderBy(@"packageDate desc")
.ToPageList(page.pageIndex, page.pageSize, ref page.totalCount).ToList();
return(new ReturnValue <List <PackageInfoSum> >().Success(sum));
}
/// <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));
}
}
/// <summary>
/// 打印验证
/// </summary>
/// <returns>返回是否通过 ref Msg</returns>
public static bool Verification(packageInfo model, ref string Msg, string page)
{
bool isPass = true;
if (string.IsNullOrEmpty(model.spec))
{
Msg = "商品名不能为空!";
return(false);
}
if (string.IsNullOrEmpty(model.description))
{
Msg = "物料描述不能为空!";
return(false);
}
if (string.IsNullOrEmpty(model.mNo))
{
Msg = "物料号不能为空！";
return(false);
}
var matDao = SqlSugarDB.Instance <MatMaping>();
var matMapingModel = matDao.Query().First(p => p.CustomMat == model.mNo);
if (matMapingModel == null)
{
Msg = "物料号" + model.mNo + "未维护有对应关系的新物料，请检查！";
return(false);
}
if (string.IsNullOrEmpty(model.standard))
{
Msg = "执行标准不能为空!";
return(false);
}
if (string.IsNullOrEmpty(model.bNo))
{
Msg = "批次号不能为空!";
return(false);
}
if (string.IsNullOrEmpty(model.workLine))
{
Msg = "生产线不能为空!";
return(false);
}
if (string.IsNullOrEmpty(model.grade))
{
Msg = "等级不能为空!";
return(false);
}
if (string.IsNullOrEmpty(model.hiddenProduct))
{
Msg = "批号不能为空!";
return(false);
}
if (string.IsNullOrEmpty(model.nbtWeight.ToString()) || !IsNumeric(model.nbtWeight.ToString()))
{
Msg = "净重不能为空,或者不是数字!";
return(false);
}
if (string.IsNullOrEmpty(model.SILONUM))
{
Msg = "料仓号不能为空!";
return(false);
}
if (string.IsNullOrEmpty(page) || !IsUnsign(page))
{
Msg = "张数为空或者不是正整数！";
return(false);
}
if (string.IsNullOrEmpty(model.packType))
{
Msg = "类型不能为空！";
return(false);
}
return(isPass);
}
