public DbModels.appgrade GetGradeInfo(XXF.Db.DbConn PubConn, int apptype, int appgradeno)
{
string sql = "select apptype,appgradeno,appgradename,appgradedesc from appgrade where apptype=@apptype and appgradeno=@appgradeno ";
XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter();
para.Add("@apptype", apptype);
para.Add("@appgradeno", appgradeno);
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.appgrade item = new DbModels.appgrade();
item.apptype = Convert.ToInt32(dr["apptype"]);
item.appgradeno = Convert.ToInt32(dr["appgradeno"]);
item.appgradename = dr["appgradename"].ToString();
item.appgradedesc = dr["appgradedesc"].ToString();
return item;
}
public List<DbModels.appgrade> GetGrades(XXF.Db.DbConn PubConn, int typ)
{
List<DbModels.appgrade> listmodel = new List<DbModels.appgrade>();
string sql = "select apptype,appgradeno,appgradename,appgradedesc from appgrade where apptype=@apptype order by appgradeno asc";
XXF.Db.SimpleProcedureParameter para = new XXF.Db.SimpleProcedureParameter();
para.Add("@apptype", typ);
DataSet ds = new DataSet();
PubConn.SqlToDataSet(ds, sql, para.ToParameters());
foreach (DataRow dr in ds.Tables[0].Rows)
{
DbModels.appgrade item = new DbModels.appgrade();
item.apptype = Convert.ToInt32(dr["apptype"]);
item.appgradeno = Convert.ToInt32(dr["appgradeno"]);
item.appgradename = dr["appgradename"].ToString();
item.appgradedesc = dr["appgradedesc"].ToString();
listmodel.Add(item);
}
return listmodel;
}
