/// <summary>
/// Get Computer Ip Address
/// </summary>
/// <returns></returns>
public string GetSystemPath()
{
string sql = "SELECT user() as address";
string ip_address;
object return_object;
return_object = _dsn.ExecuteScalar(sql);
if (return_object != null)
{
ip_address = Convert.ToString(return_object);
if (String_Utilities.CountWords(ip_address, "@") != 0)
{
ip_address = String_Utilities.GetWord(ip_address, "@", 2);
}
else
{
ip_address = "0.0.0.0";
}
}
else
{
ip_address = "0.0.0.0";
}
return(ip_address);
//string ipaddress = Convert.ToString(DbService.RunScalar(sql));
//string[] p = ipaddress.Split('@');
//return p[1].ToString();
}
public static void Fill(DsnConnection dsn, SessionMacroSchedule table, DateTime bingoday)
{
table.Clear();
DateTime date;
Object obj = dsn.ExecuteScalar("select max(" + DayColumn + ") from " + table.FullTableName + " where " + DayColumn + "<='" + bingoday.ToString("yyyy-MM-dd") + "'");
if (obj != DBNull.Value)
{
date = Convert.ToDateTime(obj);
}
else
{
date = bingoday;
}
//DsnSQLUtil.FillDataTable( dsn, table, "select * from " + table.FullTableName + " where " + DayColumn + "='" + DsnSQLUtil.MakeDate( dsn, date ) + "'" );
DsnSQLUtil.FillDataTable(dsn, table, DayColumn + "='" + DsnSQLUtil.MakeDate(dsn, date) + "'");
}