public static Ui.DataGrid GetViewCKProudctOutDetailGridBySummaryID(int SummaryID, string orderBy, long startRowIndex, int pageSize)
{
long totalRows = 0;
List <SqlParameter> parameters = new List <SqlParameter>();
List <string> conditions = new List <string>();
conditions.Add("1=1");
if (SummaryID > 0)
{
conditions.Add("[OutSummaryID]=@SummaryID");
parameters.Add(new SqlParameter("@SummaryID", SummaryID));
}
string fieldList = "[ViewCKProudctOutDetail].*";
string Statement = " from [ViewCKProudctOutDetail] where " + string.Join(" and ", conditions.ToArray());
ViewCKProudctOutDetail[] list = new ViewCKProudctOutDetail[] { };
list = GetList <ViewCKProudctOutDetail>(fieldList, Statement, parameters, orderBy, startRowIndex, pageSize, out totalRows).ToArray();
DataAccess.Ui.DataGrid dg = new Ui.DataGrid();
dg.rows = list;
dg.total = totalRows;
dg.page = pageSize;
return(dg);
}
public static Ui.DataGrid GetViewCKProudctOutDetailGridByKeywords(string Keywords, DateTime StartTime, DateTime EndTime, int DepartmentID, int CKCategoryID, string orderBy, long startRowIndex, int pageSize, List <int> IDList = null, int ProductCategoryID = 0, int AcceptUserID = 0, string DepartmentName = "", bool canexport = false)
{
long totalRows = 0;
List <SqlParameter> parameters = new List <SqlParameter>();
List <string> conditions = new List <string>();
conditions.Add("1=1");
if (AcceptUserID > 0)
{
conditions.Add("[AcceptUserID]=@AcceptUserID");
parameters.Add(new SqlParameter("@AcceptUserID", AcceptUserID));
}
if (ProductCategoryID > 0)
{
conditions.Add("[ProductID] in (select ID from [CKProduct] where [CategoryID]=@ProductCategoryID)");
parameters.Add(new SqlParameter("@ProductCategoryID", ProductCategoryID));
}
if (IDList != null && IDList.Count > 0)
{
conditions.Add("[ID] in (" + string.Join(",", IDList.ToArray()) + ")");
}
else
{
if (!string.IsNullOrEmpty(Keywords))
{
conditions.Add("([AddUserName] like @Keywords or [OrderNumber] like @Keywords or [WarehouseName] like @Keywords or [CategoryName] like @Keywords or [ProductName] like @Keywords or [ModelNumber] like @Keywords)");
parameters.Add(new SqlParameter("@Keywords", "%" + Keywords + "%"));
}
if (StartTime > DateTime.MinValue)
{
conditions.Add("convert(nvarchar(10),[OutTime],120)>=@StartTime");
parameters.Add(new SqlParameter("@StartTime", StartTime));
}
if (EndTime > DateTime.MinValue)
{
conditions.Add("convert(nvarchar(10),[OutTime],120)<=@EndTime");
parameters.Add(new SqlParameter("@EndTime", EndTime));
}
if (DepartmentID > 0)
{
if (!string.IsNullOrEmpty(DepartmentName))
{
conditions.Add("([BelongDepartmentID]=@DepartmentID or [BelongTeamName] like @DepartmentName)");
parameters.Add(new SqlParameter("@DepartmentID", DepartmentID));
parameters.Add(new SqlParameter("@DepartmentName", "%" + DepartmentName + "%"));
}
else
{
conditions.Add("[BelongDepartmentID]=@DepartmentID");
parameters.Add(new SqlParameter("@DepartmentID", DepartmentID));
}
}
if (CKCategoryID > 0)
{
conditions.Add("[CKCategoryID]=@CKCategoryID");
parameters.Add(new SqlParameter("@CKCategoryID", CKCategoryID));
}
}
string fieldList = "[ViewCKProudctOutDetail].*";
string Statement = " from [ViewCKProudctOutDetail] where " + string.Join(" and ", conditions.ToArray());
ViewCKProudctOutDetail[] list = new ViewCKProudctOutDetail[] { };
if (canexport)
{
list = GetList <ViewCKProudctOutDetail>("select " + fieldList + Statement + " " + orderBy, parameters).ToArray();
}
else
{
list = GetList <ViewCKProudctOutDetail>(fieldList, Statement, parameters, orderBy, startRowIndex, pageSize, out totalRows).ToArray();
}
DataAccess.Ui.DataGrid dg = new Ui.DataGrid();
dg.rows = list;
dg.total = totalRows;
dg.page = pageSize;
return(dg);
}