public void bindingDDLCoQuan(SqlConnection conn)
{
try
{
Su_CoQuanLuuTruLogic coquanLogic = new Su_CoQuanLuuTruLogic();
ListItem root = new ListItem("-- All --", "");
string Code = "";
string Name = "";
DataTable dtCoquan = coquanLogic.getAllSecByConnection(conn);
// them đòng dầu tiên
ddlCoQuan.Items.Add(root);
foreach (DataRow r in dtCoquan.Rows)
{
Code = r["Code"].ToString();
Name = r["Name"].ToString();
ListItem item = new ListItem(Name, Code);
ddlCoQuan.Items.Add(item);
}
ddlCoQuan.DataBind();
}
catch (Exception ex)
{
Logger.logmessage(classobject, "bindingDDLCoQuan", ex.Message + ex.StackTrace); Response.Redirect("~/ThongBaoLoi.aspx", false);
}
}
protected void bindingDDLs()
{
try
{
SqlConnection conn = new SqlConnection(connectionString);
string com = "Select * from Su_CoQuan order by GroupID";
SqlDataAdapter adpt = new SqlDataAdapter(com, conn);
Su_CoQuanLuuTruLogic coquanLogic = new Su_CoQuanLuuTruLogic();
DataTable dt = coquanLogic.getAllSec();
ddlCoQuan.DataSource = dt;
ddlCoQuan.DataBind();
ddlCoQuan.DataTextField = "Name";
ddlCoQuan.DataValueField = "Code";
ddlCoQuan.DataBind();
com = "Select TenPhong, MaPhong from Su_PhongLuuTru ";
adpt = new SqlDataAdapter(com, conn);
dt = new DataTable();
adpt.Fill(dt);
ddlPhong.DataSource = dt;
ddlPhong.DataBind();
ddlPhong.DataTextField = "TenPhong";
ddlPhong.DataValueField = "MaPhong";
ddlPhong.DataBind();
com = "Select Name,ID from Su_NgonNgu order by ID";
adpt = new SqlDataAdapter(com, conn);
dt = new DataTable();
adpt.Fill(dt);
ddlNgonNgu.DataSource = dt;
ddlNgonNgu.DataBind();
ddlNgonNgu.DataTextField = "Name";
ddlNgonNgu.DataValueField = "ID";
ddlNgonNgu.DataBind();
com = "Select Name,ID from Su_ThoiHanBaoQuan order by ID";
adpt = new SqlDataAdapter(com, conn);
dt = new DataTable();
adpt.Fill(dt);
ddlThoiHan.DataSource = dt;
ddlThoiHan.DataBind();
ddlThoiHan.DataTextField = "Name";
ddlThoiHan.DataValueField = "ID";
ddlThoiHan.DataBind();
com = "Select Name,ID from Su_TinhTrangVatLy order by ID";
adpt = new SqlDataAdapter(com, conn);
dt = new DataTable();
adpt.Fill(dt);
ddlTinhTrang.DataSource = dt;
ddlTinhTrang.DataBind();
ddlTinhTrang.DataTextField = "Name";
ddlTinhTrang.DataValueField = "ID";
ddlTinhTrang.DataBind();
//com = "Select Name,ID from Su_MucLuc order by ID";
//adpt = new SqlDataAdapter(com, conn);
//dt = new DataTable();
//adpt.Fill(dt);
//ddlMucLuc.DataSource = dt;
//ddlMucLuc.DataBind();
//ddlMucLuc.DataTextField = "Name";
//ddlMucLuc.DataValueField = "ID";
//ddlMucLuc.DataBind();
com = "Select Name,ID from Su_LoaiVanban order by ID";
adpt = new SqlDataAdapter(com, conn);
dt = new DataTable();
adpt.Fill(dt);
ddlLoaivanban.DataSource = dt;
ddlLoaivanban.DataBind();
ddlLoaivanban.DataTextField = "Name";
ddlLoaivanban.DataValueField = "ID";
ddlLoaivanban.DataBind();
com = "Select Name,ID from Su_DoMat order by ID";
adpt = new SqlDataAdapter(com, conn);
dt = new DataTable();
adpt.Fill(dt);
ddlDomat.DataSource = dt;
ddlDomat.DataBind();
ddlDomat.DataTextField = "Name";
ddlDomat.DataValueField = "ID";
ddlDomat.DataBind();
com = "Select Name,ID from Su_MucDoTinCay order by ID";
adpt = new SqlDataAdapter(com, conn);
dt = new DataTable();
adpt.Fill(dt);
ddlMucDoTinCay.DataSource = dt;
ddlMucDoTinCay.DataBind();
ddlMucDoTinCay.DataTextField = "Name";
ddlMucDoTinCay.DataValueField = "ID";
ddlMucDoTinCay.DataBind();
adpt.Dispose();
conn.Close();
conn.Dispose();
}
catch (Exception ex)
{
Logger.logmessage(classobject, "bindingDDLs", ex.Message + ex.StackTrace); Response.Redirect("~/ThongBaoLoi.aspx", false);
}
}
protected void bindingDDLs()
{
SqlConnection conn = new SqlConnection(connectionString);
string com = "Select * from Su_CoQuan order by GroupID";
SqlDataAdapter adpt = new SqlDataAdapter(com, conn);
Su_CoQuanLuuTruLogic coquanLogic = new Su_CoQuanLuuTruLogic();
DataTable dt = coquanLogic.getAllSec();
ddlCoQuan.DataSource = dt;
ddlCoQuan.DataBind();
ddlCoQuan.DataTextField = "Name";
ddlCoQuan.DataValueField = "Code";
ddlCoQuan.DataBind();
com = "Select TenPhong, MaPhong from Su_PhongLuuTru ";
adpt = new SqlDataAdapter(com, conn);
dt = new DataTable();
adpt.Fill(dt);
ddlPhong.DataSource = dt;
ddlPhong.DataBind();
ddlPhong.DataTextField = "TenPhong";
ddlPhong.DataValueField = "MaPhong";
ddlPhong.DataBind();
com = "Select Name,ID from Su_NgonNgu order by ID";
adpt = new SqlDataAdapter(com, conn);
dt = new DataTable();
adpt.Fill(dt);
ddlNgonNgu.DataSource = dt;
ddlNgonNgu.DataBind();
ddlNgonNgu.DataTextField = "Name";
ddlNgonNgu.DataValueField = "ID";
ddlNgonNgu.DataBind();
com = "Select Name,ID from Su_ThoiHanBaoQuan order by ID";
adpt = new SqlDataAdapter(com, conn);
dt = new DataTable();
adpt.Fill(dt);
ddlThoiHan.DataSource = dt;
ddlThoiHan.DataBind();
ddlThoiHan.DataTextField = "Name";
ddlThoiHan.DataValueField = "ID";
ddlThoiHan.DataBind();
com = "Select Name,ID from Su_TinhTrangVatLy order by ID";
adpt = new SqlDataAdapter(com, conn);
dt = new DataTable();
adpt.Fill(dt);
ddlTinhTrang.DataSource = dt;
ddlTinhTrang.DataBind();
ddlTinhTrang.DataTextField = "Name";
ddlTinhTrang.DataValueField = "ID";
ddlTinhTrang.DataBind();
com = "Select Name,ID from Su_MucLuc order by ID";
adpt = new SqlDataAdapter(com, conn);
dt = new DataTable();
adpt.Fill(dt);
ddlMucLuc.DataSource = dt;
ddlMucLuc.DataBind();
ddlMucLuc.DataTextField = "Name";
ddlMucLuc.DataValueField = "ID";
ddlMucLuc.DataBind();
com = "Select Name,ID from Su_LoaiVanban order by ID";
adpt = new SqlDataAdapter(com, conn);
dt = new DataTable();
adpt.Fill(dt);
ddlLoaivanban.DataSource = dt;
ddlLoaivanban.DataBind();
ddlLoaivanban.DataTextField = "Name";
ddlLoaivanban.DataValueField = "ID";
ddlLoaivanban.DataBind();
com = "Select Name,ID from Su_DoMat order by ID";
adpt = new SqlDataAdapter(com, conn);
dt = new DataTable();
adpt.Fill(dt);
ddlDomat.DataSource = dt;
ddlDomat.DataBind();
ddlDomat.DataTextField = "Name";
ddlDomat.DataValueField = "ID";
ddlDomat.DataBind();
com = "Select Name,ID from Su_MucDoTinCay order by ID";
adpt = new SqlDataAdapter(com, conn);
dt = new DataTable();
adpt.Fill(dt);
ddlMucDoTinCay.DataSource = dt;
ddlMucDoTinCay.DataBind();
ddlMucDoTinCay.DataTextField = "Name";
ddlMucDoTinCay.DataValueField = "ID";
ddlMucDoTinCay.DataBind();
adpt.Dispose();
conn.Close();
conn.Dispose();
}
