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