public static string ExecuteSql(string sql) { string retVal; using (BaseDB.BaseDataAccess baseDataAccess = new BaseDB.BaseDataAccess()) { using (BaseDB.BaseCommand cmd = new BaseDB.BaseCommand(baseDataAccess.MsConn)) { cmd.CommandText = sql; cmd.CommandType = System.Data.CommandType.Text; retVal = cmd.ExecuteScalar(); } } return(retVal); }
public static DataSet GetDataSet(string sql) { DataSet dataSet = new DataSet(); using (BaseDB.BaseAdapter baseAdapter = new BaseDB.BaseAdapter()) { using (BaseDB.BaseDataAccess baseDataAccess = new BaseDB.BaseDataAccess()) { using (BaseDB.BaseCommand cmd = new BaseDB.BaseCommand(baseDataAccess.MsConn)) { cmd.CommandText = sql; cmd.CommandType = System.Data.CommandType.Text; baseAdapter.SelectCommand = cmd.Command; baseAdapter.Fill(dataSet, "Table"); } } } return(dataSet); }
public static int GetMaxId(string tableName, string field) { string result = ""; using (BaseDB.BaseDataAccess baseDataAccess = new BaseDB.BaseDataAccess()) { using (BaseDB.BaseCommand cmd = new BaseDB.BaseCommand(baseDataAccess.MsConn)) { cmd.CommandText = "Select MAX(" + field + ") From " + tableName; cmd.CommandType = System.Data.CommandType.Text; result = cmd.ExecuteScalar(); if (result == "") { result = "0"; } } } return(Int32.Parse(result)); }
public static System.Xml.XmlReader ExecuteSPForXml(string spName, ArrayList parameterArr, ArrayList valueArr) { using (BaseDB.BaseAdapter baseAdapter = new BaseDB.BaseAdapter()) { using (BaseDB.BaseDataAccess baseDataAccess = new BaseDB.BaseDataAccess()) { using (BaseDB.BaseCommand cmd = new BaseDB.BaseCommand(baseDataAccess.MsConn)) { cmd.CommandText = spName; cmd.CommandType = System.Data.CommandType.StoredProcedure; for (int i = 0; i < parameterArr.Count; i++) { cmd.Command.Parameters.AddWithValue("@" + parameterArr[i], valueArr[i]); } baseAdapter.SelectCommand = cmd.Command; System.Xml.XmlReader x = cmd.Command.ExecuteXmlReader(); return(x); } } } }
public static string GetFieldValue(string tableName, string criteria, string field) { string retVal; using (BaseDB.BaseDataAccess baseDataAccess = new BaseDB.BaseDataAccess()) { using (BaseDB.BaseCommand cmd = new BaseDB.BaseCommand(baseDataAccess.MsConn)) { if (string.Compare(criteria, "") != 0) { cmd.CommandText = "Select " + field + " From " + tableName + " Where " + criteria; } else { cmd.CommandText = "Select " + field + " From " + tableName; } cmd.CommandType = System.Data.CommandType.Text; retVal = cmd.ExecuteScalar(); } } return(retVal); }
public static DataSet ExecuteSP(string spName, ArrayList parameterArr, ArrayList valueArr) { DataSet Data = new DataSet(); using (BaseDB.BaseAdapter baseAdapter = new BaseDB.BaseAdapter()) { using (BaseDB.BaseDataAccess baseDataAccess = new BaseDB.BaseDataAccess()) { using (BaseDB.BaseCommand cmd = new BaseDB.BaseCommand(baseDataAccess.MsConn)) { cmd.CommandText = spName; cmd.CommandType = System.Data.CommandType.StoredProcedure; for (int i = 0; i < parameterArr.Count; i++) { cmd.Command.Parameters.AddWithValue("@" + parameterArr[i], valueArr[i]); } baseAdapter.SelectCommand = cmd.Command; baseAdapter.Fill(Data, "Table"); } } } return(Data); }