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