public AccessSQL(Config.ConfigItem configSystem) { configSys = configSystem; _sqlCommand = new SqlCommand(); _sqlDataAdapter = new SqlDataAdapter(); _sqlConnection = new SqlConnection(); }
public static string getNextIDTakeIn(Config.ConfigItem _confItem) { try { COMMAND.SQL.AccessSQL _sql = new SQL.AccessSQL(_confItem); DataTable tb = _sql.GetDataByStoredProcedure("USP_SEL_TAKE_IN_ID"); return(Convert.Convert.CnvToString(tb.Rows[0][0])); } catch (Exception ex) { throw ex; } }
/// <summary> /// Thiet lap ket noi /// </summary> /// public void Connect(Config.ConfigItem config) { try { if (_sqlConnection.State == ConnectionState.Open) { _sqlConnection.Close(); } _sqlConnection = new SqlConnection(config.StrConnection); _sqlConnection.Open(); } catch { _sqlConnection.Dispose(); } }
/// <summary> /// Thiet lap ket noi /// </summary> /// public void Connect(SqlConnection cn, Config.ConfigItem config) { try { if (cn == null) { cn = new SqlConnection(config.StrConnection); } if (cn.State == ConnectionState.Open) { cn.Close(); } cn = new SqlConnection(config.StrConnection); cn.Open(); } catch { cn.Dispose(); } }