public List <Model.TrainingBaseModel> getProvinceNameListModel() { List <Model.TrainingBaseModel> list = new List <TrainingBaseModel>(); string sql = string.Format("select province_code,province_name from GP_Training_Base Group By province_code,province_name"); DataTable dt = db.RunDataTable(sql); foreach (DataRow dr in dt.Rows) { Model.TrainingBaseModel model = new TrainingBaseModel(); model.province_code = dr["province_code"].ToString(); model.province_name = dr["province_name"].ToString(); list.Add(model); } return(list); }
public List <Model.TrainingBaseModel> getHospitalNameListModel(string province_code) { List <Model.TrainingBaseModel> list = new List <TrainingBaseModel>(); string sql = string.Format("select id,hospital_code,hospital_name from GP_Training_Base where hospital_code like @province_code"); SqlParameter[] prams = { db.MakeInParam("@province_code", SqlDbType.NVarChar, 50, province_code + "%") }; DataTable dt = db.RunDataTable(sql, prams); foreach (DataRow dr in dt.Rows) { Model.TrainingBaseModel model = new TrainingBaseModel(); model.id = dr["id"].ToString(); model.hospital_code = dr["hospital_code"].ToString(); model.hospital_name = dr["hospital_name"].ToString(); list.Add(model); } return(list); }