protected void btnCapNhat_Click(object sender, EventArgs e)
{
DM_DVQLYService dm_dviSer = new DM_DVQLYService();
SYS_Session session = (SYS_Session)Session["SYS_Session"];
string strTenFile = fileUp.FileName;
UploadFile();
if (Session["Add"] + "" == "0")
{
var qtCT = (DataRowView)grdDVT.GetRow(grdDVT.FocusedRowIndex);
//CBDN.DM_LoaiDay cn = db.DM_LoaiDays.SingleOrDefault(x => x.ID == qtCT.ID);
if (!CheckName(txtMaTram.Text))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã trạm đã trùng');", true); return;
}
db.UPDATE_TTTT_QUANLYCAD_MATRAM(session.User.ma_dviqlyDN, txtMaTram.Text, strTenFile);
}
else
{
if (!CheckName(txtMaTram.Text))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã trạm đã trùng');", true); return;
}
db.INSERT_TTTT_QUANLYCAD(session.User.ma_dviqlyDN, txtMaTram.Text, strTenFile);
}
pcAddRoles.ShowOnPageLoad = false;
_DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
session.FuncID = funcid;
if (session == null || session.User.USERNAME == "Guest")
{
session.CurrentPage = Request.AppRelativeCurrentExecutionFilePath;
Response.Redirect("~\\Login.aspx");
}
else
{
List <SYS_Right> right = session.User.Rights;
foreach (SYS_Right sysRight in right)
{
if (sysRight.FuncId == funcid)
{
rightOfUser = sysRight;
Session["Right"] = sysRight;
Session["UserId"] = session.User.IDUSER;
Session["FunctionId"] = sysRight.FuncId;
break;
}
}
if (rightOfUser == null)
{
Session["Status"] = "0";
Response.Redirect("~\\HeThong\\Default.aspx");
}
}
Session["SYS_Session"] = session;
BindGrvProvince();
}
protected void OnLinkInit(object sender, EventArgs e)
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
HtmlAnchor anc = sender as HtmlAnchor;
GridViewDataItemTemplateContainer container = anc.NamingContainer as GridViewDataItemTemplateContainer;
anc.InnerText = container.Grid.GetRowValues(container.VisibleIndex, "DIACHI").ToString();
anc.Attributes["href"] = "LuuTruFileCAD" + "/" + session.User.ma_dviqlyDN + "/" + anc.InnerText;
}
private bool CheckName(string Name)
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
var dt = db.CHECK_TTTT_TRAM_CAD_CHECK(session.User.ma_dviqlyDN, Name);
if (dt.Rows.Count > 0)
{
return(true);
}
return(false);
}
protected void btnSua_Click(object sender, EventArgs e)
{
pcAddRoles.ShowOnPageLoad = true;
Session["Add"] = 0;
SYS_Session session = (SYS_Session)Session["SYS_Session"];
var qtCT = (DataRowView)grdDVT.GetRow(grdDVT.FocusedRowIndex);
txtMA_CANHBAO.Text = qtCT["MA_CANHBAO"] + "";
txtTT_CANHBAO.Text = qtCT["TT_CANHBAO"] + "";
txtDX_CANHBAO.Value = qtCT["DX_CANHBAO"] + "";
txtMA_CANHBAO.Enabled = false;
}
protected void btnThem_Click(object sender, EventArgs e)
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
if (lbTram.Text != null)
{
DataTable dtTongKT = db.select_TTTT_TONTHATKYTHUAT_THANG(lbDvi.Text + "", lbTram.Text + "", int.Parse(cmbThang.Value + ""), int.Parse(cmbNam.Value + ""), 1);
string tonthatKyThat = "2609";
if (dtTongKT.Rows.Count > 0)
{
tonthatKyThat = dtTongKT.Rows[0]["TONTHAT"] + "";
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Chưa thực hiện tính tổn thật tại trạm này');", true);
return;
}
CBDN.clTinhTonThatKT clTT = new CBDN.clTinhTonThatKT();
DataTable dtNew = new DataTable();
DataTable dta = db.SELECT_TONTHATKD_BYTRAM(lbDvi.Text + "", lbTram.Text + "", int.Parse(cmbThang.Value + ""), int.Parse(cmbNam.Value + ""));
DataTable dt = db.SELECT_TRAM_HATHE_UT_TT(lbDvi.Text + "", lbTram.Text + "", cmbThang.Value + "", cmbNam.Value + "");
var a = dt.Rows.Count;
dtNew.Columns.Add("TTDN");
dtNew.Columns.Add("TTKT");
dtNew.Columns.Add("TTKD");
dtNew.Columns.Add("SoSanh");
if (a > 0)
{
dtNew.Rows.Add("ĐN tổn thất delta A", dt.Rows[0]["KY_THUAT_DN"], dt.Rows[0]["KINH_DOANH_DN"], dt.Rows[0]["SO_SANH_DN"]);
dtNew.Rows.Add("Tỉ lệ tổn thất delta A", dt.Rows[0]["KY_THUAT_TL"], dt.Rows[0]["KINH_DOANH_TL"], dt.Rows[0]["SO_SANH_TL"]);
DataTable dtBD = new DataTable();
dtBD = dtHienThiBanDo(dtNew);
hienthiBanDo(dtBD, decimal.Parse(dta.Rows[0]["PHANTRAMTT"] + "") - decimal.Parse(dt.Rows[0]["KY_THUAT_TL"] + ""), decimal.Parse(dta.Rows[0]["PHANTRAMTT"] + ""), decimal.Parse(dt.Rows[0]["KY_THUAT_TL"] + ""));
grdDVT.Caption = "Tính toán tổn thất điện năng trạm " + lbTram.Text + " điện nhận tháng: " + cmbThang.Value + " : " + dta.Rows[0]["DAUNGUONTHANG"] + " kwwh";
grdDVT.DataSource = dtNew;
grdDVT.DataBind();
}
else
{
grdDVT.Caption = "Tính toán tổn thất điện năng trạm " + lbTram.Text + " chưa có dự liệu tháng: " + cmbThang.Value;
grdDVT.DataSource = dtNew;
grdDVT.DataBind();
}
}
btnDanhSanhKH.Enabled = true;
}
protected void btnHuyNhan_Click(object sender, EventArgs e)
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
string strMadviqly = session.User.ma_dviqly;
DM_DVQLYService isyOrganizationService = new DM_DVQLYService();
Entity.DM_DVQLY sysOrganization = new Entity.DM_DVQLY();
sysOrganization = isyOrganizationService.SelectDM_DVQLY(int.Parse(strMadviqly));
if (rdImportDuLieu.SelectedIndex == 0)
{
}
else
{
var lstData = dbSQL.CMIS_DDoGCs.Where(x => x.MA_DVIQLY == sysOrganization.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + ""));
string tenfile = "";
foreach (var a in lstData)
{
tenfile = a.TENFILE;
break;
}
Class.XuatXML_GCS class_xuatso = new Class.XuatXML_GCS();
DataSet ds = new DataSet();
CBDN.ConvertListToTable cv = new CBDN.ConvertListToTable();
DataTable dt = cv.ConvertToDataTable(lstData.ToList());
dt.Columns.Remove("TENFILE");
dt.Columns.Remove("TrangThaiDongBo");
ds.Tables.Add(dt);
string strXML = class_xuatso.HTML_XuatFileCMIS();
string strXML1 = ds.GetXml();
//strXML1 = strXML1.Replace(",", ".");
strXML1 = strXML1.Replace("<NewDataSet>", "");
strXML1 = strXML1.Replace("</NewDataSet>", "");
strXML1 = strXML1.Replace("<Table>", "<Table1>");
strXML1 = strXML1.Replace("</Table>", "</Table1>");
strXML += strXML1 + "</NewDataSet>";
string attachment = "attachment;filename=" + tenfile + ".XML";
Response.ClearContent();
Response.ContentType = "application/xml";
Response.AddHeader("content-disposition", attachment);
Response.Write(strXML);
Response.End();
}
}
private void loadDLDongBo()
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
string strMadviqly = session.User.ma_dviqly;
DM_DVQLYService isyOrganizationService = new DM_DVQLYService();
Entity.DM_DVQLY sysOrganization = new Entity.DM_DVQLY();
sysOrganization = isyOrganizationService.SelectDM_DVQLY(int.Parse(strMadviqly));
var lst = dbSQL.CMIS_DDoGCs.Where(x => x.MA_DVIQLY == sysOrganization.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + "") && x.TrangThaiDongBo == 1);
grdCN.DataSource = lst;
grdCN.DataBind();
}
protected void btnCapNhat_Click(object sender, EventArgs e)
{
DM_DVQLYService dm_dviSer = new DM_DVQLYService();
SYS_Session session = (SYS_Session)Session["SYS_Session"];
if (Session["Add"] + "" == "0")
{
var qtCT = (DataRowView)grdDVT.GetRow(grdDVT.FocusedRowIndex);
db.UPDATE_TTTT_DM_TTKD(txtMA_CANHBAO.Text, txtTT_CANHBAO.Text, txtDX_CANHBAO.Text);
}
else
{
db.INSERT_TTTT_DM_TTKD(txtMA_CANHBAO.Text, txtTT_CANHBAO.Text, txtDX_CANHBAO.Text);
}
pcAddRoles.ShowOnPageLoad = false;
_DataBind();
}
protected void grdDVT_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
{
try
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
var HoatDong = (DataRowView)grdDVT.GetRow(grdDVT.FocusedRowIndex);
db.DELETE_TTTT_QUANLYCAD_MATRAM(session.User.ma_dviqlyDN, HoatDong["MATRAM"] + "");
_DataBind();
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Xoá loại dây thành công');", true);
}
catch (Exception ex)
{ }
finally
{
e.Cancel = true;
}
}
protected void btnXuatFile_Click(object sender, EventArgs e)
{
if (rdImportDuLieu.SelectedIndex == 0)
{
try
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
string strMadviqly = session.User.ma_dviqly;
DataSet dsTem = new DataSet();
DataAccess.dbGCS dataA = new DataAccess.dbGCS();
//MemoryStream memStream = new MemoryStream();
//Stream file = Server.MapPath("~/") + "FileGCSCMIS\\" + UploadFile();
//using (Stream s = file.PostedFile.InputStream)
//{
// s.CopyTo(memStream);
//}
dsTem.ReadXml(Server.MapPath("~/") + "FileGCSCMIS\\" + UploadFile(), XmlReadMode.InferSchema);
for (int i = 0; i < dsTem.Tables[0].Rows.Count; i++)
{
CBDN.CMIS_DDoGC ddo = new CBDN.CMIS_DDoGC();
CBDN.CMIS_DDoGC kiemtraDDo = new CBDN.CMIS_DDoGC();
kiemtraDDo = dbSQL.CMIS_DDoGCs.SingleOrDefault(x => x.MA_DVIQLY == dsTem.Tables[0].Rows[i]["MA_DVIQLY"] + "" && x.MA_DDO == dsTem.Tables[0].Rows[i]["MA_DDO"] + "" && x.THANG == int.Parse(dsTem.Tables[0].Rows[i]["THANG"] + "") && x.NAM == int.Parse(dsTem.Tables[0].Rows[i]["NAM"] + "") && x.LOAI_BCS == dsTem.Tables[0].Rows[i]["LOAI_BCS"] + "");
if (kiemtraDDo == null)
{
ddo.MA_NVGCS = dsTem.Tables[0].Rows[i]["MA_NVGCS"] + "";
ddo.BOCSO_ID = dsTem.Tables[0].Rows[i]["BOCSO_ID"] + "";
ddo.CHUOI_GIA = dsTem.Tables[0].Rows[i]["CHUOI_GIA"] + "";
ddo.CS_CU = decimal.Parse(dsTem.Tables[0].Rows[i]["CS_CU"] + "");
ddo.CS_MOI = decimal.Parse(dsTem.Tables[0].Rows[i]["CS_MOI"] + "");
ddo.DIA_CHI = dsTem.Tables[0].Rows[i]["DIA_CHI"] + "";
ddo.HSN = decimal.Parse(dsTem.Tables[0].Rows[i]["HSN"] + "");
ddo.KIMUA_CSPK = decimal.Parse(dsTem.Tables[0].Rows[i]["KIMUA_CSPK"] + "");
ddo.KY = int.Parse(dsTem.Tables[0].Rows[i]["KY"] + "");
ddo.LOAI_BCS = dsTem.Tables[0].Rows[i]["LOAI_BCS"] + "";
ddo.LOAI_CS = dsTem.Tables[0].Rows[i]["LOAI_CS"] + "";
ddo.MA_CNANG = "";
ddo.MA_COT = dsTem.Tables[0].Rows[i]["MA_COT"] + "";
ddo.MA_CTO = dsTem.Tables[0].Rows[i]["MA_CTO"] + "";
ddo.MA_DDO = dsTem.Tables[0].Rows[i]["MA_DDO"] + "";
ddo.MA_DVIQLY = dsTem.Tables[0].Rows[i]["MA_DVIQLY"] + "";
ddo.MA_GC = dsTem.Tables[0].Rows[i]["MA_GC"] + "";
ddo.MA_KHANG = dsTem.Tables[0].Rows[i]["MA_KHANG"] + "";
ddo.MA_NVGCS = dsTem.Tables[0].Rows[i]["MA_NVGCS"] + "";
ddo.MA_NVIEN = "";
ddo.MA_SOGCS = dsTem.Tables[0].Rows[i]["MA_QUYEN"] + "";
ddo.MA_TRAM = dsTem.Tables[0].Rows[i]["MA_TRAM"] + "";
ddo.NAM = int.Parse(dsTem.Tables[0].Rows[i]["NAM"] + "");
ddo.NGAY_CU = DateTime.Parse(dsTem.Tables[0].Rows[i]["NGAY_CU"] + "");
ddo.NGAY_MOI = DateTime.Parse(dsTem.Tables[0].Rows[i]["NGAY_MOI"] + "");
ddo.NGAY_PMAX = DateTime.Parse(dsTem.Tables[0].Rows[i]["NGAY_PMAX"] + "");
ddo.NGUOI_GCS = dsTem.Tables[0].Rows[i]["NGUOI_GCS"] + "";
ddo.PMAX = decimal.Parse(dsTem.Tables[0].Rows[i]["PMAX"] + "");
ddo.SERY_CTO = dsTem.Tables[0].Rows[i]["SERY_CTO"] + "";
ddo.SL_MOI = decimal.Parse(dsTem.Tables[0].Rows[i]["SL_MOI"] + "");
ddo.SL_THAO = decimal.Parse(dsTem.Tables[0].Rows[i]["SL_THAO"] + "");
ddo.SL_TTIEP = decimal.Parse(dsTem.Tables[0].Rows[i]["SL_TTIEP"] + "");
ddo.SLUONG_1 = decimal.Parse(dsTem.Tables[0].Rows[i]["SLUONG_1"] + "");
ddo.SLUONG_2 = decimal.Parse(dsTem.Tables[0].Rows[i]["SLUONG_2"] + "");
ddo.SLUONG_3 = decimal.Parse(dsTem.Tables[0].Rows[i]["SLUONG_3"] + "");
ddo.SO_HO = Convert.ToInt32(Convert.ToDecimal(dsTem.Tables[0].Rows[i]["SO_HO"] + ""));
ddo.SO_HOM = dsTem.Tables[0].Rows[i]["SO_HOM"] + "";
ddo.TEN_KHANG = dsTem.Tables[0].Rows[i]["TEN_KHANG"] + "";
ddo.THANG = int.Parse(dsTem.Tables[0].Rows[i]["THANG"] + "");
ddo.TTR_CU = dsTem.Tables[0].Rows[i]["TTR_MOI"] + "";
ddo.TENFILE = fileUp.FileName;
dbSQL.CMIS_DDoGCs.InsertOnSubmit(ddo);
dbSQL.SubmitChanges();
}
}
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Nhận dữ liệu thành công');", true);
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Lỗi nhận dữ liệu: " + ex.Message + "');", true);
}
}
else
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
string strMadviqly = session.User.ma_dviqly;
DM_DVQLYService _DM_DVQLY = new DM_DVQLYService();
var dv = _DM_DVQLY.SelectDM_DVQLY(int.Parse(strMadviqly));
var lst = dbSQL.CMIS_DDoGCs.Where(x => x.MA_DVIQLY == dv.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + ""));
foreach (var ddo in lst)
{
var diemdo = dbSQL.DM_DiemDos.SingleOrDefault(x => x.MaDiemDo == ddo.MA_DDO && x.HoatDong == 1);
if (diemdo == null)
{
continue;
}
var kiemtra = dbSQL.DM_CongTos.SingleOrDefault(x => x.IDDiemDo == diemdo.IDDiemDo + "" && x.TinhTrang == 1);
if (kiemtra == null)
{
continue;
}
var hhddo = dbSQL.HD_GiaoNhanThangs.SingleOrDefault(x => x.IDCongTo == kiemtra.IDCongTo + "" && x.Thang == int.Parse(cmbThang.Value + "") && x.Nam == int.Parse(cmbNam.Value + ""));
if (hhddo == null)
{
continue;
}
if (ddo.LOAI_BCS == "BT")
{
var diemdocmis = dbSQL.CMIS_DDoGCs.SingleOrDefault(x => x.MA_DVIQLY == dv.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + "") && x.MA_DDO == diemdo.MaDiemDo && x.LOAI_BCS == "BT");
diemdocmis.CS_MOI = hhddo.Giao_Bieu1_Cuoi;
diemdocmis.SL_MOI = hhddo.Giao_Bieu1_SanLuong;
diemdocmis.TrangThaiDongBo = 1;
dbSQL.SubmitChanges();
}
else if (ddo.LOAI_BCS == "CD")
{
var diemdocmis = dbSQL.CMIS_DDoGCs.SingleOrDefault(x => x.MA_DVIQLY == dv.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + "") && x.MA_DDO == diemdo.MaDiemDo && x.LOAI_BCS == "CD");
diemdocmis.CS_MOI = hhddo.Giao_Bieu2_Cuoi;
diemdocmis.SL_MOI = hhddo.Giao_Bieu2_SanLuong;
diemdocmis.TrangThaiDongBo = 1;
dbSQL.SubmitChanges();
}
else if (ddo.LOAI_BCS == "TD")
{
var diemdocmis = dbSQL.CMIS_DDoGCs.SingleOrDefault(x => x.MA_DVIQLY == dv.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + "") && x.MA_DDO == diemdo.MaDiemDo && x.LOAI_BCS == "TD");
diemdocmis.CS_MOI = hhddo.Giao_Bieu3_Cuoi;
diemdocmis.SL_MOI = hhddo.Giao_Bieu3_SanLuong;
diemdocmis.TrangThaiDongBo = 1;
dbSQL.SubmitChanges();
}
else if (ddo.LOAI_BCS == "VC")
{
var diemdocmis = dbSQL.CMIS_DDoGCs.SingleOrDefault(x => x.MA_DVIQLY == dv.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + "") && x.MA_DDO == diemdo.MaDiemDo && x.LOAI_BCS == "VC");
diemdocmis.CS_MOI = hhddo.Giao_Q_Cuoi;
diemdocmis.SL_MOI = hhddo.Giao_Q_SanLuong;
diemdocmis.TrangThaiDongBo = 1;
dbSQL.SubmitChanges();
}
if (ddo.LOAI_BCS == "BN")
{
var diemdocmis = dbSQL.CMIS_DDoGCs.SingleOrDefault(x => x.MA_DVIQLY == dv.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + "") && x.MA_DDO == diemdo.MaDiemDo && x.LOAI_BCS == "BN");
diemdocmis.CS_MOI = hhddo.Nhan_Bieu1_Cuoi;
diemdocmis.SL_MOI = hhddo.Nhan_Bieu1_SanLuong;
diemdocmis.TrangThaiDongBo = 1;
dbSQL.SubmitChanges();
}
else if (ddo.LOAI_BCS == "CN")
{
var diemdocmis = dbSQL.CMIS_DDoGCs.SingleOrDefault(x => x.MA_DVIQLY == dv.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + "") && x.MA_DDO == diemdo.MaDiemDo && x.LOAI_BCS == "CN");
diemdocmis.CS_MOI = hhddo.Nhan_Bieu2_Cuoi;
diemdocmis.SL_MOI = hhddo.Nhan_Bieu2_SanLuong;
diemdocmis.TrangThaiDongBo = 1;
dbSQL.SubmitChanges();
}
else if (ddo.LOAI_BCS == "TN")
{
var diemdocmis = dbSQL.CMIS_DDoGCs.SingleOrDefault(x => x.MA_DVIQLY == dv.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + "") && x.MA_DDO == diemdo.MaDiemDo && x.LOAI_BCS == "TN");
diemdocmis.CS_MOI = hhddo.Nhan_Bieu3_Cuoi;
diemdocmis.SL_MOI = hhddo.Nhan_Bieu3_SanLuong;
diemdocmis.TrangThaiDongBo = 1;
dbSQL.SubmitChanges();
}
else if (ddo.LOAI_BCS == "VN")
{
var diemdocmis = dbSQL.CMIS_DDoGCs.SingleOrDefault(x => x.MA_DVIQLY == dv.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + "") && x.MA_DDO == diemdo.MaDiemDo && x.LOAI_BCS == "VN");
diemdocmis.CS_MOI = hhddo.Nhan_Q_Cuoi;
diemdocmis.SL_MOI = hhddo.Nhan_Q_SanLuong;
diemdocmis.TrangThaiDongBo = 1;
dbSQL.SubmitChanges();
}
}
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Đồng bộ số liệu thành công');", true);
loadDLDongBo();
}
}
