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