protected void btThem_Click(object sender, EventArgs e) { if (tbTenBao.Text.Trim().Length > 0) try { class_LutBao ob = new class_LutBao(); string cmd = string.Format("EXEC LutBao.LutBao_Update 0, N'{0}', {1}", tbTenBao.Text, UserId); ob.fillDataset(cmd).Tables[0].Rows[0][0].ToString(); Panel1.Visible = false; ddLutBao.DataSource = ob.fillDataset("EXEC LutBao.LutBao_Select 0, 0"); ddLutBao.DataBind(); } catch { } }
private void LOAD_CONBAO() { try { class_LutBao ob = new class_LutBao(); string cmd = string.Format("EXEC LutBao.LutBao_Select {0}, {1}", lbBaoID.Text, UserId); DataSet ds = ob.fillDataset(cmd); lbTenBao.Text = ds.Tables[0].Rows[0][1].ToString(); try { lbMaxID.Text = ds.Tables[1].Rows[0][0].ToString(); tbMaxDuongDay.Text = ds.Tables[1].Rows[0][1].ToString(); tbMaxTBA.Text = ds.Tables[1].Rows[0][2].ToString(); tbMaxHuyen.Text = ds.Tables[1].Rows[0][3].ToString(); tbMaxXa.Text = ds.Tables[1].Rows[0][4].ToString(); tbMaxKhachHang.Text = ds.Tables[1].Rows[0][5].ToString(); lbMaxError.Text = "Cập nhật lúc " + ds.Tables[1].Rows[0][7].ToString(); } catch { lbMaxID.Text = "0"; } } catch (Exception ex) { lbBaoID.Text = "0"; tbTenBao.Visible = true; lbMaxError.Text = "Có lỗi trong quá trình đọc dữ liệu. " + ex.Message; } }
private void LOAD_DATA() { hlNhap.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(TabId, "UPDATE", "mid/" + ModuleId, "BAO/" + ddLutBao.SelectedValue); try { class_LutBao ob = new class_LutBao(); DataSet ds = ob.fillDataset("EXEC LutBao.VanHanh_TrongBao_Home " + ddLutBao.SelectedValue); DataColumn dc = new DataColumn("Link"); ds.Tables[0].Columns.Add(dc); ds.Tables[0].AcceptChanges(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DataRow row = ds.Tables[0].Rows[i]; row.BeginEdit(); if (i > 0) if (row["MaDonVi"].ToString() == ds.Tables[0].Rows[i - 1]["MaDonVi"].ToString()) row["TenDonVi"] = "Lớn nhất :"; row["Link"] = DotNetNuke.Common.Globals.NavigateURL(TabId, "VIEW", "mid/" + ModuleId, "BAO/" + ddLutBao.SelectedValue, "DV/" + row[2].ToString()); row.EndEdit(); } gvVanHanh.DataSource = ds.Tables[0]; gvVanHanh.DataBind(); } catch { } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) return; if (UserId < 1) Response.Redirect(DotNetNuke.Common.Globals.NavigateURL("Login")); if (Request["ID"] == null) { if (Request["BAO"] == null) { lbID.Text = "0"; lbBaoID.Text = "0"; lbMaxID.Text = "0"; tbTenBao.Visible = true; } else { lbID.Text = "0"; lbBaoID.Text = Request["BAO"]; tbTenBao.Visible = false; LOAD_CONBAO(); } try { class_LutBao ob = new class_LutBao(); lbCongTy.Text = ob.fillDataset("EXEC ChungNT.User_DonVi " + UserId).Tables[0].Rows[0][1].ToString(); } catch { } } else { lbID.Text = Request["ID"]; tbTenBao.Visible = false; LOAD_VANHANH(); } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) return; //hlNhapMoi.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(TabId, "UPDATE", "mid/" + ModuleId); try { class_LutBao ob = new class_LutBao(); ddLutBao.DataSource = ob.fillDataset("EXEC LutBao.LutBao_Select 0, 0"); ddLutBao.DataBind(); LOAD_DATA(); } catch { } }
private void LOAD_DATA() { hlNhap.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(TabId, "UPDATE", "mid/" + ModuleId, "BAO/" + ddLutBao.SelectedValue); try { string cmd = string.Format("EXEC LutBao.VanHanh_TrongBao_CongTy {0}, '{1}'", ddLutBao.SelectedValue, lbDonVi.Text); class_LutBao ob = new class_LutBao(); DataSet ds = ob.fillDataset(cmd); DataColumn dc = new DataColumn("Link"); ds.Tables[0].Columns.Add(dc); ds.Tables[0].AcceptChanges(); foreach (DataRow row in ds.Tables[0].Rows) { row.BeginEdit(); row["Link"] = DotNetNuke.Common.Globals.NavigateURL(TabId, "UPDATE", "mid/" + ModuleId, "ID/" + row[0].ToString()); row.EndEdit(); } gvVanHanh.DataSource = ds.Tables[0]; gvVanHanh.DataBind(); lbCongTy.Text = ds.Tables[2].Rows[0][0].ToString(); try { lbMaxDuongDay.Text = ds.Tables[1].Rows[0][1].ToString(); lbMaxTBA.Text = ds.Tables[1].Rows[0][2].ToString(); lbMaxHuyen.Text = ds.Tables[1].Rows[0][3].ToString(); lbMaxXa.Text = ds.Tables[1].Rows[0][4].ToString(); lbMaxKhachHang.Text = ds.Tables[1].Rows[0][5].ToString(); lbMaxError.Text = "Cập nhật lúc " + ds.Tables[1].Rows[0][6].ToString(); } catch { lbMaxDuongDay.Text = ""; lbMaxTBA.Text = ""; lbMaxHuyen.Text = ""; lbMaxXa.Text = ""; lbMaxKhachHang.Text = ""; lbMaxError.Text = ""; } } catch (Exception ex) { lbMaxError.Text = "Có lỗi trong quá trình đọc dữ liệu. " + ex.Message; } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) return; if (Request["DV"] == null) Response.Redirect(DotNetNuke.Common.Globals.NavigateURL(TabId)); lbDonVi.Text = Request["DV"]; hlNhapMoi.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(TabId, "UPDATE", "mid/" + ModuleId); hlQuayLai.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(TabId); try { class_LutBao ob = new class_LutBao(); ddLutBao.DataSource = ob.fillDataset("EXEC LutBao.LutBao_Select 0, 0"); ddLutBao.DataBind(); if (Request["BAO"] != null) try { ddLutBao.SelectedValue = Request["BAO"]; } catch { } LOAD_DATA(); } catch { } }
private void LOAD_VANHANH() { try { class_LutBao ob = new class_LutBao(); DataSet ds = ob.fillDataset("EXEC LutBao.VanHanh_TrongBao_Select " + lbID.Text); lbBaoID.Text = ds.Tables[0].Rows[0][1].ToString(); lbCongTy.Text = ds.Tables[0].Rows[0][2].ToString(); tbDuongDay.Text = ds.Tables[0].Rows[0][3].ToString(); tbTBA.Text = ds.Tables[0].Rows[0][4].ToString(); tbHuyen.Text = ds.Tables[0].Rows[0][5].ToString(); tbXa.Text = ds.Tables[0].Rows[0][6].ToString(); tbKhachHang.Text = ds.Tables[0].Rows[0][7].ToString(); tbKhacPhuc.Text = ds.Tables[0].Rows[0][8].ToString(); tbGio.Text = ds.Tables[0].Rows[0][9].ToString(); lbError.Text = "Số liệu lúc " + ds.Tables[0].Rows[0][10].ToString(); LOAD_CONBAO(); } catch (Exception ex) { lbID.Text = "0"; lbError.Text = "Có lỗi trong quá trình đọc dữ liệu. " + ex.Message; } }
protected void btMaxCapNhat_Click(object sender, EventArgs e) { //UPDATE_CONBAO(); try { string cmd = string.Format("EXEC LutBao.VanHanh_TrongBao_Update {0}, {1}, 1, {2}, {3}, {4}, {5}, {6}, '{7}', '', {8}", lbMaxID.Text, lbBaoID.Text, tbMaxDuongDay.Text, tbMaxTBA.Text, tbMaxHuyen.Text, tbMaxXa.Text, tbMaxKhachHang.Text, "", UserId); class_LutBao ob = new class_LutBao(); ob.fillDataset(cmd); //Response.Write(cmd); Response.Redirect(DotNetNuke.Common.Globals.NavigateURL(TabId)); } catch (Exception ex) { lbError.Text = "Có lỗi trong quá trình cập nhật. " + ex.Message; } }
private void UPDATE_CONBAO() { if (lbBaoID.Text == "0" && tbTenBao.Text != "") try { class_LutBao ob = new class_LutBao(); string cmd = string.Format("EXEC LutBao.LutBao_Update 0, N'{0}', {1}", tbTenBao.Text, UserId); lbID.Text = ob.fillDataset(cmd).Tables[0].Rows[0][0].ToString(); } catch { } }