public static bool kiemTraXoa1(string sma, string scotcon, string strBangCon, string scotcha) { string strSQL = "SELECT TABLE_NAME tablename FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = N'" + scotcon + "_sd'"; SqlFunction _sqlClass = new SqlFunction(HttpContext.Current.Session.GetConnectionString2()); DataTable _dt = new DataTable(); _dt = _sqlClass.GetData(strSQL); strSQL = " "; if (_dt.Rows.Count > 0) { try { for (int i = 0; i < _dt.Rows.Count; i++) { if (i == 0) { strSQL = "select " + scotcon + "_sd from " + _dt.Rows[i][0] + " where " + scotcon + "_sd in (select " + scotcon + " from " + strBangCon + " where " + scotcha + " = N'" + sma + "')"; } else { strSQL = strSQL + " UNION ALL select " + scotcon + "_sd from " + _dt.Rows[i][0] + " where " + scotcon + "_sd in (select " + scotcon + " from " + strBangCon + " where " + scotcha + " = N'" + sma + "')"; } } return(_sqlClass.CheckHasRecord(strSQL)); } catch { return(true); } } else { return(false); } }
public static DataTable danhMucNguon(string sttDuAn) { SqlFunction sqlFunc = new SqlFunction(HttpContext.Current.Session.GetConnectionString2()); string sql = ""; if (sqlFunc.CheckHasRecord(" SELECT sttCanhBaopr_sd FROM tblCanhBao WHERE sttCanhBaopr_sd=8 and maDonVipr_sd='" + HttpContext.Current.Session.GetDonVi().maDonVi + "'")) { sql = sql = @"SELECT '' maNguonVonpr,'' tenNguonVon union all SELECT maNguonVonpr,(CASE WHEN LEN(maNguonVonpr)=1 THEN tenNguonVon WHEN LEN(maNguonVonpr)=2 THEN '--- '+tenNguonVon WHEN (LEN(maNguonVonpr)=4 OR LEN(maNguonVonpr)=3) THEN '--- --- '+tenNguonVon WHEN (LEN(maNguonVonpr)=6 OR LEN(maNguonVonpr)=5) THEN '--- --- --- '+tenNguonVon ELSE '--- --- --- --- '+tenNguonVon END ) AS tenNguonVon FROM dbo.tblDMNguonVon WHERE isnull(ngungSD,0) = 0 and maCapQuanLypr_sd=(select maCapQLpr_sd from tblDuAn where sttDuAnpr='" + sttDuAn + "') ORDER BY maNguonVonpr "; } else { sql = @"SELECT maNguonVonpr,(CASE WHEN LEN(maNguonVonpr)=1 THEN tenNguonVon WHEN LEN(maNguonVonpr)=2 THEN '--- '+tenNguonVon WHEN (LEN(maNguonVonpr)=4 OR LEN(maNguonVonpr)=3) THEN '--- --- '+tenNguonVon WHEN (LEN(maNguonVonpr)=6 OR LEN(maNguonVonpr)=5) THEN '--- --- --- '+tenNguonVon ELSE '--- --- --- --- '+tenNguonVon END ) AS tenNguonVon FROM dbo.tblDMNguonVon WHERE isnull(ngungSD,0) = 0"; } return(sqlFunc.GetData(sql)); }
public bool kiemTraLuuToChuc(string ma) { try { SqlFunction sqlFunc = new SqlFunction(HttpContext.Current.Session.GetConnectionString2()); return(sqlFunc.CheckHasRecord("select maToChucpr from tblDMToChuc where maToChucpr=N'" + ma + "'")); } catch { } return(false); }
//kiem tra ma khi them vao bang DL //Ngày bỗ sung: 19/12/2018 //Người bỗ sung: Vịnh //Nội dung: Các class dùng chung theme boostrap #region Các class dùng chung boostrap /// <summary> /// Kiêm tra trùng mã trong 1 bảng dữ liệu /// </summary> /// <param name="strMaKiemTra">Mã cần kiểm tra VD: 010</param> /// <param name="strBangKiemTra">Bảng cần kiểm tra VD: tblDMKho</param> /// <param name="strCotKiemTra">Cột cần kiểm tra VD: maKhopr</param> /// <returns>True: trùng mã, False: Không trùng mã</returns> public static bool kiemTraTrungMa(string strMaKiemTra, string strBangKiemTra, string strCotKiemTra) { try { SqlFunction sqlFun = new SqlFunction(HttpContext.Current.Session.GetConnectionString2()); string strSQL = @"Select " + strCotKiemTra + " FROM " + strBangKiemTra + " WHERE " + strCotKiemTra + "=N'" + strMaKiemTra + "'"; return(sqlFun.CheckHasRecord(strSQL)); } catch { return(false); } }
//kiem tram ma khi xoa public static bool kiemTraXoa(string sma, string schuoitru, string scot, string scotcon) { SqlFunction _sqlClass = new SqlFunction(HttpContext.Current.Session.GetConnectionString2()); if (scot == "sttNhapKhopr_sd" && _sqlClass.CheckHasRecord("SELECT sttNhapKhopr FROM dbo.tblNhapKho WHERE sttNhapKhopr = '" + sma + "' AND trangThai ='1'") == true) { return(true); } if (scot == "sttTraNhapKhopr_sd" && _sqlClass.CheckHasRecord("SELECT sttTraNhapKhopr FROM dbo.tblTraNhapKho WHERE sttTraNhapKhopr = '" + sma + "' AND trangThai ='1'") == true) { return(true); } if (scot == "sttHoaDonpr_sd" && _sqlClass.CheckHasRecord("SELECT sttHoaDonpr FROM dbo.tblHoaDon WHERE sttHoaDonpr = '" + sma + "' AND trangThai ='1'") == true) { return(true); } if (scot == "sttKiemKhopr_sd" && _sqlClass.CheckHasRecord("SELECT sttKiemKhopr FROM dbo.tblKiemKho WHERE sttKiemKhopr = '" + sma + "' AND trangThai ='1'") == true) { return(true); } bool travee = false; string strSQL = "SELECT TABLE_NAME tablename FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = N'" + scot + "' AND TABLE_NAME NOT IN (" + schuoitru + ")"; DataTable _dt = new DataTable(); _dt = _sqlClass.GetData(strSQL); strSQL = " "; if (_dt.Rows.Count > 0) { try { for (int i = 0; i < _dt.Rows.Count; i++) { if (i == 0) { strSQL = "select " + scot + " from " + _dt.Rows[i][0] + " where " + scot + " =N'" + sma + "'"; } else { strSQL = strSQL + " UNION ALL select " + scot + " from " + _dt.Rows[i][0] + " where " + scot + " =N'" + sma + "'"; } } if (!_sqlClass.CheckHasRecord(strSQL)) { if (schuoitru == "''" || schuoitru == "") { travee = false; } else { string strBangTru = schuoitru.Replace("'", ""); string[] mangBangTru = strBangTru.Split(','); string[] mangCotCon = scotcon.Split(','); for (int i = 0; i < mangBangTru.Length; i++) { travee = kiemTraXoa1(sma, mangCotCon[i].ToString(), mangBangTru[i].ToString(), scot); if (travee) { break; } } } } else { travee = true; } } catch { travee = true; } } else { travee = false; } return(travee); }