/// <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.MWeiDianDingDanInfo> GetWeiDianDingDans(string weiDianId, int pageSize, int pageIndex, ref int recordCount, Eyousoft_yhq.Model.MWeiDianDingDanChaXunInfo chaXun)
{
IList <Eyousoft_yhq.Model.MWeiDianDingDanInfo> items = new List <Eyousoft_yhq.Model.MWeiDianDingDanInfo>();
string fields = "*";
StringBuilder sql = new StringBuilder();
string tableName = "view_WeiDian_DingDan";
string orderByString = " XiaDanTime DESC ";
string sumString = "";
#region chaxun
sql.Append(" 1=1 ");
sql.AppendFormat(" AND WeiDianId='{0}' ", weiDianId);
if (chaXun != null)
{
}
#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.MWeiDianDingDanInfo();
item.ChanPinId = rdr["ChanPinId"].ToString();
item.ChanPinName = rdr["ChanPinName"].ToString();
item.ChanPinTuPianFilepath = rdr["ChanPinTuPianFilepath"].ToString();
item.DingDanId = rdr["DingDanId"].ToString();
item.DingDanStatus = (Eyousoft_yhq.Model.OrderState)rdr.GetByte(rdr.GetOrdinal("DingDanStatus"));
item.JiaoYiHao = rdr["JiaoYiHao"].ToString();
item.JinE = rdr.GetDecimal(rdr.GetOrdinal("JinE"));
item.ShenHeStatus = rdr["ShenHeStatus"].ToString();
item.WeiDianId = rdr["WeiDianId"].ToString();
item.XiaDanRenId = rdr["XiaDanRenId"].ToString();
item.XiaDanTime = rdr.GetDateTime(rdr.GetOrdinal("XiaDanTime"));
item.ZhiFuStatus = (Eyousoft_yhq.Model.PaymentState)rdr.GetByte(rdr.GetOrdinal("ZhiFuStatus"));
item.XiaoFeiStatus = (Eyousoft_yhq.Model.ConSumState)rdr.GetByte(rdr.GetOrdinal("XiaoFeiStatus"));
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.MWeiDianDingDanInfo> GetWeiDianDingDans(string weiDianId, int pageSize, int pageIndex, ref int recordCount, Eyousoft_yhq.Model.MWeiDianDingDanChaXunInfo chaXun)
{
IList<Eyousoft_yhq.Model.MWeiDianDingDanInfo> items = new List<Eyousoft_yhq.Model.MWeiDianDingDanInfo>();
string fields = "*";
StringBuilder sql = new StringBuilder();
string tableName = "view_WeiDian_DingDan";
string orderByString = " XiaDanTime DESC ";
string sumString = "";
#region chaxun
sql.Append(" 1=1 ");
sql.AppendFormat(" AND WeiDianId='{0}' ", weiDianId);
if (chaXun != null)
{
}
#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.MWeiDianDingDanInfo();
item.ChanPinId = rdr["ChanPinId"].ToString();
item.ChanPinName = rdr["ChanPinName"].ToString();
item.ChanPinTuPianFilepath = rdr["ChanPinTuPianFilepath"].ToString();
item.DingDanId = rdr["DingDanId"].ToString();
item.DingDanStatus = (Eyousoft_yhq.Model.OrderState)rdr.GetByte(rdr.GetOrdinal("DingDanStatus"));
item.JiaoYiHao = rdr["JiaoYiHao"].ToString();
item.JinE = rdr.GetDecimal(rdr.GetOrdinal("JinE"));
item.ShenHeStatus = rdr["ShenHeStatus"].ToString();
item.WeiDianId = rdr["WeiDianId"].ToString();
item.XiaDanRenId = rdr["XiaDanRenId"].ToString();
item.XiaDanTime = rdr.GetDateTime(rdr.GetOrdinal("XiaDanTime"));
item.ZhiFuStatus = (Eyousoft_yhq.Model.PaymentState)rdr.GetByte(rdr.GetOrdinal("ZhiFuStatus"));
item.XiaoFeiStatus = (Eyousoft_yhq.Model.ConSumState)rdr.GetByte(rdr.GetOrdinal("XiaoFeiStatus"));
items.Add(item);
}
}
return items;
}
