public static List <BLOG> Get8() { string sql = string.Empty; sql = @"select TOP 8 * from DISEASES order by SORT"; Hashtable param = new Hashtable(); DataSet retval = new DataSet(); retval = SQLMs.RunDataset(sql, param); return(retval.ConvertToList <BLOG>()); }
public static DataSet GetByPropertyValue(string tableName, List <WHERE> where) { DataSet retval = new DataSet(); Hashtable param = new Hashtable(); string sql = "SELECT * FROM " + TABLEPREFIX + tableName + " WHERE 1=1"; foreach (WHERE w in where) { switch (w.OPERATOR) { case "TOP": { sql = "SELECT TOP " + w.VALUE + " * FROM " + TABLEPREFIX + tableName + " WHERE 1=1"; break; } case "BETWEEN": { sql += " AND " + w.COLUMNNAME + " BETWEEN @" + w.COLUMNNAME + "Left AND @" + w.COLUMNNAME + "Right"; param.Add(w.COLUMNNAME + "Left", w.VALUE); param.Add(w.COLUMNNAME + "Right", w.VALUE2); break; } case "NOT BETWEEN": { sql += " AND " + w.COLUMNNAME + " NOT BETWEEN @" + w.COLUMNNAME + "Left AND @" + w.COLUMNNAME + "Right"; param.Add(w.COLUMNNAME + "Left", w.VALUE); param.Add(w.COLUMNNAME + "Right", w.VALUE2); break; } case "ISNOTNULL": { sql += " AND " + w.COLUMNNAME + " IS NOT NULL"; break; } case "ISNULL": { sql += " AND " + w.COLUMNNAME + " IS NULL"; break; } case "OR": { if (string.IsNullOrEmpty(w.VALUE2.ToString())) { if (!string.IsNullOrEmpty(w.OPERATOR2.ToString())) { sql += " AND (" + w.COLUMNNAME + " " + w.OPERATOR2 + " @" + w.COLUMNNAME + "Left " + w.OPERATOR + " " + w.COLUMNNAME + " IS NULL )"; param.Add(w.COLUMNNAME + "Left", w.VALUE); break; } else { sql += " AND (" + w.COLUMNNAME + "=@" + w.COLUMNNAME + "Left " + w.OPERATOR + " " + w.COLUMNNAME + " IS NULL )"; param.Add(w.COLUMNNAME + "Left", w.VALUE); break; } } else { sql += " AND (" + w.COLUMNNAME + "=@" + w.COLUMNNAME + "Left " + w.OPERATOR + " " + w.COLUMNNAME + "=@" + w.COLUMNNAME + "Right )"; param.Add(w.COLUMNNAME + "Left", w.VALUE); param.Add(w.COLUMNNAME + "Right", w.VALUE2); break; } } default: { if (!param.ContainsKey(w.COLUMNNAME)) { sql += " AND " + w.COLUMNNAME + " " + w.OPERATOR + " @" + w.COLUMNNAME; param.Add(w.COLUMNNAME, w.VALUE); } else { // bir kolon ikinci defa gelmisse string paramName = string.Empty; for (int i = 0; i < 100; i++) { if (!param.ContainsKey(w.COLUMNNAME + i.ToString())) { paramName = w.COLUMNNAME + i.ToString(); break; } } sql += " AND " + w.COLUMNNAME + " " + w.OPERATOR + " @" + paramName; param.Add(paramName, w.VALUE); } break; } } } retval = SQLMs.RunDataset(sql, param); return(retval); }