public static List <YRQ> GetYRQS()
{
List <YRQ> yrqs = new List <YRQ>();
SqlDataAdapter da = new SqlDataAdapter();
DataTable dt = new DataTable();
using (SqlConnection conn = new SqlConnection(Settings.ConnectionString))
{
using (SqlCommand comm = new SqlCommand("usp_GetYRQList_vwYRQ", conn))
{
comm.CommandType = CommandType.StoredProcedure;
conn.Open();
da.SelectCommand = comm;
da.Fill(dt);
}
}
foreach (DataRow dr in dt.Rows)
{
YRQ yrq = new YRQ();
yrq.YRQCode = dr["YRQ"].ToString();
yrq.YRQName = dr["ABBR_TITLE"].ToString();
yrqs.Add(yrq);
}
return(yrqs);
}
private void BindYRQs()
{
lbYRQ.Items.Clear();
List <YRQ> yrqs = YRQ.GetYRQS();
foreach (YRQ y in yrqs)
{
lbYRQ.Items.Add(new ListItem(y.YRQCode + " - " + y.YRQName, y.YRQCode));
}
}
