private void xacnhanky()
{
MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"];
string strMadviqly = session.User.ma_dviqly;
var dv = db.DM_DVQLies.SingleOrDefault(x => x.IDMA_DVIQLY == int.Parse(strMadviqly));
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 == 2 && x.TrangThai == null);
if (ky != null)
{
return;
}
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);
//TruongPhong
hDKyTH.ChucVu = 2;
db.HD_ThongTinKies.InsertOnSubmit(hDKyTH);
db.SubmitChanges();
}
public string UploadFile()
{
MTCSYT.SYS_Session session = (MTCSYT.SYS_Session)Session["SYS_Session"];
string strTenFile = "";
try
{
//file tổng hợp
strTenFile = cmbPhuongThuc.Value + "_" + cmbThang.Value + "_" + cmbNam.Value + "_TH.pdf";
if (!Directory.Exists(Server.MapPath("~/") + "FileKy"))
{
Directory.CreateDirectory(Server.MapPath("~/") + "FileKy");
}
if (!File.Exists(Server.MapPath("~/") + "FileKy\\" + strTenFile))
{
fileUp.PostedFile.SaveAs(Server.MapPath("~/") + "FileKy\\" + strTenFile);
//strTenFile = fileUp.FileName;
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 = "http://10.21.0.135:8091/FileKy/" + strTenFile;
hDKyTH.Link = "http://10.21.3.75:8899//FileKy/" + strTenFile;
hDKyTH.Barcode = "";
hDKyTH.Thang = int.Parse(cmbThang.Value + "");
hDKyTH.Nam = int.Parse(cmbNam.Value + "");
db.HD_ThongTinKies.InsertOnSubmit(hDKyTH);
db.SubmitChanges();
}
//hdTenFile.Value = strTenFile;
// import file quyết toán
string strQT = cmbPhuongThuc.Value + "_" + cmbThang.Value + "_" + cmbNam.Value + "_QT.pdf";
if (!File.Exists(Server.MapPath("~/") + "FileKy\\" + strQT))
{
FileUpload1.PostedFile.SaveAs(Server.MapPath("~/") + "FileKy\\" + strQT);
//strTenFile = FileUpload1.FileName;
CBDN.HD_ThongTinKy hDKyQT = new CBDN.HD_ThongTinKy();
hDKyQT.IDChinhNhanh = int.Parse(cmbPhuongThuc.Value + "");
hDKyQT.NgayTao = DateTime.Now;
hDKyQT.NguoiTao = session.User.IDUSER;
// hDKyQT.Link = "http://10.21.0.135:8091/FileKy/"+strQT;
hDKyQT.Link = "http://10.21.3.75:8899/FileKy/" + strQT;
hDKyQT.Barcode = "";
hDKyQT.Thang = int.Parse(cmbThang.Value + "");
hDKyQT.Nam = int.Parse(cmbNam.Value + "");
db.HD_ThongTinKies.InsertOnSubmit(hDKyQT);
db.SubmitChanges();
}
//hdTenFile.Value = strTenFile;
}
catch (Exception exp)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('" + exp.Message + Server.MapPath("~/") + "BaoCao\\" + hdTenFile.Value + "');", true);
}
// ScriptManager.RegisterStartupScript(Page, Page.GetType(), "", "alert('" + strTenFile + "');", true);
return(strTenFile);
}
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);
}
}
