protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) return; if (UserId < 1) Response.Redirect(DotNetNuke.Common.Globals.NavigateURL("Login")); csClass ob = new csClass(); DataSet ds = ob.fillDataset("exec bcPlan_week_getDropdown"); ddThangNam.DataSource = ds.Tables[0]; ddThangNam.DataBind(); ddDonVi.DataSource = ds.Tables[1]; ddDonVi.DataBind(); try { ddDonVi.SelectedValue = UserInfo.Profile.GetPropertyValue("MaDonVi"); } catch { } hlThang.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(TabId); hlDangKy.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(TabId, "weekEdit", "mid/" + ModuleId); hlImport.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(TabId, "weekImport", "mid/" + ModuleId); hlPhanQuyen.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(TabId, "role", "mid/" + ModuleId); hlPhanQuyen2.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(TabId, "role", "mid/" + ModuleId); if (UserInfo.IsInRole("TRUONGPHONG") || UserInfo.IsInRole("PHOPHONG")) { hlPhanQuyen.Visible = true; hlPhanQuyen2.Visible = true; } else { hlPhanQuyen.Visible = false; hlPhanQuyen2.Visible = false; } callBind(); }
private void load_data() { try { csClass ob = new csClass(); string cmd = string.Format("EXEC BCPLAN_APR_ThongKe {0}, {1}", rbWeek.SelectedValue, rbTime.SelectedValue); DataSet ds = ob.fillDataset(cmd); dlThongKe.DataSource = ds.Tables[0]; dlThongKe.DataBind(); DataView dv = ds.Tables[1].DefaultView; Label lbThoiGian, lbDonVi, lbDem; int dem; foreach (DataListItem dr in dlThongKe.Items) { lbThoiGian = (Label)dr.FindControl("lbThoiGian"); dv.RowFilter = string.Format("NgayThang = '{0}'", lbThoiGian.Text); lbDonVi = (Label)dr.FindControl("lbDonVi"); dem = 0; foreach (DataRow row in dv.ToTable().Rows) { dem++; lbDonVi.Text += row[2].ToString() + "; "; } lbDem = (Label)dr.FindControl("lbDem"); lbDem.Text = dem.ToString(); } } catch { } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) return; if (UserId < 1) Response.Redirect(DotNetNuke.Common.Globals.NavigateURL("Login")); csClass ob = new csClass(); string cmdTxt = "exec bcPlan_getDropdown @userID=" + UserId; DataSet ds = ob.fillDataset(cmdTxt); ddThangNam.DataSource = ds.Tables[0]; ddThangNam.DataBind(); ddDonVi.DataSource = ds.Tables[1]; ddDonVi.DataBind(); try { ddDonVi.SelectedValue = UserInfo.Profile.GetPropertyValue("MaDonVi"); } catch { } ddDonVi.Enabled = false; hlTuan.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(TabId, "weekview", "mid/" + ModuleId); hlThem.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(TabId, "edit", "mid/" + ModuleId); hlImport.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(TabId, "import", "mid/" + ModuleId); hlPhanQuyen.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(TabId, "role", "mid/" + ModuleId); if (UserInfo.IsInRole("TRUONGPHONG") || UserInfo.IsInRole("PHOPHONG")) hlPhanQuyen.Visible = true; else hlPhanQuyen.Visible = false; bindData(); }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) return; try { csClass ob = new csClass(); string d = Request["T"] == null ? "1900-01-01" : Request["T"]; string cmd = string.Format("EXEC ChungNT.GiaoBanTuan_Get '{0}'", d); DataSet ds = ob.fillDataset(cmd); if (ds.Tables[0].Rows[0][0].ToString() == "1") { lbThoiGian.Text = string.Format("{0} ngày {1}", ds.Tables[1].Rows[0][3].ToString(), ds.Tables[1].Rows[0][2].ToString()); lbChuTri.Text = ds.Tables[1].Rows[0][4].ToString(); lbThanhPhan.Text = ds.Tables[1].Rows[0][5].ToString(); lbNoiDung.Text = ds.Tables[1].Rows[0][6].ToString(); gvNoiDung.DataSource = ds.Tables[2]; gvNoiDung.DataBind(); DataView dv = ds.Tables[2].DefaultView; Label lbID, lbChiTiet; foreach (GridViewRow dr in gvNoiDung.Rows) { lbID = (Label)dr.FindControl("lbID"); dv.RowFilter = "ID = " + lbID.Text; lbChiTiet = (Label)dr.FindControl("lbChiTiet"); lbChiTiet.Text = dv.ToTable().Rows[0][2].ToString().Replace("\n", "<br />"); } } } catch { } }
protected void Page_Load(object sender, EventArgs e) { try { string type = "DG"; if (Request["T"] != null) type = Request["T"]; if (type == "DG") lbTieuDe.Text = "Tình hình thực hiện"; else lbTieuDe.Text = "Đăng ký kế hoạch"; lbTieuDe.Text += string.Format(" Tuần từ {0} đến {1}", DateTime.Parse(Request["D"]).ToString("dd/MM"), DateTime.Parse(Request["D"]).AddDays(6).ToString("dd/MM/yy")); gvTongHop.Columns[1].Visible = (type == "DG"); gvTongHop.Columns[2].Visible = (type == "DG"); gvTongHop.Columns[3].Visible = (type != "DG"); gvTongHop.Columns[4].Visible = (type != "DG"); csClass ob = new csClass(); string cmdTxt = string.Format("EXEC bcPlan_week_getbyWeek '{0}', '{1}'", Request["DV"], Request["D"]); DataSet ds = ob.fillDataset(cmdTxt); gvTongHop.DataSource = ds; gvTongHop.DataBind(); lbDonVi.Text = ds.Tables[0].Rows[0][8].ToString(); lbPhongBan.Text = ds.Tables[0].Rows[0][8].ToString(); if (Request["DV"] == "A00") { lbDonVi.Text = ""; lbPhongBan.Text = ""; } lbNgayThang.Text = string.Format("Ngày {0} tháng {1} năm {2}", DateTime.Today.Day, DateTime.Today.Month, DateTime.Today.Year); } catch { } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) return; csClass ob = new csClass(); GridView1.DataSource = ob.fillDataset("EXEC bcPlan_getPhanQuyen " + UserId); GridView1.DataBind(); }
private void load_kehoach() { string isWeek = Request["W"] == null ? "1" : Request["W"]; string date = Request["D"]; try { Convert.ToDateTime(date); } catch { date = DateTime.Today.ToString("yyyy-MM-01"); } try { lbTieuDe.Text = string.Format("BẢNG TỔNG HỢP KẾ HOẠCH {0}: {1}", isWeek == "1" ? "TUẦN" : "THÁNG", isWeek == "1" ? "TỪ NGÀY " + Convert.ToDateTime(date).ToString("dd/MM") : Convert.ToDateTime(date).ToString("MM/yyyy")); lbTuan.Text = isWeek == "1" ? "tuần" : "tháng"; string cmd = string.Format("EXEC BCPLAN_LinhVuc_Print {0}, '{1}'", isWeek, date); csClass ob = new csClass(); DataSet ds = ob.fillDataset(cmd); dlKeHoach.DataSource = ds.Tables[0]; dlKeHoach.DataBind(); } catch { } }
private void Get_BaoCao() { try { lbTuan.Text = Get_Monday(Date_Format(tbTuan.Text, "")); csClass ob = new csClass(); string cmd = string.Format("EXEC ChungNT.GiaoBanTuan_Get '{0}'", lbTuan.Text); DataSet ds = ob.fillDataset(cmd); if (ds.Tables[0].Rows[0][0].ToString() == "0") { lbInfo.Text = "Chưa tạo thông báo"; tbNgay.Text = ""; tbGio.Text = ""; tbChuTri.Text = ""; tbThanhPhan.Text = ""; tbNoiDung.Text = ""; hlPrint.Visible = false; gvNoiDung.DataSource = ds.Tables[1]; gvNoiDung.DataBind(); DataView dv = ds.Tables[2].DefaultView; Label lbID; TextBox tbChiTiet; foreach (GridViewRow dr in gvNoiDung.Rows) { lbID = (Label)dr.FindControl("lbID"); dv.RowFilter = "LinhVuc = " + lbID.Text; cmd = ""; foreach (DataRow row in dv.ToTable().Rows) cmd += string.Format("{0}: {1}{2}", row[1].ToString(), row[2].ToString(), Environment.NewLine); tbChiTiet = (TextBox)dr.FindControl("tbChiTiet"); tbChiTiet.Text = cmd; } } else { lbInfo.Text = "Thông báo đã gửi"; tbNgay.Text = ds.Tables[1].Rows[0][2].ToString(); tbGio.Text = ds.Tables[1].Rows[0][3].ToString(); tbChuTri.Text = ds.Tables[1].Rows[0][4].ToString(); tbThanhPhan.Text = ds.Tables[1].Rows[0][5].ToString(); tbNoiDung.Text = ds.Tables[1].Rows[0][6].ToString(); hlPrint.Visible = true; hlPrint.NavigateUrl = "Apr_GiaoBanTuan_Print.aspx?T=" + lbTuan.Text; gvNoiDung.DataSource = ds.Tables[2]; gvNoiDung.DataBind(); DataView dv = ds.Tables[2].DefaultView; Label lbID; TextBox tbChiTiet; foreach (GridViewRow dr in gvNoiDung.Rows) { lbID = (Label)dr.FindControl("lbID"); dv.RowFilter = "ID = " + lbID.Text; tbChiTiet = (TextBox)dr.FindControl("tbChiTiet"); tbChiTiet.Text = dv.ToTable().Rows[0][2].ToString(); } } } catch (Exception ex) { lbError.Text = "Có lỗi trong quá trình đọc dữ liệu. " + ex.Message; } }
private void load_thoigian() { try { csClass ob = new csClass(); ddThoiGian.DataSource = ob.fillDataset("EXEC CNT.BCPlan_getThoiGian " + rbKeHoach.SelectedValue); ddThoiGian.DataBind(); load_kehoach(); } catch (Exception ex) { lbError.Text = "Có lỗi xảy ra trong quá trình đọc dữ liệu. " + ex.Message; } }
protected void btXoaDi_Click(object sender, EventArgs e) { try { string cmdTxt = string.Format("EXEC bcPlan_week_update {0}, {1}, '$DEL$', '', '', '', ''", lbKey.Text, UserId); csClass ob = new csClass(); DataSet ds = ob.fillDataset(cmdTxt); if (ds.Tables[0].Rows[0][0].ToString() == "DEL") Response.Redirect(DotNetNuke.Common.Globals.NavigateURL(TabId, "weekview", "mid/" + ModuleId)); else lbError.Text = "Có lỗi trong quá trình xóa kế hoạch"; } catch (Exception ex) { lbError.Text = "Có lỗi trong quá trình xóa kế hoạch. " + ex.Message; } }
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Change") if (UserInfo.IsInRole("TRUONGPHONG") || UserInfo.IsInRole("PHOPHONG")) { csClass ob = new csClass(); ob.fillDataset(string.Format("EXEC bcPlan_setPhanQuyen {0}, '{1}'", GridView1.Rows[Convert.ToInt32(e.CommandArgument)].Cells[0].Text, UserInfo.Profile.GetPropertyValue("MaDonVi"))); GridView1.DataSource = ob.fillDataset("EXEC bcPlan_getPhanQuyen " + UserId); GridView1.DataBind(); } }
protected void btCapNhat_Click(object sender, EventArgs e) { string cmd; csClass ob = new csClass(); DropDownList dl; foreach (GridViewRow row in gvKeHoach.Rows) try { dl = (DropDownList)row.FindControl("ddLinhVuc"); cmd = string.Format("EXEC BCPLAN_LinhVuc_Set {0}, {1}", row.Cells[1].Text, dl.SelectedValue); ob.fillDataset(cmd); } catch (Exception ex) { lbError.Text = ex.Message; } load_kehoach(); }
public string showGroup() { string thisDV = Eval("LinhVuc").ToString(); if (thisDV == lastDV) return ""; else { lastDV = thisDV; try { csClass ob = new csClass(); DataSet ds = ob.fillDataset("select TenLinhVuc from dbo.BCPLAN_LinhVuc_DM where ID=" + thisDV); thisDV = ds.Tables[0].Rows[0][0].ToString(); } catch { thisDV = ""; } return "</td><th colspan=\"3\" class=\"groupRow\">" + thisDV + "</th></tr><tr><td>"; } }
protected void bindData() { try { csClass ob = new csClass(); string cmdTxt = string.Format("EXEC bcPlan_week_getbyID {0}, {1}", lbKey.Text, UserId); DataSet ds = ob.fillDataset(cmdTxt); DateTime dt = DateTime.Parse(ds.Tables[0].Rows[0][0].ToString()); lbThangNam.Text = string.Format("{0} đến {1}", dt.ToString("dd/MM"), dt.AddDays(6).ToString("dd/MM/yyyy")); tbNoiDung.Text = ds.Tables[0].Rows[0][1].ToString(); tbDeXuat.Text = ds.Tables[0].Rows[0][2].ToString(); tbGhiChu.Text = ds.Tables[0].Rows[0][3].ToString(); tbDanhGia.Text = ds.Tables[0].Rows[0][4].ToString(); tbLyDo.Text = ds.Tables[0].Rows[0][5].ToString(); lbError.Text = ""; } catch { lbError.Text = "Anh/chị không thể cập nhật kế hoạch này"; } }
protected void bindData() { try { csClass ob = new csClass(); string cmdTxt = string.Format("exec bcPlan_getData @donvi='{0}', @thangnam='{1}'", ddDonVi.SelectedValue, ddThangNam.SelectedValue); DataSet ds = ob.fillDataset(cmdTxt); DataColumn dc = new DataColumn("EditLink"); ds.Tables[0].Columns.Add(dc); ds.Tables[0].AcceptChanges(); foreach (DataRow dr in ds.Tables[0].Rows) { dr.BeginEdit(); dr["EditLink"] = DotNetNuke.Common.Globals.NavigateURL(TabId, "edit", "mid/" + ModuleId, "id/", dr[0].ToString()); dr.EndEdit(); } gvKeHoach.DataSource = ds; gvKeHoach.DataBind(); hlPrint.NavigateUrl = string.Format("plan_print.aspx?madv={0}&month={1}", ddDonVi.SelectedValue, ddThangNam.SelectedValue); } catch { } }
private void load_kehoach() { try { string cmd = string.Format("EXEC BCPLAN_LinhVuc_Get {0}, '{1}'", rbKeHoach.SelectedValue, ddThoiGian.SelectedValue); csClass ob = new csClass(); DataSet ds = ob.fillDataset(cmd); gvKeHoach.DataSource = ds.Tables[0]; gvKeHoach.DataBind(); ds = ob.fillDataset("EXEC BCPLAN_LinhVuc_GetDM"); DropDownList dl; foreach (GridViewRow dr in gvKeHoach.Rows) { dl = (DropDownList)dr.FindControl("ddLinhVuc"); dl.DataSource = ds.Tables[0]; dl.DataBind(); dl.SelectedValue = dr.Cells[3].Text; } hlPrint.NavigateUrl = string.Format("APR_LinhVuc_Print.aspx?W={0}&D={1}", rbKeHoach.SelectedValue, ddThoiGian.SelectedValue); } catch (Exception ex) { lbError.Text = "Có lỗi xảy ra trong quá trình đọc kế hoạch. " + ex.Message; } }
protected void bindData(int dangky, string tuan) { try { csClass ob = new csClass(); string cmdTxt = string.Format("EXEC bcPlan_week_getbyWeek '{0}', '{1}'", ddDonVi.SelectedValue, tuan); DataSet ds2 = ob.fillDataset(cmdTxt); DataColumn dc = new DataColumn("weekEdit"); ds2.Tables[0].Columns.Add(dc); ds2.Tables[0].AcceptChanges(); foreach (DataRow dr in ds2.Tables[0].Rows) { dr.BeginEdit(); dr["weekEdit"] = DotNetNuke.Common.Globals.NavigateURL(TabId, "weekEdit", "mid/" + ModuleId + "/id/" + dr[0].ToString()); dr.EndEdit(); } if (dangky == 1) { gvDangKy.DataSource = ds2; gvDangKy.DataBind(); hlDangKyTH.NavigateUrl = string.Format("/DLPhuTho/DesktopModules/CNT.KeHoach/plan_week_full.aspx?T=DK&DV={0}&D={1}", ddDonVi.SelectedValue, tuan); lbDangKy.Text = string.Format("Đăng ký kế hoạch Tuần từ {0} đến {1}", DateTime.Parse(tuan).ToString("dd/MM"), DateTime.Parse(tuan).AddDays(6).ToString("dd/MM/yy")); } else { gvDanhGia.DataSource = ds2; gvDanhGia.DataBind(); hlDanhGiaTH.NavigateUrl = string.Format("/DLPhuTho/DesktopModules/CNT.KeHoach/plan_week_full.aspx?T=DG&DV={0}&D={1}", ddDonVi.SelectedValue, tuan); lbDanhGia.Text = string.Format("Tình hình thực hiện Tuần từ {0} đến {1}", DateTime.Parse(tuan).ToString("dd/MM"), DateTime.Parse(tuan).AddDays(6).ToString("dd/MM/yy")); } } catch { } }
protected void btCapNhat_Click(object sender, EventArgs e) { if (tbNoiDung.Text.Trim() == "") { lbError.Text = "Chưa nhập nội dung kế hoạch"; return; } try { string cmdTxt = string.Format("EXEC bcPlan_week_update {0}, {1}, N'{2}', N'{3}', N'{4}', N'{5}', N'{6}'", lbKey.Text, UserId, tbNoiDung.Text, tbDeXuat.Text, tbGhiChu.Text, tbDanhGia.Text, tbLyDo.Text); csClass ob = new csClass(); string ok = ob.fillDataset(cmdTxt).Tables[0].Rows[0][0].ToString(); if (ok == "INS" || ok == "UPD" || ok == "MOD") if (ok == "INS") lbError.Text = "Thêm mới kế hoạch thành công"; else { bindData(); lbError.Text = "Cập nhật kế hoạch thành công"; } else lbError.Text = "Có lỗi trong quá trình cập nhật kế hoạch"; } catch (Exception ex) { lbError.Text = "Có lỗi trong quá trình cập nhật kế hoạch. " + ex.Message; } }
protected void btCapNhat_Click(object sender, EventArgs e) { try { csClass ob = new csClass(); string cmd = string.Format("EXEC ChungNT.GiaoBanTuan_Set 0, 1, '{0}', '{1}', N'{2}', N'{3}', N'{4}', '', {5}", lbTuan.Text, Date_Format(tbNgay.Text, tbGio.Text).ToString("yyyy-MM-dd HH:mm"), tbChuTri.Text, tbThanhPhan.Text, tbNoiDung.Text, UserId); DataSet ds = ob.fillDataset(cmd); if (ds.Tables[0].Rows[0][0].ToString() == "1") { //lbTuan.Text = ds.Tables[0].Rows[0][1].ToString(); Label lbID; TextBox tbChiTiet; foreach (GridViewRow dr in gvNoiDung.Rows) { lbID = (Label)dr.FindControl("lbID"); tbChiTiet = (TextBox)dr.FindControl("tbChiTiet"); cmd = string.Format("EXEC ChungNT.GiaoBanTuan_ChiTiet_Set 1, '{0}', {1}, N'{2}', '', {3}", lbTuan.Text, lbID.Text, tbChiTiet.Text, UserId); ob.fillDataset(cmd); } Get_BaoCao(); lbError.Text = "Tạo thông báo thành công"; } else lbError.Text = "Không thể tạo thông báo"; } catch (Exception ex) { lbError.Text = "Có lỗi trong quá trình tạo thông báo. " + ex.Message; } }