/// <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>
/// <returns></returns>
public PintInfoModel QueryData()
{
PintInfoModel model = new PintInfoModel
{
material = matNum.Text.Trim(),
//status = status.Text.Trim(),
seriesNo = serialno.Text.Trim(),
//oldMatNo = oldMatNum.Text.Trim(),
//isPackage = isChangePack.Text.Trim(),
spackageDate = txt_sPackageDate.Text ?? null,
epackageDate = txt_ePackageDate.Text ?? null,
printDate = txt_printDate.Text ?? null
};
if ("已创建".Equals(status.Text.Trim()))
{
model.status = "0";
}
else if ("已删除".Equals(status.Text.Trim()))
{
model.status = "9";
}
else
{
model.status = status.Text.Trim();
}
if ("生产下线".Equals(isChangePack.Text.Trim()))
{
model.isPackage = "1";
}
else if ("改包装".Equals(isChangePack.Text.Trim()))
{
model.isPackage = "0";
}
else
{
model.isPackage = isChangePack.Text.Trim();
}
return(model);
}
/// <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>
/// <returns></returns>
private PintInfoModel SumQueryData()
{
var model = new PintInfoModel()
{
spackageDate = txt_startPackageDate.Text ?? "",
epackageDate = txt_endPackageDate.Text ?? "",
grade = gradeCB.Text.Trim()
};
if ("是".Equals(isChangePackageCB.Text.Trim()))
{
model.isPackage = "0";
}
else if ("否".Equals(isChangePackageCB.Text.Trim()))
{
model.isPackage = "1";
}
else
{
model.isPackage = isChangePackageCB.Text.Trim();
}
return(model);
}