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 showData() { string year, month, day; if (Request["yy"] != null) year = Request["yy"]; else year = DateTime.Today.Year.ToString(); if (Request["mm"] != null) month = Request["mm"]; else month = DateTime.Today.Month.ToString(); if (Request["dd"] != null) day = Request["dd"]; else day = "32"; try { mobileClass mob = new mobileClass(); DataSet ds = mob.fillDataset(string.Format("EXEC mobile_getCV_CongVan {0}, {1}, {2}, {3}", UserId, year, month, day)); DataColumn dc = new DataColumn("fileName"); ds.Tables[0].Columns.Add(dc); dc = new DataColumn("fileLink"); ds.Tables[0].Columns.Add(dc); dc = new DataColumn("bpPhongBan"); ds.Tables[0].Columns.Add(dc); DataSet dsTemp; ds.Tables[0].AcceptChanges(); foreach (DataRow dr in ds.Tables[0].Rows) { dr.BeginEdit(); try { dsTemp = mob.fillDataset(string.Format("EXEC mobile_getCV_Shared {0}, {1}, {2}", UserId, dr[0], dr[1])); dr["fileName"] = dsTemp.Tables[0].Rows[0][2].ToString(); dr["fileLink"] = string.Format("{0}?ID={1}&CV={2}", ResolveUrl("viewfile.aspx"), dsTemp.Tables[0].Rows[0][0], dsTemp.Tables[0].Rows[0][1]); dr["bpPhongBan"] = dsTemp.Tables[1].Rows[0][0].ToString(); } catch { } if (dr["ButPheLD"].ToString() != "") dr["ButPheLD"] = "<img src='/ICT/images/icon_hostusers_16px.gif' /> " + dr["ButPheLD"]; if (dr["bpPhongBan"].ToString() != "") dr["bpPhongBan"] = "<img src='/ICT/images/edit.gif' /> " + dr["bpPhongBan"]; if (dr["TenNoiTHChinh"].ToString() != "") dr["TenNoiTHChinh"] = "<img src='/ICT/images/icon_solutions_16px.gif' /> " + dr["TenNoiTHChinh"]; dr.EndEdit(); } dataCongVan.DataSource = ds; dataCongVan.DataBind(); } catch { dataCongVan.DataSource = null; dataCongVan.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]); } } } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) return; if (Request["ID"] == null) return; if (Request["CV"] == null) return; try { mobileClass ob = new mobileClass(); DataSet ds = ob.fillDataset(string.Format("EXEC mobile_getCV_Files {0}, {1}", Request["ID"], Request["CV"])); Response.Buffer = true; Response.Clear(); Response.ClearHeaders(); Response.ClearContent(); if (Request.UserAgent.Contains("Android")) Response.AddHeader("content-disposition", "attachment; filename=" + ds.Tables[0].Rows[0]["FileName"].ToString()); Response.ContentType = ds.Tables[0].Rows[0]["FileType"].ToString(); Byte[] pdfData = (byte[])ds.Tables[0].Rows[0]["FileData"]; Response.BinaryWrite(pdfData); Response.End(); } catch (Exception ex) { Response.Write(ex.Message); } }