protected void grdDVT_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { try { SYS_Session session = (SYS_Session)Session["SYS_Session"]; CBDN.DM_DiemDo ddo = db.DM_DiemDos.SingleOrDefault(x => x.IDDiemDo == int.Parse(e.Keys[0] + "")); CBDN.DM_DVQLY dv = db.DM_DVQLies.SingleOrDefault(c => c.IDMA_DVIQLY == ddo.MaDviNhap); CBDN.HD_DiemDoLienKet cv = db.HD_DiemDoLienKets.SingleOrDefault(x => x.MaDiemDo == ddo.MaDiemDo); if (cv == null) { CBDN.HD_DiemDoLienKet ddoLK = new CBDN.HD_DiemDoLienKet(); ddoLK.DDo = e.NewValues[0] + ""; ddoLK.Nguon = e.NewValues[1] + ""; ddoLK.MaDiemDo = ddo.MaDiemDo; ddoLK.IDMaDVIQLY = ddo.MaDviNhap; ddoLK.MaDDVIQLY = dv.MA_DVIQLY; ddoLK.IsChieuGiao = (bool)e.NewValues["IsChieuGiao"]; ddoLK.IsChieuNhan = (bool)e.NewValues["IsChieuNhan"]; ddoLK.IsDaoChieu = (bool)e.NewValues["IsDaoChieu"]; ddoLK.Nhan = decimal.Parse(e.NewValues["Nhan"] + ""); ddoLK.Chia = decimal.Parse(e.NewValues["Chia"] + ""); db.HD_DiemDoLienKets.InsertOnSubmit(ddoLK); db.SubmitChanges(); } else { //CBDN.HD_DiemDoLienKet ddoLK = db.HD_DiemDoLienKets.SingleOrDefault(x => x.MaDiemDo == cv.MaDiemDo); cv.DDo = e.NewValues[0] + ""; cv.Nguon = e.NewValues[1] + ""; cv.IsChieuGiao = (bool)e.NewValues["IsChieuGiao"]; cv.IsChieuNhan = (bool)e.NewValues["IsChieuNhan"]; cv.IsDaoChieu = (bool)e.NewValues["IsDaoChieu"]; cv.Nhan = decimal.Parse(e.NewValues["Nhan"] + ""); cv.Chia = decimal.Parse(e.NewValues["Chia"] + ""); // ddoLK.MaDiemDo = e.NewValues[0] + ""; db.SubmitChanges(); } grdDVT.CancelEdit(); e.Cancel = true; db.SubmitChanges(); _DataBind(); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Xoá người phụ trách thành công');", true); } catch (Exception ex) { } finally { e.Cancel = true; } }
protected void btnCapNhat_Click(object sender, EventArgs e) { try { SYS_Session session = (SYS_Session)Session["SYS_Session"]; CBDN.DM_DiemDoLienKetResult lk = (CBDN.DM_DiemDoLienKetResult)grdDVT.GetRow(grdDVT.FocusedRowIndex); CBDN.DM_DiemDo ddo = db.DM_DiemDos.SingleOrDefault(x => x.IDDiemDo == lk.IDDiemDo); CBDN.DM_DVQLY dv = db.DM_DVQLies.SingleOrDefault(c => c.IDMA_DVIQLY == ddo.MaDviNhap); CBDN.HD_DiemDoLienKet cv = db.HD_DiemDoLienKets.SingleOrDefault(x => x.MaDiemDo == ddo.MaDiemDo); if (cv == null) { CBDN.HD_DiemDoLienKet ddoLK = new CBDN.HD_DiemDoLienKet(); ddoLK.DDo = txtMaDiemDoLK.Text; ddoLK.Nguon = txtNguon.Text; ddoLK.MaDiemDo = ddo.MaDiemDo; ddoLK.IDMaDVIQLY = ddo.MaDviNhap; ddoLK.MaDDVIQLY = dv.MA_DVIQLY; ddoLK.IsChieuGiao = ckGiao.Checked; ddoLK.IsChieuNhan = CkNhan.Checked; ddoLK.IsDaoChieu = ckDaoChieu.Checked; db.HD_DiemDoLienKets.InsertOnSubmit(ddoLK); db.SubmitChanges(); } else { //CBDN.HD_DiemDoLienKet ddoLK = db.HD_DiemDoLienKets.SingleOrDefault(x => x.MaDiemDo == cv.MaDiemDo); cv.DDo = txtMaDiemDoLK.Text; cv.Nguon = txtNguon.Text; cv.IsChieuGiao = ckGiao.Checked; cv.IsChieuNhan = CkNhan.Checked; cv.IsDaoChieu = ckDaoChieu.Checked; // ddoLK.MaDiemDo = e.NewValues[0] + ""; db.SubmitChanges(); } db.SubmitChanges(); _DataBind(); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Cập nhật dữ liệu thành công');", true); } catch (Exception ex) { } finally { } }
private void DongBoNPC(CBDN.HD_DiemDoLienKet a) { List <TSVH> services = new List <TSVH>(); ServicePointManager.ServerCertificateValidationCallback = (senderX, certificate, chain, sslPolicyErrors) => { return(true); }; WebClient client = new WebClient(); client.Headers["Content-type"] = "application/json"; client.Encoding = Encoding.UTF8; string sql; if (a.DDo + "" == "") { sql = "p_MA_DIEMDO=" + a.MaDiemDo + "&p_THANG=" + DateTime.Now.Month + "&p_NAM=" + DateTime.Now.Year + "&p_HES=KhoEVN"; } else if (a.Nguon != "IPP") { sql = "p_MA_DIEMDO=" + a.DDo + "&p_THANG=" + DateTime.Now.Month + "&p_NAM=" + DateTime.Now.Year + "&p_HES=EVNHES"; } else { sql = "p_MA_DIEMDO=" + a.DDo + "&p_THANG=" + DateTime.Now.Month + "&p_NAM=" + DateTime.Now.Year + "&p_HES=" + a.Nguon; } string json = client.DownloadString("https://vhpm.npc.com.vn/DoDemAPI/api/DoXa?" + sql); services = (new JavaScriptSerializer()).Deserialize <List <TSVH> >(json); foreach (var tsvh in services) { TSVH vh = new TSVH(); if ((bool)a.IsDaoChieu) { if (!(bool)a.IsChieuGiao && !(bool)a.IsChieuNhan) { vh.C1 = (decimal.Parse(tsvh.C2) * a.Nhan / a.Chia) + ""; vh.EXPBT = (decimal.Parse(tsvh.IMPBT) * a.Nhan / a.Chia) + ""; vh.EXPCD = (decimal.Parse(tsvh.IMPCD) * a.Nhan / a.Chia) + ""; vh.EXPTD = (decimal.Parse(tsvh.IMPTD) * a.Nhan / a.Chia) + ""; vh.EXPORTKWH = (decimal.Parse(tsvh.IMPORTKWH) * a.Nhan / a.Chia) + ""; vh.IMPBT = (decimal.Parse(tsvh.EXPBT) * a.Nhan / a.Chia) + ""; vh.IMPCD = (decimal.Parse(tsvh.EXPCD) * a.Nhan / a.Chia) + ""; vh.IMPORTKWH = (decimal.Parse(tsvh.EXPORTKWH) * a.Nhan / a.Chia) + ""; vh.IMPTD = (decimal.Parse(tsvh.EXPTD) * a.Nhan / a.Chia) + ""; vh.C2 = (decimal.Parse(tsvh.C1) * a.Nhan / a.Chia) + ""; } else { if ((bool)a.IsChieuGiao) { vh.IMPBT = (decimal.Parse(tsvh.EXPBT) * a.Nhan / a.Chia) + ""; vh.IMPCD = (decimal.Parse(tsvh.EXPCD) * a.Nhan / a.Chia) + ""; vh.IMPORTKWH = (decimal.Parse(tsvh.EXPORTKWH) * a.Nhan / a.Chia) + ""; vh.IMPTD = (decimal.Parse(tsvh.EXPTD) * a.Nhan / a.Chia) + ""; vh.C2 = (decimal.Parse(tsvh.C1) * a.Nhan / a.Chia) + ""; vh.EXPBT = "0"; vh.EXPCD = "0"; vh.EXPTD = "0"; vh.EXPORTKWH = "0"; vh.C1 = "0"; } if ((bool)a.IsChieuNhan) { vh.IMPBT = "0"; vh.IMPCD = "0"; vh.IMPTD = "0"; vh.IMPORTKWH = "0"; vh.C2 = "0"; vh.C1 = (decimal.Parse(tsvh.C2) * a.Nhan / a.Chia) + ""; vh.EXPBT = (decimal.Parse(tsvh.IMPBT) * a.Nhan / a.Chia) + ""; vh.EXPCD = (decimal.Parse(tsvh.IMPCD) * a.Nhan / a.Chia) + ""; vh.EXPTD = (decimal.Parse(tsvh.IMPTD) * a.Nhan / a.Chia) + ""; vh.EXPORTKWH = (decimal.Parse(tsvh.IMPORTKWH) * a.Nhan / a.Chia) + ""; } } } else { if (!(bool)a.IsChieuGiao && !(bool)a.IsChieuNhan) { vh.C1 = (decimal.Parse(tsvh.C1) * a.Nhan / a.Chia) + ""; vh.EXPBT = (decimal.Parse(tsvh.EXPBT) * a.Nhan / a.Chia) + ""; vh.EXPCD = (decimal.Parse(tsvh.EXPCD) * a.Nhan / a.Chia) + ""; vh.EXPTD = (decimal.Parse(tsvh.EXPTD) * a.Nhan / a.Chia) + ""; vh.EXPORTKWH = (decimal.Parse(tsvh.EXPORTKWH) * a.Nhan / a.Chia) + ""; vh.IMPBT = (decimal.Parse(tsvh.IMPBT) * a.Nhan / a.Chia) + ""; vh.IMPCD = (decimal.Parse(tsvh.IMPCD) * a.Nhan / a.Chia) + ""; vh.IMPORTKWH = (decimal.Parse(tsvh.IMPORTKWH) * a.Nhan / a.Chia) + ""; vh.IMPTD = (decimal.Parse(tsvh.IMPTD) * a.Nhan / a.Chia) + ""; vh.C2 = (decimal.Parse(tsvh.C2) * a.Nhan / a.Chia) + ""; } else { if ((bool)a.IsChieuGiao) { vh.IMPBT = (decimal.Parse(tsvh.IMPBT) * a.Nhan / a.Chia) + ""; vh.IMPCD = (decimal.Parse(tsvh.IMPCD) * a.Nhan / a.Chia) + ""; vh.IMPORTKWH = (decimal.Parse(tsvh.IMPORTKWH) * a.Nhan / a.Chia) + ""; vh.IMPTD = (decimal.Parse(tsvh.IMPTD) * a.Nhan / a.Chia) + ""; vh.C2 = (decimal.Parse(tsvh.C2) * a.Nhan / a.Chia) + ""; vh.EXPBT = "0"; vh.EXPCD = "0"; vh.EXPTD = "0"; vh.EXPORTKWH = "0"; vh.C1 = "0"; } if ((bool)a.IsChieuNhan) { vh.IMPBT = "0"; vh.IMPCD = "0"; vh.IMPTD = "0"; vh.IMPORTKWH = "0"; vh.C2 = "0"; vh.C1 = (decimal.Parse(tsvh.C1) * a.Nhan / a.Chia) + ""; vh.EXPBT = (decimal.Parse(tsvh.EXPBT) * a.Nhan / a.Chia) + ""; vh.EXPCD = (decimal.Parse(tsvh.EXPCD) * a.Nhan / a.Chia) + ""; vh.EXPTD = (decimal.Parse(tsvh.EXPTD) * a.Nhan / a.Chia) + ""; vh.EXPORTKWH = (decimal.Parse(tsvh.EXPORTKWH) * a.Nhan / a.Chia) + ""; } } } vh.MA_DIEMDO = tsvh.MA_DIEMDO; dongbosoLieu(vh, a.MaDiemDo); } }
private void DongBoDuLieuKhoEVN(CBDN.HD_DiemDoLienKet a) { if (DateTime.Now.Hour < 13) { DongBoNPC(a); } else { CBDN.ser_MDMS.Service_MDMS_EVNSoapClient ser = new CBDN.ser_MDMS.Service_MDMS_EVNSoapClient(); //DataSet ds = ser.GET_READ_IX("G2A001S000M371", "31/03/2020", "01/04/2020", "MDMS_PA", "MDMS_PA"); DataSet ds = ser.GET_READ_IX_OPT(a.DDo, "2", "AM", "PA", "01/" + DateTime.Now.Month + "/" + DateTime.Now.Year, "01/" + DateTime.Now.Month + "/" + DateTime.Now.Year, "MDMS_PA", "MDMS_PA"); if (ds.Tables[0].Rows.Count > 0) { TSVH ts = new TSVH(); if ((bool)a.IsDaoChieu) { if (!(bool)a.IsChieuGiao && !(bool)a.IsChieuNhan) { ts.EXPBT = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_BTG"] + "") / 1000 * a.Nhan / a.Chia).ToString(); ts.EXPCD = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_CDG"] + "") / 1000 * a.Nhan / a.Chia).ToString(); ts.EXPTD = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_TDG"] + "") / 1000 * a.Nhan / a.Chia).ToString(); ts.EXPORTKWH = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_SGG"] + "") / 1000 * a.Nhan / a.Chia).ToString(); ts.C2 = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_VCG"]) / 1000 * a.Nhan / a.Chia).ToString(); ts.IMPBT = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_BTN"] + "") / 1000 * a.Nhan / a.Chia).ToString(); ts.IMPCD = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_CDN"] + "") / 1000 * a.Nhan / a.Chia).ToString(); ts.IMPTD = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_TDN"] + "") / 1000 * a.Nhan / a.Chia).ToString(); ts.IMPORTKWH = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_SGN"] + "") / 1000 * a.Nhan / a.Chia).ToString(); ts.C1 = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_VCN"]) / 1000 * a.Nhan / a.Chia).ToString(); } else { if ((bool)a.IsChieuGiao) { ts.IMPBT = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_BTN"] + "") / 1000 * a.Nhan / a.Chia).ToString(); ts.IMPCD = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_CDN"] + "") / 1000 * a.Nhan / a.Chia).ToString(); ts.IMPTD = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_TDN"] + "") / 1000 * a.Nhan / a.Chia).ToString(); ts.IMPORTKWH = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_SGN"] + "") / 1000 * a.Nhan / a.Chia).ToString(); ts.C1 = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_VCN"]) / 1000 * a.Nhan / a.Chia).ToString(); ts.EXPBT = "0"; ts.EXPCD = "0"; ts.EXPTD = "0"; ts.EXPORTKWH = "0"; ts.C2 = "0"; } if ((bool)a.IsChieuNhan) { ts.IMPBT = "0"; ts.IMPCD = "0"; ts.IMPTD = "0"; ts.IMPORTKWH = "0"; ts.C1 = "0"; ts.EXPBT = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_BTG"] + "") / 1000 * a.Nhan / a.Chia).ToString(); ts.EXPCD = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_CDG"] + "") / 1000 * a.Nhan / a.Chia).ToString(); ts.EXPTD = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_TDG"] + "") / 1000 * a.Nhan / a.Chia).ToString(); ts.EXPORTKWH = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_SGG"] + "") / 1000 * a.Nhan / a.Chia).ToString(); ts.C2 = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_VCG"]) / 1000 * a.Nhan / a.Chia).ToString(); } } } else { if (!(bool)a.IsChieuGiao && !(bool)a.IsChieuNhan) { ts.IMPBT = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_BTG"] + "") / 1000 * a.Nhan / a.Chia).ToString(); ts.IMPCD = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_CDG"] + "") / 1000 * a.Nhan / a.Chia).ToString(); ts.IMPTD = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_TDG"] + "") / 1000 * a.Nhan / a.Chia).ToString(); ts.IMPORTKWH = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_SGG"] + "") / 1000 * a.Nhan / a.Chia).ToString(); ts.C1 = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_VCG"]) / 1000 * a.Nhan / a.Chia).ToString(); ts.EXPBT = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_BTN"] + "") / 1000 * a.Nhan / a.Chia).ToString(); ts.EXPCD = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_CDN"] + "") / 1000 * a.Nhan / a.Chia).ToString(); ts.EXPTD = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_TDN"] + "") / 1000 * a.Nhan / a.Chia).ToString(); ts.EXPORTKWH = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_SGN"] + "") / 1000 * a.Nhan / a.Chia).ToString(); ts.C2 = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_VCN"]) / 1000 * a.Nhan / a.Chia).ToString(); } else { if ((bool)a.IsChieuGiao) { ts.IMPBT = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_BTG"] + "") / 1000 * a.Nhan / a.Chia).ToString(); ts.IMPCD = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_CDG"] + "") / 1000 * a.Nhan / a.Chia).ToString(); ts.IMPTD = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_TDG"] + "") / 1000 * a.Nhan / a.Chia).ToString(); // ts.IMPORTKWH = ((decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_BTG"] + "") + decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_CDG"] + "") + decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_TDG"] + "")) / 1000).ToString(); ts.C1 = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_VCG"]) / 1000 * a.Nhan / a.Chia).ToString(); ts.IMPORTKWH = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_SGG"] + "") / 1000 * a.Nhan / a.Chia).ToString(); ts.EXPBT = "0"; ts.EXPCD = "0"; ts.EXPTD = "0"; ts.EXPORTKWH = "0"; ts.C2 = "0"; } if ((bool)a.IsChieuNhan) { ts.IMPBT = "0"; ts.IMPCD = "0"; ts.IMPTD = "0"; ts.IMPORTKWH = "0"; ts.C1 = "0"; ts.EXPBT = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_BTN"] + "") / 1000 * a.Nhan / a.Chia).ToString(); ts.EXPCD = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_CDN"] + "") / 1000 * a.Nhan / a.Chia).ToString(); ts.EXPTD = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_TDN"] + "") / 1000 * a.Nhan / a.Chia).ToString(); //ts.EXPORTKWH = ((decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_BTN"] + "") + decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_CDN"] + "") + decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_TDN"] + "")) / 1000).ToString(); ts.EXPORTKWH = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_SGN"] + "") / 1000 * a.Nhan / a.Chia).ToString(); ts.C2 = (decimal.Parse("0" + ds.Tables[0].Rows[0]["VAL_VCN"]) / 1000 * a.Nhan / a.Chia).ToString(); } } } ts.MA_DIEMDO = a.DDo; dongbosoLieu(ts, a.MaDiemDo); } else { DongBoNPC(a); } } }