protected void btnLuu_Click(object sender, EventArgs e)
{
MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"];
int ma_dviqly = int.Parse(session.User.ma_dviqly + "");
var congto = db.DM_CongTos.SingleOrDefault(x => x.IDCongTo == int.Parse(lbIDCongTO.Text));
//CBDN.DM_CongToSelectByIDDViResult HoatDong = (CBDN.DM_CongToSelectByIDDViResult)grdDVT.GetRow(grdDVT.FocusedRowIndex);
CBDN.HD_GiaoNhanThang giaonhan = new CBDN.HD_GiaoNhanThang();
giaonhan.IDCongTo = congto.MaCongTo;
giaonhan.IDChiNhanh = congto.IDChiNhanh;
giaonhan.IDMaDViQly = ma_dviqly;
giaonhan.IDUser = session.User.IDUSER;
giaonhan.IDTram = congto.IDTram;
giaonhan.Nam = int.Parse("0" + cmbNam.Value);
giaonhan.Thang = int.Parse("0" + cmbThang.Value);
giaonhan.Nhan_P_Dau = decimal.Parse(txtNPD.Text);
giaonhan.Giao_P_Dau = decimal.Parse(txtGPDau.Text);
giaonhan.Giao_P_SanLuong = 0;
giaonhan.Nhan_P_SanLuong = 0;
giaonhan.Nhan_Q_Dau = decimal.Parse(txtNQD.Text);
giaonhan.Giao_Q_Dau = decimal.Parse(txtGQDau.Text);
giaonhan.Giao_Q_SanLuong = 0;
giaonhan.Nhan_Q_SanLuong = 0;
giaonhan.CosGiao = 0;
giaonhan.CosNhan = 0;
giaonhan.Giao_Bieu1_Dau = decimal.Parse(txtB1D.Text);
giaonhan.Nhan_Bieu1_Dau = decimal.Parse(txtNB1D.Text);
giaonhan.Giao_Bieu1_SanLuong = 0;
giaonhan.Nhan_Bieu1_SanLuong = 0;
giaonhan.Giao_Bieu2_Dau = decimal.Parse(txtGB2D.Text);
giaonhan.Nhan_Bieu2_Dau = decimal.Parse(txtNB2D.Text);
giaonhan.Giao_Bieu2_SanLuong = 0;
giaonhan.Nhan_Bieu2_SanLuong = 0;
giaonhan.Giao_Bieu3_Dau = decimal.Parse(txtB3D.Text);
giaonhan.Nhan_Bieu3_Dau = decimal.Parse(txtNB3D.Text);
giaonhan.Giao_Bieu3_SanLuong = 0;
giaonhan.Nhan_Bieu3_SanLuong = 0;
giaonhan.ISChot = false;
giaonhan.LoaiNhap = 0;
giaonhan.NgayNhap = DateTime.Now;
db.HD_GiaoNhanThangs.InsertOnSubmit(giaonhan);
db.SubmitChanges();
rpKenhGiao.Visible = false;
rpNhan.Visible = false;
rpThongTin.Visible = false;
ThoiGianChon.Visible = false;
}
private void dongbosoLieu(TSVH vh, string maDiemDo)
{
try
{
MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"];
int ma_dviqly = int.Parse(session.User.ma_dviqly + "");
//var cto = db.DM_CongTos.SingleOrDefault(x => x.IDCongTo == int.Parse(tlDonVi.FocusedNode.Key));
//CBDN.HD_GiaoNhanThang chitiet = db.HD_GiaoNhanThangs.SingleOrDefault(x => x.ID == int.Parse(tlDonVi.FocusedNode.Key));
var lstHD = db.LayThongTinGiaoNhanQuaMaDD(maDiemDo, int.Parse(cmbThang.Value + ""), int.Parse(cmbNam.Value + ""));
foreach (var hd in lstHD)
{
CBDN.HD_GiaoNhanThang chitiet = db.HD_GiaoNhanThangs.SingleOrDefault(x => x.ID == hd.ID && x.ISNhanVien != true);
if (chitiet == null)
{
continue;
}
var congto = db.DM_CongTos.SingleOrDefault(x => x.IDCongTo == int.Parse(chitiet.IDCongTo));
if (chitiet != null)
{
chitiet.Giao_Bieu1_Cuoi = decimal.Parse("" + vh.IMPBT);
chitiet.Nhan_Bieu1_Cuoi = decimal.Parse("" + vh.EXPBT);
if (decimal.Parse("" + vh.IMPBT) < chitiet.Giao_Bieu1_Dau)
{
chitiet.Giao_Bieu1_SanLuong = (soLon(chitiet.Giao_Bieu1_Dau + "") - chitiet.Giao_Bieu1_Dau + decimal.Parse("" + vh.IMPBT)) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
else
{
chitiet.Giao_Bieu1_SanLuong = (decimal.Parse("" + vh.IMPBT) - chitiet.Giao_Bieu1_Dau) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
if (decimal.Parse("" + vh.EXPBT) < chitiet.Nhan_Bieu1_Dau)
{
chitiet.Nhan_Bieu1_SanLuong = (soLon(chitiet.Nhan_Bieu1_Dau + "") - chitiet.Nhan_Bieu1_Dau + decimal.Parse("" + vh.EXPBT)) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
else
{
chitiet.Nhan_Bieu1_SanLuong = (decimal.Parse("" + vh.EXPBT) - chitiet.Nhan_Bieu1_Dau) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
chitiet.Giao_Bieu2_Cuoi = decimal.Parse("" + vh.IMPCD);
chitiet.Nhan_Bieu2_Cuoi = decimal.Parse("" + vh.EXPCD);
if (decimal.Parse("" + vh.IMPCD) < chitiet.Giao_Bieu2_Dau)
{
chitiet.Giao_Bieu2_SanLuong = (soLon(chitiet.Giao_Bieu2_Dau + "") - chitiet.Giao_Bieu2_Dau + decimal.Parse("" + vh.IMPCD)) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
else
{
chitiet.Giao_Bieu2_SanLuong = (decimal.Parse("" + vh.IMPCD) - chitiet.Giao_Bieu2_Dau) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
if (decimal.Parse("" + vh.EXPCD) < chitiet.Nhan_Bieu2_Dau)
{
chitiet.Nhan_Bieu2_SanLuong = (soLon(chitiet.Nhan_Bieu2_Dau + "") - chitiet.Nhan_Bieu2_Dau + decimal.Parse("" + vh.EXPCD)) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
else
{
chitiet.Nhan_Bieu2_SanLuong = (decimal.Parse("" + vh.EXPCD) - chitiet.Nhan_Bieu2_Dau) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
chitiet.Giao_Bieu3_Cuoi = decimal.Parse("" + vh.IMPTD);
chitiet.Nhan_Bieu3_Cuoi = decimal.Parse("" + vh.EXPTD);
if (decimal.Parse("" + vh.IMPTD) < chitiet.Giao_Bieu3_Dau)
{
chitiet.Giao_Bieu3_SanLuong = (soLon(chitiet.Giao_Bieu3_Dau + "") - chitiet.Giao_Bieu3_Dau + decimal.Parse("" + vh.IMPTD)) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
else
{
chitiet.Giao_Bieu3_SanLuong = (decimal.Parse("" + vh.IMPTD) - chitiet.Giao_Bieu3_Dau) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
if (decimal.Parse("" + vh.EXPTD) < chitiet.Nhan_Bieu3_Dau)
{
chitiet.Nhan_Bieu3_SanLuong = (soLon(chitiet.Nhan_Bieu3_Dau + "") - chitiet.Nhan_Bieu3_Dau + decimal.Parse("" + vh.EXPTD)) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
else
{
chitiet.Nhan_Bieu3_SanLuong = (decimal.Parse("" + vh.EXPTD) - chitiet.Nhan_Bieu3_Dau) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
//chitiet.DonViTinh = int.Parse(cmbDonVi.Value + "");
chitiet.Nhan_P_Cuoi = Math.Round(decimal.Parse(vh.EXPORTKWH), 3);
chitiet.Giao_P_Cuoi = decimal.Parse(vh.IMPORTKWH);
chitiet.Giao_P_SanLuong = chitiet.Giao_Bieu1_SanLuong + chitiet.Giao_Bieu2_SanLuong + chitiet.Giao_Bieu3_SanLuong;
chitiet.Nhan_P_SanLuong = chitiet.Nhan_Bieu1_SanLuong + chitiet.Nhan_Bieu2_SanLuong + chitiet.Nhan_Bieu3_SanLuong;
//if (chitiet.Giao_P_Dau > decimal.Parse(vh.IMPORTKWH))
//{
// //trường hợp quay đầu
// chitiet.Giao_P_SanLuong = (soLon(chitiet.Giao_P_Dau + "") - chitiet.Giao_P_Dau + decimal.Parse("" + vh.IMPORTKWH)) * (decimal)congto.HeSoNhan * (decimal)congto.HeSoQuyDoi;
//}
//else
// chitiet.Giao_P_SanLuong = (decimal.Parse("" + vh.IMPORTKWH) - chitiet.Giao_P_Dau) * (decimal)congto.HeSoNhan * (decimal)congto.HeSoQuyDoi;
//if (decimal.Parse(vh.EXPORTKWH) < chitiet.Nhan_P_Cuoi)
// chitiet.Nhan_P_SanLuong = (soLon(chitiet.Nhan_P_Cuoi + "") - chitiet.Nhan_P_Cuoi + decimal.Parse(vh.EXPORTKWH)) * congto.HeSoNhan * congto.HeSoQuyDoi;
//else
// chitiet.Nhan_P_SanLuong = (decimal.Parse(vh.EXPORTKWH) - chitiet.Nhan_P_Cuoi) * congto.HeSoNhan * congto.HeSoQuyDoi;
chitiet.Nhan_Q_Cuoi = decimal.Parse("" + vh.C2);
chitiet.Giao_Q_Cuoi = decimal.Parse("" + vh.C1);
if (decimal.Parse("" + vh.C1) < chitiet.Giao_Q_Dau)
{
chitiet.Giao_Q_SanLuong = (soLon(chitiet.Giao_Q_Dau + "") - chitiet.Giao_Q_Dau + decimal.Parse("" + vh.C1)) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
else
{
chitiet.Giao_Q_SanLuong = (decimal.Parse("" + vh.C1) - chitiet.Giao_Q_Dau) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
if (decimal.Parse("" + vh.C2) < chitiet.Nhan_Q_Dau)
{
chitiet.Nhan_Q_SanLuong = (soLon(chitiet.Nhan_Q_Dau + "") - chitiet.Nhan_Q_Dau + decimal.Parse("" + vh.C2)) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
else
{
chitiet.Nhan_Q_SanLuong = (decimal.Parse("" + vh.C2) - chitiet.Nhan_Q_Dau) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
if (chitiet.Giao_P_SanLuong != null && chitiet.Giao_P_SanLuong != 0)
{
double a = (double)chitiet.Giao_Q_SanLuong;
double b = (double)chitiet.Giao_P_SanLuong;
chitiet.CosGiao = decimal.Parse("0" + Math.Round(Math.Cos(Math.Atan(a / b)), 3));
}
else
{
chitiet.CosGiao = 0;
}
if (chitiet.Nhan_P_SanLuong != 0 && chitiet.Nhan_P_SanLuong != null)
{
double nhana = (double)chitiet.Nhan_Q_SanLuong;
double nhanb = (double)chitiet.Nhan_P_SanLuong;
chitiet.CosNhan = decimal.Parse("" + Math.Round(Math.Cos(Math.Atan(nhana / nhanb)), 3));
}
else
{
chitiet.CosNhan = 0;
}
chitiet.ISDoDem = 0;
chitiet.ISChot = true;
chitiet.XacNhanDVGiao = false;
chitiet.XacNhanDVNhan = false;
chitiet.ISNhanVien = false;
if (chitiet.GhiChuXacNhanGiao != "" && !(bool)chitiet.XacNhanDVGiao)
{
chitiet.GhiChuXacNhanGiao = "Đã hiệu chỉnh số liệu";
}
if (chitiet.GhiChuXacNhanNhan != "" && !(bool)chitiet.XacNhanDVNhan)
{
chitiet.GhiChuXacNhanNhan = "Đã hiệu chỉnh số liệu";
}
chitiet.ToolDB = true;
chitiet.LoaiNhap = 0;
db.SubmitChanges();
}
}
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Cập nhật số liệu thành công');", true);
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('" + ex.Message + "');", true);
}
}
private void insertdulieu()
{
SystemManageService.DM_DVQLYService dvi = new SystemManageService.DM_DVQLYService();
DataTable dt = new DataTable();
dt = dbOR.SelectAllDDo_TT("RG");
if (dt == null)
{
return;
}
for (int i = 0; i < dt.Rows.Count; i++)
{
var donvi = dvi.SelectAllDM_DVQLY().SingleOrDefault(x => x.MA_DVIQLY == dt.Rows[i]["MA_DVIQLY"] + "");
var donviG = dvi.SelectAllDM_DVQLY().SingleOrDefault(x => x.MA_DVIQLY == dt.Rows[i]["DVIGIAO"] + "");
if (!CheckName(dt.Rows[i]["MA_DVI"] + "", 0, donvi.MA_DVIQLY))
{
continue;
}
if (!CheckName(dt.Rows[i]["MA_DVIB"] + "", 0, donvi.MA_DVIQLY))
{
continue;
}
CBDN.DM_ChiNhanh cv = new CBDN.DM_ChiNhanh();
cv.TenChiNhanh = dt.Rows[i]["MOTA"] + "";
cv.MaChiNhanh = dt.Rows[i]["MA_DVI"] + "";
if (dt.Rows[i]["CHIEU_GNHAN"] + "" == "G")
{
cv.IDMADVIQLY = "," + donvi.IDMA_DVIQLY + "," + donviG.IDMA_DVIQLY + ",";
}
else
{
cv.IDMADVIQLY = "," + donviG.IDMA_DVIQLY + "," + donvi.IDMA_DVIQLY + ",";
}
if (donvi.MA_DVIQLY == "PA" || donviG.MA_DVIQLY == "PA")
{
cv.LoaiPhuongThuc = 1;
}
else if (donvi.MA_DVIQLY.Length == 4 && donviG.MA_DVIQLY.Length == 4)
{
cv.LoaiPhuongThuc = 2;
}
else if (donvi.MA_DVIQLY.Length + donviG.MA_DVIQLY.Length < 12 && donvi.MA_DVIQLY.Length + donviG.MA_DVIQLY.Length > 9)
{
cv.LoaiPhuongThuc = 3;
}
else
{
cv.LoaiPhuongThuc = 4;
}
cv.MoTa = dt.Rows[i]["MOTA"] + "";
if (dt.Rows[i]["CHIEU_GNHAN"] + "" == "G")
{
cv.DiemDauNguon = donvi.IDMA_DVIQLY;
cv.DiemCuoiNguon = donviG.IDMA_DVIQLY;
}
else
{
cv.DiemCuoiNguon = donvi.IDMA_DVIQLY;
cv.DiemDauNguon = donviG.IDMA_DVIQLY;
}
cv.HoatDong = 1;
cv.HoatDong = 0;
db.DM_ChiNhanhs.InsertOnSubmit(cv);
db.SubmitChanges();
}
// insert tram
for (int i = 0; i < dt.Rows.Count; i++)
{
var donvi = dvi.SelectAllDM_DVQLY().SingleOrDefault(x => x.MA_DVIQLY == dt.Rows[i]["MA_DVIQLY"] + "");
var donviG = dvi.SelectAllDM_DVQLY().SingleOrDefault(x => x.MA_DVIQLY == dt.Rows[i]["DVIGIAO"] + "");
var cn = db.DM_ChiNhanhs.SingleOrDefault(x => x.MaChiNhanh == dt.Rows[i]["MA_DVI"] + "");
if (!CheckNameTramLo(dt.Rows[i]["MA_PTDIEN"] + "", 0, cn.ID + ""))
{
continue;
}
//var cn = db.DM_ChiNhanhs.SingleOrDefault(x => x.ID == int.Parse(cmbDuongDay.Value + "") && x.IDMADVIQLY.Contains(session.User.ma_dviqly));
//var lstDD = db.DM_ChiNhanhs.Where(x => x.MaChiNhanh == cn.MaChiNhanh);
//foreach (var dd in lstDD)
//{
CBDN.DM_Tram cv = new CBDN.DM_Tram();
cv.MaTram = dt.Rows[i]["MA_PTDIEN"] + "";
cv.IDMaDviQly = cn.IDMADVIQLY;
cv.TenTram = dt.Rows[i]["MA_PTDIEN"] + "";
cv.MoTa = "";
cv.TinhChatDD = 0;
cv.DiaDiem = "";
cv.IDDuongDay = cn.ID;
cv.IDChiNhanh = cn.ID + "";
cv.HoatDong = 1;
cv.ParentId = 0;
cv.IsLo = 0;
cv.MaDVNhap = donviG.IDMA_DVIQLY;
db.DM_Trams.InsertOnSubmit(cv);
db.SubmitChanges();
}
// insert ma diem do
for (int i = 0; i < dt.Rows.Count; i++)
{
var donviG = dvi.SelectAllDM_DVQLY().SingleOrDefault(x => x.MA_DVIQLY == dt.Rows[i]["DVIGIAO"] + "");
var cn = db.DM_ChiNhanhs.SingleOrDefault(x => x.MaChiNhanh == dt.Rows[i]["MA_DVI"] + "");
var tr = db.DM_Trams.SingleOrDefault(x => x.MaTram == dt.Rows[i]["MA_PTDIEN"] + "" && x.IDMaDviQly.Contains(cn.IDMADVIQLY));
if (!CheckNameDiemDo(dt.Rows[i]["MA_DDO"] + "", "0", tr.IDMaDviQly + ""))
{
continue;
}
//var tr = db.DM_Trams.SingleOrDefault(x => x.IDTram == int.Parse(tlDonVi.FocusedNode.Key + "") && x.IDMaDviQly.Contains("," + session.User.ma_dviqly + ","));
CBDN.DM_DiemDo cv = new CBDN.DM_DiemDo();
cv.MaDiemDo = dt.Rows[i]["MA_DDO"] + "";
cv.IDMaDViQly = tr.IDMaDviQly;
cv.TenDiemDo = dt.Rows[i]["MA_DDO"] + "";
cv.MoTa = "";
cv.IDChiNhanh = tr.IDChiNhanh;
cv.IDTram = tr.IDTram + "";
cv.TinhChatDD = 0;
cv.ISLoaiDD = 0;
cv.HoatDong = 1;
cv.MaDviNhap = donviG.IDMA_DVIQLY;
db.DM_DiemDos.InsertOnSubmit(cv);
db.SubmitChanges();
//}
}
DataTable dtCongTo = new DataTable();
for (int i = 0; i < dt.Rows.Count; i++)
{
var donvi = dvi.SelectAllDM_DVQLY().SingleOrDefault(x => x.MA_DVIQLY == dt.Rows[i]["MA_DVIQLY"] + "");
var donviG = dvi.SelectAllDM_DVQLY().SingleOrDefault(x => x.MA_DVIQLY == dt.Rows[i]["DVIGIAO"] + "");
dtCongTo = dbOR.SelectAllCongTo(dt.Rows[i]["MA_DDO"] + "");
if (dtCongTo.Rows.Count > 0)
{
var listddo = db.DM_DiemDos.Where(x => x.MaDiemDo == dt.Rows[i]["MA_DDO"] + "");
foreach (var ddo in listddo)
{// List<Entity.DM_DVQLY> lst = new List<DM_DVQLY>();
//var ddo = db.DM_DiemDos.SingleOrDefault(x => x.IDDiemDo == int.Parse(cmbDiemDo.Value + "") && x.IDMaDViQly.Contains(session.User.ma_dviqly));
if (!CheckNameCongTo(dtCongTo.Rows[0]["MA_TBI"] + "", 0, ddo.IDTram, ddo.IDChiNhanh))
{
continue;
}
//foreach (var ddo in lst)
//{
CBDN.DM_CongTo cv = new CBDN.DM_CongTo();
cv.MaCongTo = dtCongTo.Rows[0]["MA_TBI"] + "";
cv.TenCongTo = dtCongTo.Rows[0]["SO_TBI"] + "";
cv.MoTa = "";
cv.IDDiemDo = ddo.IDDiemDo + "";
cv.IDDonViQuanLy = ddo.IDMaDViQly;
cv.TinhTrang = 1;
cv.CapDienAp = dtCongTo.Rows[0]["CAPDA"] + "";
cv.ChungLoai = "";
cv.HangSanXuat = "";
cv.HeSoNhan = decimal.Parse(dtCongTo.Rows[0]["HSN"] + "");
cv.NgayTreoThao = DateTime.Now;
cv.TU_TI = "";
cv.IDTram = ddo.IDTram;
cv.IDChiNhanh = ddo.IDChiNhanh;
if (dt.Rows[i]["CHIEU_GNHAN"] + "" == "G")
{
cv.IDDonViGiao = donvi.IDMA_DVIQLY;
cv.KenhGiaoCongTo = "G";
cv.GiaoTinhChat = 0;
cv.IDDonViNhan = donviG.IDMA_DVIQLY;
cv.KenhNhanCongTo = "N";
cv.NhanTinhChat = 0;
}
else
{
cv.IDDonViGiao = donviG.IDMA_DVIQLY;
cv.KenhGiaoCongTo = "G";
cv.GiaoTinhChat = 0;
cv.IDDonViNhan = donvi.IDMA_DVIQLY;
cv.KenhNhanCongTo = "N";
cv.NhanTinhChat = 0;
}
cv.IDUser = 1;
cv.NgayTao = DateTime.Now;
cv.NgayKiemDinh = DateTime.Now;
cv.HeSoQuyDoi = 1;
cv.IDDVNhapDL = donviG.IDMA_DVIQLY;
cv.IDDVXacNhan = donvi.IDMA_DVIQLY;
cv.IsCToMotGia = false;
db.DM_CongTos.InsertOnSubmit(cv);
db.SubmitChanges();
//}
var congto = db.DM_CongTos.SingleOrDefault(x => x.IDCongTo == cv.IDCongTo);
//CBDN.DM_CongToSelectByIDDViResult HoatDong = (CBDN.DM_CongToSelectByIDDViResult)grdDVT.GetRow(grdDVT.FocusedRowIndex);
CBDN.HD_GiaoNhanThang giaonhan = new CBDN.HD_GiaoNhanThang();
giaonhan.IDCongTo = congto.IDCongTo + "";
giaonhan.IDChiNhanh = congto.IDChiNhanh;
giaonhan.IDDuongDay = congto.IDChiNhanh;
giaonhan.IDMaDViQly = donviG.IDMA_DVIQLY;
giaonhan.IDUser = 1;
giaonhan.IDTram = congto.IDTram;
if (DateTime.Now.Month == 1)
{
giaonhan.Thang = 12;
giaonhan.Nam = DateTime.Now.Year - 1;
}
else
{
giaonhan.Thang = DateTime.Now.Month - 1;
giaonhan.Nam = DateTime.Now.Year;
}
giaonhan.Nhan_P_Dau = 0;
giaonhan.Giao_P_Dau = 0;
giaonhan.Giao_P_SanLuong = 0;
giaonhan.Nhan_P_SanLuong = 0;
giaonhan.Nhan_Q_Dau = 0;
giaonhan.Giao_Q_Dau = 0;
giaonhan.Giao_Q_SanLuong = 0;
giaonhan.Nhan_Q_SanLuong = 0;
giaonhan.CosGiao = 0;
giaonhan.CosNhan = 0;
giaonhan.Giao_Bieu1_Dau = 0;
giaonhan.Nhan_Bieu1_Dau = 0;
giaonhan.Giao_Bieu1_SanLuong = 0;
giaonhan.Nhan_Bieu1_SanLuong = 0;
giaonhan.Giao_Bieu2_Dau = 0;
giaonhan.Nhan_Bieu2_Dau = 0;
giaonhan.Giao_Bieu2_SanLuong = 0;
giaonhan.Nhan_Bieu2_SanLuong = 0;
giaonhan.Giao_Bieu3_Dau = 0;
giaonhan.Nhan_Bieu3_Dau = 0;
giaonhan.Giao_Bieu3_SanLuong = 0;
giaonhan.Nhan_Bieu3_SanLuong = 0;
giaonhan.ISDoDem = 0;
giaonhan.ISChot = false;
giaonhan.LoaiNhap = 0;
giaonhan.NgayNhap = DateTime.Now;
db.HD_GiaoNhanThangs.InsertOnSubmit(giaonhan);
db.SubmitChanges();
}
}
}
}
protected void btnCapNhat_Click(object sender, EventArgs e)
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
int idChiNhanh = 0; int idtram = 0;
if (cmbDiemDo.Value + "" != "")
{
var diemdo = db.DM_DiemDos.SingleOrDefault(x => x.IDDiemDo == int.Parse("0" + cmbDiemDo.Value));
idChiNhanh = int.Parse("0" + diemdo.IDChiNhanh);
idtram = diemdo.IDTram;
}
decimal cda = 0;
if (txtCapDienAp.Text != "")
{
if (!decimal.TryParse(txtCapDienAp.Text, out cda))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Cấp điện áp là kiểu só');", true);
txtCapDienAp.Focus();
return;
}
cda = decimal.Parse(txtCapDienAp.Text);
}
decimal hsn = 0, hsQD = 0;
if (txtHeSoNhan.Text != "")
{
if (!decimal.TryParse(txtHeSoNhan.Text, out cda))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Hệ số nhân là kiểu số');", true);
txtHeSoNhan.Focus();
return;
}
hsn = decimal.Parse(txtHeSoNhan.Text);
}
if (txtHsNhanQD.Text != "")
{
if (!decimal.TryParse(txtHsNhanQD.Text, out cda))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Hệ số nhân quy đổi là kiểu số');", true);
txtHsNhanQD.Focus();
return;
}
hsQD = decimal.Parse(txtHsNhanQD.Text);
}
if (Session["Add"] + "" == "0")
{
CBDN.DM_CongToSelectByIDDViResult cv = (CBDN.DM_CongToSelectByIDDViResult)grdDVT.GetRow(grdDVT.FocusedRowIndex);
var lstqtCT = db.DM_CongTos.Where(x => x.MaCongTo == cv.MaCongTo);
foreach (var qtCT in lstqtCT)
{
if (!CheckName(txtMaDuongDat.Text, cv.IDCongTo))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã đường dây không được trùng');", true); return;
}
//CBDN.DM_CongTo qtCT = new CBDN.DM_CongTo();
qtCT.TenCongTo = txtTenDuongDay.Text;
qtCT.MoTa = mmMoTa.Text;
qtCT.IDDiemDo = int.Parse(cmbDiemDo.Value + "");
qtCT.IDChiNhanh = idChiNhanh;
if (CkHoatDong.Checked)
{
qtCT.TinhTrang = 1;
}
else
{
qtCT.TinhTrang = 0;
}
qtCT.CapDienAp = cda;
qtCT.ChungLoai = txtChungLoai.Text;
qtCT.HangSanXuat = txtHangSanXuat.Text;
qtCT.HeSoNhan = hsn;
qtCT.TU_TI = txtTuTi.Text;
qtCT.IDTram = idtram;
qtCT.IDDonViGiao = int.Parse(session.User.ma_dviqly + "");
if (cmbKenhGiao.Value != null)
{
qtCT.KenhGiaoCongTo = "" + cmbKenhGiao.Value;
}
if (cmbTinhChatGiao.Value + "" != "")
{
qtCT.GiaoTinhChat = int.Parse(cmbTinhChatGiao.Value + "");
}
qtCT.HeSoQuyDoi = hsQD;
db.SubmitChanges();
}
}
else
{
if (!CheckName(txtMaDuongDat.Text, 0))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã đường dây không được trùng');", true); return;
}
var diemdo = db.DM_DiemDos.SingleOrDefault(x => x.IDDiemDo == int.Parse(cmbDiemDo.Value + ""));
var lst = db.DM_DiemDos.Where(x => x.MaDiemDo == diemdo.MaDiemDo).ToList();
foreach (var ddo in lst)
{
CBDN.DM_CongTo cv = new CBDN.DM_CongTo();
cv.MaCongTo = txtMaDuongDat.Text;
cv.TenCongTo = txtTenDuongDay.Text;
cv.MoTa = mmMoTa.Text;
cv.IDDiemDo = ddo.IDDiemDo;
cv.IDDonViQuanLy = ddo.IDMaDViQly;
if (CkHoatDong.Checked)
{
cv.TinhTrang = 1;
}
else
{
cv.TinhTrang = 0;
}
cv.CapDienAp = cda;
cv.ChungLoai = txtChungLoai.Text;
cv.HangSanXuat = txtHangSanXuat.Text;
cv.HeSoNhan = hsn;
cv.NgayTreoThao = DateTime.Now;
cv.TU_TI = txtTuTi.Text;
cv.IDTram = ddo.IDTram;
cv.IDChiNhanh = ddo.IDChiNhanh;
cv.IDUser = session.User.IDUSER;
cv.NgayTao = DateTime.Now;
cv.NgayKiemDinh = dtNgayTreo.Date;
cv.HeSoQuyDoi = decimal.Parse("0" + txtHsNhanQD.Text);
cv.HeSoQuyDoi = hsQD;
cv.IDDonViGiao = int.Parse(session.User.ma_dviqly);
if (cmbKenhGiao.Value != null)
{
cv.KenhGiaoCongTo = "" + cmbKenhGiao.Value;
}
if (cmbTinhChatGiao.Value + "" != "")
{
cv.GiaoTinhChat = int.Parse(cmbTinhChatGiao.Value + "");
}
db.DM_CongTos.InsertOnSubmit(cv);
db.SubmitChanges();
pcAddRoles.ShowOnPageLoad = false;
txtGPDau.Focus();
setControlText(cv.IDCongTo);
visibleNhanChiSo();
}
}
var congto = db.DM_CongTos.SingleOrDefault(x => x.IDCongTo == int.Parse(lbIDCongTO.Text));
//CBDN.DM_CongToSelectByIDDViResult HoatDong = (CBDN.DM_CongToSelectByIDDViResult)grdDVT.GetRow(grdDVT.FocusedRowIndex);
CBDN.HD_GiaoNhanThang giaonhan = new CBDN.HD_GiaoNhanThang();
giaonhan.IDCongTo = congto.MaCongTo;
giaonhan.IDChiNhanh = congto.IDChiNhanh;
giaonhan.IDMaDViQly = int.Parse(session.User.ma_dviqly);
giaonhan.IDUser = session.User.IDUSER;
giaonhan.IDTram = congto.IDTram;
giaonhan.Nam = int.Parse("0" + cmbNam.Value);
giaonhan.Thang = int.Parse("0" + cmbThang.Value);
giaonhan.Nhan_P_Dau = decimal.Parse(txtNPD.Text);
giaonhan.Giao_P_Dau = decimal.Parse(txtGPDau.Text);
giaonhan.Giao_P_SanLuong = 0;
giaonhan.Nhan_P_SanLuong = 0;
giaonhan.Nhan_Q_Dau = decimal.Parse(txtNQD.Text);
giaonhan.Giao_Q_Dau = decimal.Parse(txtGQDau.Text);
giaonhan.Giao_Q_SanLuong = 0;
giaonhan.Nhan_Q_SanLuong = 0;
giaonhan.CosGiao = 0;
giaonhan.CosNhan = 0;
giaonhan.Giao_Bieu1_Dau = decimal.Parse(txtB1D.Text);
giaonhan.Nhan_Bieu1_Dau = decimal.Parse(txtNB1D.Text);
giaonhan.Giao_Bieu1_SanLuong = 0;
giaonhan.Nhan_Bieu1_SanLuong = 0;
giaonhan.Giao_Bieu2_Dau = decimal.Parse(txtGB2D.Text);
giaonhan.Nhan_Bieu2_Dau = decimal.Parse(txtNB2D.Text);
giaonhan.Giao_Bieu2_SanLuong = 0;
giaonhan.Nhan_Bieu2_SanLuong = 0;
giaonhan.Giao_Bieu3_Dau = decimal.Parse(txtB3D.Text);
giaonhan.Nhan_Bieu3_Dau = decimal.Parse(txtNB3D.Text);
giaonhan.Giao_Bieu3_SanLuong = 0;
giaonhan.Nhan_Bieu3_SanLuong = 0;
giaonhan.ISChot = false;
giaonhan.LoaiNhap = 0;
giaonhan.NgayNhap = DateTime.Now;
db.HD_GiaoNhanThangs.InsertOnSubmit(giaonhan);
db.SubmitChanges();
pcAddRoles.ShowOnPageLoad = false;
_DataBind();
}
protected void btnCapNhat_Click1(object sender, EventArgs e)
{
MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"];
int ma_dviqly = int.Parse(session.User.ma_dviqly + "");
//var cto = db.DM_CongTos.SingleOrDefault(x => x.IDCongTo == int.Parse(tlDonVi.FocusedNode.Key));
//CBDN.HD_GiaoNhanThang chitiet = db.HD_GiaoNhanThangs.SingleOrDefault(x => x.ID == int.Parse(tlDonVi.FocusedNode.Key));
var chitiet = db.HD_GiaoNhanThangs.SingleOrDefault(x => x.IDCongTo == tlDonVi.FocusedNode.Key && x.Thang == int.Parse(cmbThang.Value + "") && x.Nam == int.Parse(cmbNam.Value + "") && x.ISDoDem == 0);
var congto = db.DM_CongTos.SingleOrDefault(x => x.IDCongTo == int.Parse(chitiet.IDCongTo));
var diemdo = db.DM_DiemDos.SingleOrDefault(x => x.IDDiemDo == int.Parse(congto.IDDiemDo));
var tram = db.DM_Trams.SingleOrDefault(x => x.IDTram == int.Parse(diemdo.IDTram));
decimal G_PCuoi = 0, G_PKQDD = 0;
if (txtGPDau.Text != "")
{
G_PCuoi = decimal.Parse(txtGPDau.Text);
}
if (txtGPKDD.Text != "")
{
G_PKQDD = decimal.Parse(txtGPKDD.Text);
}
decimal G_QCuoi = 0, G_QKQDD = 0;
if (txtGQDau.Text != "")
{
G_QCuoi = decimal.Parse(txtGQDau.Text);
}
if (txtGQKDD.Text != "")
{
G_QKQDD = decimal.Parse(txtGQKDD.Text);
}
decimal G_B1Cuoi = 0, G_B1KQDD = 0;
if (txtB1D.Text != "")
{
G_B1Cuoi = decimal.Parse(txtB1D.Text);
}
if (txtGB1KQDD.Text != "")
{
G_B1KQDD = decimal.Parse(txtGB1KQDD.Text);
}
decimal G_B2Cuoi = 0, G_B2KQDD = 0;
if (txtGB2D.Text != "")
{
G_B2Cuoi = decimal.Parse(txtGB2D.Text);
}
if (txtGB1KQDD.Text != "")
{
G_B2KQDD = decimal.Parse(txtGB2kDD.Text);
}
decimal G_B3Cuoi = 0, G_B3KQDD = 0;
if (txtB3D.Text != "")
{
G_B3Cuoi = decimal.Parse(txtB3D.Text);
}
if (txtGB3KDD.Text != "")
{
G_B3KQDD = decimal.Parse(txtGB3KDD.Text);
}
decimal N_PCuoi = 0, N_PKQDD = 0;
if (txtNP.Text != "")
{
N_PCuoi = decimal.Parse(txtNP.Text);
}
if (txtNPKDD.Text != "")
{
N_PKQDD = decimal.Parse(txtNPKDD.Text);
}
decimal N_QCuoi = 0, N_QKQDD = 0;
if (txtNQ.Text != "")
{
N_QCuoi = decimal.Parse(txtNQ.Text);
}
if (txtNPKDD.Text != "")
{
N_QKQDD = decimal.Parse(txtNQKDD.Text);
}
decimal N_B1Cuoi = 0, N_B1KQDD = 0;
if (txtNB1.Text != "")
{
N_B1Cuoi = decimal.Parse(txtNB1.Text);
}
if (txtNB1KDD.Text != "")
{
N_B1KQDD = decimal.Parse(txtNB1KDD.Text);
}
decimal N_B2Cuoi = 0, N_B2KQDD = 0;
if (txtNB2.Text != "")
{
N_B2Cuoi = decimal.Parse(txtNB2.Text);
}
if (txtNB2KDD.Text != "")
{
N_B2KQDD = decimal.Parse(txtNB2KDD.Text);
}
decimal N_B3Cuoi = 0, N_B3KQDD = 0;
if (txtNB3.Text != "")
{
N_B3Cuoi = decimal.Parse(txtNB3.Text);
}
if (txtB3KDD.Text != "")
{
N_B3KQDD = decimal.Parse(txtB3KDD.Text);
}
if (chitiet != null)
{
if (congto.IsCToMotGia == true)
{
if (txtNhanCongTo1Gia.Text != "")
{
chitiet.Nhan_SL_CongTo1Gia = decimal.Parse(txtNhanCongTo1Gia.Text);
}
else
{
chitiet.Nhan_SL_CongTo1Gia = 0;
}
if (txtGiaoCongTo1Gia.Text != "")
{
chitiet.Giao_SL_CongTo1Gia = decimal.Parse(txtGiaoCongTo1Gia.Text);
}
else
{
chitiet.Giao_SL_CongTo1Gia = 0;
}
}
chitiet.Giao_P_Dau = decimal.Parse("0" + txtG_PDau.Text);
chitiet.Giao_Q_Dau = decimal.Parse("0" + txtG_QDau.Text);
chitiet.Giao_Bieu1_Dau = decimal.Parse("0" + txtG_B1.Text);
chitiet.Giao_Bieu2_Dau = decimal.Parse("0" + txtG_B2.Text);
chitiet.Giao_Bieu3_Dau = decimal.Parse("0" + txtG_B3.Text);
chitiet.Nhan_P_Dau = decimal.Parse("0" + txtNPD.Text);
chitiet.Nhan_Q_Dau = decimal.Parse("0" + txtNQD.Text);
chitiet.Nhan_Bieu1_Dau = decimal.Parse("0" + txtNB1D.Text);
chitiet.Nhan_Bieu2_Dau = decimal.Parse("0" + txtNB2D.Text);
chitiet.Nhan_Bieu3_Dau = decimal.Parse("0" + txtNB3D.Text);
if (chitiet.ISDoDem == 0)
{
chitiet.Nhan_P_Cuoi = Math.Round(N_PCuoi, 3);
chitiet.Giao_P_Cuoi = Math.Round(G_PCuoi, 3); //decimal.Parse("0" + txtGPDau.Text);
if (G_PCuoi < decimal.Parse("0" + txtG_PDau.Text + ""))
{
chitiet.Giao_P_SanLuong = (soLon(txtG_PDau.Text) - decimal.Parse("0" + txtG_PDau.Text + "") + G_PCuoi) * (decimal)congto.HeSoNhan * (decimal)congto.HeSoQuyDoi;
}
else
{
chitiet.Giao_P_SanLuong = (G_PCuoi - decimal.Parse("0" + txtG_PDau.Text + "")) * (decimal)congto.HeSoNhan * (decimal)congto.HeSoQuyDoi;
}
if (N_PCuoi < decimal.Parse("0" + txtNPD.Text + ""))
{
chitiet.Nhan_P_SanLuong = (soLon(txtNPD.Text) - decimal.Parse("0" + txtNPD.Text + "") + N_PCuoi) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
else
{
chitiet.Nhan_P_SanLuong = (N_PCuoi - decimal.Parse("0" + txtNPD.Text + "")) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
chitiet.Nhan_Q_Cuoi = N_QCuoi;
chitiet.Giao_Q_Cuoi = G_QCuoi;
if (G_QCuoi < decimal.Parse("0" + txtG_QDau.Text + ""))
{
chitiet.Giao_Q_SanLuong = (soLon(txtG_QDau.Text) - decimal.Parse("0" + txtG_QDau.Text + "") + G_QCuoi) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
else
{
chitiet.Giao_Q_SanLuong = (G_QCuoi - decimal.Parse("0" + txtG_QDau.Text + "")) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
if (N_QCuoi < decimal.Parse("0" + txtNQD.Text + ""))
{
chitiet.Nhan_Q_SanLuong = (soLon(txtNQD.Text) - decimal.Parse("0" + txtNQD.Text + "") + N_QCuoi) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
else
{
chitiet.Nhan_Q_SanLuong = (N_QCuoi - decimal.Parse("0" + txtNQD.Text + "")) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
if (chitiet.Giao_P_SanLuong != null && chitiet.Giao_P_SanLuong != 0)
{
double a = (double)chitiet.Giao_Q_SanLuong;
double b = (double)chitiet.Giao_P_SanLuong;
chitiet.CosGiao = decimal.Parse("0" + Math.Round(Math.Cos(Math.Atan(a / b)), 3));
}
else
{
chitiet.CosGiao = 0;
}
if (chitiet.Nhan_P_SanLuong != 0 && chitiet.Nhan_P_SanLuong != null)
{
double nhana = (double)chitiet.Nhan_Q_SanLuong;
double nhanb = (double)chitiet.Nhan_P_SanLuong;
chitiet.CosNhan = decimal.Parse("0" + Math.Round(Math.Cos(Math.Atan(nhana / nhanb)), 3));
}
else
{
chitiet.CosNhan = 0;
}
chitiet.Giao_Bieu1_Cuoi = G_B1Cuoi;
chitiet.Nhan_Bieu1_Cuoi = N_B1Cuoi;
if (G_B1Cuoi < decimal.Parse("0" + txtG_B1.Text + ""))
{
chitiet.Giao_Bieu1_SanLuong = (soLon(txtG_B1.Text) - decimal.Parse("0" + txtG_B1.Text + "") + G_B1Cuoi) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
else
{
chitiet.Giao_Bieu1_SanLuong = (G_B1Cuoi - decimal.Parse("0" + txtG_B1.Text + "")) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
if (N_B1Cuoi < decimal.Parse("0" + txtNB1D.Text + ""))
{
chitiet.Nhan_Bieu1_SanLuong = (soLon(txtNB1D.Text) - decimal.Parse("0" + txtNB1D.Text + "") + N_B1Cuoi) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
else
{
chitiet.Nhan_Bieu1_SanLuong = (N_B1Cuoi - decimal.Parse("0" + txtNB1D.Text + "")) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
chitiet.Giao_Bieu2_Cuoi = G_B2Cuoi;
chitiet.Nhan_Bieu2_Cuoi = N_B2Cuoi;
if (G_B2Cuoi < decimal.Parse("0" + txtG_B2.Text + ""))
{
chitiet.Giao_Bieu2_SanLuong = (soLon(txtG_B2.Text) - decimal.Parse("0" + txtG_B2.Text + "") + G_B2Cuoi) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
else
{
chitiet.Giao_Bieu2_SanLuong = (G_B2Cuoi - decimal.Parse("0" + txtG_B2.Text + "")) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
if (N_B2Cuoi < decimal.Parse("0" + txtNB2D.Text + ""))
{
chitiet.Nhan_Bieu2_SanLuong = (soLon(txtNB2D.Text) - decimal.Parse("0" + txtNB2D.Text + "") + N_B2Cuoi) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
else
{
chitiet.Nhan_Bieu2_SanLuong = (N_B2Cuoi - decimal.Parse("0" + txtNB2D.Text + "")) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
chitiet.Giao_Bieu3_Cuoi = G_B3Cuoi;
chitiet.Nhan_Bieu3_Cuoi = N_B3Cuoi;
if (G_B3Cuoi < decimal.Parse("0" + txtG_B3.Text + ""))
{
chitiet.Giao_Bieu3_SanLuong = (soLon(txtG_B3.Text) - decimal.Parse("0" + txtG_B3.Text + "") + G_B3Cuoi) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
else
{
chitiet.Giao_Bieu3_SanLuong = (G_B3Cuoi - decimal.Parse("0" + txtG_B3.Text + "")) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
if (N_B3Cuoi < decimal.Parse("0" + txtNB3D.Text + ""))
{
chitiet.Nhan_Bieu3_SanLuong = (soLon(txtNB3D.Text) - decimal.Parse("0" + txtNB3D.Text + "") + N_B3Cuoi) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
else
{
chitiet.Nhan_Bieu3_SanLuong = (N_B3Cuoi - decimal.Parse("0" + txtNB3D.Text + "")) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
//chitiet.DonViTinh = int.Parse(cmbDonVi.Value + "");
chitiet.ISDoDem = 0;
chitiet.ISChot = true;
chitiet.XacNhanDVGiao = false;
chitiet.XacNhanDVNhan = false;
chitiet.ISNhanVien = false;
if (chitiet.GhiChuXacNhanGiao != "" && !(bool)chitiet.XacNhanDVGiao)
{
chitiet.GhiChuXacNhanGiao = "Đã hiệu chỉnh số liệu";
}
if (chitiet.GhiChuXacNhanNhan != "" && !(bool)chitiet.XacNhanDVNhan)
{
chitiet.GhiChuXacNhanNhan = "Đã hiệu chỉnh số liệu";
}
chitiet.LoaiNhap = 0;
db.SubmitChanges();
}
}
var chitietDD = db.HD_GiaoNhanThangs.SingleOrDefault(x => x.IDCongTo == tlDonVi.FocusedNode.Key && x.Thang == int.Parse(cmbThang.Value + "") && x.Nam == int.Parse(cmbNam.Value + "") && x.ISDoDem == 1);
if (chitietDD != null)
{
chitietDD.Giao_P_SanLuong = G_PKQDD;// decimal.Parse("0" + txtGPKDD.Text);
chitietDD.Nhan_P_SanLuong = N_PKQDD;
chitietDD.Giao_Q_SanLuong = G_QKQDD; //decimal.Parse("0" + txtGQKDD.Text);
chitietDD.Nhan_Q_SanLuong = N_QKQDD;
if (chitietDD.Giao_P_SanLuong != null && chitietDD.Giao_P_SanLuong != 0)
{
double a = (double)chitietDD.Giao_Q_SanLuong;
double b = (double)chitietDD.Giao_P_SanLuong;
chitietDD.CosGiao = decimal.Parse("0" + Math.Round(Math.Cos(Math.Atan(a / b)), 3));
}
else
{
chitietDD.CosGiao = 0;
}
if (chitietDD.Nhan_P_SanLuong != 0 && chitietDD.Nhan_P_SanLuong != null)
{
double nhana = (double)chitietDD.Nhan_Q_SanLuong;
double nhanb = (double)chitietDD.Nhan_P_SanLuong;
chitietDD.CosNhan = decimal.Parse("0" + Math.Round(Math.Cos(Math.Atan(nhana / nhanb)), 3));
}
else
{
chitietDD.CosNhan = 0;
}
chitietDD.Giao_Bieu1_SanLuong = G_B1KQDD;//decimal.Parse("0" + txtGB1KQDD.Text);
chitietDD.Nhan_Bieu1_SanLuong = N_B1KQDD;
chitietDD.Giao_Bieu2_SanLuong = G_B2KQDD;//decimal.Parse("0" + txtGB2kDD.Text);
chitietDD.Nhan_Bieu2_SanLuong = N_B2KQDD;
chitietDD.Giao_Bieu3_SanLuong = G_B3KQDD;//decimal.Parse("0" + txtGB3KDD.Text);
chitietDD.Nhan_Bieu3_SanLuong = N_B3KQDD;
chitietDD.ISDoDem = 1;
chitietDD.ISChot = true;
chitietDD.LoaiNhap = 0;
db.SubmitChanges();
}
else
{
//if (decimal.Parse("0" + txtGPKDD.Text) + decimal.Parse("0" + txtGQKDD.Text) + decimal.Parse("0" + txtGB1KQDD.Text) + decimal.Parse("0" + txtGB2kDD.Text) + decimal.Parse("0" + txtGB3KDD.Text) != 0 ||
// N_PKQDD + N_QKQDD + N_B1KQDD + N_B2KQDD + N_B3KQDD != 0)
if (G_PKQDD != 0 || G_QKQDD != 0 || G_B1KQDD != 0 || G_B2KQDD != 0 || G_B3KQDD != 0 || N_PKQDD != 0 || N_QKQDD != 0 || N_B1KQDD != 0 || N_B2KQDD != 0 || N_B3KQDD != 0)
{
CBDN.HD_GiaoNhanThang giaonhan = new CBDN.HD_GiaoNhanThang();
giaonhan.IDCongTo = congto.IDCongTo + "";
giaonhan.IDChiNhanh = congto.IDChiNhanh;
giaonhan.IDDuongDay = congto.IDChiNhanh;
giaonhan.IDMaDViQly = int.Parse(session.User.ma_dviqly);
giaonhan.IDUser = session.User.IDUSER;
giaonhan.IDTram = congto.IDTram;
giaonhan.Nam = int.Parse("" + cmbNam.Value);
giaonhan.Thang = int.Parse("" + cmbThang.Value);
giaonhan.Nhan_P_Dau = 0;
giaonhan.Nhan_P_Cuoi = 0;
giaonhan.Giao_P_Dau = 0;
giaonhan.Giao_P_Cuoi = 0;
giaonhan.Giao_P_SanLuong = G_PKQDD;//decimal.Parse("0" + txtGPKDD.Text);
giaonhan.Nhan_P_SanLuong = N_PKQDD;
giaonhan.Nhan_Q_Dau = 0;
giaonhan.Nhan_Q_Cuoi = 0;
giaonhan.Giao_Q_Dau = 0;
giaonhan.Giao_Q_Cuoi = 0;
giaonhan.Giao_Q_SanLuong = G_QKQDD;//decimal.Parse("0" + txtGQKDD.Text);
giaonhan.Nhan_Q_SanLuong = N_QKQDD;
if (giaonhan.Giao_P_SanLuong != null && giaonhan.Giao_P_SanLuong != 0)
{
double a = (double)giaonhan.Giao_Q_SanLuong;
double b = (double)giaonhan.Giao_P_SanLuong;
giaonhan.CosGiao = decimal.Parse("0" + Math.Round(Math.Cos(Math.Atan(a / b)), 3));
}
else
{
giaonhan.CosGiao = 0;
}
if (giaonhan.Nhan_P_SanLuong != 0 && giaonhan.Nhan_P_SanLuong != null)
{
double nhana = (double)giaonhan.Nhan_Q_SanLuong;
double nhanb = (double)giaonhan.Nhan_P_SanLuong;
giaonhan.CosNhan = decimal.Parse("0" + Math.Round(Math.Cos(Math.Atan(nhana / nhanb)), 3));
}
else
{
giaonhan.CosNhan = 0;
}
giaonhan.Giao_Bieu1_Dau = 0;
giaonhan.Giao_Bieu1_Cuoi = 0;
giaonhan.Nhan_Bieu1_Dau = 0;
giaonhan.Nhan_Bieu1_Cuoi = 0;
giaonhan.Giao_Bieu1_SanLuong = G_B1KQDD;//decimal.Parse("0" + txtGB1KQDD.Text);
giaonhan.Nhan_Bieu1_SanLuong = N_B1KQDD;
giaonhan.Giao_Bieu2_Dau = 0;
giaonhan.Giao_Bieu2_Cuoi = 0;
giaonhan.Nhan_Bieu2_Dau = 0;
giaonhan.Nhan_Bieu2_Cuoi = 0;
giaonhan.Giao_Bieu2_SanLuong = G_B2KQDD;//decimal.Parse("0" + txtGB2kDD.Text);
giaonhan.Nhan_Bieu2_SanLuong = N_B2KQDD;
giaonhan.Giao_Bieu3_Dau = 0;
giaonhan.Giao_Bieu3_Cuoi = 0;
giaonhan.Nhan_Bieu3_Dau = 0;
giaonhan.Nhan_Bieu3_Cuoi = 0;
giaonhan.Giao_Bieu3_SanLuong = G_B3KQDD;//decimal.Parse("0" + txtGB3KDD.Text);
giaonhan.Nhan_Bieu3_SanLuong = N_B3KQDD;
giaonhan.ISDoDem = 1;
giaonhan.ISChot = true;
giaonhan.LoaiNhap = 0;
giaonhan.NgayNhap = DateTime.Now;
db.HD_GiaoNhanThangs.InsertOnSubmit(giaonhan);
db.SubmitChanges();
}
}
loadDanhMuc();
_DataBind();
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Cập nhật số liệu thành công');", true);
}
protected void btnCapNhat_Click(object sender, EventArgs e)
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
string idChiNhanh = ""; string idtram = "";
var ddo = db.DM_DiemDos.SingleOrDefault(x => x.IDDiemDo == int.Parse(cmbDiemDo.Value + "") && x.IDMaDViQly.Contains(session.User.ma_dviqly));
if (cmbDiemDo.Value + "" != "")
{
var diemdo = db.DM_DiemDos.SingleOrDefault(x => x.IDDiemDo == int.Parse("0" + cmbDiemDo.Value));
idChiNhanh = diemdo.IDChiNhanh;
idtram = diemdo.IDTram;
}
if (cmbCapDienAp.Value + "" == "")
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Bạn phải chọn cấp điện áp');", true);
}
decimal hsn = 0, hsQD = 0;
decimal testDec = 0;
if (txtHeSoNhan.Text != "")
{
if (!decimal.TryParse(txtHeSoNhan.Text, out testDec))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Hệ số nhân là kiểu số');", true);
txtHeSoNhan.Focus();
return;
}
hsn = decimal.Parse(txtHeSoNhan.Text);
}
if (txtHsNhanQD.Text != "")
{
if (!decimal.TryParse(txtHsNhanQD.Text, out testDec))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Hệ số nhân quy đổi là kiểu số');", true);
txtHsNhanQD.Focus();
return;
}
hsQD = decimal.Parse(txtHsNhanQD.Text);
}
if (Session["Add"] + "" == "0")
{
CBDN.DM_CongToSelectByIDDViResult cv = (CBDN.DM_CongToSelectByIDDViResult)grdDVT.GetRow(grdDVT.FocusedRowIndex);
var lstqtCT = db.DM_CongTos.Where(x => x.MaCongTo == cv.MaCongTo && x.IDDVNhapDL == int.Parse(session.User.ma_dviqly) && x.IDTram == cv.IDTram && x.IDChiNhanh == cv.IDChiNhanh && x.IDDiemDo == cv.IDDiemDo);
foreach (var qtCT in lstqtCT)
{
if (!CheckName(txtMaDuongDat.Text, cv.IDCongTo, cv.IDTram, cv.IDChiNhanh))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã đường dây không được trùng');", true); return;
}
//CBDN.DM_CongTo qtCT = new CBDN.DM_CongTo();
qtCT.TenCongTo = txtTenDuongDay.Text;
qtCT.MoTa = mmMoTa.Text;
qtCT.IDDiemDo = cmbDiemDo.Value + "";
qtCT.IDChiNhanh = idChiNhanh;
if (CkHoatDong.Checked)
{
qtCT.TinhTrang = 1;
}
else
{
qtCT.TinhTrang = 0;
}
qtCT.CapDienAp = cmbCapDienAp.Value + "";
qtCT.ChungLoai = txtChungLoai.Text;
qtCT.HangSanXuat = txtHangSanXuat.Text;
qtCT.HeSoNhan = hsn;
qtCT.TU_TI = txtTuTi.Text;
if (cmbNhan.Value != null)
{
qtCT.IDDonViNhan = int.Parse(cmbNhan.Value + "");
if (ddo.IDMaDViQly.Contains(cmbNhan.Value + ""))
{
qtCT.ISTonThatNhan = ckNhanTonThat.Checked;
}
qtCT.KenhNhanCongTo = "N";
qtCT.NhanTinhChat = 0;
}
qtCT.IDTram = idtram;
if (cmbDvGiao.Value != null)
{
if (ddo.IDMaDViQly.Contains(cmbDvGiao.Value + ""))
{
qtCT.IsTonThat = ckGiaoTonThat.Checked;
}
qtCT.IDDonViGiao = int.Parse(cmbDvGiao.Value + "");
qtCT.KenhGiaoCongTo = "G";
qtCT.GiaoTinhChat = 0;
}
qtCT.IsCToMotGia = ckCongTo1Gia.Checked;
qtCT.HeSoQuyDoi = hsQD;
db.SubmitChanges();
}
}
else
{
// var lstDD = db.DM_DiemDos.SingleOrDefault(x => x.IDDiemDo == int.Parse(cmbDiemDo.Value + ""));
List <Entity.DM_DVQLY> lst = new List <DM_DVQLY>();
var chinhanh = db.DM_ChiNhanhs.SingleOrDefault(x => x.ID == int.Parse(ddo.IDChiNhanh));
if (chinhanh.DiemCuoiNguon != chinhanh.DiemDauNguon && cmbDvGiao.Value + "" == cmbNhan.Value + "")
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Đơn vị nhận và đơn vị giao không thể trùng nhau do phương thức của điểm đo thuộc giao nhận giữa 2 công ty');", true); return;
}
if (!CheckName(txtMaDuongDat.Text, 0, ddo.IDTram, ddo.IDChiNhanh))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã đường dây không được trùng');", true); return;
}
CBDN.DM_CongTo cv = new CBDN.DM_CongTo();
cv.MaCongTo = txtMaDuongDat.Text;
cv.TenCongTo = txtTenDuongDay.Text;
cv.MoTa = mmMoTa.Text;
cv.IDDiemDo = ddo.IDDiemDo + "";
cv.IDDonViQuanLy = ddo.IDMaDViQly;
if (CkHoatDong.Checked)
{
cv.TinhTrang = 1;
}
else
{
cv.TinhTrang = 0;
}
cv.CapDienAp = cmbCapDienAp.Value + "";
cv.ChungLoai = txtChungLoai.Text;
cv.HangSanXuat = txtHangSanXuat.Text;
cv.HeSoNhan = hsn;
cv.NgayTreoThao = DateTime.Now;
cv.TU_TI = txtTuTi.Text;
cv.IDTram = ddo.IDTram;
cv.IDChiNhanh = ddo.IDChiNhanh;
if (cmbNhan.Value != null)
{
if (ddo.IDMaDViQly.Contains(cmbNhan.Value + ""))
{
cv.ISTonThatNhan = ckNhanTonThat.Checked;
}
cv.IDDonViNhan = int.Parse(cmbNhan.Value + "");
cv.KenhNhanCongTo = "N";
}
if (cmbDvGiao.Value != null)
{
if (ddo.IDMaDViQly.Contains(cmbDvGiao.Value + ""))
{
cv.IsTonThat = ckGiaoTonThat.Checked;
}
cv.IDDonViGiao = int.Parse(cmbDvGiao.Value + "");
cv.KenhGiaoCongTo = "G";
}
cv.IDUser = session.User.IDUSER;
cv.NgayTao = DateTime.Now;
cv.NgayKiemDinh = dtNgayTreo.Date;
cv.HeSoQuyDoi = hsQD;
cv.IDDVNhapDL = int.Parse(session.User.ma_dviqly);
if (session.User.ma_dviqly != cmbDvGiao.Value + "")
{
cv.IDDVXacNhan = int.Parse(cmbDvGiao.Value + "");
}
else
{
cv.IDDVXacNhan = int.Parse(cmbNhan.Value + "");
}
cv.IsCToMotGia = ckCongTo1Gia.Checked;
db.DM_CongTos.InsertOnSubmit(cv);
db.SubmitChanges();
pcAddRoles.ShowOnPageLoad = false;
txtGPDau.Focus();
setControlText(cv.IDCongTo);
visibleNhanChiSo();
var congto = db.DM_CongTos.SingleOrDefault(x => x.IDCongTo == int.Parse(lbIDCongTO.Text));
//CBDN.DM_CongToSelectByIDDViResult HoatDong = (CBDN.DM_CongToSelectByIDDViResult)grdDVT.GetRow(grdDVT.FocusedRowIndex);
CBDN.HD_GiaoNhanThang giaonhan = new CBDN.HD_GiaoNhanThang();
giaonhan.IDCongTo = congto.IDCongTo + "";
giaonhan.IDChiNhanh = congto.IDChiNhanh;
giaonhan.IDDuongDay = congto.IDChiNhanh;
giaonhan.IDMaDViQly = int.Parse(session.User.ma_dviqly);
giaonhan.IDUser = session.User.IDUSER;
giaonhan.IDTram = congto.IDTram;
giaonhan.Nam = int.Parse("0" + cmbNam.Value);
giaonhan.Thang = int.Parse("0" + cmbThang.Value);
giaonhan.Nhan_P_Dau = decimal.Parse(txtNPD.Text);
giaonhan.Giao_P_Dau = decimal.Parse(txtGPDau.Text);
giaonhan.Giao_P_SanLuong = 0;
giaonhan.Nhan_P_SanLuong = 0;
giaonhan.Nhan_Q_Dau = decimal.Parse(txtNQD.Text);
giaonhan.Giao_Q_Dau = decimal.Parse(txtGQDau.Text);
giaonhan.Giao_Q_SanLuong = 0;
giaonhan.Nhan_Q_SanLuong = 0;
giaonhan.CosGiao = 0;
giaonhan.CosNhan = 0;
giaonhan.Giao_Bieu1_Dau = decimal.Parse(txtB1D.Text);
giaonhan.Nhan_Bieu1_Dau = decimal.Parse(txtNB1D.Text);
giaonhan.Giao_Bieu1_SanLuong = 0;
giaonhan.Nhan_Bieu1_SanLuong = 0;
giaonhan.Giao_Bieu2_Dau = decimal.Parse(txtGB2D.Text);
giaonhan.Nhan_Bieu2_Dau = decimal.Parse(txtNB2D.Text);
giaonhan.Giao_Bieu2_SanLuong = 0;
giaonhan.Nhan_Bieu2_SanLuong = 0;
giaonhan.Giao_Bieu3_Dau = decimal.Parse(txtB3D.Text);
giaonhan.Nhan_Bieu3_Dau = decimal.Parse(txtNB3D.Text);
giaonhan.Giao_Bieu3_SanLuong = 0;
giaonhan.Nhan_Bieu3_SanLuong = 0;
giaonhan.ISDoDem = 0;
giaonhan.ISChot = false;
giaonhan.LoaiNhap = 0;
giaonhan.NgayNhap = DateTime.Now;
db.HD_GiaoNhanThangs.InsertOnSubmit(giaonhan);
}
db.SubmitChanges();
pcAddRoles.ShowOnPageLoad = false;
_DataBind();
}
protected void btnConvert_Click(object sender, EventArgs e)
{
dtData = GetData();
if (dtData != null)
{
dsData = new DataTable();
#region khai bao bang
dsData.Columns.Add("MaDiemDo");
dsData.Columns.Add("Thang");
dsData.Columns.Add("Nam");
dsData.Columns.Add("Giao_P_Cuoi");
dsData.Columns.Add("Nhan_P_Cuoi");
dsData.Columns.Add("Giao_Q_Cuoi");
dsData.Columns.Add("Nhan_Q_Cuoi");
dsData.Columns.Add("Giao_Bieu1_Cuoi");
dsData.Columns.Add("Nhan_Bieu1_Cuoi");
dsData.Columns.Add("Giao_Bieu2_Cuoi");
dsData.Columns.Add("Nhan_Bieu2_Cuoi");
dsData.Columns.Add("Giao_Bieu3_Cuoi");
dsData.Columns.Add("Nhan_Bieu3_Cuoi");
#endregion
DataTable dsdiemdo = new DataTable();
dsdiemdo.Columns.Add("MaDiemDo");
int b = dtData.Rows.Count;
int d = 0;
for (int i = 0; i < b; i++)
{
int c = dsdiemdo.Rows.Count;
var check2 = dtData.Rows[i]["MaDiemDo"] + "";
var checkhong = dtData.Rows[i]["TinhTrang"] + "";
if (checkhong != "H")
{
if (c > 0)
{
for (int j = 0; j < c; j++)
{
var check = dsdiemdo.Rows[j]["MaDiemDo"] + "";
if (check2 == check)
{
d++;
}
}
}
if (d == 0)
{
dsdiemdo.Rows.Add(check2);
}
d = 0;
}
}
int a = dsdiemdo.Rows.Count;
int a1 = dtData.Rows.Count;
for (int i = 0; i < a; i++)
{
#region Khoi tao gia tri diem do
decimal Giao_P_Cuoi = 0;
decimal Nhan_P_Cuoi = 0;
decimal Giao_Q_Cuoi = 0;
decimal Nhan_Q_Cuoi = 0;
decimal Giao_Bieu1_Cuoi = 0;
decimal Nhan_Bieu1_Cuoi = 0;
decimal Giao_Bieu2_Cuoi = 0;
decimal Nhan_Bieu2_Cuoi = 0;
decimal Giao_Bieu3_Cuoi = 0;
decimal Nhan_Bieu3_Cuoi = 0;
#endregion
var checkdiemdo = dsdiemdo.Rows[i]["MaDiemDo"] + "";
string thang = "";
string nam = "";
string madiemdo = "";
if (DateTime.Now.Month == 1)
{
thang = "12";
nam = DateTime.Now.Year - 1 + "";
}
else
{
thang = DateTime.Now.Month - 1 + "";
nam = DateTime.Now.Year + "";
}
for (int j = 0; j < a1; j++)
{
madiemdo = dtData.Rows[j]["MaDiemDo"] + "";
string bcs = dtData.Rows[j]["BoChiSo"] + "";
if (madiemdo == checkdiemdo)
{
madiemdo = dtData.Rows[j]["MaDiemDo"] + "";
var checkhong = dtData.Rows[j]["TinhTrang"] + "";
if (checkhong != "H")
{
decimal csm = 0;
if (dtData.Rows[j]["ChiSoMoi"] + "" != "")
{
var a12 = (dtData.Rows[j]["ChiSoMoi"] + "");
int x1 = a12.IndexOf(".");
int x2 = a12.LastIndexOf(".");
if (x1 == x2)
{
csm = decimal.Parse(a12.ToString().Replace(".", ","));
}
else
{
a12 = a12.Remove(x1, 1);
int x1a = a12.IndexOf(".");
int x2a = a12.LastIndexOf(".");
if (x1 == x2)
{
csm = decimal.Parse(a12.ToString().Replace(".", ","));
}
else
{
a12 = a12.Remove(x1a, 1);
csm = decimal.Parse(a12.ToString().Replace(".", ","));
}
}
}
if (bcs == "BT")
{
Giao_Bieu1_Cuoi = csm;
}
if (bcs == "CD")
{
Giao_Bieu2_Cuoi = csm;
}
if (bcs == "TD")
{
Giao_Bieu3_Cuoi = csm;
}
if (bcs == "SG")
{
Giao_P_Cuoi = csm;
}
if (bcs == "VC")
{
Giao_Q_Cuoi = csm;
}
if (bcs == "BN")
{
Nhan_Bieu1_Cuoi = csm;
}
if (bcs == "CN")
{
Nhan_Bieu2_Cuoi = csm;
}
if (bcs == "TN")
{
Nhan_Bieu3_Cuoi = csm;
}
if (bcs == "SN")
{
Nhan_P_Cuoi = csm;
}
if (bcs == "VN")
{
Nhan_Q_Cuoi = csm;
}
}
}
}
dsData.Rows.Add(checkdiemdo, thang, nam, Giao_P_Cuoi, Nhan_P_Cuoi,
Giao_Q_Cuoi, Nhan_Q_Cuoi, Giao_Bieu1_Cuoi, Nhan_Bieu1_Cuoi, Giao_Bieu2_Cuoi, Nhan_Bieu2_Cuoi,
Giao_Bieu3_Cuoi, Nhan_Bieu3_Cuoi);
}
int bdem = dsData.Rows.Count;
int adem = 0;
for (int i = 0; i < bdem; i++)
{
try
{
decimal Giao_Bieu1_Cuoi = decimal.Parse(dsData.Rows[i]["Giao_Bieu1_Cuoi"] + "");
decimal Giao_Bieu2_Cuoi = decimal.Parse(dsData.Rows[i]["Giao_Bieu2_Cuoi"] + "");
decimal Giao_Bieu3_Cuoi = decimal.Parse(dsData.Rows[i]["Giao_Bieu3_Cuoi"] + "");
decimal Giao_P_Cuoi = decimal.Parse(dsData.Rows[i]["Giao_P_Cuoi"] + "");
decimal Giao_Q_Cuoi = decimal.Parse(dsData.Rows[i]["Giao_Q_Cuoi"] + "");
decimal Nhan_Bieu1_Cuoi = decimal.Parse(dsData.Rows[i]["Nhan_Bieu1_Cuoi"] + "");
decimal Nhan_Bieu2_Cuoi = decimal.Parse(dsData.Rows[i]["Nhan_Bieu2_Cuoi"] + "");
decimal Nhan_Bieu3_Cuoi = decimal.Parse(dsData.Rows[i]["Nhan_Bieu3_Cuoi"] + "");
decimal Nhan_P_Cuoi = decimal.Parse(dsData.Rows[i]["Nhan_P_Cuoi"] + "");
decimal Nhan_Q_Cuoi = decimal.Parse(dsData.Rows[i]["Nhan_Q_Cuoi"] + "");
var MaDiemDo = dsData.Rows[i]["MaDiemDo"] + "";
var Thang = int.Parse(dsData.Rows[i]["Thang"] + "");
var Nam = int.Parse(dsData.Rows[i]["Nam"] + "");
var lstHD = db.LayThongTinGiaoNhanQuaMaDD(MaDiemDo, Thang, Nam);
adem++;
foreach (var hd in lstHD)
{
CBDN.HD_GiaoNhanThang chitiet = db.HD_GiaoNhanThangs.SingleOrDefault(x => x.ID == hd.ID && x.ISNhanVien != true);
if (chitiet == null)
{
continue;
}
var diemdo = db.DM_DiemDos.SingleOrDefault(x => x.MaDiemDo == MaDiemDo);
var congto = db.DM_CongTos.SingleOrDefault(x => x.IDDiemDo == diemdo.IDDiemDo + "" && x.TinhTrang == 1);
if (congto == null)
{
continue;
}
var tram = db.DM_Trams.SingleOrDefault(x => x.IDTram == int.Parse(diemdo.IDTram));
var ID = congto.IDCongTo;
var idDuongday = diemdo.IDChiNhanh;
var idtram = tram.IDTram;
if (chitiet != null)
{
chitiet.Giao_Bieu1_Cuoi = decimal.Parse("" + Giao_Bieu1_Cuoi);
chitiet.Nhan_Bieu1_Cuoi = decimal.Parse("" + Nhan_Bieu1_Cuoi);
if (decimal.Parse("" + Giao_Bieu1_Cuoi) < chitiet.Giao_Bieu1_Dau)
{
chitiet.Giao_Bieu1_SanLuong = (soLon(chitiet.Giao_Bieu1_Dau + "") - chitiet.Giao_Bieu1_Dau + decimal.Parse("" + Giao_Bieu1_Cuoi)) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
else
{
chitiet.Giao_Bieu1_SanLuong = (decimal.Parse("" + Giao_Bieu1_Cuoi) - chitiet.Giao_Bieu1_Dau) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
if (decimal.Parse("" + Nhan_Bieu1_Cuoi) < chitiet.Nhan_Bieu1_Dau)
{
chitiet.Nhan_Bieu1_SanLuong = (soLon(chitiet.Nhan_Bieu1_Dau + "") - chitiet.Nhan_Bieu1_Dau + decimal.Parse("" + Nhan_Bieu1_Cuoi)) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
else
{
chitiet.Nhan_Bieu1_SanLuong = (decimal.Parse("" + Nhan_Bieu1_Cuoi) - chitiet.Nhan_Bieu1_Dau) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
chitiet.Giao_Bieu2_Cuoi = decimal.Parse("" + Giao_Bieu2_Cuoi);
chitiet.Nhan_Bieu2_Cuoi = decimal.Parse("" + Nhan_Bieu2_Cuoi);
if (decimal.Parse("" + Giao_Bieu2_Cuoi) < chitiet.Giao_Bieu2_Dau)
{
chitiet.Giao_Bieu2_SanLuong = (soLon(chitiet.Giao_Bieu2_Dau + "") - chitiet.Giao_Bieu2_Dau + decimal.Parse("" + Giao_Bieu2_Cuoi)) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
else
{
chitiet.Giao_Bieu2_SanLuong = (decimal.Parse("" + Giao_Bieu2_Cuoi) - chitiet.Giao_Bieu2_Dau) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
if (decimal.Parse("" + Nhan_Bieu2_Cuoi) < chitiet.Nhan_Bieu2_Dau)
{
chitiet.Nhan_Bieu2_SanLuong = (soLon(chitiet.Nhan_Bieu2_Dau + "") - chitiet.Nhan_Bieu2_Dau + decimal.Parse("" + Nhan_Bieu2_Cuoi)) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
else
{
chitiet.Nhan_Bieu2_SanLuong = (decimal.Parse("" + Nhan_Bieu2_Cuoi) - chitiet.Nhan_Bieu2_Dau) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
chitiet.Giao_Bieu3_Cuoi = decimal.Parse("" + Giao_Bieu3_Cuoi);
chitiet.Nhan_Bieu3_Cuoi = decimal.Parse("" + Nhan_Bieu3_Cuoi);
if (decimal.Parse("" + Giao_Bieu3_Cuoi) < chitiet.Giao_Bieu3_Dau)
{
chitiet.Giao_Bieu3_SanLuong = (soLon(chitiet.Giao_Bieu3_Dau + "") - chitiet.Giao_Bieu3_Dau + decimal.Parse("" + Giao_Bieu3_Cuoi)) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
else
{
chitiet.Giao_Bieu3_SanLuong = (decimal.Parse("" + Giao_Bieu3_Cuoi) - chitiet.Giao_Bieu3_Dau) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
if (decimal.Parse("" + Nhan_Bieu3_Cuoi) < chitiet.Nhan_Bieu3_Dau)
{
chitiet.Nhan_Bieu3_SanLuong = (soLon(chitiet.Nhan_Bieu3_Dau + "") - chitiet.Nhan_Bieu3_Dau + decimal.Parse("" + Nhan_Bieu3_Cuoi)) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
else
{
chitiet.Nhan_Bieu3_SanLuong = (decimal.Parse("" + Nhan_Bieu3_Cuoi) - chitiet.Nhan_Bieu3_Dau) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
chitiet.Nhan_P_Cuoi = Math.Round(decimal.Parse(Nhan_P_Cuoi + ""), 3);
chitiet.Giao_P_Cuoi = decimal.Parse(Giao_P_Cuoi + "");
chitiet.Giao_P_SanLuong = chitiet.Giao_Bieu1_SanLuong + chitiet.Giao_Bieu2_SanLuong + chitiet.Giao_Bieu3_SanLuong;
chitiet.Nhan_P_SanLuong = chitiet.Nhan_Bieu1_SanLuong + chitiet.Nhan_Bieu2_SanLuong + chitiet.Nhan_Bieu3_SanLuong;
chitiet.Nhan_Q_Cuoi = decimal.Parse("" + Nhan_Q_Cuoi);
chitiet.Giao_Q_Cuoi = decimal.Parse("" + Giao_Q_Cuoi);
if (decimal.Parse("" + Giao_Q_Cuoi) < chitiet.Giao_Q_Dau)
{
chitiet.Giao_Q_SanLuong = (soLon(chitiet.Giao_Q_Dau + "") - chitiet.Giao_Q_Dau + decimal.Parse("" + Giao_Q_Cuoi)) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
else
{
chitiet.Giao_Q_SanLuong = (decimal.Parse("" + Giao_Q_Cuoi) - chitiet.Giao_Q_Dau) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
if (decimal.Parse("" + Nhan_Q_Cuoi) < chitiet.Nhan_Q_Dau)
{
chitiet.Nhan_Q_SanLuong = (soLon(chitiet.Nhan_Q_Dau + "") - chitiet.Nhan_Q_Dau + decimal.Parse("" + Nhan_Q_Cuoi)) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
else
{
chitiet.Nhan_Q_SanLuong = (decimal.Parse("" + Nhan_Q_Cuoi) - chitiet.Nhan_Q_Dau) * congto.HeSoNhan * congto.HeSoQuyDoi;
}
if (chitiet.Giao_P_SanLuong != null && chitiet.Giao_P_SanLuong != 0)
{
double a2 = (double)chitiet.Giao_Q_SanLuong;
double b2 = (double)chitiet.Giao_P_SanLuong;
chitiet.CosGiao = decimal.Parse("0" + Math.Round(Math.Cos(Math.Atan(a2 / b2)), 3));
}
else
{
chitiet.CosGiao = 0;
}
if (chitiet.Nhan_P_SanLuong != 0 && chitiet.Nhan_P_SanLuong != null)
{
double nhana = (double)chitiet.Nhan_Q_SanLuong;
double nhanb = (double)chitiet.Nhan_P_SanLuong;
chitiet.CosNhan = decimal.Parse("" + Math.Round(Math.Cos(Math.Atan(nhana / nhanb)), 3));
}
else
{
chitiet.CosNhan = 0;
}
chitiet.ISDoDem = 0;
chitiet.ISChot = true;
chitiet.XacNhanDVGiao = false;
chitiet.XacNhanDVNhan = false;
chitiet.ISNhanVien = false;
if (chitiet.GhiChuXacNhanGiao != "" && !(bool)chitiet.XacNhanDVGiao)
{
chitiet.GhiChuXacNhanGiao = "Đã hiệu chỉnh số liệu";
}
if (chitiet.GhiChuXacNhanNhan != "" && !(bool)chitiet.XacNhanDVNhan)
{
chitiet.GhiChuXacNhanNhan = "Đã hiệu chỉnh số liệu";
}
chitiet.ToolDB = true;
chitiet.LoaiNhap = 1;
db.SubmitChanges();
}
}
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Import dữ liệu thành công');", true);
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('" + ex.Message + adem + "');", true);
}
}
}
}
protected void btnCapNhat_Click1(object sender, EventArgs e)
{
MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"];
int ma_dviqly = int.Parse(session.User.ma_dviqly + "");
var congto = db.DM_CongTos.SingleOrDefault(x => x.IDCongTo == int.Parse(tlDonVi.FocusedNode.Key));
var chitiet = db.HD_GiaoNhanThangs.SingleOrDefault(x => x.IDCongTo == congto.MaCongTo && x.IDMaDViQly == ma_dviqly && x.Thang == int.Parse("" + cmbThang.Value) && x.Nam == int.Parse("" + cmbNam.Value));
var diemdo = db.DM_DiemDos.SingleOrDefault(x => x.IDDiemDo == congto.IDDiemDo);
var tram = db.DM_Trams.SingleOrDefault(x => x.IDTram == diemdo.IDTram);
if (chitiet == null)
{
CBDN.HD_GiaoNhanThang giaonhan = new CBDN.HD_GiaoNhanThang();
giaonhan.IDCongTo = congto.MaCongTo;
giaonhan.IDChiNhanh = int.Parse("0" + tram.IDChiNhanh);
giaonhan.IDMaDViQly = ma_dviqly;
giaonhan.IDUser = session.User.IDUSER;
giaonhan.Nam = int.Parse("0" + cmbNam.Value);
giaonhan.Thang = int.Parse("0" + cmbThang.Value);
giaonhan.IDTram = int.Parse("0" + tram.IDTram);
giaonhan.Nhan_P_Dau = decimal.Parse(txtP2Dau.Text);
giaonhan.Nhan_P_Cuoi = decimal.Parse(txtP2Cuoi.Text);
giaonhan.Giao_P_Dau = decimal.Parse(txtPDau.Text);
giaonhan.Giao_P_Cuoi = decimal.Parse(txtPCuoi.Text);
giaonhan.Giao_P_SanLuong = (decimal.Parse(txtP2Cuoi.Text) - decimal.Parse(txtP2Dau.Text)) * congto.HeSoNhan;
giaonhan.Nhan_P_SanLuong = (decimal.Parse(txtPCuoi.Text) - decimal.Parse(txtPDau.Text)) * congto.HeSoNhan;
giaonhan.Nhan_Q_Dau = decimal.Parse(txtQ2Dau.Text);
giaonhan.Nhan_Q_Cuoi = decimal.Parse(txtQ2Cuoi.Text);
giaonhan.Giao_Q_Dau = decimal.Parse(txtQDau.Text);
giaonhan.Giao_Q_Cuoi = decimal.Parse(txtQCuoi.Text);
giaonhan.Giao_Q_SanLuong = (decimal.Parse(txtQ2Cuoi.Text) - decimal.Parse(txtQ2Dau.Text)) * congto.HeSoNhan;
giaonhan.Nhan_Q_SanLuong = (decimal.Parse(txtQCuoi.Text) - decimal.Parse(txtQDau.Text)) * congto.HeSoNhan;
if (giaonhan.Giao_P_SanLuong != null && giaonhan.Giao_P_SanLuong != 0)
{
double a = (double)giaonhan.Giao_Q_SanLuong;
double b = (double)giaonhan.Giao_P_SanLuong;
giaonhan.CosGiao = decimal.Parse("0" + Math.Cos(Math.Atan(a / b)));
}
else
{
giaonhan.CosGiao = 0;
}
if (giaonhan.Nhan_P_SanLuong != 0 && giaonhan.Nhan_P_SanLuong != null)
{
double nhana = (double)giaonhan.Nhan_Q_SanLuong;
double nhanb = (double)giaonhan.Nhan_P_SanLuong;
giaonhan.CosNhan = decimal.Parse("0" + Math.Cos(Math.Atan(nhana / nhanb)));
}
else
{
giaonhan.CosNhan = 0;
}
giaonhan.Giao_Bieu1_Dau = decimal.Parse(txtB1Dau.Text);
giaonhan.Giao_Bieu1_Cuoi = decimal.Parse(txtB1Cuoi.Text);
giaonhan.Nhan_Bieu1_Dau = decimal.Parse(txtB1NDau.Text);
giaonhan.Nhan_Bieu1_Cuoi = decimal.Parse(txtB1NCuoi.Text);
giaonhan.Giao_Bieu1_SanLuong = (decimal.Parse(txtB1Cuoi.Text) - decimal.Parse(txtB1Dau.Text)) * congto.HeSoNhan;
giaonhan.Nhan_Bieu1_SanLuong = (decimal.Parse(txtB1NCuoi.Text) - decimal.Parse(txtB1NDau.Text)) * congto.HeSoNhan;
giaonhan.Giao_Bieu2_Dau = decimal.Parse(txtB2Dau.Text);
giaonhan.Giao_Bieu2_Cuoi = decimal.Parse(txtB2Cuoi.Text);
giaonhan.Nhan_Bieu2_Dau = decimal.Parse(txtB2N_Dau.Text);
giaonhan.Nhan_Bieu2_Cuoi = decimal.Parse(txtB2N_Cuoi.Text);
giaonhan.Giao_Bieu2_SanLuong = (decimal.Parse(txtB2Cuoi.Text) - decimal.Parse(txtB2Dau.Text)) * congto.HeSoNhan;
giaonhan.Nhan_Bieu2_SanLuong = (decimal.Parse(txtB2N_Cuoi.Text) - decimal.Parse(txtB2N_Dau.Text)) * congto.HeSoNhan;
giaonhan.Giao_Bieu3_Dau = decimal.Parse(txtB3Dau.Text);
giaonhan.Giao_Bieu3_Cuoi = decimal.Parse(txtB3Cuoi.Text);
giaonhan.Nhan_Bieu3_Dau = decimal.Parse(txtB3NDau.Text);
giaonhan.Nhan_Bieu3_Cuoi = decimal.Parse(txtB3NCuoi.Text);
giaonhan.Giao_Bieu3_SanLuong = (decimal.Parse(txtB3Cuoi.Text) - decimal.Parse(txtB2Dau.Text)) * congto.HeSoNhan;
giaonhan.Nhan_Bieu3_SanLuong = (decimal.Parse(txtB3Cuoi.Text) - decimal.Parse(txtB3NDau.Text)) * congto.HeSoNhan;
giaonhan.NgayNhap = DateTime.Now;
db.HD_GiaoNhanThangs.InsertOnSubmit(giaonhan);
db.SubmitChanges();
}
else
{
chitiet.Nhan_P_Dau = decimal.Parse(txtP2Dau.Text);
chitiet.Nhan_P_Cuoi = decimal.Parse(txtP2Cuoi.Text);
chitiet.Giao_P_Dau = decimal.Parse(txtPDau.Text);
chitiet.Giao_P_Cuoi = decimal.Parse(txtPCuoi.Text);
chitiet.Giao_P_SanLuong = (decimal.Parse(txtP2Cuoi.Text) - decimal.Parse(txtP2Dau.Text)) * congto.HeSoNhan;
chitiet.Nhan_P_SanLuong = (decimal.Parse(txtPCuoi.Text) - decimal.Parse(txtPDau.Text)) * congto.HeSoNhan;
chitiet.Nhan_Q_Dau = decimal.Parse(txtQ2Dau.Text);
chitiet.Nhan_Q_Cuoi = decimal.Parse(txtQ2Cuoi.Text);
chitiet.Giao_Q_Dau = decimal.Parse(txtQDau.Text);
chitiet.Giao_Q_Cuoi = decimal.Parse(txtQCuoi.Text);
chitiet.Giao_Q_SanLuong = (decimal.Parse(txtQ2Cuoi.Text) - decimal.Parse(txtQ2Dau.Text)) * congto.HeSoNhan;
chitiet.Nhan_Q_SanLuong = (decimal.Parse(txtQCuoi.Text) - decimal.Parse(txtQDau.Text)) * congto.HeSoNhan;
if (chitiet.Giao_P_SanLuong != null && chitiet.Giao_P_SanLuong != 0)
{
double a = (double)chitiet.Giao_Q_SanLuong;
double b = (double)chitiet.Giao_P_SanLuong;
chitiet.CosGiao = decimal.Parse("0" + Math.Cos(Math.Atan(a / b)));
}
else
{
chitiet.CosGiao = 0;
}
if (chitiet.Nhan_P_SanLuong != 0 && chitiet.Nhan_P_SanLuong != null)
{
double nhana = (double)chitiet.Nhan_Q_SanLuong;
double nhanb = (double)chitiet.Nhan_P_SanLuong;
chitiet.CosNhan = decimal.Parse("0" + Math.Cos(Math.Atan(nhana / nhanb)));
}
else
{
chitiet.CosNhan = 0;
}
chitiet.Giao_Bieu1_Dau = decimal.Parse(txtB1Dau.Text);
chitiet.Giao_Bieu1_Cuoi = decimal.Parse(txtB1Cuoi.Text);
chitiet.Nhan_Bieu1_Dau = decimal.Parse(txtB1NDau.Text);
chitiet.Nhan_Bieu1_Cuoi = decimal.Parse(txtB1NCuoi.Text);
chitiet.Giao_Bieu1_SanLuong = (decimal.Parse(txtB1Cuoi.Text) - decimal.Parse(txtB1Dau.Text)) * congto.HeSoNhan;
chitiet.Nhan_Bieu1_SanLuong = (decimal.Parse(txtB1NCuoi.Text) - decimal.Parse(txtB1NDau.Text)) * congto.HeSoNhan;
chitiet.Giao_Bieu2_Dau = decimal.Parse(txtB2Dau.Text);
chitiet.Giao_Bieu2_Cuoi = decimal.Parse(txtB2Cuoi.Text);
chitiet.Nhan_Bieu2_Dau = decimal.Parse(txtB2N_Dau.Text);
chitiet.Nhan_Bieu2_Cuoi = decimal.Parse(txtB2N_Cuoi.Text);
chitiet.Giao_Bieu2_SanLuong = (decimal.Parse(txtB2Cuoi.Text) - decimal.Parse(txtB2Dau.Text)) * congto.HeSoNhan;
chitiet.Nhan_Bieu2_SanLuong = (decimal.Parse(txtB2N_Cuoi.Text) - decimal.Parse(txtB2N_Dau.Text)) * congto.HeSoNhan;
chitiet.Giao_Bieu3_Dau = decimal.Parse(txtB3Dau.Text);
chitiet.Giao_Bieu3_Cuoi = decimal.Parse(txtB3Cuoi.Text);
chitiet.Nhan_Bieu3_Dau = decimal.Parse(txtB3NDau.Text);
chitiet.Nhan_Bieu3_Cuoi = decimal.Parse(txtB3NCuoi.Text);
chitiet.Giao_Bieu3_SanLuong = (decimal.Parse(txtB3Cuoi.Text) - decimal.Parse(txtB2Dau.Text)) * congto.HeSoNhan;
chitiet.Nhan_Bieu3_SanLuong = (decimal.Parse(txtB3Cuoi.Text) - decimal.Parse(txtB3NDau.Text)) * congto.HeSoNhan;
db.SubmitChanges();
}
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Cập nhật số liệu thành công');", true);
}
