protected void showData() { try { mobileClass mob = new mobileClass(); DataSet ds = mob.fillData(ddDonVi.SelectedValue, "EXEC mobile_LichTuan2 " + ddTuan.SelectedValue); DataView dv = ds.Tables[1].DefaultView; dlNgayThang.DataSource = ds.Tables[0]; dlNgayThang.DataBind(); string cmdTxt; foreach (DataListItem li in dlNgayThang.Items) { cmdTxt = string.Format("NgayThang = '{0}'", ((Label)li.FindControl("lbNgayThang")).Text); dv.RowFilter = cmdTxt; DataList myDL = (DataList)li.FindControl("dlNoiDung"); myDL.DataSource = dv; myDL.DataBind(); } } catch { dlNgayThang.DataSource = null; dlNgayThang.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) return; try { mobileClass ob=new mobileClass(); DataSet ds = ob.fillData("EOFFICE_ICT", "EXEC Mobile.CV_GetCV 47"); dlCongVan.DataSource = ds.Tables[0]; dlCongVan.DataBind(); } catch { } }
public void showData() { try { mobileClass mob = new mobileClass(); dataLichTuan.DataSource = mob.fillData(ddDonVi.SelectedValue, "EXEC mobile_getLichTuan " + ddTuan.SelectedValue); dataLichTuan.DataBind(); } catch { dataLichTuan.DataSource = null; dataLichTuan.DataBind(); } }
protected void bindData() { mobileClass mob = new mobileClass(); DataSet ds = mob.fillData("EOFFICE_ICT", "EXEC mobile_getCV_CapSo 47"); HtmlGenericControl divYear = new HtmlGenericControl("div"); HtmlGenericControl divMonth = new HtmlGenericControl("div"); HtmlGenericControl divTemp = new HtmlGenericControl("div"); string newMonth = "", htmMonth = ""; foreach (DataRow dr in ds.Tables[0].Rows) { if (dr[1].ToString() == "13") { if (newMonth != "") { divMonth.InnerHtml += string.Format("<ul data-role=\"listview\">{0}</ul>", htmMonth); divTemp.Controls.Add(divMonth); } // Tạo năm mới divYear = newDIV(dr[0].ToString()); placeHolder.Controls.Add(divYear); divTemp = newDIV(""); divYear.Controls.Add(divTemp); } else { if (dr[2].ToString() == "32") { if (newMonth != "") { divMonth.InnerHtml += string.Format("<ul data-role=\"listview\">{0}</ul>", htmMonth); divTemp.Controls.Add(divMonth); } // Tạo tháng mới divMonth = newDIV(dr[1].ToString()); htmMonth = ""; newMonth = dr[1].ToString(); } else { htmMonth += string.Format("<li><a href=\"{0}\">{1}</a></li>", dr[3], dr[2]); } } } }