/// <summary>
/// get chaxun info
/// </summary>
/// <returns></returns>
Eyousoft_yhq.Model.MWeiDianChaXunInfo GetChaXunInfo()
{
var info = new Eyousoft_yhq.Model.MWeiDianChaXunInfo();
info.MingCheng = Utils.GetQueryStringValue("txtMingCheng");
info.Status = (Eyousoft_yhq.Model.WeiDianStatus?)Utils.GetEnumValueNull(typeof(Eyousoft_yhq.Model.WeiDianStatus), Utils.GetQueryStringValue("txtStatus"));
return(info);
}
/// <summary>
/// get chaxun info
/// </summary>
/// <returns></returns>
Eyousoft_yhq.Model.MWeiDianChaXunInfo GetChaXunInfo()
{
var info = new Eyousoft_yhq.Model.MWeiDianChaXunInfo();
info.MingCheng = Utils.GetQueryStringValue("txtMingCheng");
info.Status = (Eyousoft_yhq.Model.WeiDianStatus?)Utils.GetEnumValueNull(typeof(Eyousoft_yhq.Model.WeiDianStatus), Utils.GetQueryStringValue("txtStatus"));
return info;
}
/// <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)
{
return(dal.GetWeiDians(pageSize, pageIndex, ref recordCount, chaXun));
}
/// <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);
}
