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)
{
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;
}
public static bool InsertModulesProduct(ModulesProduct model)
{
return ModulesProductDAL.BaseProvider.InsertModulesProduct(model.Period, model.PeriodQuantity, model.UserQuantity,
model.Price, model.Description,model.Type,model.IsChild, model.CreateUserID);
}
public static bool UpdateModulesProduct(ModulesProduct model)
{
return ModulesProductDAL.BaseProvider.UpdateModulesProduct(model.AutoID, model.Period, model.PeriodQuantity, model.UserQuantity,
model.Price, model.Description,model.Type,model.IsChild);
}