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