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