/// <summary> /// 返回分页列表 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <returns></returns> public IList <Eyousoft_yhq.Model.GYSticket> GetList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.GysTicketSer serModel) { IList <Eyousoft_yhq.Model.GYSticket> list = new List <Eyousoft_yhq.Model.GYSticket>(); string tableName = "GYSTicket"; string fileds = " ID , CusName , CusSex , CusMob , PlaneTicket , IssueTime , Remark, OpertorID,OrderState,TicketState "; string orderByString = "IssueTime desc"; StringBuilder query = new StringBuilder(); query.Append(" 1=1 "); if (serModel != null) { if (!string.IsNullOrEmpty(serModel.OpertorID)) { query.AppendFormat(" and OpertorID = '{0}' ", serModel.OpertorID); } if (!string.IsNullOrEmpty(serModel.cusName)) { query.AppendFormat(" and CusName LIKE '%{0}%' ", serModel.cusName); } if (!string.IsNullOrEmpty(serModel.cusMob)) { query.AppendFormat(" and CusMob LIKE '%{0}%' ", serModel.cusMob); } if (!string.IsNullOrEmpty(serModel.tickNO)) { query.AppendFormat(" and PlaneTicket LIKE '%{0}%' ", serModel.tickNO); } } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { Eyousoft_yhq.Model.GYSticket model = new Eyousoft_yhq.Model.GYSticket(); model.ID = dr.GetString(dr.GetOrdinal("ID"));; model.CusName = dr.GetString(dr.GetOrdinal("CusName")); model.CusSex = (Eyousoft_yhq.Model.sexType)dr.GetByte(dr.GetOrdinal("CusSex")); model.CusMob = dr.GetString(dr.GetOrdinal("CusMob")); model.PlaneTicket = dr.GetString(dr.GetOrdinal("PlaneTicket")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.Remark = dr.GetString(dr.GetOrdinal("Remark")); model.OpertorID = dr.GetString(dr.GetOrdinal("OpertorID")); model.orderState = (Eyousoft_yhq.Model.TickOrderState)dr.GetByte(dr.GetOrdinal("OrderState")); model.payState = (Eyousoft_yhq.Model.PaymentState)dr.GetByte(dr.GetOrdinal("TicketState")); list.Add(model); } } return(list); }
/// <summary> /// 获取微店信息集合 /// </summary> /// <param name="pageSize">每页记录数</param> /// <param name="pageIndex">页序号</param> /// <param name="recordCount">总记录数</param> /// <param name="chaXun">查询</param> /// <returns></returns> public IList <Eyousoft_yhq.Model.MWeiDianInfo> GetWeiDians(int pageSize, int pageIndex, ref int recordCount, Eyousoft_yhq.Model.MWeiDianChaXunInfo chaXun) { IList <Eyousoft_yhq.Model.MWeiDianInfo> items = new List <Eyousoft_yhq.Model.MWeiDianInfo>(); string fields = "*"; StringBuilder sql = new StringBuilder(); string tableName = "view_WeiDian"; string orderByString = " ShenQingTime DESC "; string sumString = ""; #region chaxun sql.Append(" 1=1 "); if (chaXun != null) { if (!string.IsNullOrEmpty(chaXun.HuiYuanName)) { sql.AppendFormat(" AND HuiYuanName LIKE '%{0}%' ", chaXun.HuiYuanName); } 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); } if (!string.IsNullOrEmpty(chaXun.YongHuMing)) { sql.AppendFormat(" AND YongHuMing LIKE '%{0}%' ", chaXun.YongHuMing); } } #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.MWeiDianInfo(); item.HuiYuanId = rdr["HuiYuanId"].ToString(); item.IdentityId = rdr.GetInt32(rdr.GetOrdinal("IdentityId")); item.JieShao = rdr["JieShao"].ToString(); item.MingCheng = rdr["MingCheng"].ToString(); item.ShenHeTime = rdr.GetDateTime(rdr.GetOrdinal("ShenHeTime")); item.ShenQingTime = rdr.GetDateTime(rdr.GetOrdinal("ShenQingTime")); item.Status = (Eyousoft_yhq.Model.WeiDianStatus)rdr.GetInt32(rdr.GetOrdinal("Status")); item.WeiDianId = rdr["WeiDianId"].ToString(); item.HuiYuanName = rdr["HuiYuanName"].ToString(); item.YongHuMing = rdr["YongHuMing"].ToString(); item.LogoFilepath = rdr["LogoFilepath"].ToString(); item.DianHua = rdr["DianHua"].ToString(); items.Add(item); } } return(items); }
/// <summary> /// 获取分页数据 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <returns></returns> public IList <MChongZhi> GetList(int PageSize, int PageIndex, ref int RecordCount, MChongZhiSer serModel) { IList <MChongZhi> list = new List <MChongZhi>(); string tableName = "view_ChongZhi"; string fileds = "* "; string orderByString = "ISSUETIME DESC "; StringBuilder query = new StringBuilder(); query.AppendFormat(" PayState=2 "); if (serModel != null) { if (!string.IsNullOrEmpty(serModel.OrderCode)) { query.AppendFormat(" and OrderCode like '%{0}%' ", serModel.OrderCode); } if (!string.IsNullOrEmpty(serModel.TradeNo)) { query.AppendFormat(" and TradeNo like '%{0}%' ", serModel.TradeNo); } if (!string.IsNullOrEmpty(serModel.Account)) { query.AppendFormat(" and UserName like '%{0}%' ", serModel.Account); } if (!string.IsNullOrEmpty(serModel.OperatorID)) { query.AppendFormat(" and OperatorID = '{0}' ", serModel.OperatorID); } } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { MChongZhi model = new MChongZhi(); model.UserName = dr.IsDBNull(dr.GetOrdinal("UserName")) ? "" : dr.GetString(dr.GetOrdinal("UserName")); model.ContactName = dr.IsDBNull(dr.GetOrdinal("ContactName")) ? "" : dr.GetString(dr.GetOrdinal("ContactName")); model.OrderID = dr.GetString(dr.GetOrdinal("OrderID")); model.OperatorID = dr.GetString(dr.GetOrdinal("OperatorID")); model.OptMoney = dr.GetDecimal(dr.GetOrdinal("OptMoney")); model.Issuetime = dr.GetDateTime(dr.GetOrdinal("Issuetime")); model.OrderCode = dr.GetString(dr.GetOrdinal("OrderCode")); model.PayState = (PaymentState)dr.GetByte(dr.GetOrdinal("PayState")); model.TradeNo = dr.IsDBNull(dr.GetOrdinal("TradeNo")) ? "" : dr.GetString(dr.GetOrdinal("TradeNo")); list.Add(model); } } return(list); }
/// <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="pageSize"></param> /// <param name="pageIndex"></param> /// <param name="recordCount"></param> /// <param name="chaXun"></param> /// <returns></returns> public IList <Eyousoft_yhq.Model.MSysProvince> GetSysProvinceList(int pageSize, int pageIndex, ref int recordCount, Eyousoft_yhq.Model.MSysProvince chaXun) { IList <Eyousoft_yhq.Model.MSysProvince> ResultList = null; string tableName = "tbl_SysProvince"; string fields = "ID, CountryId,HeaderLetter,Name,AreaId,SortId,(select [Id],[ProvinceId],[Name],[CenterCityId],[HeaderLetter],[IsSite],[DomainName],[IsEnabled] from tbl_SysCity where tbl_SysCity.ProvinceId = tbl_SysProvince.ID for xml raw,root('Root')) as CityList "; string query = " 1=1 "; if (chaXun != null) { if (chaXun.CountryId > 0) { query = query + string.Format(" AND CountryId={0} ", chaXun.CountryId); } if (!string.IsNullOrEmpty(chaXun.HeaderLetter)) { query = query + string.Format(" AND HeaderLetter like '%{0}%'", chaXun.HeaderLetter); } if (!string.IsNullOrEmpty(chaXun.Name)) { query = query + string.Format(" AND Name like '%{0}%'", chaXun.Name); } if (chaXun.AreaId > 0) { query = query + string.Format(" AND AreaId={0} ", chaXun.AreaId); } } string orderByString = " ID ASC"; using (IDataReader dr = DbHelper.ExecuteReader1(_db, pageSize, pageIndex, ref recordCount, tableName, fields, query , orderByString, string.Empty)) { ResultList = new List <Eyousoft_yhq.Model.MSysProvince>(); while (dr.Read()) { Eyousoft_yhq.Model.MSysProvince model = new Eyousoft_yhq.Model.MSysProvince() { ID = dr.GetInt32(dr.GetOrdinal("ID")), CountryId = dr.GetInt32(dr.GetOrdinal("CountryId")), HeaderLetter = dr.IsDBNull(dr.GetOrdinal("HeaderLetter")) ? "" : dr.GetString(dr.GetOrdinal("HeaderLetter")), Name = dr.IsDBNull(dr.GetOrdinal("Name")) ? "" : dr.GetString(dr.GetOrdinal("Name")), AreaId = dr.GetInt32(dr.GetOrdinal("AreaId")), SortId = dr.GetInt32(dr.GetOrdinal("SortId")) }; if (!dr.IsDBNull(dr.GetOrdinal("CityList"))) { model.CityList = (List <Eyousoft_yhq.Model.MSysCity>) this.GetCity(dr.GetString(dr.GetOrdinal("CityList"))); } ResultList.Add(model); model = null; } }; return(ResultList); }
public IList <EyouSoft.Model.SSOStructure.MGuanLiYuanInfo> GetList(int PageSize, int PageIndex, ref int RecordCount, EyouSoft.Model.SSOStructure.MGuanLiYuanChaXunInfo serModel) { IList <EyouSoft.Model.SSOStructure.MGuanLiYuanInfo> list = new List <EyouSoft.Model.SSOStructure.MGuanLiYuanInfo>(); string tableName = "tbl_User"; string fileds = " * "; string orderByString = "IssueTime desc"; StringBuilder query = new StringBuilder(); query.AppendFormat(" 1=1 "); if (serModel != null) { if (!string.IsNullOrEmpty(serModel.Username)) { query.AppendFormat(" and UserName like '%{0}%' ", serModel.Username); } if (!string.IsNullOrEmpty(serModel.XingMing)) { query.AppendFormat(" and ContactName like '%{0}%' ", serModel.XingMing); } } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { var model = new EyouSoft.Model.SSOStructure.MGuanLiYuanInfo(); model.UserId = dr["UserID"].ToString(); model.Username = dr["UserName"].ToString(); model.MiMa = dr["UserPwd"].ToString(); model.XingMing = dr["ContactName"].ToString(); if (!dr.IsDBNull(dr.GetOrdinal("ContactSex"))) { model.XingBie = (sexType)dr.GetByte(dr.GetOrdinal("ContactSex")); } model.BeiZhu = dr["Remark"].ToString(); model.Telephone = dr["ContactTel"].ToString(); model.IsAdmin = dr["IsAdmin"].ToString() == "1"; model.Status = dr.GetByte(dr.GetOrdinal("UserState")); model.Privs = dr["Privs"].ToString(); model.GongZhangFilepath = dr["SealImg"].ToString(); model.CreateTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.LeiXing = (Eyousoft_yhq.Model.WebmasterLeiXing)dr.GetInt32(dr.GetOrdinal("LeiXing")); list.Add(model); } } return(list); }
/// <summary> /// 获取保险编号 /// </summary> /// <param name="id"></param> /// <returns></returns> public IList <MPlanIns> GetList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.MPlanInsSer serModel) { IList <Eyousoft_yhq.Model.MPlanIns> list = new List <Eyousoft_yhq.Model.MPlanIns>(); string tableName = "tbl_PlantIns"; string fileds = " * "; string orderByString = " IssueTime desc "; StringBuilder query = new StringBuilder(); query.Append(" 1=1"); if (serModel != null) { if (!string.IsNullOrEmpty(serModel.OperatorID)) { query.AppendFormat(" and OperatorID='{0}' ", serModel.OperatorID); } } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { Eyousoft_yhq.Model.MPlanIns model = new Eyousoft_yhq.Model.MPlanIns(); model.ID = dr.GetInt32(dr.GetOrdinal("ID")); model.InsMoney = dr.GetDecimal(dr.GetOrdinal("InsMoney")); model.InsName = dr.GetString(dr.GetOrdinal("InsName")); model.InsNO = dr.GetString(dr.GetOrdinal("InsNO")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.LinkAddress = dr.GetString(dr.GetOrdinal("LinkAddress")); model.LinkMail = dr.GetString(dr.GetOrdinal("LinkMail")); model.LinkTel = dr.GetString(dr.GetOrdinal("LinkTel")); model.OperatorID = dr.GetString(dr.GetOrdinal("OperatorID")); model.OperatorName = dr.GetString(dr.GetOrdinal("OperatorName")); model.OrderCode = dr.GetString(dr.GetOrdinal("OrderCode")); model.OrderID = dr.GetString(dr.GetOrdinal("OrderID")); model.PlantID = dr.GetString(dr.GetOrdinal("PlantID")); model.PolicTor = dr.GetString(dr.GetOrdinal("PolicTor")); model.State = (InsState)dr.GetByte(dr.GetOrdinal("State")); list.Add(model); } } return(list); }
/// <summary> /// 获得数据列表集合,分页 /// </summary> /// <param name="pageSize"></param> /// <param name="pageIndex"></param> /// <param name="recordCount"></param> /// <param name="chaXun"></param> /// <returns></returns> public IList <Eyousoft_yhq.Model.MSysDistrict> GetSysDistrictList(int pageSize, int pageIndex, ref int recordCount, Eyousoft_yhq.Model.MSysDistrict chaXun) { IList <Eyousoft_yhq.Model.MSysDistrict> ResultList = null; string tableName = "tbl_SysDistrict"; string identityColumnName = "Id"; string fields = "Id, Name,ProvinceId,CityId,HeaderLetter"; string query = " 1=1 "; if (chaXun != null) { if (!string.IsNullOrEmpty(chaXun.Name)) { query = query + string.Format(" AND Name like '%{0}%'", chaXun.Name); } if (chaXun.ProvinceId > 0) { query = query + string.Format(" AND ProvinceId={0} ", chaXun.ProvinceId); } if (chaXun.CityId > 0) { query = query + string.Format(" AND CityId={0} ", chaXun.CityId); } if (!string.IsNullOrEmpty(chaXun.HeaderLetter)) { query = query + string.Format(" AND HeaderLetter like '%{0}%'", chaXun.HeaderLetter); } } string orderByString = " Id ASC"; using (IDataReader dr = DbHelper.ExecuteReader1(_db, pageSize, pageIndex, ref recordCount, tableName, identityColumnName, fields, query, orderByString)) { ResultList = new List <Eyousoft_yhq.Model.MSysDistrict>(); while (dr.Read()) { Eyousoft_yhq.Model.MSysDistrict model = new Eyousoft_yhq.Model.MSysDistrict() { Id = dr.GetInt32(dr.GetOrdinal("Id")), Name = dr.IsDBNull(dr.GetOrdinal("Name")) ? "" : dr.GetString(dr.GetOrdinal("Name")), ProvinceId = dr.GetInt32(dr.GetOrdinal("ProvinceId")), CityId = dr.GetInt32(dr.GetOrdinal("CityId")), HeaderLetter = dr.IsDBNull(dr.GetOrdinal("HeaderLetter")) ? "" : dr.GetString(dr.GetOrdinal("HeaderLetter")) }; ResultList.Add(model); model = null; } }; return(ResultList); }
/// <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="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <returns></returns> public IList <MYouJi> GetList(int PageSize, int PageIndex, ref int RecordCount, MYouJiSer serModel) { IList <MYouJi> list = new List <MYouJi>(); string tableName = "tbl_HuiYouYouJi"; string fileds = " * "; string orderByString = " IssueTime DESC "; StringBuilder query = new StringBuilder(); query.AppendFormat(" 1=1 "); if (serModel != null) { if (!string.IsNullOrEmpty(serModel.HuiYuanId)) { query.AppendFormat(" AND HuiYuanId='{0}' ", serModel.HuiYuanId); } if (serModel.YouJiType.HasValue) { query.AppendFormat(" AND YouJiLeiXing='{0}' ", (int)serModel.YouJiType.Value); } } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { MYouJi model = new MYouJi(); model.YouJiId = dr.IsDBNull(dr.GetOrdinal("YouJiId")) ? "" : dr.GetString(dr.GetOrdinal("YouJiId")); model.YouJiTitle = dr.IsDBNull(dr.GetOrdinal("YouJiTitle")) ? "" : dr.GetString(dr.GetOrdinal("YouJiTitle")); model.YouJiContent = dr.IsDBNull(dr.GetOrdinal("YouJiContent")) ? null : getStrJson(dr.GetString(dr.GetOrdinal("YouJiContent"))); model.HuiYuanId = dr.IsDBNull(dr.GetOrdinal("HuiYuanId")) ? "" : dr.GetString(dr.GetOrdinal("HuiYuanId")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.ShiPinLink = dr.IsDBNull(dr.GetOrdinal("ShiPinLink")) ? "" : dr.GetString(dr.GetOrdinal("ShiPinLink")); model.WeiXinMa = dr.IsDBNull(dr.GetOrdinal("WeiXinMa")) ? "" : dr.GetString(dr.GetOrdinal("WeiXinMa")); list.Add(model); } } return(list); }
/// <summary> /// 获取分页数据 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <returns></returns> public IList <ChouJiang> GetList(int PageSize, int PageIndex, ref int RecordCount, ChouJiangSer serModel) { IList <ChouJiang> list = new List <ChouJiang>(); string tableName = "view_ChouJiang"; string fileds = " * "; string orderByString = "ChouJiangShiJian desc"; StringBuilder query = new StringBuilder(); query.AppendFormat(" 1=1 "); if (serModel != null) { if (!string.IsNullOrEmpty(serModel.CaoZuoRenID)) { query.AppendFormat(" and CaoZuoRenID = '{0}' ", serModel.CaoZuoRenID); } } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { ChouJiang model = new ChouJiang(); model.CaoZuoRenID = dr.GetString(dr.GetOrdinal("CaoZuoRenID")); model.ChouJiangID = dr.GetString(dr.GetOrdinal("ChouJiangID")); model.ChouJiangShiJian = dr.GetDateTime(dr.GetOrdinal("ChouJiangShiJian")); model.ContactName = dr.GetString(dr.GetOrdinal("ContactName")); model.DianShu = dr.GetDecimal(dr.GetOrdinal("DianShu")); model.ID = dr.GetString(dr.GetOrdinal("ID")); model.JieGuo = (ChouJiangJieGuo)dr.GetByte(dr.GetOrdinal("JieGuo")); model.LiuShuiHao = dr.GetString(dr.GetOrdinal("LiuShuiHao")); model.UserName = dr.GetString(dr.GetOrdinal("UserName")); model.FangShi = (JiangLiFangShi)dr.GetByte(dr.GetOrdinal("FangShi")); list.Add(model); } } return(list); }
/// <summary> /// 获得数据列表集合,分页 /// </summary> /// <param name="pageSize"></param> /// <param name="pageIndex"></param> /// <param name="recordCount"></param> /// <param name="chaXun"></param> /// <returns></returns> public IList <Eyousoft_yhq.Model.MSysCountry> GetSysCountryList(int pageSize, int pageIndex, ref int recordCount, Eyousoft_yhq.Model.MSysCountry chaXun) { IList <Eyousoft_yhq.Model.MSysCountry> ResultList = null; string tableName = "tbl_SysCountry"; string identityColumnName = "Id"; string fields = "Id, EnName,Zones,CnName"; string query = " 1=1 "; if (chaXun != null) { if (chaXun.Zones > 0) { query = query + string.Format(" AND Zones={0} ", chaXun.Zones); } if (!string.IsNullOrEmpty(chaXun.EnName)) { query = query + string.Format(" AND EnName like '%{0}%'", chaXun.EnName); } if (!string.IsNullOrEmpty(chaXun.CnName)) { query = query + string.Format(" AND CnName like '%{0}%'", chaXun.CnName); } } string orderByString = " ID ASC"; using (IDataReader dr = DbHelper.ExecuteReader1(_db, pageSize, pageIndex, ref recordCount, tableName, identityColumnName, fields, query, orderByString)) { ResultList = new List <Eyousoft_yhq.Model.MSysCountry>(); while (dr.Read()) { Eyousoft_yhq.Model.MSysCountry model = new Eyousoft_yhq.Model.MSysCountry() { Id = dr.GetInt32(dr.GetOrdinal("Id")), EnName = dr.IsDBNull(dr.GetOrdinal("EnName")) ? "" : dr.GetString(dr.GetOrdinal("EnName")), Zones = dr.GetInt32(dr.GetOrdinal("Zones")), CnName = dr.IsDBNull(dr.GetOrdinal("CnName")) ? "" : dr.GetString(dr.GetOrdinal("CnName")) }; ResultList.Add(model); model = null; } }; return(ResultList); }
/// <summary> /// 获取分页列表 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <returns></returns> public IList <Eyousoft_yhq.Model.Comment> GetList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.serComment serModel) { IList <Eyousoft_yhq.Model.Comment> list = new List <Eyousoft_yhq.Model.Comment>(); string tableName = "tbl_Comment"; string fileds = " ProductID,CommentID,PeopleID,CommentText,IssueTime,(select ContactName from tbl_member where userid=PeopleID) as PeopleName "; string orderByString = "IssueTime desc"; StringBuilder query = new StringBuilder(); query.Append(" 1=1 "); if (serModel != null) { if (serModel.sTime.HasValue) { query.AppendFormat(" AND datediff(day,'{0}',IssueTime)>=0 ", serModel.sTime.Value); } if (serModel.eTime.HasValue) { query.AppendFormat(" AND datediff(day,'{0}',IssueTime)<=0 ", serModel.eTime.Value); } } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { Eyousoft_yhq.Model.Comment model = new Eyousoft_yhq.Model.Comment(); model.ProductID = dr.IsDBNull(dr.GetOrdinal("ProductID")) ? "" : dr.GetString(dr.GetOrdinal("ProductID"));; model.CommentID = dr.IsDBNull(dr.GetOrdinal("CommentID")) ? "" : dr.GetString(dr.GetOrdinal("CommentID")); model.PeopleID = dr.IsDBNull(dr.GetOrdinal("PeopleID")) ? "" : dr.GetString(dr.GetOrdinal("PeopleID")); model.CommentText = dr.IsDBNull(dr.GetOrdinal("CommentText")) ? "" : dr.GetString(dr.GetOrdinal("CommentText")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.PeopleName = dr.IsDBNull(dr.GetOrdinal("PeopleName")) ? "" : dr.GetString(dr.GetOrdinal("PeopleName")); list.Add(model); } } return(list); }
/// <summary> /// 获取分页数据 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <returns></returns> public IList <Eyousoft_yhq.Model.MConDetaile> GetModelList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.MConDetaile serModel) { IList <Eyousoft_yhq.Model.MConDetaile> list = new List <Eyousoft_yhq.Model.MConDetaile>(); string tableName = "tbl_ConDetailed"; string fileds = " ID,HuiYuanID,(select UserName from tbl_Member where UserId=tbl_ConDetailed.HuiYuanID ) as HuiYuanName, JiaoYiHao ,JinE ,JiaoYiShiJian, XiaoFeiFangShi ,DingDanBianHao ,JiaoYiDuiXiang,(select UserName from tbl_Member where UserId=tbl_ConDetailed.JiaoYiDuiXiang ) as DXName, DingDanLeiBie "; string orderByString = "JiaoYiShiJian desc "; StringBuilder query = new StringBuilder(); query.AppendFormat(" 1=1 "); if (serModel != null) { } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { Eyousoft_yhq.Model.MConDetaile model = new Eyousoft_yhq.Model.MConDetaile(); model.ID = dr.GetInt32(dr.GetOrdinal("ID")); model.HuiYuanID = dr.GetString(dr.GetOrdinal("HuiYuanID")); model.HuiYuanName = dr.GetString(dr.GetOrdinal("HuiYuanName")); model.JiaoYiHao = dr.GetString(dr.GetOrdinal("JiaoYiHao")); model.JinE = dr.GetDecimal(dr.GetOrdinal("JinE")); model.JiaoYiShiJian = dr.GetDateTime(dr.GetOrdinal("JiaoYiShiJian")); model.XFway = (Eyousoft_yhq.Model.XFfangshi)dr.GetByte(dr.GetOrdinal("XiaoFeiFangShi")); model.DingDanBianHao = dr.GetString(dr.GetOrdinal("DingDanBianHao")); model.DuiXiangName = dr.IsDBNull(dr.GetOrdinal("DXName")) ? "" : dr.GetString(dr.GetOrdinal("DXName")); model.DDCarrtes = (Eyousoft_yhq.Model.DDleibie)dr.GetByte(dr.GetOrdinal("DingDanLeiBie")); list.Add(model); } } return(list); }
/// <summary> /// 获取分页列表 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <returns></returns> public IList <Eyousoft_yhq.Model.MYuYue> GetList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.MYuYueSer serModel) { IList <Eyousoft_yhq.Model.MYuYue> list = new List <Eyousoft_yhq.Model.MYuYue>(); string tableName = "tbl_YuYue"; string fileds = " * "; string orderByString = " YYTime desc "; StringBuilder query = new StringBuilder(); query.Append(" 1=1 "); if (serModel != null) { } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { Eyousoft_yhq.Model.MYuYue model = new Eyousoft_yhq.Model.MYuYue(); model.YYID = dr.GetInt32(dr.GetOrdinal("YYID")); model.YYRoute = dr.IsDBNull(dr.GetOrdinal("YYRoute")) ? "" : dr.GetString(dr.GetOrdinal("YYRoute")); model.YYName = dr.IsDBNull(dr.GetOrdinal("YYName")) ? "" : dr.GetString(dr.GetOrdinal("YYName")); model.YYMobile = dr.IsDBNull(dr.GetOrdinal("YYMobile")) ? "" : dr.GetString(dr.GetOrdinal("YYMobile")); model.YYInfo = dr.IsDBNull(dr.GetOrdinal("YYInfo")) ? "" : dr.GetString(dr.GetOrdinal("YYInfo")); model.YYTime = dr.GetDateTime(dr.GetOrdinal("YYTime")); list.Add(model); } }; return(list); }
public IList <Eyousoft_yhq.Model.MJiPiaoBaoCun> GetModelList(int PageSize, int PageIndex, ref int RecordCount, string userid) { IList <Eyousoft_yhq.Model.MJiPiaoBaoCun> list = new List <Eyousoft_yhq.Model.MJiPiaoBaoCun>(); Eyousoft_yhq.Model.MJiPiaoBaoCun model = null; string tableName = "tbl_PlanTicket"; string fileds = " OrderID,OrderCode, OpeatorID ,OpeatorName ,IssueTime, payState ,ModifyTag ,JpAdress,InsPrice"; string orderByString = "IssueTime desc "; StringBuilder query = new StringBuilder(); query.AppendFormat(" 1=1 and OpeatorID = '{0}' ", userid); //if (serModel != null) //{ //} using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { model = new Eyousoft_yhq.Model.MJiPiaoBaoCun(); model.OrderID = dr.GetString(dr.GetOrdinal("OrderID")); model.OrderCode = dr.GetString(dr.GetOrdinal("OrderCode")); model.OpeatorID = dr.GetString(dr.GetOrdinal("OpeatorID")); model.OpeatorName = dr.GetString(dr.GetOrdinal("OpeatorName")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.payState = (TickOrderPayState)dr.GetByte(dr.GetOrdinal("payState")); model.ModifyTag = dr.IsDBNull(dr.GetOrdinal("ModifyTag")) ? "" : dr.GetString(dr.GetOrdinal("ModifyTag")); model.JpAdress = dr.IsDBNull(dr.GetOrdinal("JpAdress")) ? "" : dr.GetString(dr.GetOrdinal("JpAdress")); model.InsPrice = dr.GetDecimal(dr.GetOrdinal("InsPrice")); list.Add(model); } } return(list); }
/// <summary> /// 获取发送列表 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <param name="i"></param> /// <returns></returns> public IList <Eyousoft_yhq.Model.MsgLog> GetList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.serMsgLog serModel) { IList <Eyousoft_yhq.Model.MsgLog> list = new List <Eyousoft_yhq.Model.MsgLog>(); string tableName = "tbl_MsgLog"; string fileds = " msgID,TelCode,MsgText,ReResult,Issuetime "; string orderByString = " msgID desc"; StringBuilder query = new StringBuilder(); query.Append(" 1=1 "); if (serModel != null) { if (!string.IsNullOrEmpty(serModel.TelCode)) { query.AppendFormat(" and TelCode = '{0}' ", serModel.TelCode); } } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { Eyousoft_yhq.Model.MsgLog model = new Eyousoft_yhq.Model.MsgLog(); model.msgid = dr.GetInt32(dr.GetOrdinal("msgID")); model.TelCode = dr.IsDBNull(dr.GetOrdinal("TelCode")) ? "" : dr.GetString(dr.GetOrdinal("TelCode")); model.MsgText = dr.IsDBNull(dr.GetOrdinal("MsgText")) ? "" : dr.GetString(dr.GetOrdinal("MsgText")); model.ReResult = dr.IsDBNull(dr.GetOrdinal("ReResult")) ? "" : dr.GetString(dr.GetOrdinal("ReResult")); model.Issuetime = dr.GetDateTime(dr.GetOrdinal("ProductID")); list.Add(model); } } return(list); }
/// <summary> /// 获取分页数据 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <returns></returns> public IList <HongBao> GetList(int PageSize, int PageIndex, ref int RecordCount, HongBaoSer serModel) { IList <HongBao> list = new List <HongBao>(); string tableName = "view_hongbao"; string fileds = " ID , UserID , IssueTime , HongBaoJinE,UserName,ContactName "; string orderByString = "IssueTime desc"; StringBuilder query = new StringBuilder(); query.AppendFormat(" 1=1 "); if (serModel != null) { if (!string.IsNullOrEmpty(serModel.UserID)) { query.AppendFormat(" and userid = '{0}' ", serModel.UserID); } } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { HongBao model = new HongBao(); model.ID = dr.GetString(dr.GetOrdinal("ID")); model.UserID = dr.GetString(dr.GetOrdinal("UserID")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.HongBaoJinE = dr.GetDecimal(dr.GetOrdinal("HongBaoJinE")); model.UserName = dr.GetString(dr.GetOrdinal("UserName")); model.ContactName = dr.GetString(dr.GetOrdinal("ContactName")); list.Add(model); } } return(list); }
/// <summary> /// 获取分页列表 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <returns></returns> public IList <Eyousoft_yhq.Model.CustomMsg> GetList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.serCustomMsg serModel) { IList <Eyousoft_yhq.Model.CustomMsg> list = new List <Eyousoft_yhq.Model.CustomMsg>(); string tableName = "tbl_Recommend"; string fileds = " * "; string orderByString = " IssueTime desc "; StringBuilder query = new StringBuilder(); query.Append(" 1=1 "); if (serModel != null) { } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { Eyousoft_yhq.Model.CustomMsg model = new Eyousoft_yhq.Model.CustomMsg(); model.Id = dr.GetInt32(dr.GetOrdinal("id")); model.OpenId = dr.GetString(dr.GetOrdinal("OpenId")); model.NickName = dr.GetString(dr.GetOrdinal("NickName")); model.Sex = dr.GetString(dr.GetOrdinal("Sex")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.CommendInfo = dr.GetString(dr.GetOrdinal("CommendInfo")); list.Add(model); } }; return(list); }
/// <summary> /// 获取发送列表 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <param name="i"></param> /// <returns></returns> public IList <Eyousoft_yhq.Model.SendMSG> GetList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.serSendMSG serModel) { IList <Eyousoft_yhq.Model.SendMSG> list = new List <Eyousoft_yhq.Model.SendMSG>(); string tableName = "tbl_SendMSG"; string fileds = " msgId,sendNum,SendText,issuetime,ProductID "; string orderByString = "msgId desc"; StringBuilder query = new StringBuilder(); query.Append(" 1=1 "); if (serModel != null) { if (!string.IsNullOrEmpty(serModel.ProductID)) { query.AppendFormat(" and ProductID = '{0}' ", serModel.ProductID); } } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { Eyousoft_yhq.Model.SendMSG model = new Eyousoft_yhq.Model.SendMSG(); model.MsgID = dr.GetInt32(dr.GetOrdinal("msgId")); model.SendNum = dr.IsDBNull(dr.GetOrdinal("SendNum")) ? "" : dr.GetString(dr.GetOrdinal("SendNum")); model.SendText = dr.IsDBNull(dr.GetOrdinal("SendText")) ? "" : dr.GetString(dr.GetOrdinal("SendText")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.ProductID = dr.IsDBNull(dr.GetOrdinal("ProductID")) ? "" : dr.GetString(dr.GetOrdinal("ProductID")).ToString(); list.Add(model); } } return(list); }
public IList <Eyousoft_yhq.Model.OrderPassenger> GetModelList(string ordercode, int PageSize, int PageIndex, ref int RecordCount) { IList <Eyousoft_yhq.Model.OrderPassenger> list = new List <Eyousoft_yhq.Model.OrderPassenger>(); string tableName = "tbl_OrderPassenger"; string fileds = "ID, OrderCode, PsrName ,PsrType ,IdentityType, IdentityCard ,Mobile"; string orderByString = "ID desc "; StringBuilder query = new StringBuilder(); query.AppendFormat(" 1=1 and OrderCode={0}", ordercode); using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { Eyousoft_yhq.Model.OrderPassenger model = new Eyousoft_yhq.Model.OrderPassenger(); model.ID = dr.GetInt32(dr.GetOrdinal("ID")); model.OrderCode = dr.GetString(dr.GetOrdinal("OrderCode")); model.PsrName = dr.GetString(dr.GetOrdinal("PsrName")); model.PsrType = (Eyousoft_yhq.Model.PerType)dr.GetByte(dr.GetOrdinal("PsrType")); model.IdentityType = (Eyousoft_yhq.Model.CartType)dr.GetByte(dr.GetOrdinal("IdentityType")); model.IdentityCard = dr.GetString(dr.GetOrdinal("IdentityCard")); model.Mobile = dr.IsDBNull(dr.GetOrdinal("Mobile")) ? "" : dr.GetString(dr.GetOrdinal("Mobile")); list.Add(model); } } return(list); }
/// <summary> /// 获取分页数据 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <returns></returns> public IList <MZengZhi> GetList(int PageSize, int PageIndex, ref int RecordCount, MZengZhiSer serModel) { IList <MZengZhi> list = new List <MZengZhi>(); string tableName = "view_ZengZhi"; string fileds = " * "; string orderByString = "FenXiangShiJian desc"; StringBuilder query = new StringBuilder(); query.AppendFormat(" 1=1 "); if (serModel != null) { } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { MZengZhi model = new MZengZhi(); model.FenXiangID = dr.GetInt32(dr.GetOrdinal("ID")); model.ContactName = dr.GetString(dr.GetOrdinal("ID")); model.FenXiangRenID = dr.GetString(dr.GetOrdinal("ID")); model.FenXiangShiJian = dr.GetDateTime(dr.GetOrdinal("ID")); model.ID = dr.GetString(dr.GetOrdinal("ID")); model.UserName = dr.GetString(dr.GetOrdinal("ID")); model.ZengZhi = dr.GetDecimal(dr.GetOrdinal("ID")); list.Add(model); } } return(list); }
public IList <Eyousoft_yhq.Model.ProductType> GetList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.serProductType serModel, string i) { IList <Eyousoft_yhq.Model.ProductType> list = new List <Eyousoft_yhq.Model.ProductType>(); string tableName = "tbl_ProductType"; string fileds = " TypeID, TypeName , ProductID , TypeImg,TpMark,AdminName ,OrderByInt ,WebImg,XianLu"; string orderByString = "OrderByInt desc"; StringBuilder query = new StringBuilder(); query.Append(" 1=1 "); switch (i) { case "1": query.Append(" and TpMark ='1' "); break; case "0": query.Append(" and TpMark ='0' "); break; default: break; } if (serModel != null) { if (!string.IsNullOrEmpty(serModel.TypeName) && !serModel.IsAdmin) { query.AppendFormat(" and TypeName like '%{0}%' ", serModel.TypeName); } if (!string.IsNullOrEmpty(serModel.AdminID) && !serModel.IsAdmin) { query.AppendFormat(" and charindex('{0}',[AdminName])>0 ", serModel.AdminID); } if (serModel.IsAdmin && !string.IsNullOrEmpty(serModel.TypeName)) { query.AppendFormat(" and TypeName like '%{0}%' ", serModel.TypeName); } if (serModel.xianlu.HasValue) { query.AppendFormat(" and XianLu = '{0}' ", (int)serModel.xianlu.Value); } } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { Eyousoft_yhq.Model.ProductType model = new Eyousoft_yhq.Model.ProductType(); model.TypeID = dr.GetInt32(dr.GetOrdinal("TypeID")); model.ProductID = dr.IsDBNull(dr.GetOrdinal("ProductID")) ? "" : dr.GetString(dr.GetOrdinal("ProductID")); model.TypeName = dr.IsDBNull(dr.GetOrdinal("TypeName")) ? "" : dr.GetString(dr.GetOrdinal("TypeName")); model.TypeImg = dr.IsDBNull(dr.GetOrdinal("TypeImg")) ? "" : dr.GetString(dr.GetOrdinal("TypeImg")); model.TpMark = dr.IsDBNull(dr.GetOrdinal("TpMark")) ? "" : dr.GetByte(dr.GetOrdinal("TpMark")).ToString(); model.AdminName = dr.IsDBNull(dr.GetOrdinal("AdminName")) ? null : getStrJson(dr.GetString(dr.GetOrdinal("AdminName"))); model.OrderBy = dr.IsDBNull(dr.GetOrdinal("OrderByInt")) ? 0 : dr.GetInt32(dr.GetOrdinal("OrderByInt")); model.WebImg = dr.IsDBNull(dr.GetOrdinal("WebImg")) ? "" : dr.GetString(dr.GetOrdinal("WebImg")); model.xianlu = (Eyousoft_yhq.Model.XianLu)dr.GetByte(dr.GetOrdinal("XianLu")); list.Add(model); } } return(list); }
/// <summary> /// 获得数据列表集合,分页 /// </summary> /// <param name="pageSize"></param> /// <param name="pageIndex"></param> /// <param name="recordCount"></param> /// <param name="chaXun"></param> /// <returns></returns> public IList <Eyousoft_yhq.Model.MSysCity> GetSysCityList(int pageSize, int pageIndex, ref int recordCount, Eyousoft_yhq.Model.MSysCity chaXun) { IList <Eyousoft_yhq.Model.MSysCity> ResultList = null; string tableName = "tbl_SysCity"; string identityColumnName = "Id"; string fields = "Id, ProvinceId,Name,CenterCityId,HeaderLetter,IsSite,DomainName,IsEnabled"; string query = " 1=1 "; if (chaXun != null) { if (chaXun.ProvinceId > 0) { query = query + string.Format(" AND ProvinceId={0} ", chaXun.ProvinceId); } if (!string.IsNullOrEmpty(chaXun.Name)) { query = query + string.Format(" AND Name like '%{0}%'", chaXun.Name); } if (chaXun.CenterCityId > 0) { query = query + string.Format(" AND CenterCityId={0} ", chaXun.CenterCityId); } if (!string.IsNullOrEmpty(chaXun.HeaderLetter)) { query = query + string.Format(" OR HeaderLetter like '%{0}%'", chaXun.HeaderLetter); } if (chaXun.IsSite) { query = query + string.Format(" AND IsSite='{0}'", this.GetBooleanToStr(chaXun.IsSite)); } if (!string.IsNullOrEmpty(chaXun.DomainName)) { query = query + string.Format(" AND DomainName like '%{0}%'", chaXun.DomainName); } if (chaXun.IsEnabled) { query = query + string.Format(" AND IsEnabled='{0}'", this.GetBooleanToStr(chaXun.IsEnabled)); } } string orderByString = " Id ASC"; using (IDataReader dr = DbHelper.ExecuteReader1(_db, pageSize, pageIndex, ref recordCount, tableName, fields, query, orderByString, "")) { ResultList = new List <Eyousoft_yhq.Model.MSysCity>(); while (dr.Read()) { Eyousoft_yhq.Model.MSysCity model = new Eyousoft_yhq.Model.MSysCity() { Id = dr.GetInt32(dr.GetOrdinal("Id")), ProvinceId = dr.GetInt32(dr.GetOrdinal("ProvinceId")), Name = dr.IsDBNull(dr.GetOrdinal("Name")) ? "" : dr.GetString(dr.GetOrdinal("Name")), CenterCityId = dr.GetInt32(dr.GetOrdinal("CenterCityId")), HeaderLetter = dr.IsDBNull(dr.GetOrdinal("HeaderLetter")) ? "" : dr.GetString(dr.GetOrdinal("HeaderLetter")), IsSite = this.GetBoolean(dr.IsDBNull(dr.GetOrdinal("IsSite")) ? "" : dr.GetString(dr.GetOrdinal("IsSite"))), DomainName = dr.IsDBNull(dr.GetOrdinal("DomainName")) ? "" : dr.GetString(dr.GetOrdinal("DomainName")), IsEnabled = this.GetBoolean(dr.IsDBNull(dr.GetOrdinal("IsEnabled")) ? "" : dr.GetString(dr.GetOrdinal("IsEnabled"))) }; ResultList.Add(model); model = null; } }; return(ResultList); }
public IList <Eyousoft_yhq.Model.Product> GetList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.SerProduct serModel) { IList <Eyousoft_yhq.Model.Product> list = new List <Eyousoft_yhq.Model.Product>(); string tableName = "view_Product"; string fileds = " * "; string orderByString = ""; StringBuilder query = new StringBuilder(); query.Append(" 1=1 "); if (serModel != null) { #region 排序 if (serModel.SFTJ == 1) { orderByString += " IsHot DESC,"; } if (serModel.DDXL == 1) { orderByString += "SaleNum DESC,"; } if (serModel.DDXL == 2) { orderByString += "SaleNum ASC,"; } if (serModel.SJPX == 1) { orderByString += "CreateDate DESC,"; } else if (serModel.SJPX == 2) { orderByString += "CreateDate ASC,"; } if (serModel.JGPX == 1) { orderByString += "AppPrice DESC,"; } if (serModel.JGPX == 2) { orderByString += "AppPrice ASC,"; } if (!string.IsNullOrEmpty(orderByString)) { orderByString = orderByString.TrimEnd(','); } else { orderByString = "IsHot DESC,CreateDate desc"; } #endregion if (!string.IsNullOrEmpty(serModel.FavourCode)) { query.AppendFormat(" and (FavourCode = '{0}' )", serModel.FavourCode); } if (serModel.PType > 0) { query.AppendFormat(" and (PType = {0} )", serModel.PType); } if (serModel.IsAdmin != "1" && !string.IsNullOrEmpty(serModel.AdminName)) { query.AppendFormat(" and ( charindex('{0}',[AdminName])>0 or AdminName is null)", serModel.AdminName); } if (!string.IsNullOrEmpty(serModel.PurductName)) { query.AppendFormat(" and ProductName like '%{0}%' ", serModel.PurductName); } if (!string.IsNullOrEmpty(serModel.PurductType) && serModel.PurductType != "0") { query.AppendFormat(" and ProductType = '{0}' ", serModel.PurductType); } if (!string.IsNullOrEmpty(serModel.PurductState) && serModel.PurductState != "2") { query.AppendFormat(" and ProductState = '{0}' ", serModel.PurductState); } if (serModel.Stime.HasValue) { query.AppendFormat(" AND datediff(day,'{0}',ValidiDate)>=0 ", serModel.Stime.Value); } if (serModel.Etime.HasValue) { query.AppendFormat(" AND datediff(day,'{0}',ValidiDate)< 0 ", serModel.Etime.Value.AddDays(1)); } if (!serModel.isVisable) { query.AppendFormat(" AND ProductState = 0 "); } if (serModel.isHot.HasValue && serModel.isHot == 1) { query.AppendFormat(" and IsHot = '{0}' ", serModel.isHot); } else if (serModel.isHot.HasValue && serModel.isHot == 0) { query.AppendFormat(" and (IsHot = '{0}' or IsHot is null) ", serModel.isHot); } if (serModel.xianlu != null && serModel.PType == 1) { query.AppendFormat(" and XianLu = '{0}' ", (int)serModel.xianlu); } if (!string.IsNullOrEmpty(serModel.WeiDianId)) { query.AppendFormat(" AND EXISTS(SELECT 1 FROM tbl_WeiDianChanPinGuanXi AS A1 WHERE A1.ChanPinId=view_Product.ProductID AND A1.WeiDianId='{0}') ", serModel.WeiDianId); } if (!string.IsNullOrEmpty(serModel.FaBuRenId)) { query.AppendFormat(" AND FaBuRenId='{0}' ", serModel.FaBuRenId); } if (serModel.ShenHeStatus.HasValue) { query.AppendFormat(" AND ShenHeStatus={0} ", (int)serModel.ShenHeStatus.Value); } } else { orderByString = "IsHot DESC,CreateDate desc"; } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { Eyousoft_yhq.Model.Product model = new Eyousoft_yhq.Model.Product(); model.ProductID = dr.GetString(dr.GetOrdinal("ProductID"));; model.ProductName = dr.GetString(dr.GetOrdinal("ProductName")); model.ProductType = dr.GetInt32(dr.GetOrdinal("ProductType")); model.TourDate = dr.IsDBNull(dr.GetOrdinal("TourDate")) ? null : Utils.GetDateTimeNullable(dr.GetDateTime(dr.GetOrdinal("TourDate")).ToString()); model.MarketPrice = dr.GetDecimal(dr.GetOrdinal("MarketPrice")); model.AppPrice = dr.GetDecimal(dr.GetOrdinal("AppPrice")); model.FavourCode = dr.GetString(dr.GetOrdinal("FavourCode")); model.LinkTel = dr.GetString(dr.GetOrdinal("LinkTel")); model.ProductDis = dr.GetString(dr.GetOrdinal("ProductDis")); model.TourDis = dr.GetString(dr.GetOrdinal("TourDis")); model.SendTourKnow = dr.GetString(dr.GetOrdinal("SendTourKnow")); model.ValidiDate = dr.GetDateTime(dr.GetOrdinal("ValidiDate")); model.ProductState = dr.GetByte(dr.GetOrdinal("ProductState")); model.IsEveryDay = dr.IsDBNull(dr.GetOrdinal("IsEveryDay")) ? false : GetBoolean(dr.GetString(dr.GetOrdinal("IsEveryDay"))); model.IsHot = dr.IsDBNull(dr.GetOrdinal("IsHot")) ? 0 : dr.GetByte(dr.GetOrdinal("IsHot")); model.CreateDate = dr.GetDateTime(dr.GetOrdinal("CreateDate")); model.ServiceQQ = dr.IsDBNull(dr.GetOrdinal("ServiceQQ")) ? "" : dr.GetString(dr.GetOrdinal("ServiceQQ")); model.ContractType = (Eyousoft_yhq.Model.ContractType)dr.GetByte(dr.GetOrdinal("ContractType")); model.ControlPeople = dr.GetInt32(dr.GetOrdinal("ControlPeople")); model.ResidueNum = dr.GetInt32(dr.GetOrdinal("ResidueNum")); model.SaleNum = dr.GetInt32(dr.GetOrdinal("SaleNum")); model.ProductOpState = (Eyousoft_yhq.Model.ProductOp)dr.GetByte(dr.GetOrdinal("ProductOpState")); model.ProductSdate = dr.IsDBNull(dr.GetOrdinal("ProductSdate")) ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("ProductSdate")); model.ZCodeViaDate = dr.IsDBNull(dr.GetOrdinal("ZCodeViaDate")) ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("ZCodeViaDate")); model.PType = dr.IsDBNull(dr.GetOrdinal("PType")) ? 1 : dr.GetInt32(dr.GetOrdinal("PType")); model.xianlu = dr.IsDBNull(dr.GetOrdinal("XianLu")) ? Eyousoft_yhq.Model.XianLu.国内游 : (Eyousoft_yhq.Model.XianLu)dr.GetByte(dr.GetOrdinal("XianLu")); model.FaBuRenId = dr["FaBuRenId"].ToString(); model.ShenHeStatus = (Eyousoft_yhq.Model.ChanPinShenHeStatus)dr.GetInt32(dr.GetOrdinal("ShenHeStatus")); model.FaBuRenName = dr["FaBuRenName"].ToString(); list.Add(model); } } return(list); }
/// <summary> /// 获取分页列表 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <returns></returns> public IList <Eyousoft_yhq.Model.Order> GetList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.MSearchOrder serModel) { IList <Eyousoft_yhq.Model.Order> list = new List <Eyousoft_yhq.Model.Order>(); string tableName = "view_Order"; string fileds = " * "; string orderByString = " IssueTime desc "; StringBuilder query = new StringBuilder(); query.Append(" 1=1 "); if (serModel != null) { if (!string.IsNullOrEmpty(serModel.MemberID)) { query.AppendFormat(" and MemberID = '{0}' ", serModel.MemberID); } if (!string.IsNullOrEmpty(serModel.OrderCode)) { query.AppendFormat(" and OrderCode like '%{0}%' ", serModel.OrderCode); } if (!string.IsNullOrEmpty(serModel.ConfirmCode)) { query.AppendFormat(" and ConfirmCode like '%{0}%' ", serModel.ConfirmCode); } if (!string.IsNullOrEmpty(serModel.AppUserId)) { query.AppendFormat(" and AppUserId = '{0}' ", serModel.AppUserId); } if (!string.IsNullOrEmpty(serModel.AppUser)) { query.AppendFormat(" and AppUserName like '%{0}%' ", serModel.ConfirmCode); } if (serModel.OrderState.HasValue) { query.AppendFormat(" AND OrderState = '{0}' ", (int)serModel.OrderState.Value); } if (serModel.ConSumState.HasValue) { query.AppendFormat(" AND ConSumState = '{0}' ", (int)serModel.ConSumState.Value); } if (serModel.PaymentState.HasValue) { query.AppendFormat(" AND PayState = '{0}' ", (int)serModel.PaymentState.Value); } if (serModel.STime.HasValue) { query.AppendFormat(" AND IssueTime>='{0}' ", serModel.STime.Value); } if (serModel.ETime.HasValue) { query.AppendFormat(" AND IssueTime< '{0}' ", serModel.ETime.Value.AddDays(1)); } if (serModel.XSTime.HasValue) { query.AppendFormat(" AND AppTime>='{0}' ", serModel.XSTime.Value); } if (serModel.XETime.HasValue) { query.AppendFormat(" AND AppTime< '{0}' ", serModel.XETime.Value.AddDays(1)); } if (!string.IsNullOrEmpty(serModel.RouteName)) { query.AppendFormat(" AND ProductName like '%{0}%' ", serModel.RouteName); } if (serModel.OrderPrice != 0) { query.AppendFormat(" AND OrderPrice = '{0}' ", serModel.OrderPrice); } if (!string.IsNullOrEmpty(serModel.PromotionCode)) { query.AppendFormat(" and (PollCode = '{0}' OR PromotionCode= '{0}' )", serModel.PromotionCode); } if (serModel.jiesuan.HasValue) { query.AppendFormat(" AND JState = '{0}' ", (int)serModel.jiesuan.Value); } if (!string.IsNullOrEmpty(serModel.ChanPinFaBuRenId)) { query.AppendFormat(" AND ChanPinFaBuRenId='{0}' ", serModel.ChanPinFaBuRenId); } } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { Eyousoft_yhq.Model.Order model = new Eyousoft_yhq.Model.Order(); model.OrderID = dr.GetString(dr.GetOrdinal("OrderId")); model.ProductID = dr.IsDBNull(dr.GetOrdinal("ProductID")) ? "" : dr.GetString(dr.GetOrdinal("ProductID")); model.ProductName = dr.IsDBNull(dr.GetOrdinal("ProductName")) ? "" : dr.GetString(dr.GetOrdinal("ProductName")); model.OrderCode = dr.GetString(dr.GetOrdinal("OrderCode")); model.MemberID = dr.GetString(dr.GetOrdinal("MemberID")); model.MemberName = dr.GetString(dr.GetOrdinal("MemberName")); model.MemberTel = dr.IsDBNull(dr.GetOrdinal("MemberTel")) ? "" : dr.GetString(dr.GetOrdinal("MemberTel")); model.MemberSex = (Eyousoft_yhq.Model.sexType)dr.GetByte(dr.GetOrdinal("MemberSex")); model.OrderState = (Eyousoft_yhq.Model.OrderState)dr.GetByte(dr.GetOrdinal("OrderState")); model.PayState = (Eyousoft_yhq.Model.PaymentState)dr.GetByte(dr.GetOrdinal("PayState")); model.IsCheck = this.GetBoolean(dr.GetString(dr.GetOrdinal("ProductName"))); model.ConfirmCode = dr.IsDBNull(dr.GetOrdinal("ConfirmCode")) ? "" : dr.GetString(dr.GetOrdinal("ConfirmCode")); model.Remark = dr.IsDBNull(dr.GetOrdinal("Remark")) ? "" : dr.GetString(dr.GetOrdinal("Remark")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.OrderPrice = dr.GetDecimal(dr.GetOrdinal("OrderPrice")); model.TourDate = dr.IsDBNull(dr.GetOrdinal("TourDate")) ? null : Utils.GetDateTimeNullable(dr.GetDateTime(dr.GetOrdinal("TourDate")).ToString()); model.FavourCode = dr.GetString(dr.GetOrdinal("FavourCode")); model.isEvery = this.GetBoolean(dr.GetString(dr.GetOrdinal("isEvery"))); model.ProductType = dr.GetInt32(dr.GetOrdinal("ProductType")); model.ContractType = dr.IsDBNull(dr.GetOrdinal("ContractType")) ? Eyousoft_yhq.Model.ContractType.国内合同 : (Eyousoft_yhq.Model.ContractType)dr.GetByte(dr.GetOrdinal("ContractType")); model.OrderPrice = dr.GetDecimal(dr.GetOrdinal("OrderPrice")); model.PeopleNum = dr.GetInt32(dr.GetOrdinal("PeopleNum")); model.ContractText = dr.IsDBNull(dr.GetOrdinal("ContractText")) ? "" : dr.GetString(dr.GetOrdinal("ContractText")); model.IsealCheck = GetBoolean(dr.GetString(dr.GetOrdinal("IsealCheck"))); model.FYJE = dr.IsDBNull(dr.GetOrdinal("fyje")) ? 0 : dr.GetDecimal(dr.GetOrdinal("fyje")); model.SendFile = this.GetAttachList(dr["ComAttachXML"].ToString(), model.OrderID); model.AddressID = dr.IsDBNull(dr.GetOrdinal("AddressID")) ? "" : dr.GetString(dr.GetOrdinal("AddressID")); model.RebackMoney = dr.IsDBNull(dr.GetOrdinal("RebackMoney")) ? 0 : dr.GetDecimal(dr.GetOrdinal("RebackMoney")); model.backMoney = dr.IsDBNull(dr.GetOrdinal("backMoney")) ? 0 : dr.GetDecimal(dr.GetOrdinal("backMoney")); model.ProductOpState = (Eyousoft_yhq.Model.ProductOp)dr.GetByte(dr.GetOrdinal("ProductOpState")); model.ZCodeViaDate = dr.IsDBNull(dr.GetOrdinal("ZCodeViaDate")) ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("ZCodeViaDate")); model.XiaoFei = (Eyousoft_yhq.Model.XFstate)dr.GetByte(dr.GetOrdinal("ConSumState")); model.AppTime = dr.IsDBNull(dr.GetOrdinal("AppTime")) ? DateTime.MinValue : dr.GetDateTime(dr.GetOrdinal("AppTime")); model.AppUserName = dr.IsDBNull(dr.GetOrdinal("AppUserName")) ? string.Empty : dr.GetString(dr.GetOrdinal("AppUserName")); model.JIESUAN = (Eyousoft_yhq.Model.JSfangshi)dr.GetByte(dr.GetOrdinal("JState")); model.WeiDianName = dr["WeiDianName"].ToString(); list.Add(model); } }; return(list); }
/// <summary> /// 获取返佣 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <returns></returns> public IList <Eyousoft_yhq.Model.Order> GetFYList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.MSearchOrder serModel) { IList <Eyousoft_yhq.Model.Order> list = new List <Eyousoft_yhq.Model.Order>(); string tableName = "view_Order"; string fileds = " * "; string orderByString = " IssueTime desc "; StringBuilder query = new StringBuilder(); query.Append(" PayState=2 "); if (serModel != null) { if (!string.IsNullOrEmpty(serModel.MemberID)) { query.AppendFormat(" and (PollCode = '{0}' OR PromotionCode= '{0}' OR MemberID = '{1}' ) ", serModel.PromotionCode, serModel.MemberID); } } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { Eyousoft_yhq.Model.Order model = new Eyousoft_yhq.Model.Order(); model.OrderID = dr.GetString(dr.GetOrdinal("OrderId")); model.ProductID = dr.IsDBNull(dr.GetOrdinal("ProductID")) ? "" : dr.GetString(dr.GetOrdinal("ProductID")); model.ProductName = dr.IsDBNull(dr.GetOrdinal("ProductName")) ? "" : dr.GetString(dr.GetOrdinal("ProductName")); model.OrderCode = dr.GetString(dr.GetOrdinal("OrderCode")); model.MemberID = dr.GetString(dr.GetOrdinal("MemberID")); model.MemberName = dr.GetString(dr.GetOrdinal("MemberName")); model.MemberTel = dr.IsDBNull(dr.GetOrdinal("MemberTel")) ? "" : dr.GetString(dr.GetOrdinal("MemberTel")); model.MemberSex = (Eyousoft_yhq.Model.sexType)dr.GetByte(dr.GetOrdinal("MemberSex")); model.OrderState = (Eyousoft_yhq.Model.OrderState)dr.GetByte(dr.GetOrdinal("OrderState")); model.PayState = (Eyousoft_yhq.Model.PaymentState)dr.GetByte(dr.GetOrdinal("PayState")); model.IsCheck = this.GetBoolean(dr.GetString(dr.GetOrdinal("ProductName"))); model.ConfirmCode = dr.IsDBNull(dr.GetOrdinal("ConfirmCode")) ? "" : dr.GetString(dr.GetOrdinal("ConfirmCode")); model.Remark = dr.IsDBNull(dr.GetOrdinal("Remark")) ? "" : dr.GetString(dr.GetOrdinal("Remark")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.OrderPrice = dr.GetDecimal(dr.GetOrdinal("OrderPrice")); model.TourDate = dr.IsDBNull(dr.GetOrdinal("TourDate")) ? null : Utils.GetDateTimeNullable(dr.GetDateTime(dr.GetOrdinal("TourDate")).ToString()); model.FavourCode = dr.GetString(dr.GetOrdinal("FavourCode")); model.isEvery = this.GetBoolean(dr.GetString(dr.GetOrdinal("isEvery"))); model.ProductType = dr.GetInt32(dr.GetOrdinal("ProductType")); model.ContractType = dr.IsDBNull(dr.GetOrdinal("ContractType")) ? Eyousoft_yhq.Model.ContractType.国内合同 : (Eyousoft_yhq.Model.ContractType)dr.GetByte(dr.GetOrdinal("ContractType")); model.OrderPrice = dr.GetDecimal(dr.GetOrdinal("OrderPrice")); model.PeopleNum = dr.GetInt32(dr.GetOrdinal("PeopleNum")); model.ContractText = dr.IsDBNull(dr.GetOrdinal("ContractText")) ? "" : dr.GetString(dr.GetOrdinal("ContractText")); model.IsealCheck = GetBoolean(dr.GetString(dr.GetOrdinal("IsealCheck"))); model.FYJE = dr.IsDBNull(dr.GetOrdinal("fyje")) ? 0 : dr.GetDecimal(dr.GetOrdinal("fyje")); model.AddressID = dr.IsDBNull(dr.GetOrdinal("AddressID")) ? "" : dr.GetString(dr.GetOrdinal("AddressID")); model.RebackMoney = dr.IsDBNull(dr.GetOrdinal("RebackMoney")) ? 0 : dr.GetDecimal(dr.GetOrdinal("RebackMoney")); model.backMoney = dr.IsDBNull(dr.GetOrdinal("backMoney")) ? 0 : dr.GetDecimal(dr.GetOrdinal("backMoney")); model.ProductOpState = (Eyousoft_yhq.Model.ProductOp)dr.GetByte(dr.GetOrdinal("ProductOpState")); model.ZCodeViaDate = dr.IsDBNull(dr.GetOrdinal("ZCodeViaDate")) ? DateTime.Now : dr.GetDateTime(dr.GetOrdinal("ZCodeViaDate")); model.XiaoFei = (Eyousoft_yhq.Model.XFstate)dr.GetByte(dr.GetOrdinal("ConSumState")); model.JIESUAN = (Eyousoft_yhq.Model.JSfangshi)dr.GetByte(dr.GetOrdinal("JState")); list.Add(model); } }; return(list); }
/// <summary> /// 获取分页列表 /// </summary> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="RecordCount"></param> /// <param name="serModel"></param> /// <returns></returns> public IList <Eyousoft_yhq.Model.Order> GetScanList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.MSearchOrder serModel) { IList <Eyousoft_yhq.Model.Order> list = new List <Eyousoft_yhq.Model.Order>(); string tableName = "view_OrderScan"; string fileds = " * "; string orderByString = " AppTime desc "; StringBuilder query = new StringBuilder(); query.Append(" 1=1 "); if (serModel != null) { if (serModel.ConSumState.HasValue) { query.AppendFormat(" AND ConSumState = '{0}' ", (int)serModel.ConSumState.Value); } if (!string.IsNullOrEmpty(serModel.OrderCode)) { query.AppendFormat(" and OrderCode like '%{0}%' ", serModel.OrderCode); } if (!string.IsNullOrEmpty(serModel.ConfirmCode)) { query.AppendFormat(" and ConfirmCode like '%{0}%' ", serModel.ConfirmCode); } if (!string.IsNullOrEmpty(serModel.AppUserId)) { query.AppendFormat(" and AppUserId = '{0}' ", serModel.AppUserId); } if (!string.IsNullOrEmpty(serModel.AppUser)) { query.AppendFormat(" and AppUserName like '%{0}%' ", serModel.ConfirmCode); } if (serModel.STime.HasValue) { query.AppendFormat(" AND IssueTime>='{0}' ", serModel.STime.Value); } if (serModel.ETime.HasValue) { query.AppendFormat(" AND IssueTime< '{0}' ", serModel.ETime.Value.AddDays(1)); } if (serModel.XSTime.HasValue) { query.AppendFormat(" AND AppTime>='{0}' ", serModel.XSTime.Value); } if (serModel.XETime.HasValue) { query.AppendFormat(" AND AppTime< '{0}' ", serModel.XETime.Value.AddDays(1)); } if (!string.IsNullOrEmpty(serModel.RouteName)) { query.AppendFormat(" AND ProductName like '%{0}%' ", serModel.RouteName); } } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { Eyousoft_yhq.Model.Order model = new Eyousoft_yhq.Model.Order(); model.OrderID = dr.GetString(dr.GetOrdinal("OrderId")); model.ProductID = dr.IsDBNull(dr.GetOrdinal("ProductID")) ? "" : dr.GetString(dr.GetOrdinal("ProductID")); model.ProductName = dr.IsDBNull(dr.GetOrdinal("ProductName")) ? "" : dr.GetString(dr.GetOrdinal("ProductName")); model.OrderCode = dr.GetString(dr.GetOrdinal("OrderCode")); model.MemberID = dr.GetString(dr.GetOrdinal("MemberID")); model.MemberName = dr.GetString(dr.GetOrdinal("MemberName")); model.OrderState = (Eyousoft_yhq.Model.OrderState)dr.GetByte(dr.GetOrdinal("OrderState")); model.PayState = (Eyousoft_yhq.Model.PaymentState)dr.GetByte(dr.GetOrdinal("PayState")); model.IsCheck = this.GetBoolean(dr.GetString(dr.GetOrdinal("ProductName"))); model.ConfirmCode = dr.IsDBNull(dr.GetOrdinal("ConfirmCode")) ? "" : dr.GetString(dr.GetOrdinal("ConfirmCode")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.ProductType = dr.GetInt32(dr.GetOrdinal("ProductType")); model.AppTime = dr.IsDBNull(dr.GetOrdinal("AppTime")) ? DateTime.MinValue : dr.GetDateTime(dr.GetOrdinal("AppTime")); model.AppUserName = dr.IsDBNull(dr.GetOrdinal("AppUserName")) ? string.Empty : dr.GetString(dr.GetOrdinal("AppUserName")); model.AppMobNo = dr.IsDBNull(dr.GetOrdinal("AppMobNo")) ? "" : dr.GetString(dr.GetOrdinal("AppMobNo")); list.Add(model); } }; return(list); }