void init()
{
string sql = "select table_id,tablename from tables order by table_id";
dt = OdbcTool.ExecuteDataTable(sql);
list.ItemsSource = dt.DefaultView;
}
/// <summary>
/// 获取班次
/// </summary>
/// <returns></returns>
public static String GetShift()
{
DateTime serverTime;
serverTime = GetServerTime();
string sql = "";
sql = "SELECT shift_id,shift,time_start FROM shift Where time_start <= ? And time_end >= ?";
DataTable dt = OdbcTool.ExecuteDataTable(sql, serverTime, serverTime);
if (dt.Rows.Count > 0)
{
return(dt.Rows[0][1].ToString());
}
sql = "SELECT shift_id,shift,time_start "
+ " FROM shift Where (SELECT Max(time_start) From shift ) <= ? And "
+ " time_start = (SELECT Max(time_start) From shift )";
dt = OdbcTool.ExecuteDataTable(sql, serverTime);
if (dt.Rows.Count > 0)
{
return(dt.Rows[0][1].ToString());
}
sql = "SELECT shift_id,shift,time_start "
+ " FROM shift Where (SELECT Min(time_end) From shift ) >= ? And "
+ " time_end = (SELECT Min(time_end) From shift)";
dt = OdbcTool.ExecuteDataTable(sql, serverTime);
if (dt.Rows.Count > 0)
{
return(dt.Rows[0][1].ToString());
}
return("");
}
public List <Dish> GetListByTypeId(string typeid)
{
string sql = "select * from dish where dishtype_id = ?";
DataTable dt = OdbcTool.ExecuteDataTable(sql, typeid);
List <Dish> list = dt.ToEntityList <Dish>();
return(list);
}
public List <Dish> GetList()
{
string sql = "select * from dish";
DataTable dt = OdbcTool.ExecuteDataTable(sql);
List <Dish> list = dt.ToEntityList <Dish>();
return(list);
}
public List <Bill> GetByHisorderId(string id)
{
string sql = "select * from bill where hisorder_id = ?";
DataTable dt = OdbcTool.ExecuteDataTable(sql, id);
List <Bill> list = dt.ToEntityList <Bill>();
return(list);
}
public Dish GetById(string id)
{
Dish o = new Dish();
string sql = "select * from dish where dish_id = ?";
DataTable dt = OdbcTool.ExecuteDataTable(sql, id);
o = dt.ToEntity <Dish>();
return(o);
}
public Bill GetByBillId(string id)
{
Bill o = new Bill();
string sql = "select * from bill where bill_id = ?";
DataTable dt = OdbcTool.ExecuteDataTable(sql, id);
o = dt.ToEntity <Bill>();
return(o);
}
public List <Operator> GetList()
{
string sql = "select * from operator";
DataTable dt = OdbcTool.ExecuteDataTable(sql);
dt.TableName = "operator";
List <Operator> list = dt.ToEntityList <Operator>();
return(list);
}
public Hisorder GetByTablename(string tablename)
{
string sql = "select * from hisorder where tablename = ?";
DataTable dt = OdbcTool.ExecuteDataTable(sql, tablename);
dt.TableName = "hisorder";
Hisorder o = dt.ToEntity <Hisorder>();
return(o);
}
public Hisorder GetByHisorderId(string id)
{
Hisorder o = new Hisorder();
string sql = "select * from hisorder where hisorder_id = ?";
DataTable dt = OdbcTool.ExecuteDataTable(sql, id);
dt.TableName = "hisorder";
o = dt.ToEntity <Hisorder>();
return(o);
}
public List <Hisorder> GetList()
{
string sql = "select * from hisorder";
DataTable dt = OdbcTool.ExecuteDataTable(sql);
dt.TableName = "hisorder";
List <Hisorder> list = dt.ToEntityList <Hisorder>();
return(list);
}
public Curorder GetByCurorderId(string id)
{
Curorder o = new Curorder();
string sql = "select * from curorder where curorder_id = ?";
DataTable dt = OdbcTool.ExecuteDataTable(sql, id);
dt.TableName = "curorder";
o = dt.ToEntity <Curorder>();
return(o);
}
public DishType GetByName(string name)
{
DishType o = new DishType();
string sql = "select * from dishtype where dishtype = ?";
DataTable dt = OdbcTool.ExecuteDataTable(sql, name);
dt.TableName = "dishtype";
o = dt.ToEntity <DishType>();
return(o);
}
public List <DishType> GetList()
{
string sql = "select * from dishtype";
DataTable dt = OdbcTool.ExecuteDataTable(sql);
dt.TableName = "dishtype";
List <DishType> list = dt.ToEntityList <DishType>();
return(list);
}
public Operator GetById(string id)
{
Operator o = new Operator();
string sql = "select * from operator where operator_id=?";
DataTable dt = OdbcTool.ExecuteDataTable(sql, id);
dt.TableName = "operator";
o = dt.ToEntity <Operator>();
return(o);
}
public List <Hisorder> GetListByDateRange(DateTime start, DateTime end)
{
string sql = "select * from hisorder where date(bill_date) between ? and ?";
DataTable dt = OdbcTool.ExecuteDataTable(sql, start, end);
dt.TableName = "hisorder";
List <Hisorder> list = dt.ToEntityList <Hisorder>();
return(list);
}
public List <HisorderDetail> GetListByHisorderId(string id)
{
List <HisorderDetail> list = new List <HisorderDetail>();
string sql = "select * from hisorderdetail where hisorder_id = ?";
DataTable dt = OdbcTool.ExecuteDataTable(sql, id);
dt.TableName = "hisorderdetail";
list = dt.ToEntityList <HisorderDetail>();
return(list);
}
public List <Bill> GetList()
{
string sql = "select * from bill";
DataTable dt = OdbcTool.ExecuteDataTable(sql);
dt.TableName = "bill";
List <Bill> list = dt.ToEntityList <Bill>();
return(list);
}
public static void testODBCDataSet()
{
String sql = "select * from uoption where opt_id = ?";
OdbcCommand cmd;
DataTable table = OdbcTool.ExecuteDataTable(sql, out cmd, "900002");
table.Rows[0][3] = table.Rows[0][3].ToString() + "c";
int rtn = OdbcTool.UpdateDataTable(table, cmd);
Console.WriteLine(rtn.ToString());
}
private void Update_Click(object sender, RoutedEventArgs e)
{
sql = "select * from uoption where opt_id = ?";
OdbcCommand cmd;
DataTable dr = OdbcTool.ExecuteDataTable(sql, out cmd, "900002");
dr.Rows[0]["note"] = "csj1";
int rtn = OdbcTool.UpdateDataTable(dr, cmd);
MessageBox.Show(rtn.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);
}