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