public Models.DbModels.appcategory GetCategoryInfo(XXF.Db.DbConn PubConn, int typeid, int categoryid) { string sql = "select apptype,categoryid,categorytitle, categorydesc from appcategory where apptype=@apptype and categoryid=@categoryid"; XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter(); para.Add("@apptype", typeid); para.Add("@categoryid", categoryid); DataSet ds = new DataSet(); PubConn.SqlToDataSet(ds, sql, para.ToParameters()); if (ds.Tables[0].Rows.Count == 0) return null; DataRow dr = ds.Tables[0].Rows[0]; DbModels.appcategory item = new DbModels.appcategory(); item.apptype = Convert.ToInt32(dr["apptype"]); item.categoryid = Convert.ToInt32(dr["categoryid"]); item.categorytitle = dr["categorytitle"].ToString(); item.categorydesc = dr["categorydesc"].ToString(); return item; }
public List<Models.DbModels.appcategory> GetAppTypeCategorys(XXF.Db.DbConn PubConn, int typeid) { List<DbModels.appcategory> listmodel = new List<DbModels.appcategory>(); string sql = "select apptype,categoryid,categorytitle, categorydesc from appcategory where apptype=@apptype order by categoryid asc"; XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter(); para.Add("@apptype", typeid); DataSet ds = new DataSet(); PubConn.SqlToDataSet(ds, sql, para.ToParameters()); foreach (DataRow dr in ds.Tables[0].Rows) { DbModels.appcategory item = new DbModels.appcategory(); item.apptype = Convert.ToInt32(dr["apptype"]); item.categoryid = Convert.ToInt32(dr["categoryid"]); item.categorytitle = dr["categorytitle"].ToString(); item.categorydesc = dr["categorydesc"].ToString(); listmodel.Add(item); } return listmodel; }
public List <Models.DbModels.appcategory> GetAppTypeCategorys(XXF.Db.DbConn PubConn, int typeid) { List <DbModels.appcategory> listmodel = new List <DbModels.appcategory>(); string sql = "select apptype,categoryid,categorytitle, categorydesc from appcategory where apptype=@apptype order by categoryid asc"; XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter(); para.Add("@apptype", typeid); DataSet ds = new DataSet(); PubConn.SqlToDataSet(ds, sql, para.ToParameters()); foreach (DataRow dr in ds.Tables[0].Rows) { DbModels.appcategory item = new DbModels.appcategory(); item.apptype = Convert.ToInt32(dr["apptype"]); item.categoryid = Convert.ToInt32(dr["categoryid"]); item.categorytitle = dr["categorytitle"].ToString(); item.categorydesc = dr["categorydesc"].ToString(); listmodel.Add(item); } return(listmodel); }
public Models.DbModels.appcategory GetCategoryInfo(XXF.Db.DbConn PubConn, int typeid, int categoryid) { string sql = "select apptype,categoryid,categorytitle, categorydesc from appcategory where apptype=@apptype and categoryid=@categoryid"; XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter(); para.Add("@apptype", typeid); para.Add("@categoryid", categoryid); DataSet ds = new DataSet(); PubConn.SqlToDataSet(ds, sql, para.ToParameters()); if (ds.Tables[0].Rows.Count == 0) { return(null); } DataRow dr = ds.Tables[0].Rows[0]; DbModels.appcategory item = new DbModels.appcategory(); item.apptype = Convert.ToInt32(dr["apptype"]); item.categoryid = Convert.ToInt32(dr["categoryid"]); item.categorytitle = dr["categorytitle"].ToString(); item.categorydesc = dr["categorydesc"].ToString(); return(item); }