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