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; }
}