public ActionResult TraInStock_FindByPage(Mes_Tra_InStock obj, int page, int rows)
{
var pager = new PagerBase()
{
CurrentPageIndex = page, PageSize = rows
};
var list = MesTraInStockDao.Instance.FindByPage(obj, ref pager);
return(Json(new { total = pager.TotalItemCount, rows = list }));
}
public List <Mes_Tra_InStock> FindByPage(Mes_Tra_InStock obj, ref PagerBase pager)
{
string sql = @"select T1.*,T2.OrgName as Show_OrgID from Mes_Tra_InStock T1 with (nolock) Left join Mes_Sys_Organization T2 with (nolock)
on T1.OrgID=T2.ID WHERE 1=1 ";
if (!string.IsNullOrEmpty(obj.Barcode))
{
sql += string.Format(" AND T1.Barcode='{0}'", obj.Barcode);
}
if (!string.IsNullOrEmpty(obj.SN))
{
sql += string.Format(" AND T1.SN='{0}'", obj.SN);
}
if (!string.IsNullOrEmpty(obj.PackSN))
{
sql += string.Format(" AND T1.PackSN='{0}'", obj.PackSN);
}
if (!string.IsNullOrEmpty(obj.MaterialProNo))
{
sql += string.Format(" AND T1.MaterialProNo='{0}'", obj.MaterialProNo);
}
if (!string.IsNullOrEmpty(obj.MaterialCode))
{
sql += string.Format(" AND T1.MaterialCode='{0}'", obj.MaterialCode);
}
if (!string.IsNullOrEmpty(obj.WorkOrderNumber))
{
sql += string.Format(" AND T1.WorkOrderNumber='{0}'", obj.WorkOrderNumber);
}
if (!string.IsNullOrEmpty(obj.ScanTimeStart))
{
sql += string.Format(" AND T1.ScanTime>='{0}'", obj.ScanTimeStart);
}
if (!string.IsNullOrEmpty(obj.ScanTimeEnd))
{
sql += string.Format(" AND T1.ScanTime<'{0}'", TConvertHelper.FormatDBDate(obj.ScanTimeEnd).AddDays(1));
}
string orderBy = pager.OrderBy;
if (string.IsNullOrEmpty(orderBy))
{
orderBy = "ScanTime DESC";
}
string cmdPageSql = string.Format(BaseDao.PageSql, orderBy, sql, pager.StartNo, pager.EndNo);
string cmdCountSql = string.Format(BaseDao.CountSql, sql.Substring(sql.ToLower().IndexOf("from", StringComparison.Ordinal)));
//查询总记录数
pager.TotalItemCount = this.CurDbSession.FromSql(cmdCountSql).ToScalar <int>();
//返回当前页的记录数
return(this.CurDbSession.FromSql(cmdPageSql).ToList <Mes_Tra_InStock>());
}
