public static ModulesProduct GetModulesProductDetail(int id)
{
ModulesProduct model = new ModulesProduct();
DataTable dt = ModulesProductDAL.BaseProvider.GetModulesProductDetail(id);
model.FillData(dt.Rows[0]);
return(model);
}
public static List <ModulesProduct> GetModulesProducts(string keyWords, int pageSize, int pageIndex, ref int totalCount, ref int pageCount)
{
DataTable dt = CommonBusiness.GetPagerData("ModulesProduct as p,Modules as m ", " p.*,m.name ", " p.ModulesID=m.ModulesID and p.Status<>9 ", "p.AutoID", pageSize, pageIndex, out totalCount, out pageCount);
List <ModulesProduct> list = new List <ModulesProduct>();
ModulesProduct model;
foreach (DataRow item in dt.Rows)
{
model = new ModulesProduct();
model.FillData(item);
list.Add(model);
}
return(list);
}
public static List <ModulesProduct> GetModulesProducts(string keyWords, int pageSize, int pageIndex, ref int totalCount, ref int pageCount)
{
string sqlWhere = "p.Status<>9 ";
DataTable dt = CommonBusiness.GetPagerData("ModulesProduct as p", " p.*", sqlWhere, "p.AutoID", " p.UserQuantity asc,p.PeriodQuantity asc", pageSize, pageIndex, out totalCount, out pageCount);
List <ModulesProduct> list = new List <ModulesProduct>();
ModulesProduct model;
foreach (DataRow item in dt.Rows)
{
model = new ModulesProduct();
model.FillData(item);
list.Add(model);
}
return(list);
}