/// <summary> /// 获取积分商品信息集合 /// </summary> /// <param name="companyId">公司编号</param> /// <param name="pageSize">页记录数</param> /// <param name="pageIndex">页序号</param> /// <param name="recordCount">总记录数</param> /// <param name="chaXun">查询</param> /// <returns></returns> public IList <EyouSoft.Model.YlStructure.MWzJiFenShangPinInfo> GetJiFenShangPins(string companyId, int pageSize, int pageIndex, ref int recordCount, EyouSoft.Model.YlStructure.MWzJiFenShangPinChaXunInfo chaXun) { IList <EyouSoft.Model.YlStructure.MWzJiFenShangPinInfo> items = new List <EyouSoft.Model.YlStructure.MWzJiFenShangPinInfo>(); string tableName = "view_YL_JiFenShangPin"; string fields = "*"; string orderByString = "IssueTime DESC"; string sumString = string.Empty; StringBuilder sql = new StringBuilder(); sql.AppendFormat(" CompanyId='{0}' ", companyId); if (chaXun != null) { switch (chaXun.PaiXu) { case 0: orderByString = "JiFen DESC"; break; case 1: orderByString = "JiFen ASC"; break; case 2: orderByString = "LiPinKaJinE DESC"; break; case 3: orderByString = "LiPinKaJinE ASC"; break; case 4: orderByString = "XianJinJinE DESC"; break; case 5: orderByString = "XianJinJinE ASC"; break; case 6: orderByString = "IssueTime DESC"; break; case 7: orderByString = "IssueTime ASC"; break; default: orderByString = "IssueTime DESC"; break; } if (!string.IsNullOrEmpty(chaXun.MingCheng)) { sql.AppendFormat(" AND MingCheng LIKE '%{0}%' ", chaXun.MingCheng); } if (chaXun.Status.HasValue) { sql.AppendFormat(" AND Status={0} ", (int)chaXun.Status.Value); } } using (IDataReader rdr = DbHelper.ExecuteReader1(_db, pageSize, pageIndex, ref recordCount, tableName, fields.ToString(), sql.ToString(), orderByString, sumString)) { while (rdr.Read()) { var info = new EyouSoft.Model.YlStructure.MWzJiFenShangPinInfo(); info.CompanyId = rdr["CompanyId"].ToString(); info.FangShis = null; info.FuJians = null; info.IssueTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime")); info.MingCheng = rdr["MingCheng"].ToString(); info.OperatorId = rdr["OperatorId"].ToString(); info.ShangPinId = rdr["ShangPinId"].ToString(); info.ShuoMing = rdr["ShuoMing"].ToString(); info.XuZhi = rdr["XuZhi"].ToString(); info.Status = (EyouSoft.Model.EnumType.YlStructure.JiFenShangPinStatus)rdr.GetByte(rdr.GetOrdinal("Status")); info.ShuLiang = rdr.GetInt32(rdr.GetOrdinal("ShuLiang")); info.ChengJiaoShuLiang = rdr.GetInt32(rdr.GetOrdinal("ChengJiaoShuLiang")); info.ShangPinJinE = rdr.GetDecimal(rdr.GetOrdinal("ShangPinJinE")); items.Add(info); } } if (items != null && items.Count > 0) { foreach (var item in items) { item.FangShis = GetJiFenShangPinFangShis(item.ShangPinId); item.FuJians = GetJiFenShangPinFuJians(item.ShangPinId); } } return(items); }