/// <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); }