/// <summary>
/// 获取微店产品信息集合
/// </summary>
/// <param name="weiDianId">微店编号</param>
/// <param name="pageSize">页记录数</param>
/// <param name="pageIndex">页序号</param>
/// <param name="recordCount">总记录数</param>
/// <param name="chaXun">查询</param>
/// <returns></returns>
public IList <Eyousoft_yhq.Model.MWeiDianChanPinInfo> GetWeiDianChanPins(string weiDianId, int pageSize, int pageIndex, ref int recordCount, Eyousoft_yhq.Model.MWeiDianChanPinChaXunInfo chaXun)
{
IList <Eyousoft_yhq.Model.MWeiDianChanPinInfo> items = new List <Eyousoft_yhq.Model.MWeiDianChanPinInfo>();
string fields = "*";
StringBuilder sql = new StringBuilder();
string tableName = "view_WeiDian_ChanPin";
string orderByString = " IssueTime DESC ";
string sumString = "";
#region chaxun
sql.Append(" 1=1 ");
sql.AppendFormat(" AND WeiDianId='{0}' ", weiDianId);
if (chaXun != null)
{
if (chaXun.ChanPinLeiXing.HasValue)
{
sql.AppendFormat(" AND ChanPinLeiXing={0} ", chaXun.ChanPinLeiXing.Value);
}
if (!string.IsNullOrEmpty(chaXun.ChanPinName))
{
sql.AppendFormat(" AND ChanPinName LIKE '%{0}%' ", chaXun.ChanPinName);
}
}
#endregion
using (IDataReader rdr = DbHelper.ExecuteReader1(_db, pageSize, pageIndex, ref recordCount, tableName, fields.ToString(), sql.ToString(), orderByString, sumString))
{
while (rdr.Read())
{
var item = new Eyousoft_yhq.Model.MWeiDianChanPinInfo();
item.ChanPinId = rdr["ChanPinId"].ToString();
item.ChanPinName = rdr["ChanPinName"].ToString();
item.ChanPinTuPianFilepath = rdr["ChanPinTuPianFilepath"].ToString();
item.GuanXiId = rdr.GetInt32(rdr.GetOrdinal("IdentityId"));
item.HuiYuanId = rdr["HuiYuanId"].ToString();
item.TianJiaTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
item.WeiDianId = rdr["WeiDianId"].ToString();
item.ShiChangJiaGe = rdr.GetDecimal(rdr.GetOrdinal("ShiChangJiaGe"));
item.JieSuanJiaGe = rdr.GetDecimal(rdr.GetOrdinal("JieSuanJiaGe"));
if (!rdr.IsDBNull(rdr.GetOrdinal("ChuTuanRiQi")))
{
item.ChuTuanRiQi = rdr.GetDateTime(rdr.GetOrdinal("ChuTuanRiQi"));
}
item.IsTianTianFaTuan = rdr["IsTianTianFaTuan"].ToString() == "1";
item.PingLunJiShu = rdr.GetInt32(rdr.GetOrdinal("PingLunJiShu"));
items.Add(item);
}
}
return(items);
}
/// <summary>
/// 获取微店产品信息集合
/// </summary>
/// <param name="weiDianId">微店编号</param>
/// <param name="chaXun">查询</param>
/// <returns></returns>
public IList <Eyousoft_yhq.Model.MWeiDianChanPinInfo> GetWeiDianChanPins(string weiDianId, Eyousoft_yhq.Model.MWeiDianChanPinChaXunInfo chaXun)
{
IList <Eyousoft_yhq.Model.MWeiDianChanPinInfo> items = new List <Eyousoft_yhq.Model.MWeiDianChanPinInfo>();
var sql = new StringBuilder();
sql.AppendFormat("SELECT * FROM view_WeiDian_ChanPin WHERE [WeiDianId]='{0}' ", weiDianId);
if (chaXun != null)
{
if (chaXun.ChanPinLeiXing.HasValue)
{
sql.AppendFormat(" AND ChanPinLeiXing={0} ", chaXun.ChanPinLeiXing.Value);
}
if (!string.IsNullOrEmpty(chaXun.ChanPinName))
{
sql.AppendFormat(" AND ChanPinName LIKE '%{0}%' ", chaXun.ChanPinName);
}
}
sql.AppendFormat(" ORDER BY IssueTime DESC ");
var cmd = _db.GetSqlStringCommand(sql.ToString());
using (var rdr = DbHelper.ExecuteReader(cmd, _db))
{
while (rdr.Read())
{
var item = new Eyousoft_yhq.Model.MWeiDianChanPinInfo();
item.ChanPinId = rdr["ChanPinId"].ToString();
item.ChanPinName = rdr["ChanPinName"].ToString();
item.ChanPinTuPianFilepath = rdr["ChanPinTuPianFilepath"].ToString();
item.GuanXiId = rdr.GetInt32(rdr.GetOrdinal("IdentityId"));
item.HuiYuanId = rdr["HuiYuanId"].ToString();
item.TianJiaTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
item.WeiDianId = rdr["WeiDianId"].ToString();
item.ShiChangJiaGe = rdr.GetDecimal(rdr.GetOrdinal("ShiChangJiaGe"));
item.JieSuanJiaGe = rdr.GetDecimal(rdr.GetOrdinal("JieSuanJiaGe"));
if (!rdr.IsDBNull(rdr.GetOrdinal("ChuTuanRiQi")))
{
item.ChuTuanRiQi = rdr.GetDateTime(rdr.GetOrdinal("ChuTuanRiQi"));
}
item.IsTianTianFaTuan = rdr["IsTianTianFaTuan"].ToString() == "1";
item.PingLunJiShu = rdr.GetInt32(rdr.GetOrdinal("PingLunJiShu"));
items.Add(item);
}
}
return(items);
}
/// <summary>
/// 获取微店产品信息集合
/// </summary>
/// <param name="weiDianId">微店编号</param>
/// <param name="chaXun">查询</param>
/// <returns></returns>
public IList<Eyousoft_yhq.Model.MWeiDianChanPinInfo> GetWeiDianChanPins(string weiDianId,Eyousoft_yhq.Model.MWeiDianChanPinChaXunInfo chaXun)
{
IList<Eyousoft_yhq.Model.MWeiDianChanPinInfo> items = new List<Eyousoft_yhq.Model.MWeiDianChanPinInfo>();
var sql = new StringBuilder();
sql.AppendFormat("SELECT * FROM view_WeiDian_ChanPin WHERE [WeiDianId]='{0}' ", weiDianId);
if (chaXun != null)
{
if (chaXun.ChanPinLeiXing.HasValue)
{
sql.AppendFormat(" AND ChanPinLeiXing={0} ", chaXun.ChanPinLeiXing.Value);
}
if (!string.IsNullOrEmpty(chaXun.ChanPinName))
{
sql.AppendFormat(" AND ChanPinName LIKE '%{0}%' ", chaXun.ChanPinName);
}
}
sql.AppendFormat(" ORDER BY IssueTime DESC ");
var cmd = _db.GetSqlStringCommand(sql.ToString());
using (var rdr = DbHelper.ExecuteReader(cmd, _db))
{
while (rdr.Read())
{
var item = new Eyousoft_yhq.Model.MWeiDianChanPinInfo();
item.ChanPinId = rdr["ChanPinId"].ToString();
item.ChanPinName = rdr["ChanPinName"].ToString();
item.ChanPinTuPianFilepath = rdr["ChanPinTuPianFilepath"].ToString();
item.GuanXiId = rdr.GetInt32(rdr.GetOrdinal("IdentityId"));
item.HuiYuanId = rdr["HuiYuanId"].ToString();
item.TianJiaTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
item.WeiDianId = rdr["WeiDianId"].ToString();
item.ShiChangJiaGe = rdr.GetDecimal(rdr.GetOrdinal("ShiChangJiaGe"));
item.JieSuanJiaGe = rdr.GetDecimal(rdr.GetOrdinal("JieSuanJiaGe"));
if (!rdr.IsDBNull(rdr.GetOrdinal("ChuTuanRiQi"))) item.ChuTuanRiQi = rdr.GetDateTime(rdr.GetOrdinal("ChuTuanRiQi"));
item.IsTianTianFaTuan = rdr["IsTianTianFaTuan"].ToString() == "1";
item.PingLunJiShu = rdr.GetInt32(rdr.GetOrdinal("PingLunJiShu"));
items.Add(item);
}
}
return items;
}
/// <summary>
/// 获取微店产品信息集合
/// </summary>
/// <param name="weiDianId">微店编号</param>
/// <param name="pageSize">页记录数</param>
/// <param name="pageIndex">页序号</param>
/// <param name="recordCount">总记录数</param>
/// <param name="chaXun">查询</param>
/// <returns></returns>
public IList<Eyousoft_yhq.Model.MWeiDianChanPinInfo> GetWeiDianChanPins(string weiDianId, int pageSize, int pageIndex, ref int recordCount, Eyousoft_yhq.Model.MWeiDianChanPinChaXunInfo chaXun)
{
IList<Eyousoft_yhq.Model.MWeiDianChanPinInfo> items = new List<Eyousoft_yhq.Model.MWeiDianChanPinInfo>();
string fields = "*";
StringBuilder sql = new StringBuilder();
string tableName = "view_WeiDian_ChanPin";
string orderByString = " IssueTime DESC ";
string sumString = "";
#region chaxun
sql.Append(" 1=1 ");
sql.AppendFormat(" AND WeiDianId='{0}' ", weiDianId);
if (chaXun != null)
{
if (chaXun.ChanPinLeiXing.HasValue)
{
sql.AppendFormat(" AND ChanPinLeiXing={0} ", chaXun.ChanPinLeiXing.Value);
}
if (!string.IsNullOrEmpty(chaXun.ChanPinName))
{
sql.AppendFormat(" AND ChanPinName LIKE '%{0}%' ", chaXun.ChanPinName);
}
}
#endregion
using (IDataReader rdr = DbHelper.ExecuteReader1(_db, pageSize, pageIndex, ref recordCount, tableName, fields.ToString(), sql.ToString(), orderByString, sumString))
{
while (rdr.Read())
{
var item = new Eyousoft_yhq.Model.MWeiDianChanPinInfo();
item.ChanPinId = rdr["ChanPinId"].ToString();
item.ChanPinName = rdr["ChanPinName"].ToString();
item.ChanPinTuPianFilepath = rdr["ChanPinTuPianFilepath"].ToString();
item.GuanXiId = rdr.GetInt32(rdr.GetOrdinal("IdentityId"));
item.HuiYuanId = rdr["HuiYuanId"].ToString();
item.TianJiaTime = rdr.GetDateTime(rdr.GetOrdinal("IssueTime"));
item.WeiDianId = rdr["WeiDianId"].ToString();
item.ShiChangJiaGe = rdr.GetDecimal(rdr.GetOrdinal("ShiChangJiaGe"));
item.JieSuanJiaGe = rdr.GetDecimal(rdr.GetOrdinal("JieSuanJiaGe"));
if (!rdr.IsDBNull(rdr.GetOrdinal("ChuTuanRiQi"))) item.ChuTuanRiQi = rdr.GetDateTime(rdr.GetOrdinal("ChuTuanRiQi"));
item.IsTianTianFaTuan = rdr["IsTianTianFaTuan"].ToString() == "1";
item.PingLunJiShu = rdr.GetInt32(rdr.GetOrdinal("PingLunJiShu"));
items.Add(item);
}
}
return items;
}
