public static Dictionary <String, DataRow> BuildIndex_SQL(String SQLCommand, List <String> ColumnName, String seperator)
{
DataTable table = DataSupport.RunDataSet(SQLCommand).Tables[0];
Dictionary <String, DataRow> index = new Dictionary <String, DataRow>(table.Rows.Count);
foreach (DataRow Row in table.Rows)
{
String key = "";
int cnt = 0;
foreach (String col in ColumnName)
{
if (cnt == ColumnName.Count - 1)
{
key += Row[col].ToString().Trim();
}
else
{
key += Row[col].ToString().Trim() + seperator;
}
cnt++;
}
index[key] = Row;
}
return(index);
}
public static String GetNextMenuCodeInt(String menu)
{
String result = "";
System.Data.DataSet ds = DataSupport.RunDataSet(String.Format("SELECT menu_current FROM MENU WHERE menu_id = '{0}' ", menu) + UpdateMenuCode(menu));
String next_value = ds.Tables[0].Rows[0][0].ToString();
result = next_value;
return(result);
}
private static Boolean IsInConflict(String value, String table, String id)
{
String sql = "SELECT " + id + " FROM " + table + " WHERE " + id + " = @id ";
DataTable dt = DataSupport.RunDataSet(sql, "id", value).Tables[0];
if (dt.Rows.Count > 0)
{
return(true);
}
return(false);
}
public static String GetNextMenuCode(String menu, String menu_prefix)
{
String result = "";
String building_id = "WEB";
System.Data.DataSet ds = DataSupport.RunDataSet(String.Format("SELECT menu_current FROM MENU WHERE menu_id = '{0}' ", menu));
String next_value = ds.Tables[0].Rows[0][0].ToString();
result = String.Format("{0}-{1}-{2}", building_id, menu_prefix, next_value);
return(result);
}
public static Dictionary <String, DataRow> BuildIndex_SQL(String SQLCommand, String ColumnName)
{
DataTable table = DataSupport.RunDataSet(SQLCommand).Tables[0];
Dictionary <String, DataRow> index = new Dictionary <String, DataRow>(table.Rows.Count);
foreach (DataRow Row in table.Rows)
{
index[Row[ColumnName].ToString()] = Row;
}
return(index);
}
public static void GetChildren(String table_name, String parent_key, String primary_key, String value, ref List <String> result)
{
String sql = "SELECT " + primary_key + " FROM " + table_name + " WHERE " + parent_key + " = @value";
var dt = DataSupport.RunDataSet(sql, "value", value).Tables[0];
foreach (DataRow row in dt.Rows)
{
String child_value = row[primary_key].ToString();
result.Add(child_value);
GetChildren(table_name, parent_key, primary_key, child_value, ref result);
}
}
public static string GetDataString(String sql, params Object[] parameters)
{
DataTable dt = DataSupport.RunDataSet(sql).Tables[0];
if (dt.Rows.Count == 0)
{
return("");
}
else
{
return(dt.Rows[0][0].ToString());
}
}
public static int GetDataInt(String sql, params Object[] parameters)
{
DataTable dt = DataSupport.RunDataSet(sql).Tables[0];
if (dt.Rows.Count == 0)
{
return(0);
}
else
{
return(Convert.ToInt32(dt.Rows[0][0]));
}
}
public static decimal GetDataDecimal(String sql, params Object[] parameters)
{
DataTable dt = DataSupport.RunDataSet(sql).Tables[0];
if (dt.Rows.Count == 0)
{
return(Convert.ToDecimal("0.00"));
}
else
{
return(Convert.ToDecimal(dt.Rows[0][0]));
}
}
public static DataTable GetDataTable(String sql, params Object[] parameters)
{
return(DataSupport.RunDataSet(sql).Tables[0]);
}
public static System.Data.DataSet GetDataset(String sql)
{
return(DataSupport.RunDataSet(sql));
}