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