/// <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>()); }