protected void grdDVT_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
{
try
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
CBDN.DM_TramSelectByIDDViResult HoatDong = (CBDN.DM_TramSelectByIDDViResult)grdDVT.GetRow(grdDVT.FocusedRowIndex);
if (HoatDong.MaDVNhap != int.Parse(session.User.ma_dviqly))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Không thể xóa giao nhận này vì không phải đơn vị bạn tạo ra');", true);
return;
}
CBDN.DM_Tram cv = new CBDN.DM_Tram();
cv = db.DM_Trams.SingleOrDefault(x => x.IDTram == cv.IDTram && x.IDChiNhanh == cv.IDChiNhanh);
db.DM_Trams.DeleteOnSubmit(cv);
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 grdDVT_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
{
try
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
CBDN.DM_ChiNhanhSelectByIDDViResult HoatDong = (CBDN.DM_ChiNhanhSelectByIDDViResult)grdDVT.GetRow(grdDVT.FocusedRowIndex);
if (HoatDong.DiemDauNguon != int.Parse(session.User.ma_dviqly))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Không thể xóa giao nhận này vì không phải đơn vị bạn tạo ra');", true);
return;
}
var check = db.DM_Trams.Where(x => x.IDChiNhanh == HoatDong.ID + "");
if (check.Count() > 0)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Không thể xóa giao nhận này vì có trạm đang hoạt động ');", true);
return;
}
CBDN.DM_ChiNhanh cv = new CBDN.DM_ChiNhanh();
cv = db.DM_ChiNhanhs.SingleOrDefault(x => x.ID == HoatDong.ID && x.IDMADVIQLY.Contains(session.User.ma_dviqly));
db.DM_ChiNhanhs.DeleteOnSubmit(cv);
db.SubmitChanges();
_DataBind();
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Xoá phương thức giao nhận thành công');", true);
}
catch (Exception ex)
{ }
finally
{
e.Cancel = true;
}
}
protected void btnDuyet_Click(object sender, EventArgs e)
{
try
{
MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"];
string strMadviqly = session.User.ma_dviqly;
if (grdNhan.Selection.Count == 0)
{
return;
}
List <Object> keyvalues = grdNhan.GetSelectedFieldValues("ID");
// List<Object> temp = new List<Object>();
foreach (object key in keyvalues)
{
var bd_chitiet = db.HD_GiaoNhanThangs.SingleOrDefault(x => x.ID == int.Parse(key + ""));
bd_chitiet.ISNhanVien = true;
bd_chitiet.IDUseNhanVienXN = session.User.IDUSER;
bd_chitiet.DateNhanVienXN = DateTime.Now;
db.SubmitChanges();
}
LoadGrdNhan();
//pcAddRoles.ShowOnPageLoad = false;
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Lỗi duyệt chấm nợ " + ex.Message + "');", true);
}
}
protected void grdDVT_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
{
try
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
CBDN.DM_CongToSelectByIDDViResult HoatDong = (CBDN.DM_CongToSelectByIDDViResult)grdDVT.GetRow(grdDVT.FocusedRowIndex);
CBDN.DM_CongTo cv = new CBDN.DM_CongTo();
cv = db.DM_CongTos.SingleOrDefault(x => x.IDCongTo == HoatDong.IDCongTo && x.IDDonViQuanLy == int.Parse(session.User.ma_dviqly));
db.DM_CongTos.DeleteOnSubmit(cv);
db.SubmitChanges();
_DataBind();
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Xoá công tơ thành công');", true);
}
catch (Exception ex)
{ }
finally
{
e.Cancel = true;
}
}
protected void grdDVT_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
{
try
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
CBDN.DM_NhaMay HoatDong = (CBDN.DM_NhaMay)grdDVT.GetRow(grdDVT.FocusedRowIndex);
CBDN.DM_NhaMay cv = new CBDN.DM_NhaMay();
cv = db.DM_NhaMays.SingleOrDefault(x => x.ID == HoatDong.ID && x.IDMADVIQLY == int.Parse(session.User.ma_dviqly));
db.DM_NhaMays.DeleteOnSubmit(cv);
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 grdDVT_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
{
try
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
CBDN.HD_SanLuongThuongPham HoatDong = (CBDN.HD_SanLuongThuongPham)grdDVT.GetRow(grdDVT.FocusedRowIndex);
CBDN.HD_SanLuongThuongPham cv = new CBDN.HD_SanLuongThuongPham();
cv = db.HD_SanLuongThuongPhams.SingleOrDefault(x => x.ID == HoatDong.ID);
db.HD_SanLuongThuongPhams.DeleteOnSubmit(cv);
db.SubmitChanges();
_DataBind();
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Xoá phương thức giao nhận thành công');", true);
}
catch (Exception ex)
{ }
finally
{
e.Cancel = true;
}
}
protected void grdDVT_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
{
try
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
CBDN.TT_KhachHangDAThapTrongThangResult HoatDong = (CBDN.TT_KhachHangDAThapTrongThangResult)grdDVT.GetRow(grdDVT.FocusedRowIndex);
CBDN.TT_KhachHangDAThap cv = new CBDN.TT_KhachHangDAThap();
cv = db.TT_KhachHangDAThaps.SingleOrDefault(x => x.ID == HoatDong.ID);
db.TT_KhachHangDAThaps.DeleteOnSubmit(cv);
db.SubmitChanges();
_DataBind();
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Xoá tổn thất khách hàng điện áp thấp thành công');", true);
}
catch (Exception ex)
{ }
finally
{
e.Cancel = true;
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
List <Object> keyvalues = grdKHCHUA.GetSelectedFieldValues("IDMA_DVIQLY");
foreach (object key in keyvalues)
{
CBDN.DN_MoKhoaDV cv = new CBDN.DN_MoKhoaDV();
cv.ID_MADVIQLY = int.Parse(key.ToString());
cv.Nam = DateTime.Now.Year;
cv.Ngay = DateTime.Now.Day - 2;
cv.NgayTao = DateTime.Now;
cv.Thang = DateTime.Now.Month;
var check = db.DN_MoKhoaDVs.SingleOrDefault(x => x.ID_MADVIQLY == int.Parse(key.ToString()) && x.Nam == DateTime.Now.Year && x.Thang == DateTime.Now.Month && x.Ngay == DateTime.Now.Day);
if (check == null)
{
db.DN_MoKhoaDVs.InsertOnSubmit(cv);
db.SubmitChanges();
}
}
loadKHDaP();
loadKHChua();
grdKH.Selection.UnselectAll();
grdKHCHUA.Selection.UnselectAll();
}
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 grdDVT_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
try
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
CBDN.DN_TongNhapDienNhan cv = new CBDN.DN_TongNhapDienNhan();
cv = db.DN_TongNhapDienNhans.SingleOrDefault(x => x.ID == int.Parse(e.Keys[0] + ""));
cv.DienNhanThucTe = int.Parse(e.NewValues[0] + "");
cv.DN_Thang = int.Parse(e.NewValues[1] + "");
if (int.Parse(e.NewValues[2] + "") != 0 && cv.NgayDCL1 == DateTime.Now.Day)
{
cv.DN_DC_Lan1 = int.Parse(e.NewValues[2] + "");
cv.NgayDCLan1 = DateTime.Now;
cv.NgayDCL1 = DateTime.Now.Day;
}
if (int.Parse(e.NewValues[3] + "") != 0 && cv.NgayDCL2 == DateTime.Now.Day)
{
cv.DN_DC_Lan2 = int.Parse(e.NewValues[3] + "");
cv.NgayDCLan2 = DateTime.Now;
cv.NgayDCL2 = DateTime.Now.Day;
}
if (int.Parse(e.NewValues[4] + "") != 0 && cv.NgayDCL3 == DateTime.Now.Day)
{
cv.NgayDCL3 = DateTime.Now.Day;
cv.NgayDCLan3 = DateTime.Now;
cv.DN_DC_Lan3 = int.Parse(e.NewValues[4] + "");
}
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_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);
}
protected void grdDVT_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
try
{
CBDN.DN_CTy_DienNhan cv = new CBDN.DN_CTy_DienNhan();
cv = db.DN_CTy_DienNhans.SingleOrDefault(x => x.ID == int.Parse(e.Keys[0] + ""));
/* var tongKH = db.DN_TongNhapDienNhans.SingleOrDefault(x => x.IDMA_DVIQLY == cv.IDMA_DVIQLY && x.Thang == cv.Thang && x.Nam == cv.Nam);
* var dcKH1 = db.DN_TongNhapDienNhans.Where(x => x.IDMA_DVIQLY == cv.IDMA_DVIQLY && x.Thang == cv.Thang && x.Nam == cv.Nam
* && x.NgayDCL1 == cv.Ngay);
* var dcKH2 = db.DN_TongNhapDienNhans.Where(x => x.IDMA_DVIQLY == cv.IDMA_DVIQLY && x.Thang == cv.Thang && x.Nam == cv.Nam
* && x.NgayDCL2 == cv.Ngay);
* var dcKH3 = db.DN_TongNhapDienNhans.Where(x => x.IDMA_DVIQLY == cv.IDMA_DVIQLY && x.Thang == cv.Thang && x.Nam == cv.Nam
* && x.NgayDCL3 == cv.Ngay);
*
* int tongDC = 0;
* foreach (var khDC in dcKH1)
* {
* tongDC = tongDC + (int)khDC.DN_DC_Lan1;
* }
* foreach (var khDC in dcKH2)
* {
* tongDC = tongDC + (int)khDC.DN_DC_Lan2;
* }
* foreach (var khDC in dcKH3)
* {
* tongDC = tongDC + (int)khDC.DN_DC_Lan3;
* }
*
* if (cv.Ngay != 1)
* {
* var cvls = db.DN_CTy_DienNhans.SingleOrDefault(x => x.IDMA_DVIQLY == cv.IDMA_DVIQLY && x.Thang == cv.Thang && x.Nam == cv.Nam && x.Ngay == cv.Ngay - 1);
* cv.LuyKeTH = cvls.LuyKeTH + int.Parse(e.NewValues[0] + "");
* cv.TH_PhanBoNgay = (tongKH.DN_Thang + tongDC - cvls.LuyKePhanBo) / (DateTime.DaysInMonth(int.Parse(cmbNam.Value + ""), int.Parse("" + cmbThang.Value)) - cv.Ngay);
* cv.TongKH_PBNgay = cvls.TongKH_PBNgay + cv.TH_PhanBoNgay + tongDC;
* cv.LuyKePhanBo = cvls.LuyKePhanBo + cv.TH_PhanBoNgay;
* }
* else
* {
* cv.TH_PhanBoNgay = (tongKH.DN_Thang + tongDC) / (DateTime.DaysInMonth(int.Parse(cmbNam.Value + ""), int.Parse("" + cmbThang.Value)) - 1);
* cv.LuyKeTH = int.Parse(e.NewValues[0] + "");
* cv.TongKH_PBNgay = cv.TH_PhanBoNgay + tongDC;
* cv.LuyKePhanBo = cv.TH_PhanBoNgay;
* }*/
//if (cv.Ngay <= DateTime.Now.Day-4 && cv.DienNhan != int.Parse(e.NewValues[0] + ""))
//{
// throw new Exception("Bạn không thể sửa giá trị điện nhận vì không phải ngày sửa hiện tại.");
//}
cv.DienNhan = int.Parse(e.NewValues[0] + "");
cv.SanLuongKH = int.Parse(e.NewValues[1] + "");
cv.SanLuongPB = int.Parse(e.NewValues[2] + "");
cv.GhiChu = e.NewValues[3] + "";
grdDVT.CancelEdit();
e.Cancel = true;
db.SubmitChanges();
_DataBind();
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Cập nhật dữ liệu thành công');", true);
}
catch (Exception ex)
{
grdDVT.JSProperties["cpError"] = "SqlException";
e.Cancel = true;
}
//finally
//{
// e.Cancel = 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);
}
}
}
}
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"];
if (cmbDuongDay.Value + "" == "")
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Bạn phải chọn phương thức giao nhận');", true);
return;
}
if (txtTenDuongDay.Value + "" == "")
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Tên trạm không thể bỏ trống');", true);
return;
}
var cn = db.DM_ChiNhanhs.SingleOrDefault(x => x.ID == int.Parse(cmbDuongDay.Value + "") && x.IDMADVIQLY.Contains(session.User.ma_dviqly));
if (Session["Add"] + "" == "0")
{
CBDN.DM_Tram HoatDong = db.DM_Trams.SingleOrDefault(x => x.IDTram == int.Parse(TreeListOrganization.FocusedNode.Key + ""));
//var lst = db.DM_Trams.Where(x => x.MaTram == cv.MaTram && x.IDChiNhanh==cv.IDChiNhanh);
if (!CheckName(txtMaDuongDat.Text, HoatDong.IDTram, cmbDuongDay.Value + ""))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã trạm không được trùng');", true); return;
}
CBDN.DM_Tram qtCT = db.DM_Trams.Single(x => x.IDTram == HoatDong.IDTram);
//foreach (var qtCT in lst)
//{
qtCT.IDMaDviQly = cn.IDMADVIQLY;
qtCT.MaTram = txtMaDuongDat.Text;
qtCT.TenTram = txtTenDuongDay.Text;
qtCT.MoTa = txtmoTa.Text;
qtCT.DiaDiem = "";
//qtCT.ParentId = int.Parse(TreeListOrganization.FocusedNode.Key + "");
qtCT.IsLo = int.Parse("" + cmbTinhChat.Value);
if (cmbDuongDay.Value + "" != "")
{
qtCT.IDChiNhanh = cmbDuongDay.Value + "";
}
else
{
qtCT.IDChiNhanh = "";
qtCT.IDDuongDay = 0;
}
if (CkHoatDong.Checked)
{
qtCT.HoatDong = 1;
}
else
{
qtCT.HoatDong = 0;
}
db.SubmitChanges();
}
else
{
if (!CheckName(txtMaDuongDat.Text, 0, cmbDuongDay.Value + ""))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã trạm không được trùng');", true); return;
}
//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 = txtMaDuongDat.Text;
cv.IDMaDviQly = cn.IDMADVIQLY;
cv.TenTram = txtTenDuongDay.Text;
cv.MoTa = txtmoTa.Text;
cv.TinhChatDD = int.Parse(cmbTinhChat.Value + "");
cv.DiaDiem = "";
if (cmbDuongDay.Value + "" != "")
{
cv.IDDuongDay = cn.ID;
cv.IDChiNhanh = cn.ID + "";
}
else
{
cv.IDDuongDay = 0;
cv.IDChiNhanh = "";
}
if (CkHoatDong.Checked)
{
cv.HoatDong = 1;
}
else
{
cv.HoatDong = 0;
}
cv.ParentId = int.Parse(TreeListOrganization.FocusedNode.Key + "");
cv.IsLo = int.Parse("" + cmbTinhChat.Value);
cv.MaDVNhap = int.Parse(session.User.ma_dviqly);
db.DM_Trams.InsertOnSubmit(cv);
db.SubmitChanges();
//}
}
pcAddRoles.ShowOnPageLoad = false;
_DataBind();
}
protected void btnXacNhan_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 chinhanh = db.DM_ChiNhanhs.SingleOrDefault(x => x.ID == int.Parse(tlDonVi.FocusedNode.Key));
var congto = db.DM_CongTos.Where(x => x.IDChiNhanh == cmbPhuongThuc.Value + "");
int dvGiao = 0, idDVNhan = 0;
CBDN.DM_CongTo cto = new CBDN.DM_CongTo();
foreach (var ct in congto)
{
cto = ct;
break;
}
dvGiao = (int)cto.IDDonViGiao;
idDVNhan = (int)cto.IDDonViNhan;
var gdXN = db.HD_GiamDocXNGiaoNhans.SingleOrDefault(x => x.IDChiNhanh == cto.IDChiNhanh + "" && x.Thang == int.Parse(cmbThang.Value + "") && x.Nam == int.Parse(cmbNam.Value + ""));
if (gdXN == null)
{
CBDN.HD_GiamDocXNGiaoNhan gd = new CBDN.HD_GiamDocXNGiaoNhan();
gd.IDChiNhanh = cto.IDChiNhanh + "";
if (dvGiao == ma_dviqly)
{
gd.IDGDGXN = ma_dviqly;
gd.ISGDGXN = true;
gd.NgayGDGXN = DateTime.Now;
gd.IDUserGiaoXN = session.User.IDUSER;
}
else if (idDVNhan == ma_dviqly)
{
gd.IDGDNXN = ma_dviqly;
gd.ISGDNXN = true;
gd.NgayGDNXN = DateTime.Now;
gd.IDUserNhanXN = session.User.IDUSER;
}
gd.Thang = int.Parse("" + cmbThang.Value);
gd.Nam = int.Parse("" + cmbNam.Value);
db.HD_GiamDocXNGiaoNhans.InsertOnSubmit(gd);
db.SubmitChanges();
}
else
{
if (dvGiao == ma_dviqly)
{
gdXN.IDGDGXN = ma_dviqly;
gdXN.ISGDGXN = true;
gdXN.NgayGDGXN = DateTime.Now;
gdXN.IDUserGiaoXN = session.User.IDUSER;
}
else if (idDVNhan == ma_dviqly)
{
gdXN.IDGDNXN = ma_dviqly;
gdXN.ISGDNXN = true;
gdXN.NgayGDNXN = DateTime.Now;
gdXN.IDUserNhanXN = session.User.IDUSER;
}
db.SubmitChanges();
}
InTongHopDienNang();
}
protected void btnDuyet_Click(object sender, EventArgs e)
{
//List<Object> keyvalues = grdNhan.GetSelectedFieldValues("ID");
//if (keyvalues.Count == 0)
//{
// ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Bạn chưa chọn dữ liệu để xác nhận.');", true);
// return;
//}
//pcFileKy.ShowOnPageLoad = true;
MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"];
string strMadviqly = session.User.ma_dviqly;
if (int.Parse(cmbPhuongThuc.Value + "") == 0)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Không thể xác nhận khi Phương thức giao nhận là: Tất Cả');", true);
return;
}
try
{
List <Object> keyvalues = grdNhan.GetSelectedFieldValues("ID");
if (keyvalues.Count == 0)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Bạn chưa chọn dữ liệu để xác nhận.');", true);
return;
}
//Lưu file ký
// UploadFile();
var ky = db.HD_ThongTinKies.SingleOrDefault(x => x.IDChinhNhanh == int.Parse(cmbPhuongThuc.Value + "") && x.Nam == int.Parse(cmbNam.Value + "") && x.Thang == int.Parse(cmbThang.Value + "") && x.IDMaDViQLy == int.Parse(strMadviqly) && x.ChucVu == 1 && x.TrangThai == null);
if (ky == null)
{
CBDN.HD_ThongTinKy hDKyTH = new CBDN.HD_ThongTinKy();
hDKyTH.IDChinhNhanh = int.Parse(cmbPhuongThuc.Value + "");
hDKyTH.NgayTao = DateTime.Now;
hDKyTH.NguoiTao = session.User.IDUSER;
hDKyTH.Link = "";
hDKyTH.Barcode = "";
hDKyTH.Thang = int.Parse(cmbThang.Value + "");
hDKyTH.Nam = int.Parse(cmbNam.Value + "");
hDKyTH.IDMaDViQLy = int.Parse(strMadviqly);
//Nhan viên
hDKyTH.ChucVu = 1;
db.HD_ThongTinKies.InsertOnSubmit(hDKyTH);
db.SubmitChanges();
}
if (grdNhan.Selection.Count == 0)
{
return;
}
// List<Object> temp = new List<Object>();
foreach (object key in keyvalues)
{
var bd_chitiet = db.HD_GiaoNhanThangs.SingleOrDefault(x => x.ID == int.Parse(key + ""));
bd_chitiet.ISNhanVien = true;
bd_chitiet.IDUseNhanVienXN = session.User.IDUSER;
bd_chitiet.DateNhanVienXN = DateTime.Now;
db.SubmitChanges();
}
loadTax();
pcAddRoles.ShowOnPageLoad = false;
pcFileKy.ShowOnPageLoad = false;
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Lỗi duyệt chấm nợ " + ex.Message + "');", true);
}
}
protected void btnDuyet_Click(object sender, EventArgs e)
{
try
{
int Nam = DateTime.Now.Year; int thang = DateTime.Now.Month - 1;
int sosanh = DateTime.Now.Month - 1 - int.Parse(cmbThang.Value + "");
if (DateTime.Now.Month == 1)
{
Nam = DateTime.Now.Year - 1;
thang = 12;
sosanh = DateTime.Now.Month + 11 - int.Parse(cmbThang.Value + "");
}
if (DateTime.Now.Month == 2 && cmbThang.Value + "" != "1" && DateTime.Now.Year < int.Parse(cmbNam.Value + ""))
{
sosanh = DateTime.Now.Month + 10 - int.Parse(cmbThang.Value + "");
}
DateTime dtkiemtra = new DateTime(Nam, thang, 28);
DateTime ngaytra = new DateTime(int.Parse(cmbNam.Value.ToString()), int.Parse(cmbThang.Value.ToString()), DateTime.Now.Day);
TimeSpan Time = ngaytra - dtkiemtra;
DateTime dtHT = new DateTime(Nam, thang, DateTime.Now.Day);
if (ngaytra > dtHT)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Chưa đến 28 bạn chưa thể chốt số liệu!');", true);
return;
}
if (Time.Days < 0 && sosanh <= 0 && DateTime.Now.Year <= int.Parse(cmbNam.Value + ""))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Chưa đến 28 bạn chưa thể chốt số liệu!');", true);
return;
}
//return;
MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"];
int strMadviqly = int.Parse(session.User.ma_dviqly);
int thangTT = 0, namTT = 0;
if (int.Parse("" + cmbThang.Value) == 12)
{
namTT = int.Parse("" + cmbNam.Value) + 1;
thangTT = 1;
}
else
{
namTT = int.Parse("" + cmbNam.Value);
thangTT = int.Parse("" + cmbThang.Value) + 1;
}
db.ChotSoLieu(strMadviqly, int.Parse(cmbThang.Value + ""), int.Parse(cmbNam.Value + ""), thangTT, namTT);
CBDN.HD_DonViChotThang chotthang = new CBDN.HD_DonViChotThang();
chotthang.IDMADVIQLY = strMadviqly;
chotthang.IDUser = session.User.IDUSER;
chotthang.Nam = int.Parse("" + cmbNam.Value);
chotthang.Thang = int.Parse("" + cmbThang.Value);
chotthang.NgayChot = DateTime.Now;
db.HD_DonViChotThangs.InsertOnSubmit(chotthang);
db.SubmitChanges();
LoadGrdGiao();
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Chốt số liệu thành công!');", true);
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Lỗi duyệt chấm nợ " + ex.Message + "');", 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 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)
{
MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"];
string strMadviqly = session.User.ma_dviqly;
var lstNhan = db.db_DSDiemNhanCanXacNhan(int.Parse(strMadviqly), int.Parse(cmbThang.Value + ""), int.Parse(cmbNam.Value + ""), int.Parse(cmbPhuongThuc.Value + "")).ToList();
foreach (var a in lstNhan)
{
var bd_chitiet = db.HD_GiaoNhanThangs.SingleOrDefault(x => x.ID == a.ID);
bd_chitiet.XacNhanDVNhan = false;
bd_chitiet.ISChot = false;
bd_chitiet.IDXacNhanNhan = int.Parse(strMadviqly);
bd_chitiet.NgayXacNhanDVNhan = DateTime.Now;
if (int.Parse(strMadviqly) == 2)
{
bd_chitiet.ISNhanVien = false;
}
if (txtLyDo.Text != "")
{
bd_chitiet.GhiChuXacNhanNhan = txtLyDo.Text;
}
else
{
bd_chitiet.GhiChuXacNhanNhan = "Không đồng ý xác nhận điểm đo này";
}
db.SubmitChanges();
}
var lstGiao = db.db_DSDiemGiaoCanXacNhan(int.Parse(strMadviqly), int.Parse(cmbThang.Value + ""), int.Parse(cmbNam.Value + ""), int.Parse(cmbPhuongThuc.Value + "")).ToList();
foreach (var a in lstGiao)
{
var bd_chitiet = db.HD_GiaoNhanThangs.SingleOrDefault(x => x.ID == a.ID);
bd_chitiet.XacNhanDVGiao = false;
bd_chitiet.IDXacNhanGiao = int.Parse(strMadviqly);
bd_chitiet.NgayXacNhanDVGiao = DateTime.Now;
bd_chitiet.ISChot = false;
if (int.Parse(strMadviqly) == 2)
{
bd_chitiet.ISNhanVien = false;
}
if (txtLyDo.Text != "")
{
bd_chitiet.GhiChuXacNhanGiao = txtLyDo.Text;
}
else
{
bd_chitiet.GhiChuXacNhanGiao = "Không đồng ý xác nhận điểm đo này";
}
db.SubmitChanges();
}
huyxacnhanky();
LoadGrdGiao();
LoadGrdNhan();
pcAddRoles.ShowOnPageLoad = false;
}
protected void btnCapNhat_Click(object sender, EventArgs e)
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
if (txtMaDuongDat.Text + "" == "")
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã Điểm đo không được để trống');", true);
txtMaDuongDat.Focus(); return;
}
if (txtTenDuongDay.Text == "")
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Tên Điểm đo không được để trống');", true);
txtTenDuongDay.Focus(); return;
}
string madviNhap = db.DM_DVQLies.SingleOrDefault(x => x.IDMA_DVIQLY == int.Parse(session.User.ma_dviqly)).MA_DVIQLY;
if (madviNhap.Length == 2)
{
if (madviNhap.Substring(0, 2) != txtMaDuongDat.Text.Substring(0, 2))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã điểm đo không trùng mã đơn vị quản lý đăng nhập. Bạn ko thể quản lý điểm đo này');", true);
txtMaDuongDat.Focus();
return;
}
}
else if (madviNhap.Substring(0, 4) != txtMaDuongDat.Text.Substring(0, 4))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã điểm đo không trùng mã đơn vị quản lý đăng nhập. Bạn ko thể quản lý điểm đo này');", true);
txtMaDuongDat.Focus();
return;
}
if (Session["Add"] + "" == "0")
{
CBDN.DM_DiemDoSelectByIDDViResult cv = (CBDN.DM_DiemDoSelectByIDDViResult)grdCN.GetRow(grdCN.FocusedRowIndex);
//var lst = db.DM_DiemDos.Where(x => x.MaDiemDo == cv.MaDiemDo && x.MaDviNhap == int.Parse(session.User.ma_dviqly) && x.IDTram == cv.IDTram && x.IDChiNhanh == cv.IDChiNhanh).ToList();
CBDN.DM_DiemDo qtCT = db.DM_DiemDos.SingleOrDefault(x => x.IDDiemDo == cv.IDDiemDo);
//foreach (var qtCT in lst)
//{
if (!CheckName(txtMaDuongDat.Text, cv.IDDiemDo, cv.IDTram, cv.IDChiNhanh))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã Điểm đo không được trùng');", true); return;
}
//CBDN.DM_DiemDo qtCT = new CBDN.DM_DiemDo();
qtCT.MaDiemDo = txtMaDuongDat.Text;
if (cmbLoaiDD.Value + "" == "4")
{
qtCT.TinhChatDD = 8;
}
else
{
qtCT.TinhChatDD = int.Parse(cmbTinhChat.Value + "");
}
qtCT.ISLoaiDD = int.Parse(cmbLoaiDD.Value + "");
qtCT.TenDiemDo = txtTenDuongDay.Text;
qtCT.MoTa = txtmoTa.Text;
if (CkHoatDong.Checked)
{
qtCT.HoatDong = 1;
}
else
{
qtCT.HoatDong = 0;
}
db.SubmitChanges();
//}
}
else
{
var tr = db.DM_Trams.SingleOrDefault(x => x.IDTram == int.Parse(tlMucTin.FocusedNode.Key) && x.IDMaDviQly.Contains("," + session.User.ma_dviqly + ","));
if (!CheckName(txtMaDuongDat.Text, 0, tr.IDTram + "", tr.IDChiNhanh + ""))
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Mã Điểm đo không được trùng');", true); return;
}
//var lst = db.DM_Trams.Where(x => x.MaTram == cmbTram.Value + "" && x.MaDVNhap == int.Parse(session.User.ma_dviqly)).ToList();
//foreach (var tr in lst)
//{
CBDN.DM_DiemDo cv = new CBDN.DM_DiemDo();
cv.MaDiemDo = txtMaDuongDat.Text;
cv.IDMaDViQly = tr.IDMaDviQly;
cv.TenDiemDo = txtTenDuongDay.Text;
cv.MoTa = txtmoTa.Text;
cv.IDChiNhanh = tr.IDChiNhanh;
cv.IDTram = tr.IDTram + "";
if (cmbLoaiDD.Value + "" == "4")
{
cv.TinhChatDD = 8;
}
else
{
cv.TinhChatDD = int.Parse(cmbTinhChat.Value + "");
}
cv.ISLoaiDD = int.Parse(cmbLoaiDD.Value + "");
if (CkHoatDong.Checked)
{
cv.HoatDong = 1;
}
else
{
cv.HoatDong = 0;
}
cv.MaDviNhap = int.Parse(session.User.ma_dviqly);
db.DM_DiemDos.InsertOnSubmit(cv);
db.SubmitChanges();
//}
}
loadKH();
pcAddRoles.ShowOnPageLoad = false;
}
protected void btnXuatFile_Click(object sender, EventArgs e)
{
if (rdImportDuLieu.SelectedIndex == 0)
{
try
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
string strMadviqly = session.User.ma_dviqly;
DataSet dsTem = new DataSet();
DataAccess.dbGCS dataA = new DataAccess.dbGCS();
//MemoryStream memStream = new MemoryStream();
//Stream file = Server.MapPath("~/") + "FileGCSCMIS\\" + UploadFile();
//using (Stream s = file.PostedFile.InputStream)
//{
// s.CopyTo(memStream);
//}
dsTem.ReadXml(Server.MapPath("~/") + "FileGCSCMIS\\" + UploadFile(), XmlReadMode.InferSchema);
for (int i = 0; i < dsTem.Tables[0].Rows.Count; i++)
{
CBDN.CMIS_DDoGC ddo = new CBDN.CMIS_DDoGC();
CBDN.CMIS_DDoGC kiemtraDDo = new CBDN.CMIS_DDoGC();
kiemtraDDo = dbSQL.CMIS_DDoGCs.SingleOrDefault(x => x.MA_DVIQLY == dsTem.Tables[0].Rows[i]["MA_DVIQLY"] + "" && x.MA_DDO == dsTem.Tables[0].Rows[i]["MA_DDO"] + "" && x.THANG == int.Parse(dsTem.Tables[0].Rows[i]["THANG"] + "") && x.NAM == int.Parse(dsTem.Tables[0].Rows[i]["NAM"] + "") && x.LOAI_BCS == dsTem.Tables[0].Rows[i]["LOAI_BCS"] + "");
if (kiemtraDDo == null)
{
ddo.MA_NVGCS = dsTem.Tables[0].Rows[i]["MA_NVGCS"] + "";
ddo.BOCSO_ID = dsTem.Tables[0].Rows[i]["BOCSO_ID"] + "";
ddo.CHUOI_GIA = dsTem.Tables[0].Rows[i]["CHUOI_GIA"] + "";
ddo.CS_CU = decimal.Parse(dsTem.Tables[0].Rows[i]["CS_CU"] + "");
ddo.CS_MOI = decimal.Parse(dsTem.Tables[0].Rows[i]["CS_MOI"] + "");
ddo.DIA_CHI = dsTem.Tables[0].Rows[i]["DIA_CHI"] + "";
ddo.HSN = decimal.Parse(dsTem.Tables[0].Rows[i]["HSN"] + "");
ddo.KIMUA_CSPK = decimal.Parse(dsTem.Tables[0].Rows[i]["KIMUA_CSPK"] + "");
ddo.KY = int.Parse(dsTem.Tables[0].Rows[i]["KY"] + "");
ddo.LOAI_BCS = dsTem.Tables[0].Rows[i]["LOAI_BCS"] + "";
ddo.LOAI_CS = dsTem.Tables[0].Rows[i]["LOAI_CS"] + "";
ddo.MA_CNANG = "";
ddo.MA_COT = dsTem.Tables[0].Rows[i]["MA_COT"] + "";
ddo.MA_CTO = dsTem.Tables[0].Rows[i]["MA_CTO"] + "";
ddo.MA_DDO = dsTem.Tables[0].Rows[i]["MA_DDO"] + "";
ddo.MA_DVIQLY = dsTem.Tables[0].Rows[i]["MA_DVIQLY"] + "";
ddo.MA_GC = dsTem.Tables[0].Rows[i]["MA_GC"] + "";
ddo.MA_KHANG = dsTem.Tables[0].Rows[i]["MA_KHANG"] + "";
ddo.MA_NVGCS = dsTem.Tables[0].Rows[i]["MA_NVGCS"] + "";
ddo.MA_NVIEN = "";
ddo.MA_SOGCS = dsTem.Tables[0].Rows[i]["MA_QUYEN"] + "";
ddo.MA_TRAM = dsTem.Tables[0].Rows[i]["MA_TRAM"] + "";
ddo.NAM = int.Parse(dsTem.Tables[0].Rows[i]["NAM"] + "");
ddo.NGAY_CU = DateTime.Parse(dsTem.Tables[0].Rows[i]["NGAY_CU"] + "");
ddo.NGAY_MOI = DateTime.Parse(dsTem.Tables[0].Rows[i]["NGAY_MOI"] + "");
ddo.NGAY_PMAX = DateTime.Parse(dsTem.Tables[0].Rows[i]["NGAY_PMAX"] + "");
ddo.NGUOI_GCS = dsTem.Tables[0].Rows[i]["NGUOI_GCS"] + "";
ddo.PMAX = decimal.Parse(dsTem.Tables[0].Rows[i]["PMAX"] + "");
ddo.SERY_CTO = dsTem.Tables[0].Rows[i]["SERY_CTO"] + "";
ddo.SL_MOI = decimal.Parse(dsTem.Tables[0].Rows[i]["SL_MOI"] + "");
ddo.SL_THAO = decimal.Parse(dsTem.Tables[0].Rows[i]["SL_THAO"] + "");
ddo.SL_TTIEP = decimal.Parse(dsTem.Tables[0].Rows[i]["SL_TTIEP"] + "");
ddo.SLUONG_1 = decimal.Parse(dsTem.Tables[0].Rows[i]["SLUONG_1"] + "");
ddo.SLUONG_2 = decimal.Parse(dsTem.Tables[0].Rows[i]["SLUONG_2"] + "");
ddo.SLUONG_3 = decimal.Parse(dsTem.Tables[0].Rows[i]["SLUONG_3"] + "");
ddo.SO_HO = Convert.ToInt32(Convert.ToDecimal(dsTem.Tables[0].Rows[i]["SO_HO"] + ""));
ddo.SO_HOM = dsTem.Tables[0].Rows[i]["SO_HOM"] + "";
ddo.TEN_KHANG = dsTem.Tables[0].Rows[i]["TEN_KHANG"] + "";
ddo.THANG = int.Parse(dsTem.Tables[0].Rows[i]["THANG"] + "");
ddo.TTR_CU = dsTem.Tables[0].Rows[i]["TTR_MOI"] + "";
ddo.TENFILE = fileUp.FileName;
dbSQL.CMIS_DDoGCs.InsertOnSubmit(ddo);
dbSQL.SubmitChanges();
}
}
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Nhận dữ liệu thành công');", true);
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Lỗi nhận dữ liệu: " + ex.Message + "');", true);
}
}
else
{
SYS_Session session = (SYS_Session)Session["SYS_Session"];
string strMadviqly = session.User.ma_dviqly;
DM_DVQLYService _DM_DVQLY = new DM_DVQLYService();
var dv = _DM_DVQLY.SelectDM_DVQLY(int.Parse(strMadviqly));
var lst = dbSQL.CMIS_DDoGCs.Where(x => x.MA_DVIQLY == dv.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + ""));
foreach (var ddo in lst)
{
var diemdo = dbSQL.DM_DiemDos.SingleOrDefault(x => x.MaDiemDo == ddo.MA_DDO && x.HoatDong == 1);
if (diemdo == null)
{
continue;
}
var kiemtra = dbSQL.DM_CongTos.SingleOrDefault(x => x.IDDiemDo == diemdo.IDDiemDo + "" && x.TinhTrang == 1);
if (kiemtra == null)
{
continue;
}
var hhddo = dbSQL.HD_GiaoNhanThangs.SingleOrDefault(x => x.IDCongTo == kiemtra.IDCongTo + "" && x.Thang == int.Parse(cmbThang.Value + "") && x.Nam == int.Parse(cmbNam.Value + ""));
if (hhddo == null)
{
continue;
}
if (ddo.LOAI_BCS == "BT")
{
var diemdocmis = dbSQL.CMIS_DDoGCs.SingleOrDefault(x => x.MA_DVIQLY == dv.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + "") && x.MA_DDO == diemdo.MaDiemDo && x.LOAI_BCS == "BT");
diemdocmis.CS_MOI = hhddo.Giao_Bieu1_Cuoi;
diemdocmis.SL_MOI = hhddo.Giao_Bieu1_SanLuong;
diemdocmis.TrangThaiDongBo = 1;
dbSQL.SubmitChanges();
}
else if (ddo.LOAI_BCS == "CD")
{
var diemdocmis = dbSQL.CMIS_DDoGCs.SingleOrDefault(x => x.MA_DVIQLY == dv.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + "") && x.MA_DDO == diemdo.MaDiemDo && x.LOAI_BCS == "CD");
diemdocmis.CS_MOI = hhddo.Giao_Bieu2_Cuoi;
diemdocmis.SL_MOI = hhddo.Giao_Bieu2_SanLuong;
diemdocmis.TrangThaiDongBo = 1;
dbSQL.SubmitChanges();
}
else if (ddo.LOAI_BCS == "TD")
{
var diemdocmis = dbSQL.CMIS_DDoGCs.SingleOrDefault(x => x.MA_DVIQLY == dv.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + "") && x.MA_DDO == diemdo.MaDiemDo && x.LOAI_BCS == "TD");
diemdocmis.CS_MOI = hhddo.Giao_Bieu3_Cuoi;
diemdocmis.SL_MOI = hhddo.Giao_Bieu3_SanLuong;
diemdocmis.TrangThaiDongBo = 1;
dbSQL.SubmitChanges();
}
else if (ddo.LOAI_BCS == "VC")
{
var diemdocmis = dbSQL.CMIS_DDoGCs.SingleOrDefault(x => x.MA_DVIQLY == dv.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + "") && x.MA_DDO == diemdo.MaDiemDo && x.LOAI_BCS == "VC");
diemdocmis.CS_MOI = hhddo.Giao_Q_Cuoi;
diemdocmis.SL_MOI = hhddo.Giao_Q_SanLuong;
diemdocmis.TrangThaiDongBo = 1;
dbSQL.SubmitChanges();
}
if (ddo.LOAI_BCS == "BN")
{
var diemdocmis = dbSQL.CMIS_DDoGCs.SingleOrDefault(x => x.MA_DVIQLY == dv.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + "") && x.MA_DDO == diemdo.MaDiemDo && x.LOAI_BCS == "BN");
diemdocmis.CS_MOI = hhddo.Nhan_Bieu1_Cuoi;
diemdocmis.SL_MOI = hhddo.Nhan_Bieu1_SanLuong;
diemdocmis.TrangThaiDongBo = 1;
dbSQL.SubmitChanges();
}
else if (ddo.LOAI_BCS == "CN")
{
var diemdocmis = dbSQL.CMIS_DDoGCs.SingleOrDefault(x => x.MA_DVIQLY == dv.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + "") && x.MA_DDO == diemdo.MaDiemDo && x.LOAI_BCS == "CN");
diemdocmis.CS_MOI = hhddo.Nhan_Bieu2_Cuoi;
diemdocmis.SL_MOI = hhddo.Nhan_Bieu2_SanLuong;
diemdocmis.TrangThaiDongBo = 1;
dbSQL.SubmitChanges();
}
else if (ddo.LOAI_BCS == "TN")
{
var diemdocmis = dbSQL.CMIS_DDoGCs.SingleOrDefault(x => x.MA_DVIQLY == dv.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + "") && x.MA_DDO == diemdo.MaDiemDo && x.LOAI_BCS == "TN");
diemdocmis.CS_MOI = hhddo.Nhan_Bieu3_Cuoi;
diemdocmis.SL_MOI = hhddo.Nhan_Bieu3_SanLuong;
diemdocmis.TrangThaiDongBo = 1;
dbSQL.SubmitChanges();
}
else if (ddo.LOAI_BCS == "VN")
{
var diemdocmis = dbSQL.CMIS_DDoGCs.SingleOrDefault(x => x.MA_DVIQLY == dv.MA_DVIQLY && x.THANG == int.Parse(cmbThang.Value + "") && x.NAM == int.Parse(cmbNam.Value + "") && x.MA_DDO == diemdo.MaDiemDo && x.LOAI_BCS == "VN");
diemdocmis.CS_MOI = hhddo.Nhan_Q_Cuoi;
diemdocmis.SL_MOI = hhddo.Nhan_Q_SanLuong;
diemdocmis.TrangThaiDongBo = 1;
dbSQL.SubmitChanges();
}
}
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Đồng bộ số liệu thành công');", true);
loadDLDongBo();
}
}
private void kySo(string TenFile)
{
MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"];
var userky = db.DM_USERs.SingleOrDefault(x => x.IDUSER == session.User.IDUSER);
if (userky.NguoiKy != txtTenNguoiKy.Text)
{
userky.HOTEN = txtHoTenNguoiKy.Text;
userky.NguoiKy = txtTenNguoiKy.Text;
db.SubmitChanges();
}
// thong tin thoi gian ký
var isKy = db.HD_ThongTinKies.SingleOrDefault(x => x.IDChinhNhanh == int.Parse(cmbPhuongThuc.Value + "") && x.Nam == int.Parse(cmbNam.Value + "") && x.Thang == int.Parse(cmbThang.Value + "") && x.Link.Contains(cmbPhuongThuc.Value + "_" + cmbThang.Value + "_" + cmbNam.Value + "_QT.pdf"));
if (isKy != null)
{
isKy.Barcode = isKy.Barcode + "GD_" + session.User.ma_dviqly + "_" + txtHoTenNguoiKy.Text + "_" + DateTime.Now + ";";
}
string strSerial = "";
string strAlias = txtTenNguoiKy.Text;
string strUrl = "http://10.0.0.146:8080/SignServerWSService?wsdl";
string strFileName = TenFile;
string strSaveTo = TenFile;
string strAppCode = "cmis";
string strPassword = "******";
string strHashAlogrithm = "SHA-1";
//string strInt = txtInt.Text;
CBDN.ServerSignWS.signFileResponceBO signBO = null;
try
{
var cn = db.DM_ChiNhanhs.SingleOrDefault(x => x.ID == int.Parse(cmbPhuongThuc.Value + ""));
float Trai = 0, Phai = 0, Tren = 0, Duoi = 0;
if (cn.IDMADVIQLY.Contains(",2,"))
{
if (session.User.MA_DVIQLY != cn.DiemDauNguon + "")
{
//giao trái (ngược lại với tổng công ty)
Tren = 70;
Duoi = 300;
Phai = 410;
Trai = 80;
}
else
{
//nhan phải
Tren = 70;
Duoi = 300;
Phai = 140;
Trai = 360;
}
}
else
{
if (session.User.MA_DVIQLY != cn.DiemDauNguon + "")
{
//nhan phải
Tren = 70;
Duoi = 300;
Phai = 140;
Trai = 360;
}
else
{
//giao trái (ngược lại với tổng công ty)
Tren = 70;
Duoi = 300;
Phai = 410;
Trai = 80;
}
}
byte[] AsBytes = File.ReadAllBytes(strFileName);
string AsBase64String = Convert.ToBase64String(AsBytes);
//byte[] tempBytes = Convert.FromBase64String(AsBase64String);
CBDN.ServerSignWS.SignServerWSService ser = new CBDN.ServerSignWS.SignServerWSService();
//ser.Url = strUrl;
#region Display
CBDN.ServerSignWS.displayRectangleTextConfigBO dspRec = new CBDN.ServerSignWS.displayRectangleTextConfigBO();
dspRec.numberPageSign = DisplayConfigConsts.NUMBER_PAGE_SIGN_DEFAULT;
dspRec.widthRectangle = DisplayConfigConsts.WIDTH_RECTANGLE_DEFAULT;
dspRec.heightRectangle = DisplayConfigConsts.HEIGHT_RECTANGLE_DEFAULT;
dspRec.locateSign = DisplayConfigConsts.LOCATE_SIGN_DEFAULT;
dspRec.marginTopOfRectangle = Tren;
dspRec.marginBottomOfRectangle = Duoi;
dspRec.marginRightOfRectangle = Phai;
dspRec.marginLeftOfRectangle = Trai;
dspRec.displayText = DisplayConfigConsts.DISPLAY_TEXT_DEFAULT_EMPTY;
dspRec.formatRectangleText = DisplayConfigConsts.FORMAT_RECTANGLE_TEXT_DEFAULT;
dspRec.contact = DisplayConfigConsts.CONTACT_DEFAULT_EMPTY;
dspRec.reason = DisplayConfigConsts.REASON_DEFAULT_EMPTY;
dspRec.location = DisplayConfigConsts.LOCATION_DEFAULT_EMPTY;
dspRec.dateFormatString = DisplayConfigConsts.DATE_FORMAT_STRING_DEFAULT;
dspRec.fontPath = DisplayConfigConsts.FONT_PATH_DEFAULT;
dspRec.sizeFont = DisplayConfigConsts.SIZE_FONT_DEFAULT;
dspRec.organizationUnit = DisplayConfigConsts.ORGANIZATION_UNIT_DEFAULT_EMPTY;
dspRec.organization = DisplayConfigConsts.ORGANIZATION_DEFAULT_EMPTY;
dspRec.signDate = DateTime.Now;
#endregion
CBDN.ServerSignWS.timestampConfig timestamp = new CBDN.ServerSignWS.timestampConfig();
timestamp.useTimestamp = false;
signBO = ser.signPdfBase64RectangleText(strAppCode, strPassword, strSerial, strAlias, AsBase64String, strHashAlogrithm, dspRec, timestamp);
string strOutput = signBO.signedFileBase64;
byte[] tempBytes = Convert.FromBase64String(strOutput);
try
{
File.WriteAllBytes(strSaveTo, tempBytes);
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Ký số thành công');", true);
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Lỗi duyệt chấm nợ " + ex.Message + "');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('Lỗi duyệt chấm nợ " + ex.Message + "');", true);
}
}
