protected static List <int> EnumRecords(string table, string returnfield, string[] filterfields = null, object[] values = null) { List <OleDbParameter> pars = new List <OleDbParameter>(); string where = ""; if (filterfields != null && filterfields.Length > 0) { where = " WHERE "; for (int i = 0; i < filterfields.Length; i++) { if (values[i] is Expression) { where += string.Format("{0} {1} = {2}", i == 0 ? "" : " AND ", filterfields[i], values[i].ToString()); } else { where += string.Format("{0} {1} = ?", i == 0 ? "" : " AND ", filterfields[i]); OleDbParameter p = new OleDbParameter("@" + filterfields[i], OleDbTypeMap.GetType(values[i].GetType())); p.Value = values[i]; pars.Add(p); } } } string slq = string.Format("SELECT {0} FROM {1} {2}", returnfield, table, where); List <int> res = new List <int>(); foreach (DataRow row in DBHelper.GetDataSet(slq, pars.ToArray()).Tables[0].Rows) { res.Add(Convert.ToInt32(row[returnfield])); } return(res); }
protected static void SQLExecute(string sql, object[] vals = null) { List <OleDbParameter> pars = new List <OleDbParameter>(); if (vals != null) { foreach (object o in vals) { OleDbParameter p = new OleDbParameter("@par" + pars.Count.ToString(), OleDbTypeMap.GetType(o.GetType())); p.Value = o; pars.Add(p); } } DBHelper.SQLExecute(sql, pars.ToArray()); }