/// <summary>
/// 获取类型列表
/// </summary>
/// <param name="serModel"></param>
/// <returns></returns>
public IList <Eyousoft_yhq.Model.ProductType> GetList(Eyousoft_yhq.Model.serProductType serModel)
{
IList <Eyousoft_yhq.Model.ProductType> list = new List <Eyousoft_yhq.Model.ProductType>();
StringBuilder strSql = new StringBuilder();
strSql.Append("select TypeID, TypeName , ProductID , TypeImg,TpMark ,AdminName,OrderByInt,WebImg,XianLu");
strSql.Append(" from tbl_ProductType where 1=1");
if (serModel != null)
{
if (!string.IsNullOrEmpty(serModel.TypeName) && !serModel.IsAdmin)
{
strSql.AppendFormat(" and TypeName like '%{0}%' ", serModel.TypeName);
}
if (!string.IsNullOrEmpty(serModel.AdminID) && !serModel.IsAdmin)
{
strSql.AppendFormat(" and charindex('{0}',[AdminName])>0 ", serModel.AdminID);
}
if (serModel.IsAdmin && !string.IsNullOrEmpty(serModel.TypeName))
{
strSql.AppendFormat(" and TypeName like '%{0}%' ", serModel.TypeName);
}
}
strSql.Append(" order by OrderByInt DESC ");
DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString());
using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db))
{
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);
}
protected void initList()
{
Eyousoft_yhq.BLL.ProductType bll = new Eyousoft_yhq.BLL.ProductType();
Eyousoft_yhq.Model.serProductType serchModel = new Eyousoft_yhq.Model.serProductType();
serchModel.TypeName = Utils.GetQueryStringValue("productName");
pageIndex = UtilsCommons.GetPagingIndex("Page");
var list = bll.GetList(pageSize, pageIndex, ref recordCount, serchModel, "0");
if (list != null && list.Count > 0)
{
rpt_list.DataSource = list;
rpt_list.DataBind();
BindPage();
litMsg.Visible = false;
}
else
{
rpt_list.Visible = false;
}
}
protected void initList()
{
Eyousoft_yhq.BLL.ProductType bll = new Eyousoft_yhq.BLL.ProductType();
Eyousoft_yhq.Model.serProductType serchModel = new Eyousoft_yhq.Model.serProductType();
serchModel.TypeName = Utils.GetQueryStringValue("productName");
pageIndex = UtilsCommons.GetPagingIndex("Page");
var list = bll.GetList(pageSize, pageIndex, ref recordCount, serchModel, "0");
if (list != null && list.Count > 0)
{
rpt_list.DataSource = list;
rpt_list.DataBind();
BindPage();
litMsg.Visible = false;
}
else
{
rpt_list.Visible = false;
}
}
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);
}
