/// <summary>
/// 获取服务器时间
/// </summary>
/// <returns></returns>
public static DateTime GetServerTime()
{
string sql = "select getdate() as t from dinner";
DateTime dt = (DateTime)OdbcTool.ExecuteScalar(sql);
return(dt);
}
/// <summary>
/// 检查权限
/// </summary>
/// <param name="operator_id"></param>
/// <param name="function_id"></param>
/// <returns></returns>
public static bool CheckRight(String operator_id, String function_id)
{
string sql = "select count(*) as cnt "
+ " from operator_group,operator_group_function "
+ " where operator_group.group_id = operator_group_function.group_id "
+ " and operator_id = ? and function_id = ?";
int cnt = (int)OdbcTool.ExecuteScalar(sql, operator_id, function_id);
return(cnt > 0);
}
{/// <summary>
/// 获取数据库值
/// </summary>
/// <param name="key"></param>
/// <returns></returns>
public static string GetDbValue(string key)
{
if (string.IsNullOrEmpty(key))
{
return(string.Empty);
}
string sql = "select note from uoption where opt_id= ?;";
object value = OdbcTool.ExecuteScalar(sql, key);
return(value == null ? null : value.ToString());
}
/// <summary>
/// 初始化检测
/// </summary>
private bool Init()
{
string tableName = Tools.IniRead(App.MainIni, "App", "posname", "");
if (string.IsNullOrEmpty(tableName))
{
SelectTableWindow w = new SelectTableWindow();
w.OKCallback += (sender, parm) =>
{
if (parm == null)
{
return(null);
}
tableName = parm.ToString();
Tools.IniWrite(App.MainIni, "App", "posname", tableName);
return(null);
};
w.ShowDialog();
}
if (string.IsNullOrEmpty(tableName))
{
MessageBox.Show("必须选择收银机才能继续使用系统！");
return(false);
}
App.TableName = tableName;
var o = OdbcTool.ExecuteScalar("select hme_id from tables where tablename = ?", tableName);
if (o == null)
{
Tools.IniWrite(App.MainIni, "App", "posname", "");
MessageBox.Show("未找到与服务器对应的台位ID\r\n" + "本地台位名称:" + tableName);
return(false);
}
App.HmeTableId = int.Parse(o.ToString());
string sql = "select top 1 dinnername,dinnneraddress,dinnertel from dinner";
DataTable dt = OdbcTool.ExecuteDataTable(sql);
if (dt.Rows.Count > 0)
{
App.DinnerName = dt.Rows[0][0] == null ? string.Empty : dt.Rows[0][0].ToString();
App.DinnerAddr = dt.Rows[0][1] == null ? string.Empty : dt.Rows[0][1].ToString();
App.DinnerTel = dt.Rows[0][2] == null ? string.Empty : dt.Rows[0][2].ToString();
}
return(true);
}
/// <summary>
/// 设置数据库值
/// </summary>
/// <param name="key"></param>
/// <param name="value"></param>
/// <returns></returns>
public static bool SetDbValue(string key, string value)
{
if (string.IsNullOrEmpty(key) || string.IsNullOrEmpty(value))
{
return(false);
}
string sql = "select count(*) from uoption where opt_id= ?;";
int cnt = (int)OdbcTool.ExecuteScalar(sql, key);
if (cnt < 1)
{
sql = "insert into uoption(opt_id,note) values(?,?);";
cnt = (int)OdbcTool.ExecuteSql(sql, key, value);
}
else
{
sql = "update uoption set note = ? where opt_id = ?;";
cnt = (int)OdbcTool.ExecuteSql(sql, value, key);
}
return(cnt > 0);
}
