private ZXPlaceInfo GetQueryZXPlaceInfo() { ZXPlaceInfo qrZXPlaceInfo = new ZXPlaceInfo(); if (!string.IsNullOrEmpty(this.txtZxPlaceCode.Text)) { qrZXPlaceInfo.ZXPlaceCode = txtZxPlaceCode.Text; } return(qrZXPlaceInfo); }
/// <summary> ///查询装卸点列表信息 /// </summary> /// <param name="info">ZXPlaceInfo实体类(可以是根据装卸点编号,如果为null则查询所有装卸点信息)</param> /// <param name="pageSize">网页列表一次最多显示多少行记录</param> /// <param name="currentPage">用户查询的第几页信息</param> /// <param name="sortInfo">排列的列名实体类,可以指定几个列名,并且可以指定排列是升序还是降序</param> /// <param name="isFirstSearch">代表是否第一点击查询(如果是则需要对totalRecNum赋值,否则不需要,这样可以避免每次都去计算记录总数)</param> /// <param name="totalRecNum">根据查询条件查询的总记录数</param> /// <param name="retValue"返回string(DataSet格式)类型,字段包括仓库名称、装卸点编号、装卸点标签号等信息</param> /// <returns>返回bool类型,错误返回false,正确返回true</returns> public static bool QueryZXPlaceList(ZXPlaceInfo info, int pageSize, int currentPage, SortInfo sortInfo, bool isFirstSearch, out int totalRecNum, out string retValue) { totalRecNum = 0; retValue = null; #region 处理查询语句和排序语句 string sqlSelect = @"select zx.*,wh.whnumber,wh.whname"; string[] sortColumns = null; if (sortInfo != null && !string.IsNullOrEmpty(sortInfo.SortSql)) { sortColumns = sortInfo.SortSql.Split(','); string sqlSortIn = null; if (sortColumns != null && sortColumns.Length > 0) { foreach (string sortItem in sortColumns) { sqlSortIn += "zx." + sortItem + ","; } sqlSortIn = sqlSortIn.Substring(0, sqlSortIn.Length - 1); } sqlSelect += ",Row_Number() Over(Order By " + sqlSortIn + ") AS serialNum"; } else { sqlSelect += ",Row_Number() Over(Order By zx.ZxPlaceID) AS serialNum"; } string sqlFrom = @" from View_ZXPlace zx,WareHouse wh Where zx.whid=wh.whid"; #endregion #region 处理参数 List <System.Data.SqlClient.SqlParameter> listSqlPara = new List <System.Data.SqlClient.SqlParameter>(); if (info != null) { System.Data.SqlClient.SqlParameter sqlPara = null; if (!string.IsNullOrEmpty(info.ZXPlaceCode)) { sqlFrom += " AND zx.ZXPlaceCode like '%'+@ZXPlaceCode+'%'"; sqlPara = new System.Data.SqlClient.SqlParameter(); sqlPara.SqlDbType = SqlDbType.NVarChar; sqlPara.ParameterName = "ZXPlaceCode"; sqlPara.Value = info.ZXPlaceCode; listSqlPara.Add(sqlPara); } } #endregion return(ExcutePage.ExcutePageCommand(sqlSelect, sqlFrom, sortColumns, pageSize, currentPage, listSqlPara, isFirstSearch, out totalRecNum, out retValue)); }