/// <summary>
/// 条件拼接
/// </summary>
/// <param name="SearchCondition"></param>
/// <returns></returns>
private string GenGetWhere(MachiningSearchCondition SearchCondition)
{
StringBuilder sb = new StringBuilder();
if (!string.IsNullOrEmpty(SearchCondition.MachiningNumber))
{
IEnumerable <string> numbers = Enumerable.Empty <string>();
if (SearchCondition.MachiningNumber.IndexOf("\n") > 0)
{
numbers = SearchCondition.MachiningNumber.Split('\n').Select(s => { return(s.Trim()); });
}
if (SearchCondition.MachiningNumber.IndexOf(',') > 0)
{
numbers = SearchCondition.MachiningNumber.Split(',').Select(s => { return(s.Trim()); });
}
if (numbers != null && numbers.Any())
{
numbers = numbers.Where(c => !string.IsNullOrEmpty(c));
}
if (numbers != null && numbers.Any())
{
sb.Append(" and MachiningNumber in ( ");
foreach (string s in numbers)
{
sb.Append("'").Append(s).Append("',");
}
sb.Remove(sb.Length - 1, 1);
sb.Append(" ) ");
}
else
{
sb.Append(" and MachiningNumber like '%" + SearchCondition.MachiningNumber.Trim() + "%' ");
}
//sb.Append(" AND a.ASNNumber ='").Append(SearchCondition.ASNNumber).Append("' ");
}
if (SearchCondition.CustomerID != 0)
{
sb.Append(" AND CustomerID='").Append(SearchCondition.CustomerID).Append("' ");
}
if (SearchCondition.ExpectDate != null)
{
sb.Append(" AND ExpectDate >='").Append(SearchCondition.ExpectDate.DateTimeToString("yyyy-MM-dd 00:00:00.00")).Append("' ");
}
if (SearchCondition.EndExpectDate != null)
{
sb.Append(" AND a.ExpectDate <='").Append(SearchCondition.ExpectDate.DateTimeToString("yyyy-MM-dd 23:59:59.99")).Append("' ");
}
if (!string.IsNullOrEmpty(SearchCondition.MachiningType))
{
sb.Append(" AND MachiningType ='").Append(SearchCondition.MachiningType).Append("' ");
}
return(sb.ToString());
}
public string GenGetInventory(MachiningSearchCondition SearchCondition)
{
StringBuilder sb = new StringBuilder();
if (SearchCondition.CustomerID != 0)
{
sb.Append(" AND CustomerID = ").Append(SearchCondition.CustomerID);
}
if (!string.IsNullOrEmpty(SearchCondition.Location))
{
sb.Append(" AND Location LIKE '%" + SearchCondition.Location.Trim() + "%' ");
}
return(sb.ToString());
}
public IEnumerable <Inventorys> GetLittleInventoryBySearchCondition(MachiningSearchCondition SearchCondition)
{
string sqlWhere = this.GenGetInventory(SearchCondition);
//int tempRowCount = 0;
DbParam[] dbParams = new DbParam[] {
new DbParam("@Where", DbType.String, sqlWhere, ParameterDirection.Input)
//new DbParam("@PageIndex", DbType.Int32, PageIndex, ParameterDirection.Input),
//new DbParam("@PageSize", DbType.Int32, PageSize, ParameterDirection.Input),
//new DbParam("@RowCount", DbType.Int32, tempRowCount, ParameterDirection.Output)
};
DataTable dt = this.ExecuteDataTable("Proc_WMS_GetLittleInventoryBySearchCondition", dbParams);
//RowCount = (int)dbParams[3].Value;
return(dt.ConvertToEntityCollection <Inventorys>());
}
/// <summary>
/// 查询显示 分页查询
/// </summary>
/// <param name="SearchCondition"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="rowCount"></param>
/// <returns></returns>
public IEnumerable <WMS_MachiningHeaderAndDetail> GetMachiningByCondition(MachiningSearchCondition SearchCondition, int pageIndex, int pageSize, out int rowCount)
{
string sqlWhere = this.GenGetWhere(SearchCondition);
int tempRowCount = 0;
DbParam[] dbParams = new DbParam[] {
new DbParam("@Where", DbType.String, sqlWhere, ParameterDirection.Input),
new DbParam("@PageIndex", DbType.Int32, pageIndex, ParameterDirection.Input),
new DbParam("@PageSize", DbType.Int32, pageSize, ParameterDirection.Input),
new DbParam("@RowCount", DbType.Int32, tempRowCount, ParameterDirection.Output)
};
DataTable dt = this.ExecuteDataTable("Proc_WMS_GetMachiningByCondition", dbParams);
rowCount = (int)dbParams[3].Value;
return(dt.ConvertToEntityCollection <WMS_MachiningHeaderAndDetail>());
}
