protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack) return;
if (UserId < 1) Response.Redirect(DotNetNuke.Common.Globals.NavigateURL("Login"));
execSQL.connectionClass ob = new execSQL.connectionClass();
DataSet ds = ob.fillDataset("EXEC ChungNT.BC_getUsers 'ALL'");
ddNguoiNhan.DataSource = ds.Tables[0];
ddNguoiNhan.DataBind();
ddDonVi.DataSource = ds.Tables[1];
ddDonVi.DataBind();
if (Request["reply"] != null) tbNguoiNhan.Text = Request["reply"];
if (Request["forward"] != null)
try
{
lbForward.Text = Request["forward"];
string cmdText = string.Format("EXEC ChungNT.BC_getChiTiet {0}, {1}", lbForward.Text, UserId);
ds = ob.fillDataset(cmdText);
tbTieuDe.Text = ds.Tables[0].Rows[0][3].ToString();
tbNoiDung.Text = ds.Tables[0].Rows[0][4].ToString();
cmdText = string.Format("EXEC ChungNT.BC_getFiles {0}, {1}", lbForward.Text, UserId);
gvDinhKem.DataSource = ob.fillDataset(cmdText);
gvDinhKem.DataBind();
tbNoiDung.Enabled = false;
tbTieuDe.Enabled = false;
fileUpload.Enabled = false;
btThemFile.Visible = false;
}
catch { }
}
private void Load_Data()
{
execSQL.connectionClass ob = new execSQL.connectionClass();
lbNgayThang.Text = ob.dateFormat(tbNgayThang.Text);
try
{
string cmd = string.Format("EXEC ChamCong.Reason_Select '{0}', {1}, '{2}'", lbMaDV.Text, dlNhanVien.SelectedValue, lbNgayThang.Text);
gvChamCong.DataSource = ob.fillDataset(cmd).Tables[0];
gvChamCong.DataBind();
DataSet ds = ob.fillDataset("ChamCong.Type_Select");
DropDownList dlLoai;
foreach (GridViewRow dr in gvChamCong.Rows)
{
dlLoai = (DropDownList)dr.FindControl("dlLoai");
dlLoai.DataSource = ds.Tables[0];
dlLoai.DataBind();
try
{
dlLoai.SelectedValue = dr.Cells[2].Text;
}
catch { }
dr.CssClass = dr.Cells[1].Text;
}
}
catch (Exception ex) { lbError.Text = "Có lỗi trong quá trình đọc dữ liệu. " + ex.Message; }
}
protected void btCapNhat_Click(object sender, EventArgs e)
{
if (fileUpload.HasFile) btDinhKem_Click(sender, e);
try
{
execSQL.connectionClass ob = new execSQL.connectionClass();
string sql = string.Format("EXEC TrongTam.CongViec_Update 0, N'{0}', '{1}', '{2}', '{3}', '{4}', {5}",
tbTieuDe.Text, ob.dateFormat(tbBatDau.Text), ob.dateFormat(tbKetThuc.Text), ob.dateFormat(tbCanhBao.Text), lbChuTri.Text, UserId);
DataSet ds = ob.fillDataset(sql);
string newID = ds.Tables[0].Rows[0][1].ToString();
int trongSo;
TextBox txt_TrongSo, txt_BatDau, txt_KetThuc, txt_CanhBao, txt_NoiDung;
CheckBox cbPhanCong;
foreach (GridViewRow dr in gvPhanCong.Rows)
{
cbPhanCong = (CheckBox)dr.FindControl("cbPhanCong");
txt_BatDau = (TextBox)dr.FindControl("tbBatDau");
if (txt_BatDau.Text == "") txt_BatDau.Text = tbBatDau.Text;
txt_KetThuc = (TextBox)dr.FindControl("tbKetThuc");
if (txt_KetThuc.Text == "") txt_KetThuc.Text = tbKetThuc.Text;
txt_CanhBao = (TextBox)dr.FindControl("tbCanhBao");
if (txt_CanhBao.Text == "") txt_CanhBao.Text = txt_KetThuc.Text;
txt_NoiDung = (TextBox)dr.FindControl("tbNoiDung");
sql = string.Format("EXEC TrongTam.CongViec_PhanCong {0}, N'{1}', '{2}', '{3}', '{4}', {5}, {6}, '{7}'",
newID, txt_NoiDung.Text, ob.dateFormat(txt_BatDau.Text), ob.dateFormat(txt_KetThuc.Text), dr.Cells[0].Text, UserId,
cbPhanCong.Checked ? 3 : 0,
ob.dateFormat(txt_CanhBao.Text));
ob.fillDataset(sql);
}
Response.Redirect(hlQuayLai.NavigateUrl);
}
catch (Exception ex) { lbError.Text = "Có lỗi trong quá trình cập nhật. " + ex.Message; }
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack) return;
if (UserId < 0) Response.Redirect(DotNetNuke.Common.Globals.NavigateURL("Login"));
hlChamDiem_Ban.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(TabId, "BAN", "mid/" + ModuleId);
hlDuyetTB.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(TabId, "DUYET", "mid/" + ModuleId);
hlPhucTra.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(TabId, "PHUCTRA", "mid/" + ModuleId);
execSQL.connectionClass ob = new execSQL.connectionClass();
try
{
string sql = string.Format("SELECT VHDN.Quyen_CheckUser(2, {0})", UserId);
DataSet ds = ob.fillDataset(sql);
hlChamDiem_Ban.Visible = ds.Tables[0].Rows[0][0].ToString() == "1";
hlDuyetTB.Visible = ds.Tables[0].Rows[0][0].ToString() == "1";
sql = string.Format("SELECT VHDN.Quyen_CheckUser(1, {0})", UserId);
ds = ob.fillDataset(sql);
hlChamDiem_Ban.Visible = ds.Tables[0].Rows[0][0].ToString() == "1";
hlPhucTra.Visible = ds.Tables[0].Rows[0][0].ToString() == "1";
}
catch { }
tbThoiGian.Text = DateTime.Today.ToString("dd/MM/yyyy");
lbThoiGian.Text = ob.dateFormat(tbThoiGian.Text);
Load_Data();
}
private void Load_Data()
{
try
{
execSQL.connectionClass ob = new execSQL.connectionClass();
string sql = string.Format("EXEC ChungNT.cv_spCongVan_HanPheDuyet_TongHop {0}, {1}, {2}", UserId, cbQuaHan.Checked ? 1 : 0, dlThucHien.SelectedValue);
DataSet ds = ob.fillDataset(sql);
gvCongVan.DataSource = ds.Tables[0];
gvCongVan.DataBind();
DataSet dsTemp;
GridView gvThucHien;
HyperLink hlFile;
foreach (GridViewRow dr in gvCongVan.Rows)
{
sql = string.Format("EXEC ChungNT.cv_spCongVan_HanPheDuyet_ChiTiet {0}, {1}", dr.Cells[0].Text, dlThucHien.SelectedValue);
dsTemp = ob.fillDataset(sql);
gvThucHien = (GridView)dr.FindControl("gvThucHien");
gvThucHien.DataSource = dsTemp.Tables[0];
gvThucHien.DataBind();
try
{
hlFile = (HyperLink)dr.FindControl("hlDinhKem");
hlFile.NavigateUrl = ds.Tables[1].Rows[0][0].ToString();
hlFile.Text = ds.Tables[1].Rows[0][1].ToString();
}
catch { }
}
lbError.Text = string.Format("Danh sách <b>{0}</b> công văn", ds.Tables[0].Rows.Count);
}
catch (Exception ex) { lbError.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 (UserId > 0)
try
{
execSQL.connectionClass ob = new execSQL.connectionClass();
string sql = string.Format("EXEC TrongTam.CV_Tree '', '', 0, {0}", UserId);
DataSet ds = ob.fillDataset(sql);
int quaHan = 0, canhBao = 0, hoanThanh = 0;
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr[1].ToString().StartsWith("<span class=\"QuaHan"))
quaHan++;
if (dr[1].ToString().StartsWith("<span class=\"CanhBao"))
canhBao++;
if (dr[1].ToString().StartsWith("<span class=\"HoanThanh"))
hoanThanh++;
}
lbQuaHan.Text = quaHan.ToString();
lbCanhBao.Text = canhBao.ToString();
lbHoanThanh.Text = hoanThanh.ToString();
lbDangTH.Text = (ds.Tables[0].Rows.Count - quaHan - canhBao - hoanThanh).ToString();
sql = "select ChungNT.DNN_Link('CongViec_TrongTam', '') LinkCV";
ds = ob.fillDataset(sql);
hlTrongTam.NavigateUrl = ds.Tables[0].Rows[0][0].ToString().Replace("ctl//", "");
}
catch { }
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack) return;
execSQL.connectionClass ob = new execSQL.connectionClass();
string cmdText = string.Format("EXEC bc_getUsersByDonvi @userID={0}, @maDV=0", UserId);
cmdText = "EXEC bc_getUsersByDonvi @userID=" + UserId;
DataSet ds = ob.fillDataset(cmdText);
ddDonVi.DataSource = ds.Tables[1];
ddDonVi.DataBind();
ddNguoiNhan.DataSource = ds.Tables[0];
ddNguoiNhan.DataBind();
//if (UserId > 0)
//{
// ddNguoiNhan.DataSource = ob.fillDataset(cmdText);
// ddNguoiNhan.DataTextField = "DisplayName";
// ddNguoiNhan.DataValueField = "Username";
// ddNguoiNhan.DataBind();
//}
if (Request["reply"] != null)
{
tbNguoiNhan.Text = Request["reply"];
}
if (Request["forward"] != null)
{
cmdText = string.Format("EXEC bc_getsChiTietBC @userName='******', @idBC={1}", UserInfo.Username, Request["forward"]);
ds = ob.fillDataset(cmdText);
try
{
tbTieuDe.Text = ds.Tables[0].Rows[0][4].ToString();
tbNoiDung.Text = ds.Tables[0].Rows[0][5].ToString();
tbDinhKem.Text = ds.Tables[0].Rows[0][6].ToString();
}
catch { }
}
}
private void Load_Data()
{
try
{
string sql = string.Format("EXEC VHDN.BangDiem_Select_CaNhan 1, {0}, '{1}'", Request["ID"], Request["DT"]);
execSQL.connectionClass ob = new execSQL.connectionClass();
DataSet ds = ob.fillDataset(sql);
gvData.DataSource = ds.Tables[0];
gvData.DataBind();
int diemC, diem, diemTB, diemPT;
diemC = 0; diem = 0; diemTB = 0; diemPT = 0;
foreach (DataRow dr in ds.Tables[0].Rows)
try
{
diemC += int.Parse(dr["DiemChuan"].ToString());
diem += int.Parse(dr["Diem"].ToString());
diemTB += int.Parse(dr["DiemTB"].ToString());
diemPT += int.Parse(dr["DiemPT"].ToString());
}
catch { }
gvData.FooterRow.CssClass = "group";
gvData.FooterRow.Cells[1].Text = "Tổng cộng :";
gvData.FooterRow.Cells[2].Text = diemC.ToString();
gvData.FooterRow.Cells[3].Text = diem.ToString();
gvData.FooterRow.Cells[4].Text = diemTB.ToString();
gvData.FooterRow.Cells[5].Text = diemPT.ToString();
sql = string.Format("EXEC VHDN.TongHop_TieuDe {0}, '{1}'", Request["ID"], Request["DT"]);
ds = ob.fillDataset(sql);
lbThang.Text = ds.Tables[0].Rows[0][0].ToString();
lbBan.Text = ds.Tables[1].Rows[0][0].ToString();
}
catch { }
}
private void Load_Data()
{
try
{
execSQL.connectionClass ob = new execSQL.connectionClass();
string sql = string.Format("EXEC ChungNT.cv_spCongVan_NgayHetHan_TongHop {0}, {1}, N'{2}', {3}",
UserId, dlTrangThai.SelectedValue, dlPhongBan.SelectedItem.Text, dlSapXep.SelectedValue);
DataSet ds = ob.fillDataset(sql);
gvCongVan.DataSource = ds.Tables[0];
gvCongVan.DataBind();
lbError.Text = string.Format("Danh sách <b>{0}</b> công văn", ds.Tables[0].Rows.Count);
TreeView tree;
TreeNode node;
TreeNode child;
HyperLink hlFile;
string txt;
foreach (GridViewRow dr in gvCongVan.Rows)
{
sql = "EXEC ChungNT.cv_spCongVan_NgayHetHan_ChiTiet " + dr.Cells[0].Text;
ds = ob.fillDataset(sql);
tree = (TreeView)dr.FindControl("tvThucHien");
int i = 0;
int j = 0;
while (i < ds.Tables[0].Rows.Count)
try
{
if (ds.Tables[0].Rows[i]["SX"].ToString() == "3")
{
txt = string.Format("<span class='{0}'>{1}{2}</span>", ds.Tables[0].Rows[i]["Class_HH"].ToString(),
ds.Tables[0].Rows[i]["DisplayName"].ToString(), ds.Tables[0].Rows[i]["Ngay_HH"].ToString());
node = new TreeNode(txt);
node.SelectAction = TreeNodeSelectAction.Expand;
j = i + 1;
while (j < ds.Tables[0].Rows.Count && ds.Tables[0].Rows[j]["SX"].ToString() != "3")
{
txt = string.Format("<span class='{0}'>{1}{2}</span>", ds.Tables[0].Rows[j]["Class_HH"].ToString(),
ds.Tables[0].Rows[j]["Ngay_GQ"].ToString(), ds.Tables[0].Rows[j]["DisplayName"].ToString());
child = new TreeNode(txt);
child.SelectAction = TreeNodeSelectAction.None;
node.ChildNodes.Add(child);
j++;
}
tree.Nodes.Add(node);
i = j;
}
else i++;
}
catch { }
try
{
hlFile = (HyperLink)dr.FindControl("hlDinhKem");
hlFile.NavigateUrl = ds.Tables[1].Rows[0][0].ToString();
hlFile.Text = ds.Tables[1].Rows[0][1].ToString();
}
catch { }
}
}
catch (Exception ex) { lbError.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;
string cmdText = string.Format("EXEC bc_getsChiTietBC @userName='******', @idBC={1}", UserInfo.Username, Request["idBC"]);
execSQL.connectionClass ob = new execSQL.connectionClass();
DataSet ds = ob.fillDataset(cmdText);
try
{
hlChuyen.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(TabId, "GuiBC", "mid/" + ModuleId + "/forward/" + ds.Tables[0].Rows[0][0].ToString());
hlTraLoi.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(TabId, "GuiBC", "mid/" + ModuleId + "/reply/" + ds.Tables[0].Rows[0][2].ToString());
lbUserName.Text = ds.Tables[0].Rows[0][3].ToString();
lbTieuDe.Text = ds.Tables[0].Rows[0][4].ToString();
lbNoiDung.Text = ds.Tables[0].Rows[0][5].ToString();
lbThoiGian.Text = "vào lúc " + ds.Tables[0].Rows[0][7].ToString();
}
catch (Exception ex) { lbTieuDe.Text = ex.Message; }
// Tạo liên kết đến file đính kèm
lbDinhKem.Text = "";
string[] split = ds.Tables[0].Rows[0][6].ToString().Split(',');
foreach (string s in split)
{
try
{
cmdText = "EXEC bc_getsFile " + int.Parse(s);
if (lbDinhKem.Text.Length > 0) lbDinhKem.Text += "<br />";
lbDinhKem.Text += string.Format("[+] <a href='{0}/DesktopModules/cntBaoCao/fileview.aspx?ID={1}' target='_blank'>{2}</a>",
Request.ApplicationPath, int.Parse(s), ob.fillDataset(cmdText).Tables[0].Rows[0][0].ToString());
}
catch
{
if (lbDinhKem.Text.Length > 0) lbDinhKem.Text += "<br />";
lbDinhKem.Text += string.Format("[+] <a href='{0}' target='_blank'>{0}</a>", s);
}
}
// Hiện tên nhãn
if (ds.Tables[0].Rows[0][1].ToString() == "$$$")
{
lbNhan.Text = "";
lbNguoiGui.Text = "Gửi đến";
btSave.Visible = false;
ddNhan.Visible = false;
}
else
{
lbNhan.Text = ds.Tables[0].Rows[0][1].ToString();
lbNguoiGui.Text = "Gửi từ";
ddNhan.Visible = true;
btSave.Visible = true;
cmdText = "EXEC bc_getsNhan @userID=" + UserId;
ds = ob.fillDataset(cmdText);
DataRow dr = ds.Tables[0].NewRow();
dr[0] = "0";
dr[1] = "Chọn danh mục";
ds.Tables[0].Rows.InsertAt(dr, 0);
ddNhan.DataSource = ds;
ddNhan.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack) return;
try
{
string nam = Request["Y"];
string tuan = Request["W"];
string maDV = Request["DV"];
lbThang.Text = tuan;
lbNam.Text = nam;
execSQL.connectionClass ob = new execSQL.connectionClass();
string cmd = string.Format("EXEC BaoCao.DonVi_Select '{0}'", maDV);
DataSet ds = ob.fillDataset(cmd);
lbDonVi.Text = ds.Tables[0].Rows[0][1].ToString();
lbKyHieu.Text = ds.Tables[0].Rows[0][2].ToString();
lbDiaDanh.Text = ds.Tables[0].Rows[0][3].ToString();
lbCapTren.Text = ds.Tables[0].Rows[0][4].ToString();
if (maDV.Length == 9) lbNoiNhan.Text = lbCapTren.Text.ToUpper().Replace("CÔNG TY ĐIỆN LỰC", "PC");
lbNgayThang.Text = string.Format("{0} tháng {1} năm {2}", DateTime.Today.Day, DateTime.Today.Month, DateTime.Today.Year);
cmd = string.Format("EXEC BaoCao.Tuan_Select '{0}', {1}, {2}", maDV, nam, tuan);
ds = ob.fillDataset(cmd);
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
lbChuTri.Text = dr[2].ToString();
lbChucVu.Text = dr[3].ToString();
lbCongViec.Text = dr[4].ToString();
lbKeHoach.Text = dr[5].ToString();
lbDotXuat.Text = dr[6].ToString();
lbBienBan.Text = dr[7].ToString();
lbLanhDao.Text = dr[8].ToString();
lbCanBo.Text = dr[9].ToString();
lbTongPCT.Text = dr[10].ToString();
lbPCT.Text = dr[11].ToString();
lbTongLCT.Text = dr[12].ToString();
lbLCT.Text = dr[13].ToString();
lbViPham.Text = dr[14].ToString();
lbGiamThuong.Text = dr[15].ToString();
lbCatThuong.Text = dr[16].ToString();
lbKyLuat.Text = dr[17].ToString();
lbHuanLuyen.Text = dr[18].ToString();
lbLyThuyet.Text = dr[19].ToString();
lbThucHanh.Text = dr[20].ToString();
lbHLLai.Text = dr[21].ToString();
lbBanDau.Text = dr[22].ToString();
lbKienNghi.Text = dr[23].ToString().Replace("\r\n", "<br />");
lbThoiGian.Text = dr[30].ToString();
}
ClientScript.RegisterStartupScript(this.GetType(), "print", "<script>window.print();</script>");
}
catch { }
}
private void Load_Data()
{
try
{
execSQL.connectionClass ob = new execSQL.connectionClass();
string sql = string.Format("EXEC ChungNT.cv_spCongVan_NgayHetHan_TongHop '{0}', '{1}', {2}, '{3}'",
ob.dateFormat(tbTuNgay.Text), ob.dateFormat(tbDenNgay.Text), dlLanhDao.SelectedValue, dlPhongBan.SelectedValue);
DataSet ds = ob.fillDataset(sql);
gvCongVan.DataSource = ds.Tables[0];
gvCongVan.DataBind();
lbError.Text = string.Format("Danh sách <b>{0}</b> công văn", ds.Tables[0].Rows.Count);
TreeView tree;
TreeNode node;
TreeNode child;
string txt;
foreach (GridViewRow dr in gvCongVan.Rows)
try
{
tree = (TreeView)dr.FindControl("tvThucHien");
sql = "EXEC ChungNT.cv_spCongVan_NgayHetHan_ChiTiet " + dr.Cells[0].Text;
ds = ob.fillDataset(sql);
dr.CssClass = ds.Tables[1].Rows[0][0].ToString();
int i = 0;
int j = 0;
while (i < ds.Tables[0].Rows.Count)
try
{
if (ds.Tables[0].Rows[i]["SX"].ToString() == "3")
{
txt = string.Format("<span class='{0}'>{1}{2}</span>", ds.Tables[0].Rows[i]["Class_HH"].ToString(),
ds.Tables[0].Rows[i]["DisplayName"].ToString(), ds.Tables[0].Rows[i]["Ngay_HH"].ToString());
node = new TreeNode(txt);
node.SelectAction = TreeNodeSelectAction.Expand;
j = i + 1;
while (j < ds.Tables[0].Rows.Count && ds.Tables[0].Rows[j]["SX"].ToString() != "3")
{
txt = string.Format("<span class='{0}'>{1}{2}</span>", ds.Tables[0].Rows[j]["Class_HH"].ToString(),
ds.Tables[0].Rows[j]["Ngay_GQ"].ToString(), ds.Tables[0].Rows[j]["DisplayName"].ToString());
child = new TreeNode(txt);
child.SelectAction = TreeNodeSelectAction.None;
node.ChildNodes.Add(child);
j++;
}
tree.Nodes.Add(node);
i = j;
}
else i++;
//tree.ExpandAll();
}
catch { }
}
catch { }
}
catch (Exception ex) { lbError.Text = "Có lỗi trong quá trình đọc dữ liệu. " + ex.Message; }
}
private void Load_CongViec()
{
try
{
execSQL.connectionClass ob = new execSQL.connectionClass();
string sql = string.Format("EXEC TrongTam.CongViec_Select {0}, {1}", lbID.Text, UserId);
DataSet ds = ob.fillDataset(sql);
if (ds.Tables[0].Rows.Count > 0)
{
lbID.Text = ds.Tables[0].Rows[0]["ID"].ToString();
tbTieuDe.Text = ds.Tables[0].Rows[0]["TieuDe"].ToString();
tbBatDau.Text = ds.Tables[0].Rows[0]["BatDau"].ToString();
tbKetThuc.Text = ds.Tables[0].Rows[0]["KetThuc"].ToString();
tbCanhBao.Text = ds.Tables[0].Rows[0]["CanhBao"].ToString();
lbChuTri.Text = ds.Tables[0].Rows[0]["ChuTri"].ToString();
lbError.Text = string.Format("Cập nhật lần cuối: {0}, {1}", ds.Tables[0].Rows[0]["DisplayName"].ToString(), ds.Tables[0].Rows[0]["DateS"].ToString());
btCapNhat.Text = "Cập nhật";
}
else
{
lbChuTri.Text = UserInfo.Profile.GetPropertyValue("MaDonVi");
btCapNhat.Text = "Thêm mới";
}
sql = string.Format("EXEC TrongTam.CongViec_PhanCong_Select {0}, {1}", lbID.Text, UserId);
ds = ob.fillDataset(sql);
gvPhanCong.DataSource = ds.Tables[0];
gvPhanCong.DataBind();
foreach (GridViewRow dr in gvPhanCong.Rows)
{
if (dr.Cells[2].Text == "0") dr.CssClass = "ChuaPC";
if (dr.Cells[1].Text == "1") dr.CssClass = "ChuTri";
}
Load_DinhKem();
Load_ThucHien();
sql = string.Format("EXEC TrongTam.CongViec_CheckRole {0}, {1}", lbID.Text, UserId);
ds = ob.fillDataset(sql);
gvPhanCong.Columns[5].Visible = ds.Tables[0].Rows[0]["SELECT"].ToString() == "1" && lbID.Text == "0";
bool canEdit = ds.Tables[0].Rows[0]["SELECT"].ToString() == "1" || ds.Tables[0].Rows[0]["EDIT"].ToString() == "1";
btThemPC.Visible = canEdit;
fileUpload.Visible = canEdit;
btDinhKem.Visible = canEdit;
gvDinhKem.Columns[3].Visible = canEdit;
btCapNhat.Enabled = canEdit;
bool canDo = ds.Tables[0].Rows[0]["EDIT"].ToString() == "1" || ds.Tables[0].Rows[0]["DO"].ToString() == "1";
gvThucHien.Columns[8].Visible = canDo;
btThucHien.Enabled = canDo;
}
catch (Exception ex) { lbError.Text = "Có lỗi trong quá trình đọc dữ liệu. " + ex.Message; }
}
private void Load_CongViec()
{
string cv = Request["ID"] == null ? "0" : Request["ID"];
try
{
execSQL.connectionClass ob = new execSQL.connectionClass();
string sql = string.Format("EXEC TrongTam.CongViec_Select {0}, {1}", cv, UserId);
DataSet ds = ob.fillDataset(sql);
if (ds.Tables[0].Rows.Count > 0)
{
lbTieuDe.Text = ds.Tables[0].Rows[0]["TieuDe"].ToString();
lbBatDau.Text = ds.Tables[0].Rows[0]["BatDau"].ToString();
lbKetThuc.Text = ds.Tables[0].Rows[0]["KetThuc"].ToString();
lbCanhBao.Text = ds.Tables[0].Rows[0]["CanhBao"].ToString();
lbError.Text = string.Format("Cập nhật lần cuối: {0}, {1}", ds.Tables[0].Rows[0]["DisplayName"].ToString(), ds.Tables[0].Rows[0]["DateS"].ToString());
}
else lbError.Text = "Không tìm thấy công việc";
gvPhanCong.DataSource = ds.Tables[2];
gvPhanCong.DataBind();
foreach (GridViewRow dr in gvPhanCong.Rows)
{
if (ds.Tables[0].Rows.Count > 0)
if (dr.Cells[2].Text == "0")
dr.CssClass = "ChuaPC";
if (dr.Cells[1].Text == "1") dr.CssClass = "ChuTri";
}
sql = string.Format("EXEC TrongTam.CongViec_DinhKem_Select {0}, {1}", cv, UserId);
gvDinhKem.DataSource = ob.fillDataset(sql).Tables[0];
gvDinhKem.DataBind();
ds = ob.fillDataset("EXEC TrongTam.CongViec_ThucHien_Select " + cv);
gvThucHien.DataSource = ds.Tables[0];
gvThucHien.DataBind();
string lastDV = "";
int i = 0;
foreach (GridViewRow dr in gvThucHien.Rows)
if (dr.Cells[1].Text == lastDV)
{
dr.Cells[3].Text = "";
dr.Cells[4].Text = "";
}
else
{
lastDV = dr.Cells[1].Text;
i++;
dr.Cells[3].Text = i.ToString();
if (dr.Cells[2].Text == "1") dr.CssClass = "ChuTri2";
}
}
catch (Exception ex) { lbError.Text = "Có lỗi trong quá trình đọc dữ liệu. " + ex.Message; }
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Change")
if (UserInfo.IsInRole("TRUONGPHONG") || UserInfo.IsInRole("PHOPHONG"))
{
execSQL.connectionClass ob = new execSQL.connectionClass();
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 Page_Load(object sender, EventArgs e)
{
if (IsPostBack) return;
string maDV = Request["DV"];
DateTime dt = DateTime.Parse(Request["DT"]);
DateTime fri_day = dt.AddDays(-2 - (int)dt.DayOfWeek);
if (dt.DayOfWeek == DayOfWeek.Friday || dt.DayOfWeek == DayOfWeek.Saturday)
fri_day = dt.AddDays(5 - (int)dt.DayOfWeek);
DateTimeFormatInfo dfi = DateTimeFormatInfo.CurrentInfo;
System.Globalization.Calendar cal = dfi.Calendar;
if (Request["W"] == "1")
lbThoiGian.Text = string.Format("Tuần {0}/{1}: từ ngày {2} đến ngày {3}",
cal.GetWeekOfYear(fri_day, dfi.CalendarWeekRule, dfi.FirstDayOfWeek), dt.Year, fri_day.ToString("dd/MM"), fri_day.AddDays(6).ToString("dd/MM"));
else
lbThoiGian.Text = string.Format("Ngày {0} tháng {1} năm {2}", dt.Day, dt.Month, dt.Year);
try
{
string cmd = string.Format("EXEC EOFFICE_NPC.ChungNT.B4_SuCo_NgungGiam_Select '{0}', '{1}', '{2}', 1",
maDV, fri_day.ToString("yyyy-MM-dd"), fri_day.AddDays(6).ToString("yyyy-MM-dd"));
if (Request["W"] != "1")
cmd = string.Format("EXEC EOFFICE_NPC.ChungNT.B4_SuCo_NgungGiam_Select '{0}', '{1}', '{1}', 1", maDV, dt.ToString("yyyy-MM-dd"));
execSQL.connectionClass ob = new execSQL.connectionClass();
DataSet ds = ob.fillDataset(cmd);
int khachhang = 0, thoigian = 0, sanluong = 0;
foreach (DataRow dr in ds.Tables[0].Rows)
{
khachhang += Convert.ToInt32(dr["KhachHang"].ToString());
thoigian += Convert.ToInt32(dr["ThoiGian"].ToString());
sanluong += Convert.ToInt32(dr["SanLuong"].ToString());
}
DataRow row = ds.Tables[0].NewRow();
row["DuongDay"] = "Tổng";
row["KhachHang"] = khachhang;
row["ThoiGian"] = thoigian;
row["SanLuong"] = sanluong;
ds.Tables[0].Rows.Add(row);
gvSuCo.DataSource = ds.Tables[0];
gvSuCo.DataBind();
gvSuCo.Rows[gvSuCo.Rows.Count - 1].Style.Add("font-weight", "bold");
if (maDV != "F01")
{
cmd = string.Format("EXEC EOFFICE_NPC.ChungNT.B4_SuCo_NgungGiam_DonVi '{0}'", maDV);
lbDonVi.Text = ob.fillDataset(cmd).Tables[0].Rows[0][1].ToString();
}
}
catch { }
ClientScript.RegisterStartupScript(this.GetType(), "print", "<script>window.print();</script>");
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack) return;
string ngay = Request["DT"];
string donvi = Request["DV"];
if (donvi == "F01P11") Response.Redirect("HanhLang_ViPham_PrintNPC.aspx?DT=" + ngay);
lbNgay.Text = string.Format("{0} tháng {1} năm {2}", DateTime.Today.Day, DateTime.Today.Month, DateTime.Today.Year);
if (ngay.EndsWith("07-01"))
lbNgayThang.Text = "Từ ngày 01/07 đến ngày 31/12/" + ngay.Substring(0, 4);
else
lbNgayThang.Text = "Từ ngày 01/01 đến ngày 30/06/" + ngay.Substring(0, 4);
execSQL.connectionClass ob = new execSQL.connectionClass();
DataSet ds;
string cmd;
try
{
cmd = string.Format("EXEC BaoCao.DonVi_Select '{0}'", donvi);
ds = ob.fillDataset(cmd);
if (donvi != "F01P11") lbCongTy.Text = ds.Tables[0].Rows[0][1].ToString();
lbKyHieu.Text = ds.Tables[0].Rows[0][2].ToString();
lbDiaDanh.Text = ds.Tables[0].Rows[0][3].ToString();
}
catch { }
try
{
cmd = string.Format("EXEC LichLV.HanhLang_ViPham_DonVi '{0}', '{1}', 0", ngay, donvi);
ds = ob.fillDataset(cmd);
string lastDV = "";
ds.Tables[0].AcceptChanges();
foreach (DataRow dr in ds.Tables[0].Rows)
if (dr[1].ToString() == lastDV)
{
dr.BeginEdit();
dr[2] = "";
dr.EndEdit();
}
else
{
lastDV = dr[1].ToString();
if (dr[1].ToString() == "Z01") dr[2] = "Cộng theo cấp điện áp";
}
dlGiamThieu.DataSource = ds.Tables[0];
dlGiamThieu.DataBind();
ClientScript.RegisterStartupScript(this.GetType(), "print", "<script>window.print();</script>");
}
catch { }
}
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" ? Convert.ToDateTime(date).ToString("dd/MM") + " - " + Convert.ToDateTime(date).AddDays(6).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);
execSQL.connectionClass ob = new execSQL.connectionClass();
DataSet ds = ob.fillDataset(cmd);
dlKeHoach.DataSource = ds.Tables[0];
dlKeHoach.DataBind();
}
catch { }
}
protected void btChuyen_Click(object sender, EventArgs e)
{
try
{
execSQL.connectionClass ob = new execSQL.connectionClass();
DataSet ds;
CheckBox cb;
string cmd;
int ok = 0;
foreach (GridViewRow row in gvKeHoach.Rows)
{
cb = (CheckBox)row.FindControl("cbSelect");
if (cb.Checked)
try
{
cmd = string.Format("EXEC ChungNT.KeHoach_ChuyenTiep_Update {0}, {1}, '{2}', {3}", row.Cells[1].Text, rbKeHoach.SelectedValue, ob.dateFormat(tbTime.Text), UserId);
ds = ob.fillDataset(cmd);
if (ds.Tables[0].Rows[0][0].ToString() == "1")
ok++;
}
catch { }
}
gvKeHoach.DataSource = null;
gvKeHoach.DataBind();
lbError.Text = string.Format("Chuyển tiếp thành công <b>{0}</b> kế hoạch", ok);
}
catch (Exception ex) { lbError.Text = "Có lỗi trong quá trình cập nhật. " + ex.Message; }
}
private void Load_GiamThieu()
{
try
{
execSQL.connectionClass ob = new execSQL.connectionClass();
string cmd = string.Format("EXEC LichLV.HanhLang_GiamThieu_DonVi '{0}', '', {1}", ob.dateFormat(tbNgayThang.Text), UserId);
if (ddThaoTac.SelectedValue != "ALL")
cmd = string.Format("EXEC LichLV.HanhLang_GiamThieu_DonVi '{0}', '{1}', 0", ob.dateFormat(tbNgayThang.Text), ddThaoTac.SelectedValue);
DataSet ds = ob.fillDataset(cmd);
lbThoiGian.Text = ds.Tables[0].Rows[0][0].ToString();
tbThoiGian.Text = "Đến ngày " + ds.Tables[0].Rows[0][1].ToString();
if (ddThaoTac.SelectedValue == "ALL")
{
gvGiamThieu.DataSource = ds.Tables[1];
gvGiamThieu.DataBind();
}
else
{
DataView dv = ds.Tables[1].DefaultView;
dv.RowFilter = "MaDV <> 'Z01'";
gvGiamThieu.DataSource = dv;
gvGiamThieu.DataBind();
}
}
catch (Exception ex) { lbError.Text = "Có lỗi xảy ra trong quá trình đọc dữ liệu. " + ex.Message; }
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack) return;
hlQuayLai.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(TabId);
if (UserInfo.IsInRole("Administrators") || UserInfo.IsInRole("Admin_DonVi"))
try
{
execSQL.connectionClass ob = new execSQL.connectionClass();
DataSet ds = ob.fillDataset("EXEC ChungNT.Password_Admin");
string tab = ds.Tables[1].Rows[0]["TabID"].ToString();
string module = ds.Tables[1].Rows[0]["ModuleID"].ToString();
DataColumn dc = new DataColumn("Link");
ds.Tables[0].Columns.Add(dc);
ds.Tables[0].AcceptChanges();
foreach (DataRow dr in ds.Tables[0].Rows)
{
dr.BeginEdit();
dr["Link"] = DotNetNuke.Common.Globals.NavigateURL(int.Parse(tab), "Edit", "mid/" + module, "UserId/" + dr["UserID"].ToString());
dr.EndEdit();
}
gvNhanVien.DataSource = ds.Tables[0];
gvNhanVien.DataBind();
int d = 0;
foreach (GridViewRow dr in gvNhanVien.Rows)
{
dr.CssClass = dr.Cells[6].Text;
if (dr.Cells[6].Text != "OK") d++;
}
lbError.Text = string.Format("Mật khẩu quá hạn: <b>{0}</b> / {1} tài khoản", d, gvNhanVien.Rows.Count);
}
catch (Exception ex) { lbError.Text = "Có lỗi trong quá trình đọc dữ liệu. " + ex.Message; }
else Response.Redirect(DotNetNuke.Common.Globals.NavigateURL(TabId));
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack) return;
hlThemMoi.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(TabId, "CONGVIEC", "mid/" + ModuleId);
hlKiemTra.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(TabId, "KIEMTRA", "mid/" + ModuleId);
hlDuyet.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(TabId, "DUYET", "mid/" + ModuleId);
try
{
hlDuyet.Visible = UserInfo.Profile.City.Substring(0, 4) == "F01F";
hlThemMoi.Visible = UserInfo.Profile.City.Length == 9;
hlKiemTra.Visible = UserInfo.Profile.City.Length == 9;
}
catch { }
try
{
string cmd = string.Format("EXEC LichLV.DonVi_List 1, {0}, ''", UserId);
execSQL.connectionClass ob = new execSQL.connectionClass();
dlCongTy.DataSource = ob.fillDataset(cmd);
dlCongTy.DataBind();
load_dienluc();
}
catch (Exception ex) { lbError.Text = ex.Message; }
tbTuNgay.Text = DateTime.Today.ToString("dd/MM/yyyy");
tbDenNgay.Text = DateTime.Today.ToString("dd/MM/yyyy");
}
private void Load_Ke()
{
try
{
execSQL.connectionClass ob = new execSQL.connectionClass();
DataSet ds = ob.fillDataset("EXEC LuuTru.Ke_Select_2015 " + lbGiaID.Text);
DataColumn dc = new DataColumn("Link");
ds.Tables[0].Columns.Add(dc);
ds.Tables[0].AcceptChanges();
foreach (DataRow dr in ds.Tables[0].Rows)
{
dr.BeginEdit();
dr["Link"] = DotNetNuke.Common.Globals.NavigateURL(TabId, "CAP", "mid/" + ModuleId, "ID/" + dr[2].ToString());
dr.EndEdit();
}
gvCap.DataSource = ds.Tables[0];
gvCap.DataBind();
string last = "";
int last_i = 0, count = 0;
for (int i = 0; i < gvCap.Rows.Count; i++)
if (last == gvCap.Rows[i].Cells[1].Text)
count++;
else
{
//gvCap.Rows[last_i].Cells[1].RowSpan = count;
last = gvCap.Rows[i].Cells[1].Text;
last_i = i;
count = 1;
}
}
catch (Exception ex) { lbErrorGia.Text = "Có lỗi trong quá trình đọc dữ liệu. " + ex.Message; }
}
private void load_congviec()
{
if (lbID.Text == "0")
{
tbNgayThang.Text = DateTime.Today.ToString("dd/MM/yyyy");
try
{
execSQL.connectionClass ob = new execSQL.connectionClass();
DataSet ds = ob.fillDataset("EXEC LichLV.User_DonVi " + UserId);
lbDonVi.Text = ds.Tables[0].Rows[0][3].ToString();
lbTrangThai.Text = "Mới nhập";
}
catch (Exception ex) { lbTrangThai.Text = ex.Message; }
}
else try
{
execSQL.connectionClass ob = new execSQL.connectionClass();
DataSet ds = ob.fillDataset("EXEC LichLV.CongViec_ID " + lbID.Text);
tbNgayThang.Text = ds.Tables[0].Rows[0][1].ToString();
tbNoiDung.Text = ds.Tables[0].Rows[0][2].ToString();
tbDonVi.Text = ds.Tables[0].Rows[0][3].ToString();
tbDiaDiem.Text = ds.Tables[0].Rows[0][4].ToString();
tbThoiGian.Text = ds.Tables[0].Rows[0][5].ToString();
lbDonVi.Text = ds.Tables[0].Rows[0][6].ToString();
lbTrangThai.Text = ds.Tables[0].Rows[0][7].ToString();
}
catch (Exception ex) { lbError.Text = ex.Message; }
}
private void BindDuLieuDanhMucGia()
{
try
{
execSQL.connectionClass ob = new execSQL.connectionClass();
DataSet ds = ob.fillDataset("EXEC LuuTru.Ke_Select " + lbID.Text + ", 0");
lbID.Text = ds.Tables[0].Rows[0][2].ToString();
lbTieuDe.Text = ds.Tables[0].Rows[0][1].ToString();
lbMoTa.Text = ds.Tables[0].Rows[0][3].ToString();
DataColumn dc = new DataColumn("LinkID");
ds.Tables[0].Columns.Add(dc);
ds.Tables[0].AcceptChanges();
foreach (DataRow dr in ds.Tables[0].Rows)
{
dr.BeginEdit();
dr["LinkID"] = DotNetNuke.Common.Globals.NavigateURL(TabId, "KE", "mid/" + ModuleId, "ID/" + dr[4].ToString());
dr.EndEdit();
}
if (ds.Tables[0].Rows.Count == 0)
{
DataRow dr = ds.Tables[0].NewRow();
dr[4] = 0;
ds.Tables[0].Rows.Add(dr);
}
gvKho.DataSource = ds.Tables[0];
gvKho.DataBind();
gvKho.Columns[4].Visible = UserInfo.IsInRole("Administrators") || UserInfo.IsInRole("Admin_DonVi") || UserInfo.IsInRole("VANTHU") || UserInfo.IsInRole("NHANVIENLUUTRU");
lbError.Text = "Danh sách: " + ds.Tables[0].Rows.Count;
}
catch (Exception ex) { lbError.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;
execSQL.connectionClass ob = new execSQL.connectionClass();
GridView1.DataSource = ob.fillDataset("EXEC bcPlan_getPhanQuyen " + UserId);
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack) return;
try
{
execSQL.connectionClass ob = new execSQL.connectionClass();
string sql = string.Format("EXEC ThongtinMHTB.dbo.Lay_Thongbao_tonghop_new '{0}', '{1}'", UserInfo.Username, UserInfo.Profile.GetPropertyValue("MaDonVi"));
DataSet ds = ob.fillDataset(sql);
ds.Tables[0].AcceptChanges();
foreach (DataRow dr in ds.Tables[0].Rows)
{
dr.BeginEdit();
dr["noidung"] = HttpUtility.HtmlDecode(dr["noidung"].ToString());
dr.EndEdit();
}
gvThongBao.DataSource = ds.Tables[0];
gvThongBao.DataBind();
DataView dv = ds.Tables[1].DefaultView;
GridView gvDinhKem;
foreach (GridViewRow dr in gvThongBao.Rows)
{
gvDinhKem = (GridView)dr.FindControl("gvDinhKem");
dv.RowFilter = "ma_tb = " + dr.Cells[0].Text;
gvDinhKem.DataSource = dv.Table;
gvDinhKem.DataBind();
}
}
catch { }
}
private void Load_Data()
{
try
{
lbTieuDe.Text = lbThoiGian.Text.Substring(5, 2) + "/" + lbThoiGian.Text.Substring(0, 4);
string sql = string.Format("EXEC VHDN.BangDiem_Select_PhucTra_Ban '{0}'", lbThoiGian.Text);
execSQL.connectionClass ob = new execSQL.connectionClass();
DataSet ds = ob.fillDataset(sql);
DataColumn dc = new DataColumn("Links");
ds.Tables[0].Columns.Add(dc);
ds.Tables[0].AcceptChanges();
foreach (DataRow dr in ds.Tables[0].Rows)
{
dr.BeginEdit();
dr["Links"] = DotNetNuke.Common.Globals.NavigateURL(TabId, "BANPHUCTRA2", "mid/" + ModuleId, "ID/" + dr[0].ToString());
dr.EndEdit();
}
gvNhanVien.DataSource = ds.Tables[0];
gvNhanVien.DataBind();
foreach (GridViewRow dr in gvNhanVien.Rows)
if (dr.Cells[1].Text == "0" || dr.Cells[4].Text != dr.Cells[6].Text)
dr.CssClass = "show";
}
catch (Exception ex)
{
lbError.Text = "Có lỗi trong quá trình đọc dữ liệu. " + ex.Message;
lbError2.Text = lbError.Text;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack) return;
string ngayThang = Request["DT"] == null ? DateTime.Today.ToString("yyyy-MM-dd") : Request["DT"];
string donVi = Request["DV"] == null ? "F01P11" : Request["DV"];
try
{
execSQL.connectionClass ob = new execSQL.connectionClass();
string cmd = string.Format("EXEC LichLV.HanhLang_ViPham_DonVi '{0}', '{1}', 0", ngayThang, donVi);
DataSet ds = ob.fillDataset(cmd);
lbNgayThang.Text = ds.Tables[0].Rows[0][1].ToString();
lbCongTy.Text = ds.Tables[0].Rows[0][2].ToString();
string lastDV = "";
ds.Tables[1].AcceptChanges();
foreach (DataRow dr in ds.Tables[1].Rows)
if (dr[1].ToString() == lastDV)
{
dr.BeginEdit();
dr[2] = "";
dr.EndEdit();
}
else
{
lastDV = dr[1].ToString();
if (dr[1].ToString() == "Z01") dr[2] = "Cộng theo cấp điện áp";
}
dlGiamThieu.DataSource = ds.Tables[1];
dlGiamThieu.DataBind();
}
catch { }
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack) return;
hlQuayLai.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(TabId);
try
{
execSQL.connectionClass ob = new execSQL.connectionClass();
ddDonVi.DataSource = ob.fillDataset("EXEC LichLV.DonVi_QuanLy " + UserId);
ddDonVi.DataBind();
ddThoiGian.DataSource = ob.fillDataset("EXEC LichLV.ThoiGian_Tuan");
ddThoiGian.DataBind();
}
catch (Exception ex) { lbError.Text = ex.Message; }
load_congviec();
}
