public virtual void Remove(CONG_NO b)
{
try
{
db.CONG_NOs.DeleteOnSubmit(b);
db.SubmitChanges();
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public virtual void Remove(int id)
{
try
{
CONG_NO b = this.GetById(id);
this.Remove(b);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public virtual void Create(CONG_NO cus)
{
try
{
this.db.CONG_NOs.InsertOnSubmit(cus);
db.SubmitChanges();
}
catch //(Exception e)
{
//throw new Exception(e.Message);
}
}
public virtual void Update(CONG_NO cus)
{
try
{
CONG_NO cusOld = this.GetById(cus.ID);
cusOld = cus;
db.SubmitChanges();
}
catch //(Exception e)
{
//throw new Exception(e.Message);
}
}
private bool DuplicateCongNo()
{
try
{
var _obj = db.PROFILE_NEWs.Where(n => n.ID == _id).Single();
if (_obj != null)
{
if (KiemTraMST())
{
var i = _CongNoData.GetByMST(_obj.PROF_TAXCODE.Trim());
i.TEN_KH = _obj.PROF_NAME;
i.DIEN_THOAI = _obj.PROF_PHONE;
i.EMAIL = _obj.PROF_EMAIL;
i.DIA_CHI = _obj.PROF_ADDRESS;
i.MST = _obj.PROF_TAXCODE;
i.NV_KT = _obj.USER_KT;
i.NV_KD = _obj.USER_NVKD;
i.NV_GN = _obj.USER_GN;
i.NAM = Utils.CIntDef(DateTime.Now.Year);
_CongNoData.Update(i);
}
else
{
CONG_NO i = new CONG_NO();
i.TEN_KH = _obj.PROF_NAME;
i.DIEN_THOAI = _obj.PROF_PHONE;
i.EMAIL = _obj.PROF_EMAIL;
i.DIA_CHI = _obj.PROF_ADDRESS;
i.MST = _obj.PROF_TAXCODE;
i.NV_KT = _obj.USER_KT;
i.NV_KD = _obj.USER_NVKD;
i.NV_GN = _obj.USER_GN;
i.DATE = DateTime.Now;
i.NAM = Utils.CIntDef(DateTime.Now.Year);
_CongNoData.Create(i);
}
}
return(true);
}
catch (Exception) { return(false); }
}
private void CreateCongNo()
{
List<object> fieldValues = ASPxGridView1_project.GetSelectedFieldValues(new string[] { "ID" });
if (fieldValues.Count > 0)
{
foreach (var item in fieldValues)
{
var obj = _MerHopDongDVData.GetById(Utils.CIntDef(item));
if (obj != null)
{
//Kiểm tra xem trạng thái đã Hoàn thành chưa
if (Utils.CIntDef(obj.MER_STATUS) == 3)
{
var objCheck = db.CONG_NOs.Where(u => u.MST == obj.MER_TAXCODE && u.NAM == Utils.CIntDef(obj.MER_POS05, 0)).ToList();
if (objCheck.Count == 0)
{
CONG_NO i = new CONG_NO();
i.TINH_TRANG = "---";
i.NAM = Utils.CIntDef(obj.MER_POS05, 0);
string _ngayHD = obj.MER_POS03 + "/" + obj.MER_POS04 + "/" + obj.MER_POS05;
i.NGAY_KY_HD = DateTime.ParseExact(_ngayHD, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
i.TEN_KH = obj.MER_NAME;
i.DIA_CHI = obj.MER_ADDRESS;
i.DIEN_THOAI = obj.MER_PHONE;
i.MST = obj.MER_TAXCODE;
i.EMAIL = obj.MER_EMAIL;
i.GIAM_DOC = obj.MER_REPRESENT;
i.PHI = obj.PHI_HANGTHANG;
i.NV_KD = obj.USER_ID;
if (Utils.CIntDef(obj.PHI_TU1_1) > 0 && Utils.CIntDef(obj.PHI_TU1_2) > 0)
{
i.BIEUPHI1_SL = obj.PHI_TU1_1 + "-" + obj.PHI_TU1_2;
i.BIEUPHI1_PHI = obj.PHI_HD1;
}
if (Utils.CIntDef(obj.PHI_TU2_1) > 0 && Utils.CIntDef(obj.PHI_TU2_2) > 0)
{
i.BIEUPHI2_SL = obj.PHI_TU2_1 + "-" + obj.PHI_TU2_2;
i.BIEUPHI2_PHI = obj.PHI_HD2;
}
if (Utils.CIntDef(obj.PHI_TU3_1) > 0 && Utils.CIntDef(obj.PHI_TU3_2) > 0)
{
i.BIEUPHI3_SL = obj.PHI_TU3_1 + "-" + obj.PHI_TU3_2;
i.BIEUPHI3_PHI = obj.PHI_HD3;
}
if (Utils.CIntDef(obj.PHI_TU4_1) > 0 && Utils.CIntDef(obj.PHI_TU4_2) > 0)
{
i.BIEUPHI4_SL = obj.PHI_TU4_1 + "-" + obj.PHI_TU4_2;
i.BIEUPHI4_PHI = obj.PHI_HD4;
}
if (Utils.CIntDef(obj.PHI_TU5_1) > 0 && Utils.CIntDef(obj.PHI_TU5_2) > 0)
{
i.BIEUPHI5_SL = obj.PHI_TU5_1 + "-" + obj.PHI_TU5_2;
i.BIEUPHI5_PHI = obj.PHI_HD5;
}
if (Utils.CIntDef(obj.PHI_TU6_1) > 0 && Utils.CIntDef(obj.PHI_TU6_2) > 0)
{
i.BIEUPHI6_SL = obj.PHI_TU6_1 + "-" + obj.PHI_TU6_2;
i.BIEUPHI6_PHI = obj.PHI_HD6;
}
if (Utils.CIntDef(obj.PHI_THEMPHI) > 0)
{
i.BIEUPHI_THEM = obj.PHI_THEMPHI;
}
i.THANG_BD_THU = obj.MER_BEGIN_M;
i.STT = _CongNoData.GetSTT(Utils.CIntDef(obj.MER_POS05)) + 1;
_CongNoData.Create(i);
db.SubmitChanges();
}
}
}
}
string strScript = "<script>";
strScript += "alert('Đã xử lý xong!');";
strScript += "window.location='danh-sach-hop-dong-ke-toan.aspx';";
strScript += "</script>";
Page.RegisterClientScriptBlock("strScript", strScript);
}
else {
string strScript = "<script>";
strScript += "alert('Xin chọn hợp đồng để cập nhật vào công nợ kế toán!');";
strScript += "</script>";
Page.RegisterClientScriptBlock("strScript", strScript);
}
}
private void Import_data()
{
try
{
if (fileUpload.HasFile == true)
{
string path = Server.MapPath("/File/ExcelFile/" + fileUpload.FileName);
fileUpload.SaveAs(path);
DataTable dt = getDataexcel(path);
int i = 0;
foreach (DataRow row in dt.Rows)
{
CONG_NO obj = new CONG_NO();
obj.STT = Utils.CIntDef(row[0].ToString().Trim());
obj.TEN_KH = row[1].ToString().Trim();
obj.MST = row[2].ToString().Trim();
obj.DIA_CHI = row[3].ToString().Trim();
obj.GIAM_DOC = row[5].ToString().Trim();
obj.DIEN_THOAI = row[6].ToString().Trim();
obj.EMAIL = row[7].ToString().Trim();
obj.THANG_BD_THU = row[8].ToString().Trim();
obj.NO_NAM_TRUOC = Utils.CIntDef(row[9].ToString().Replace(".", ""));
obj.PHI_DV_1 = Utils.CIntDef(row[10].ToString().Replace(".", ""));
obj.DA_TT1_1 = Utils.CIntDef(row[11].ToString().Replace(".", ""));
obj.NGAY_TT_1 = row[12].ToString().Trim();
obj.CON_NO_1 = Utils.CIntDef(row[13].ToString().Replace(".", ""));
obj.PHI_DV_2 = Utils.CIntDef(row[14].ToString().Replace(".", ""));
obj.DA_TT2_1 = Utils.CIntDef(row[15].ToString().Replace(".", ""));
obj.NGAY_TT_2 = row[16].ToString().Trim();
obj.CON_NO_2 = Utils.CIntDef(row[17].ToString().Replace(".", ""));
obj.PHI_DV_3 = Utils.CIntDef(row[18].ToString().Replace(".", ""));
obj.DA_TT3_1 = Utils.CIntDef(row[19].ToString().Replace(".", ""));
obj.NGAY_TT_3 = row[20].ToString().Trim();
obj.CON_NO_3 = Utils.CIntDef(row[21].ToString().Replace(".", ""));
obj.PHI_DV_4 = Utils.CIntDef(row[22].ToString().Replace(".", ""));
obj.DA_TT4_1 = Utils.CIntDef(row[23].ToString().Replace(".", ""));
obj.NGAY_TT_4 = row[24].ToString().Trim();
obj.CON_NO_4 = Utils.CIntDef(row[25].ToString().Replace(".", ""));
obj.PHI_DV_5 = Utils.CIntDef(row[26].ToString().Replace(".", ""));
obj.DA_TT5_1 = Utils.CIntDef(row[27].ToString().Replace(".", ""));
obj.NGAY_TT_5 = row[28].ToString().Trim();
obj.CON_NO_5 = Utils.CIntDef(row[29].ToString().Replace(".", ""));
obj.PHI_DV_6 = Utils.CIntDef(row[30].ToString().Replace(".", ""));
obj.DA_TT6_1 = Utils.CIntDef(row[31].ToString().Replace(".", ""));
obj.NGAY_TT_6 = row[32].ToString().Trim();
obj.CON_NO_6 = Utils.CIntDef(row[33].ToString().Replace(".", ""));
obj.PHI_DV_7 = Utils.CIntDef(row[34].ToString().Replace(".", ""));
obj.DA_TT7_1 = Utils.CIntDef(row[35].ToString().Replace(".", ""));
obj.NGAY_TT_7 = row[36].ToString().Trim();
obj.CON_NO_7 = Utils.CIntDef(row[37].ToString().Replace(".", ""));
obj.PHI_DV_8 = Utils.CIntDef(row[38].ToString().Replace(".", ""));
obj.DA_TT8_1 = Utils.CIntDef(row[39].ToString().Replace(".", ""));
obj.NGAY_TT_8 = row[40].ToString().Trim();
obj.CON_NO_8 = Utils.CIntDef(row[41].ToString().Replace(".", ""));
obj.PHI_DV_9 = Utils.CIntDef(row[42].ToString().Replace(".", ""));
obj.DA_TT9_1 = Utils.CIntDef(row[43].ToString().Replace(".", ""));
obj.NGAY_TT_9 = row[44].ToString().Trim();
obj.CON_NO_9 = Utils.CIntDef(row[45].ToString().Replace(".", ""));
obj.PHI_DV_10 = Utils.CIntDef(row[46].ToString().Replace(".", ""));
obj.DA_TT10_1 = Utils.CIntDef(row[47].ToString().Replace(".", ""));
obj.NGAY_TT_10 = row[48].ToString().Trim();
obj.CON_NO_10 = Utils.CIntDef(row[49].ToString().Replace(".", ""));
obj.PHI_DV_11 = Utils.CIntDef(row[50].ToString().Replace(".", ""));
obj.DA_TT11_1 = Utils.CIntDef(row[51].ToString().Replace(".", ""));
obj.NGAY_TT_11 = row[52].ToString().Trim();
obj.CON_NO_11 = Utils.CIntDef(row[53].ToString().Replace(".", ""));
obj.PHI_DV_12 = Utils.CIntDef(row[54].ToString().Replace(".", ""));
obj.DA_TT12_1 = Utils.CIntDef(row[55].ToString().Replace(".", ""));
obj.NGAY_TT_12 = row[56].ToString().Trim();
obj.CON_NO_12 = Utils.CIntDef(row[57].ToString().Replace(".", ""));
obj.PHI_DV_BCTC = Utils.CIntDef(row[58].ToString().Replace(".", ""));
obj.DA_TT13_1 = Utils.CIntDef(row[59].ToString().Replace(".", ""));
obj.NGAY_TT_BCTC = row[60].ToString().Trim();
obj.CON_NO_BCTC = Utils.CIntDef(row[61].ToString().Replace(".", ""));
obj.TONG_NO = Utils.CIntDef(row[62].ToString().Replace(".", ""));
obj.GHI_CHU = row[63].ToString().Trim();
obj.NAM = Utils.CIntDef(ddlNam.SelectedValue);
_ProjectData.Create(obj);
i++;
}
string strScript = "<script>";
strScript += "alert('Đã Import dữ liệu thành công');";
strScript += "window.location='danh-sach-cong-no.aspx';";
strScript += "</script>";
Page.RegisterClientScriptBlock("strScript", strScript);
}
else
{
string strScript = "<script>";
strScript += "alert('Xin chọn file để Import');";
strScript += "window.location='danh-sach-cong-no.aspx';";
strScript += "</script>";
Page.RegisterClientScriptBlock("strScript", strScript);
}
}
catch {
string strScript = "<script>";
strScript += "alert('Dữ liệu không khớp với hệ thống!');";
strScript += "window.location='danh-sach-cong-no.aspx';";
strScript += "</script>";
Page.RegisterClientScriptBlock("strScript", strScript);
}
}
public virtual void Remove(CONG_NO b)
{
try
{
db.CONG_NOs.DeleteOnSubmit(b);
db.SubmitChanges();
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public virtual void Update(CONG_NO cus)
{
try
{
CONG_NO cusOld = this.GetById(cus.ID);
cusOld = cus;
db.SubmitChanges();
}
catch //(Exception e)
{
//throw new Exception(e.Message);
}
}
public virtual void Create(CONG_NO cus)
{
try
{
this.db.CONG_NOs.InsertOnSubmit(cus);
db.SubmitChanges();
}
catch //(Exception e)
{
//throw new Exception(e.Message);
}
}
private bool DuplicateCongNo()
{
try
{
var _obj = db.PROFILE_NEWs.Where(n => n.ID == _id).Single();
if (_obj != null)
{
if (KiemTraMST())
{
var i = _CongNoData.GetByMST(_obj.PROF_TAXCODE.Trim());
i.TEN_KH = _obj.PROF_NAME;
i.DIEN_THOAI = _obj.PROF_PHONE;
i.EMAIL = _obj.PROF_EMAIL;
i.DIA_CHI = _obj.PROF_ADDRESS;
i.MST = _obj.PROF_TAXCODE;
i.NV_KT = _obj.USER_KT;
i.NV_KD = _obj.USER_NVKD;
i.NV_GN = _obj.USER_GN;
i.NAM = Utils.CIntDef(DateTime.Now.Year);
_CongNoData.Update(i);
}
else
{
CONG_NO i = new CONG_NO();
i.TEN_KH = _obj.PROF_NAME;
i.DIEN_THOAI = _obj.PROF_PHONE;
i.EMAIL = _obj.PROF_EMAIL;
i.DIA_CHI = _obj.PROF_ADDRESS;
i.MST = _obj.PROF_TAXCODE;
i.NV_KT = _obj.USER_KT;
i.NV_KD = _obj.USER_NVKD;
i.NV_GN = _obj.USER_GN;
i.DATE = DateTime.Now;
i.NAM = Utils.CIntDef(DateTime.Now.Year);
_CongNoData.Create(i);
}
}
return true;
}
catch (Exception) { return false; }
}
private int Save_Data(int year)
{
var obj = proj_data.GetByMSTYear(mst, year);
int temp = obj != null ? 1 : 0;//Nếu mst và năm chưa có thì thêm
if (id == 0 || temp == 0)
{
if (id != 0 && ddlNam.Enabled == false)
{
var i = db.CONG_NOs.Where(n => n.ID == id).Single();
i.TINH_TRANG = ddlTinhTrang.SelectedValue;
i.DATE_TINHTRANG = txtNgayBatDau.Text != "" ?
DateTime.ParseExact(txtNgayBatDau.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture) : i.DATE_TINHTRANG = null;
i.DATE_TINHTRANG1 = txtNgayKetThuc.Text != "" ?
DateTime.ParseExact(txtNgayKetThuc.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture) : i.DATE_TINHTRANG1 = null;
i.DATE_THANHLAP = txtNgayThanhLap.Text != "" ?
DateTime.ParseExact(txtNgayThanhLap.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture) : i.DATE_THANHLAP = null;
i.TEN_KH = txtTenKH.Text;
i.QL_THUE_CITY = Utils.CIntDef(ddlCity.SelectedValue);
i.QL_THUE_DIST = Utils.CIntDef(ddlDist.SelectedValue);
i.STT = Utils.CIntDef(txtSTT.Text);
i.NO_NAM_TRUOC = Utils.CIntDef(txtNoNamTruoc.Text.Replace(",", ""));
i.MST = txtMST.Text;
i.DIA_CHI = txtDiaChi1.Text;
i.GIAM_DOC = txtGiamDoc.Text;
i.DIEN_THOAI = txtDienThoai.Text;
i.EMAIL = txtEmail.Text;
i.PHI = Utils.CIntDef(txtPhi.Text.Replace(",", ""));
i.THANG_BD_THU = txtNgayThu.Text;
i.NV_KT = Utils.CIntDef(ddlNVKT.SelectedValue);
i.NV_KD = Utils.CIntDef(ddlNVKD.SelectedValue);
i.NV_GN = Utils.CIntDef(ddlNVGN.SelectedValue);
i.NGAY_KY_HD = txtNgayKyHD.Text != "" ?
DateTime.ParseExact(txtNgayKyHD.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture) : i.NGAY_KY_HD = null;
i.LOAI_CKS = ddlLoaiCKS.SelectedValue;
i.GIU_CKS = chkCoGiuCKS.Checked ? 1 : 0;
i.NGAY_HET_HAN_CKS = txtNgayHetHanCKS.Text != "" ?
DateTime.ParseExact(txtNgayHetHanCKS.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture) : i.NGAY_HET_HAN_CKS = null;
if (chkCoGiuCKS.Checked)
{
i.NGAY_GIU_CKS = txtNgayLayCKS.Text != "" ?
DateTime.ParseExact(txtNgayLayCKS.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture) : i.NGAY_GIU_CKS = null;
}
else i.NGAY_GIU_CKS = null;
i.GHI_CHU = txtGhiChuMain.Text;
i.LOAI_NOP = Utils.CIntDef(rdbLoainop.SelectedItem.Value);
i.DATE = DateTime.Now;
i.BIEUPHI1_SL = txtBP1_SL.Text.Trim();
i.BIEUPHI1_PHI = Utils.CIntDef(txtBP1_PHI.Text.Replace(",", ""));
i.BIEUPHI2_SL = txtBP2_SL.Text.Trim();
i.BIEUPHI2_PHI = Utils.CIntDef(txtBP2_PHI.Text.Replace(",", ""));
i.BIEUPHI3_SL = txtBP3_SL.Text.Trim();
i.BIEUPHI3_PHI = Utils.CIntDef(txtBP3_PHI.Text.Replace(",", ""));
i.BIEUPHI4_SL = txtBP4_SL.Text.Trim();
i.BIEUPHI4_PHI = Utils.CIntDef(txtBP4_PHI.Text.Replace(",", ""));
i.BIEUPHI5_SL = txtBP5_SL.Text.Trim();
i.BIEUPHI5_PHI = Utils.CIntDef(txtBP5_PHI.Text.Replace(",", ""));
i.BIEUPHI6_SL = txtBP6_SL.Text.Trim();
i.BIEUPHI6_PHI = Utils.CIntDef(txtBP6_PHI.Text.Replace(",", ""));
i.BIEUPHI_THEM = Utils.CIntDef(txtPhiPhatSinh.Text.Replace(",", ""));
i.TONG_NO = i.CON_NO_1 + i.CON_NO_2 + i.CON_NO_3 + i.CON_NO_4 + i.CON_NO_5 + i.CON_NO_6 + i.CON_NO_7
+ i.CON_NO_8 + i.CON_NO_9 + i.CON_NO_10 + i.CON_NO_11 + i.CON_NO_12 + i.CON_NO_BCTC + i.NO_NAM_TRUOC;
proj_data.Update(i);
db.SubmitChanges();
}
else
{
CONG_NO i = new CONG_NO();
i.TINH_TRANG = ddlTinhTrang.SelectedValue;
i.DATE_TINHTRANG = txtNgayBatDau.Text != "" ?
DateTime.ParseExact(txtNgayBatDau.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture) : i.DATE_TINHTRANG = null;
i.DATE_TINHTRANG1 = txtNgayKetThuc.Text != "" ?
DateTime.ParseExact(txtNgayKetThuc.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture) : i.DATE_TINHTRANG1 = null;
i.DATE_THANHLAP = txtNgayThanhLap.Text != "" ?
DateTime.ParseExact(txtNgayThanhLap.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture) : i.DATE_THANHLAP = null;
i.TEN_KH = txtTenKH.Text;
i.QL_THUE_CITY = Utils.CIntDef(ddlCity.SelectedValue);
i.QL_THUE_DIST = Utils.CIntDef(ddlDist.SelectedValue);
i.STT = Utils.CIntDef(txtSTT.Text);
i.NO_NAM_TRUOC = Utils.CIntDef(txtNoNamTruoc.Text.Replace(",", ""));
i.MST = txtMST.Text;
i.DIA_CHI = txtDiaChi1.Text;
i.GIAM_DOC = txtGiamDoc.Text;
i.DIEN_THOAI = txtDienThoai.Text;
i.EMAIL = txtEmail.Text;
i.PHI = Utils.CIntDef(txtPhi.Text.Replace(",", ""));
i.THANG_BD_THU = txtNgayThu.Text;
i.NV_KT = Utils.CIntDef(ddlNVKT.SelectedValue);
i.NV_KD = Utils.CIntDef(ddlNVKD.SelectedValue);
i.NV_GN = Utils.CIntDef(ddlNVGN.SelectedValue);
i.NGAY_KY_HD = txtNgayKyHD.Text != "" ?
DateTime.ParseExact(txtNgayKyHD.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture) : i.NGAY_KY_HD = null;
i.LOAI_CKS = ddlLoaiCKS.SelectedValue;
i.GIU_CKS = chkCoGiuCKS.Checked ? 1 : 0;
i.NGAY_HET_HAN_CKS = txtNgayHetHanCKS.Text != "" ?
DateTime.ParseExact(txtNgayHetHanCKS.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture) : i.NGAY_HET_HAN_CKS = null;
if (chkCoGiuCKS.Checked)
{
i.NGAY_GIU_CKS = txtNgayLayCKS.Text != "" ?
DateTime.ParseExact(txtNgayLayCKS.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture) : i.NGAY_GIU_CKS = null;
}
else i.NGAY_GIU_CKS = null;
i.GHI_CHU = txtGhiChuMain.Text;
i.LOAI_NOP = Utils.CIntDef(rdbLoainop.SelectedItem.Value);
i.DATE = DateTime.Now;
i.NAM = Utils.CIntDef(ddlNam.SelectedValue);
i.BIEUPHI1_SL = txtBP1_SL.Text.Trim();
i.BIEUPHI1_PHI = Utils.CIntDef(txtBP1_PHI.Text.Replace(",", ""));
i.BIEUPHI2_SL = txtBP2_SL.Text.Trim();
i.BIEUPHI2_PHI = Utils.CIntDef(txtBP2_PHI.Text.Replace(",", ""));
i.BIEUPHI3_SL = txtBP3_SL.Text.Trim();
i.BIEUPHI3_PHI = Utils.CIntDef(txtBP3_PHI.Text.Replace(",", ""));
i.BIEUPHI4_SL = txtBP4_SL.Text.Trim();
i.BIEUPHI4_PHI = Utils.CIntDef(txtBP4_PHI.Text.Replace(",", ""));
i.BIEUPHI5_SL = txtBP5_SL.Text.Trim();
i.BIEUPHI5_PHI = Utils.CIntDef(txtBP5_PHI.Text.Replace(",", ""));
i.BIEUPHI6_SL = txtBP6_SL.Text.Trim();
i.BIEUPHI6_PHI = Utils.CIntDef(txtBP6_PHI.Text.Replace(",", ""));
i.BIEUPHI_THEM = Utils.CIntDef(txtPhiPhatSinh.Text.Replace(",", ""));
proj_data.Create(i);
var getlink = db.CONG_NOs.OrderByDescending(n => n.ID).Take(1).ToList();
if (getlink.Count > 0)
{
id = Utils.CIntDef(getlink[0].ID);
namCN = Utils.CIntDef(getlink[0].NAM);
mst = getlink[0].MST;
return 1;
}
}
}
else
{
if (temp != 0)
{
obj.TINH_TRANG = ddlTinhTrang.SelectedValue;
obj.DATE_TINHTRANG = txtNgayBatDau.Text != "" ?
DateTime.ParseExact(txtNgayBatDau.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture) : obj.DATE_TINHTRANG = null;
obj.DATE_TINHTRANG1 = txtNgayKetThuc.Text != "" ?
DateTime.ParseExact(txtNgayKetThuc.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture) : obj.DATE_TINHTRANG1 = null;
obj.DATE_THANHLAP = txtNgayThanhLap.Text != "" ?
DateTime.ParseExact(txtNgayThanhLap.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture) : obj.DATE_THANHLAP = null;
obj.TEN_KH = txtTenKH.Text;
obj.QL_THUE_CITY = Utils.CIntDef(ddlCity.SelectedValue);
obj.QL_THUE_DIST = Utils.CIntDef(ddlDist.SelectedValue);
obj.STT = Utils.CIntDef(txtSTT.Text);
obj.NO_NAM_TRUOC = Utils.CIntDef(txtNoNamTruoc.Text.Replace(",", ""));
obj.MST = txtMST.Text;
obj.DIA_CHI = txtDiaChi1.Text;
obj.GIAM_DOC = txtGiamDoc.Text;
obj.DIEN_THOAI = txtDienThoai.Text;
obj.EMAIL = txtEmail.Text;
obj.PHI = Utils.CIntDef(txtPhi.Text.Replace(",", ""));
obj.THANG_BD_THU = txtNgayThu.Text;
obj.NV_KT = Utils.CIntDef(ddlNVKT.SelectedValue);
obj.NV_KD = Utils.CIntDef(ddlNVKD.SelectedValue);
obj.NV_GN = Utils.CIntDef(ddlNVGN.SelectedValue);
obj.NGAY_KY_HD = txtNgayKyHD.Text != "" ?
DateTime.ParseExact(txtNgayKyHD.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture) : obj.NGAY_KY_HD = null;
obj.LOAI_CKS = ddlLoaiCKS.SelectedValue;
obj.GIU_CKS = chkCoGiuCKS.Checked ? 1 : 0;
obj.NGAY_HET_HAN_CKS = txtNgayHetHanCKS.Text != "" ?
DateTime.ParseExact(txtNgayHetHanCKS.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture) : obj.NGAY_HET_HAN_CKS = null;
if (chkCoGiuCKS.Checked)
{
obj.NGAY_GIU_CKS = txtNgayLayCKS.Text != "" ?
DateTime.ParseExact(txtNgayLayCKS.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture) : obj.NGAY_GIU_CKS = null;
}
else obj.NGAY_GIU_CKS = null;
obj.GHI_CHU = txtGhiChuMain.Text;
obj.LOAI_NOP = Utils.CIntDef(rdbLoainop.SelectedItem.Value);
obj.DATE = DateTime.Now;
obj.BIEUPHI1_SL = txtBP1_SL.Text.Trim();
obj.BIEUPHI1_PHI = Utils.CIntDef(txtBP1_PHI.Text.Replace(",", ""));
obj.BIEUPHI2_SL = txtBP2_SL.Text.Trim();
obj.BIEUPHI2_PHI = Utils.CIntDef(txtBP2_PHI.Text.Replace(",", ""));
obj.BIEUPHI3_SL = txtBP3_SL.Text.Trim();
obj.BIEUPHI3_PHI = Utils.CIntDef(txtBP3_PHI.Text.Replace(",", ""));
obj.BIEUPHI4_SL = txtBP4_SL.Text.Trim();
obj.BIEUPHI4_PHI = Utils.CIntDef(txtBP4_PHI.Text.Replace(",", ""));
obj.BIEUPHI5_SL = txtBP5_SL.Text.Trim();
obj.BIEUPHI5_PHI = Utils.CIntDef(txtBP5_PHI.Text.Replace(",", ""));
obj.BIEUPHI6_SL = txtBP6_SL.Text.Trim();
obj.BIEUPHI6_PHI = Utils.CIntDef(txtBP6_PHI.Text.Replace(",", ""));
obj.BIEUPHI_THEM = Utils.CIntDef(txtPhiPhatSinh.Text.Replace(",", ""));
obj.TONG_NO = obj.CON_NO_1 + obj.CON_NO_2 + obj.CON_NO_3 + obj.CON_NO_4 + obj.CON_NO_5 + obj.CON_NO_6 + obj.CON_NO_7
+ obj.CON_NO_8 + obj.CON_NO_9 + obj.CON_NO_10 + obj.CON_NO_11 + obj.CON_NO_12 + obj.CON_NO_BCTC + obj.NO_NAM_TRUOC;
proj_data.Update(obj);
db.SubmitChanges();
}
else
{
var i = db.CONG_NOs.Where(n => n.ID == id).Single();
i.TINH_TRANG = ddlTinhTrang.SelectedValue;
i.DATE_TINHTRANG = txtNgayBatDau.Text != "" ?
DateTime.ParseExact(txtNgayBatDau.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture) : i.DATE_TINHTRANG = null;
i.DATE_TINHTRANG1 = txtNgayKetThuc.Text != "" ?
DateTime.ParseExact(txtNgayKetThuc.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture) : i.DATE_TINHTRANG1 = null;
i.DATE_THANHLAP = txtNgayThanhLap.Text != "" ?
DateTime.ParseExact(txtNgayThanhLap.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture) : i.DATE_THANHLAP = null;
i.TEN_KH = txtTenKH.Text;
i.QL_THUE_CITY = Utils.CIntDef(ddlCity.SelectedValue);
i.QL_THUE_DIST = Utils.CIntDef(ddlDist.SelectedValue);
i.STT = Utils.CIntDef(txtSTT.Text);
i.NO_NAM_TRUOC = Utils.CIntDef(txtNoNamTruoc.Text.Replace(",", ""));
i.MST = txtMST.Text;
i.DIA_CHI = txtDiaChi1.Text;
i.GIAM_DOC = txtGiamDoc.Text;
i.DIEN_THOAI = txtDienThoai.Text;
i.EMAIL = txtEmail.Text;
i.PHI = Utils.CIntDef(txtPhi.Text.Replace(",", ""));
i.THANG_BD_THU = txtNgayThu.Text;
i.NV_KT = Utils.CIntDef(ddlNVKT.SelectedValue);
i.NV_KD = Utils.CIntDef(ddlNVKD.SelectedValue);
i.NV_GN = Utils.CIntDef(ddlNVGN.SelectedValue);
i.NGAY_KY_HD = txtNgayKyHD.Text != "" ?
DateTime.ParseExact(txtNgayKyHD.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture) : i.NGAY_KY_HD = null;
i.LOAI_CKS = ddlLoaiCKS.SelectedValue;
i.GIU_CKS = chkCoGiuCKS.Checked ? 1 : 0;
i.NGAY_HET_HAN_CKS = txtNgayHetHanCKS.Text != "" ?
DateTime.ParseExact(txtNgayHetHanCKS.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture) : i.NGAY_HET_HAN_CKS = null;
if (chkCoGiuCKS.Checked)
{
i.NGAY_GIU_CKS = txtNgayLayCKS.Text != "" ?
DateTime.ParseExact(txtNgayLayCKS.Text, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture) : i.NGAY_GIU_CKS = null;
}
else i.NGAY_GIU_CKS = null;
i.GHI_CHU = txtGhiChuMain.Text;
i.LOAI_NOP = Utils.CIntDef(rdbLoainop.SelectedItem.Value);
i.DATE = DateTime.Now;
i.BIEUPHI1_SL = txtBP1_SL.Text.Trim();
i.BIEUPHI1_PHI = Utils.CIntDef(txtBP1_PHI.Text.Replace(",", ""));
i.BIEUPHI2_SL = txtBP2_SL.Text.Trim();
i.BIEUPHI2_PHI = Utils.CIntDef(txtBP2_PHI.Text.Replace(",", ""));
i.BIEUPHI3_SL = txtBP3_SL.Text.Trim();
i.BIEUPHI3_PHI = Utils.CIntDef(txtBP3_PHI.Text.Replace(",", ""));
i.BIEUPHI4_SL = txtBP4_SL.Text.Trim();
i.BIEUPHI4_PHI = Utils.CIntDef(txtBP4_PHI.Text.Replace(",", ""));
i.BIEUPHI5_SL = txtBP5_SL.Text.Trim();
i.BIEUPHI5_PHI = Utils.CIntDef(txtBP5_PHI.Text.Replace(",", ""));
i.BIEUPHI6_SL = txtBP6_SL.Text.Trim();
i.BIEUPHI6_PHI = Utils.CIntDef(txtBP6_PHI.Text.Replace(",", ""));
i.BIEUPHI_THEM = Utils.CIntDef(txtPhiPhatSinh.Text.Replace(",", ""));
i.TONG_NO = i.CON_NO_1 + i.CON_NO_2 + i.CON_NO_3 + i.CON_NO_4 + i.CON_NO_5 + i.CON_NO_6 + i.CON_NO_7
+ i.CON_NO_8 + i.CON_NO_9 + i.CON_NO_10 + i.CON_NO_11 + i.CON_NO_12 + i.CON_NO_BCTC + i.NO_NAM_TRUOC;
proj_data.Update(i);
db.SubmitChanges();
}
}
return 0;
}
private void CreateCongNo()
{
List <object> fieldValues = ASPxGridView1_project.GetSelectedFieldValues(new string[] { "ID" });
if (fieldValues.Count > 0)
{
foreach (var item in fieldValues)
{
var obj = _MerHopDongDVData.GetById(Utils.CIntDef(item));
if (obj != null)
{
//Kiểm tra xem trạng thái đã Hoàn thành chưa
if (Utils.CIntDef(obj.MER_STATUS) == 3)
{
var objCheck = db.CONG_NOs.Where(u => u.MST == obj.MER_TAXCODE && u.NAM == Utils.CIntDef(obj.MER_POS05, 0)).ToList();
if (objCheck.Count == 0)
{
CONG_NO i = new CONG_NO();
i.TINH_TRANG = "---";
i.NAM = Utils.CIntDef(obj.MER_POS05, 0);
string _ngayHD = obj.MER_POS03 + "/" + obj.MER_POS04 + "/" + obj.MER_POS05;
i.NGAY_KY_HD = DateTime.ParseExact(_ngayHD, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
i.TEN_KH = obj.MER_NAME;
i.DIA_CHI = obj.MER_ADDRESS;
i.DIEN_THOAI = obj.MER_PHONE;
i.MST = obj.MER_TAXCODE;
i.EMAIL = obj.MER_EMAIL;
i.GIAM_DOC = obj.MER_REPRESENT;
i.PHI = obj.PHI_HANGTHANG;
i.NV_KD = obj.USER_ID;
if (Utils.CIntDef(obj.PHI_TU1_1) > 0 && Utils.CIntDef(obj.PHI_TU1_2) > 0)
{
i.BIEUPHI1_SL = obj.PHI_TU1_1 + "-" + obj.PHI_TU1_2;
i.BIEUPHI1_PHI = obj.PHI_HD1;
}
if (Utils.CIntDef(obj.PHI_TU2_1) > 0 && Utils.CIntDef(obj.PHI_TU2_2) > 0)
{
i.BIEUPHI2_SL = obj.PHI_TU2_1 + "-" + obj.PHI_TU2_2;
i.BIEUPHI2_PHI = obj.PHI_HD2;
}
if (Utils.CIntDef(obj.PHI_TU3_1) > 0 && Utils.CIntDef(obj.PHI_TU3_2) > 0)
{
i.BIEUPHI3_SL = obj.PHI_TU3_1 + "-" + obj.PHI_TU3_2;
i.BIEUPHI3_PHI = obj.PHI_HD3;
}
if (Utils.CIntDef(obj.PHI_TU4_1) > 0 && Utils.CIntDef(obj.PHI_TU4_2) > 0)
{
i.BIEUPHI4_SL = obj.PHI_TU4_1 + "-" + obj.PHI_TU4_2;
i.BIEUPHI4_PHI = obj.PHI_HD4;
}
if (Utils.CIntDef(obj.PHI_TU5_1) > 0 && Utils.CIntDef(obj.PHI_TU5_2) > 0)
{
i.BIEUPHI5_SL = obj.PHI_TU5_1 + "-" + obj.PHI_TU5_2;
i.BIEUPHI5_PHI = obj.PHI_HD5;
}
if (Utils.CIntDef(obj.PHI_TU6_1) > 0 && Utils.CIntDef(obj.PHI_TU6_2) > 0)
{
i.BIEUPHI6_SL = obj.PHI_TU6_1 + "-" + obj.PHI_TU6_2;
i.BIEUPHI6_PHI = obj.PHI_HD6;
}
if (Utils.CIntDef(obj.PHI_THEMPHI) > 0)
{
i.BIEUPHI_THEM = obj.PHI_THEMPHI;
}
i.THANG_BD_THU = obj.MER_BEGIN_M;
i.STT = _CongNoData.GetSTT(Utils.CIntDef(obj.MER_POS05)) + 1;
_CongNoData.Create(i);
db.SubmitChanges();
}
}
}
}
string strScript = "<script>";
strScript += "alert('Đã xử lý xong!');";
strScript += "window.location='danh-sach-hop-dong-ke-toan.aspx';";
strScript += "</script>";
Page.RegisterClientScriptBlock("strScript", strScript);
}
else
{
string strScript = "<script>";
strScript += "alert('Xin chọn hợp đồng để cập nhật vào công nợ kế toán!');";
strScript += "</script>";
Page.RegisterClientScriptBlock("strScript", strScript);
}
}
