//构造函数
public DepositForm(CSeat seat)
{
db = new BathDBDataContext(LogIn.connectionString);
m_Seat = seat;
dao = new DAO(LogIn.connectionString);
//m_Seat = db.Seat.FirstOrDefault(x => x.systemId == seat.systemId);
InitializeComponent();
}
//构造函数
public OrderCheckForm(CSeat seat, string con_str, COptions options)
{
m_con_str = con_str;
m_Seat = seat;
m_options = options;
dao = new DAO(con_str);
InitializeComponent();
}
//构造函数
public MemberFingerForm(CCardInfo member)
{
InitializeComponent();
try
{
dao = new DAO(LogIn.connectionString);
m_member = member;
}
catch (System.Exception e)
{
BathClass.printErrorMsg(e.Message);
}
}
//构造函数
public MemberPromotionForm(List<CSeat> seat, string systemid)
{
InitializeComponent();
try
{
dao = new DAO(LogIn.connectionString);
m_systemId = systemid;
m_Seats = seat;
}
catch (System.Exception e)
{
BathClass.printErrorMsg(e.Message);
}
}
public OpenSeatForm(CSeat seat, bool open)
{
m_open = open;
//var db = new BathDBDataContext(LogIn.connectionString);
m_Seats.Add(seat);
seat_length = seat.text.Length;
dao = new DAO(LogIn.connectionString);
chainId = dao.chainId();
seatlock = LogIn.options.启用手牌锁.Value;
lock_type = LogIn.options.手牌锁类型;
auto_seat_card = MConvert<bool>.ToTypeOrDefault(LogIn.options.自动感应手牌, false);
InitializeComponent();
seatBox.Enabled = MConvert<bool>.ToTypeOrDefault(LogIn.options.允许手工输入手牌号开牌, false);
dgv_show();
}
private bool _close = false; //线程终止标志
#endregion Fields
#region Constructors
//构造函数
public SeatExpenseForm(CSeat seat, int _seat_length, bool _seatLock, bool _auto_seat_card, DAO _dao)
{
seatLock = _seatLock;
auto_seat_card = _auto_seat_card;
seat_length = _seat_length;
dao = _dao;
if (seatLock)
{
m_Seats.Add(dao.get_seat("text", seat.text));
}
else
{
string cmd_str = "((chainId is null and text='" + seat.text + "') or (chainId is not null and chainId='" + seat.chainId + "'))"
+ @" and (status=2 or status=6 or status=7 or status=8)";
var seats = dao.get_seats(cmd_str);
m_Seats.AddRange(seats);
}
var pars = new List<string>();
pars.Add("paying");
var vals = new List<string>();
vals.Add("True");
int count = m_Seats.Count;
string update_str = @"update [Seat] set paying='True' where ";
for (int i = 0; i < count; i++ )
{
update_str += "text='" + m_Seats[i].text + "'";
if (i != count - 1)
update_str += " or ";
}
if (!dao.execute_command(update_str))
{
BathClass.printErrorMsg("手牌状态更新失败，如有超时浴资，请删除手牌重新载入");
}
InitializeComponent();
}
//对话框载入
private void MemberPopForm_Load(object sender, EventArgs e)
{
dao = new DAO(LogIn.connectionString);
cardType = MemberForm.memberSetting.cardType;
id.ReadOnly = !(cardType == "CT");
if (cardType != "CT")
get_member();
else
id.Focus();
}
//��ӡ̨λ������Ϣ
public static void print_seat_information(System.Drawing.Printing.PrintPageEventArgs e)
{
DAO dao=new DAO(LogIn.connectionString);
List<string> infor = new List<string>();
string str = "�� �� ��:" + m_Act.id;
infor.Add(str);
str = "̨��/�����:";
string s_str = "\n ";
bool first = true;
int i = 0;
foreach (var t in m_seats)
{
if (m_room != null)
{
if (first)
str += t.text + " " + m_room[i];
else
str += s_str + t.text + " " + m_room[i];
}
else
{
if (first)
str += t.text ;
else
str += s_str + t.text;
}
if (t.note != null && t.note.Contains("������"))
str += "(������)";
i++;
first = false;
}
infor.Add(str);
str = "����ʱ��:" + m_Act.openTime.Split('|')[0];
infor.Add(str);
str = "��ʱ��:" + DateTime.Now.ToString();
infor.Add(str);
str = "��ҵԱ��:" + LogIn.m_User.name;
infor.Add(str);
foreach (string st in infor)
{
print_str(e, st, 11F, e.MarginBounds.Left, tmpTop); //ԭ����13F���壬���ڸ�Ϊ11F
tmpTop += str_h(e, 11F, st);
}
}
//对话框载入
private void MemberReadForm_Load(object sender, EventArgs e)
{
dao = new DAO(LogIn.connectionString);
get_member();
}
public ReserveOverDueForm(Seat seat)
{
dao = new DAO(LogIn.connectionString);
m_seat = dao.get_seat("text='" + seat.text + "'");
InitializeComponent();
}
//监控台位数据库改变
/*private void watchSeat()
{
if (m_connection == null)
m_connection = new SqlConnection(LogIn.connectionString);
if (m_connection.State != ConnectionState.Open)
m_connection.Open();
SqlCommand cmd = m_connection.CreateCommand();
cmd.Notification = null;//清除
cmd.CommandText = "select id, oId, text, typeId, systemId, openTime, openEmployee, payTime, payEmployee, chainId, status From dbo.Seat";
//监控台位数据库
SqlDependency dependency = new SqlDependency(cmd);
dependency.OnChange += new OnChangeEventHandler(seat_OnChange);
//SqlDependency绑定的SqlCommand对象必须要执行一下，才能将SqlDependency对象的HasChange属性设为true
SqlDataAdapter thisAdapter = new SqlDataAdapter(cmd);
DataSet posDataSet = new DataSet();
thisAdapter.Fill(posDataSet, "Seat");
//刷新台位信息
if (this.WindowState != FormWindowState.Minimized)
update_seats();
//刷新状态栏
setStatus();
}
private delegate void watchSeatDelegate();
//监控台位数据库改变
private void seat_OnChange(object sender, SqlNotificationEventArgs e)
{
//因为是子线程，需要用invoke方法更新ui
if (this.InvokeRequired)
{
this.Invoke(new watchSeatDelegate(watchSeat), null);
}
else
{
watchSeat();
}
SqlDependency dependency = (SqlDependency)sender;
//通知之后，当前dependency失效，需要重新设置通知
dependency.OnChange -= seat_OnChange;
}*/
//点击台位按钮
private void btn_Click(object sender, EventArgs e)
{
var db_new = new BathDBDataContext(LogIn.connectionString);
Button btn = sender as Button;
btn.Enabled = false;
btn.Enabled = true;
var seat = db_new.Seat.FirstOrDefault(x => x.text == btn.Text);
switch (seat.status)
{
case 2://正在使用
case 6://警告
case 7://押金离场
case 8://重新结账
var dao = new DAO(LogIn.connectionString);
var s = dao.get_seat("text='" + seat.text + "'");
OrderCheckForm orderForm = new OrderCheckForm(s, LogIn.connectionString, LogIn.options);
orderForm.ShowDialog();
break;
default:
break;
}
}
public static void reprint_bill(CSeat seat, DAO dao, bool use_pad)
{
if (seat.status != SeatStatus.PAIED)
{
BathClass.printErrorMsg("已经重新开牌，不能重打账单!");
return;
}
var account = dao.get_account("abandon is null and systemId like '%" + seat.systemId + "%'");
if (account == null)
return;
var seats_txt = account.text.Split('|');
string state_str = "";
int count = seats_txt.Count();
for (int i = 0; i < count; i++)
{
state_str += "text='" + seats_txt[i] + "'";
if (i != count - 1)
state_str += " or ";
}
var seats_reprint = dao.get_seats(state_str);
List<string> m_rooms = new List<string>();
foreach (var s in seats_reprint)
{
m_rooms.Add(dao.get_seat_room(s.text));
}
DataGridView dgv = new DataGridView();
DataGridViewTextBoxColumn col = new DataGridViewTextBoxColumn();
col.HeaderText = "手牌";
dgv.Columns.Add(col);
DataGridViewTextBoxColumn coll = new DataGridViewTextBoxColumn();
coll.HeaderText = "房间";
dgv.Columns.Add(coll);
DataGridViewTextBoxColumn col1 = new DataGridViewTextBoxColumn();
col1.HeaderText = "项目名称";
dgv.Columns.Add(col1);
DataGridViewTextBoxColumn col2 = new DataGridViewTextBoxColumn();
col2.HeaderText = "技师";
dgv.Columns.Add(col2);
DataGridViewTextBoxColumn col3 = new DataGridViewTextBoxColumn();
col3.HeaderText = "单价";
dgv.Columns.Add(col3);
DataGridViewTextBoxColumn col4 = new DataGridViewTextBoxColumn();
col4.HeaderText = "数量";
dgv.Columns.Add(col4);
DataGridViewTextBoxColumn col5 = new DataGridViewTextBoxColumn();
col5.HeaderText = "金额";
dgv.Columns.Add(col5);
List<string> printCols = new List<string>();
printCols.Add("手牌");
if (use_pad)
printCols.Add("房间");
printCols.Add("项目名称");
printCols.Add("单价");
printCols.Add("数量");
printCols.Add("金额");
var use_disAssemble = MConvert<bool>.ToTypeOrDefault(LogIn.options.启用大项拆分, false);
var co_name = LogIn.options.companyName;
if (account != null)
{
try
{
var db = new BathDBDataContext(LogIn.connectionString);
var orders = db.HisOrders.Where(x => x.deleteEmployee == null && x.accountId == account.id).OrderBy(x => x.text);
foreach (var order in orders)
{
var cmenu = db.Menu.FirstOrDefault(x => x.name == order.menu);
var price = "";
if (cmenu != null)
{
price = cmenu.price.ToString();
if (use_disAssemble && db.BigCombo.FirstOrDefault(x => x.menuid == cmenu.id) != null)
{
var substIDs = BathClass.disAssemble(db.BigCombo.FirstOrDefault(x => x.menuid == cmenu.id).substmenuid, Constants.SplitChar);
for (int i = 0; i < substIDs.Count; i++)
{
var menu = db.Menu.FirstOrDefault(x => x.id == substIDs[i]);
dgv.Rows.Add(order.text, order.roomId, menu.name, order.technician,
menu.price, order.number, menu.price * MConvert<double>.ToTypeOrDefault(order.number, 0));
}
continue;
}
}
dgv.Rows.Add(order.text, order.roomId, order.menu, order.technician, price, order.number,order.money);
}
PrintBill.Print_DataGridView(seats_reprint, m_rooms,account, "存根单", dgv, printCols, co_name);
}
catch (System.Exception ex)
{
BathClass.printErrorMsg(ex.ToString());
}
}
else
{
double money = 0;
try
{
var db = new BathDBDataContext(LogIn.connectionString);
var orders = db.Orders.Where(x => x.text == seat.text && x.systemId != seat.systemId && x.deleteEmployee == null).OrderBy(x => x.text);
foreach (var order in orders)
{
var cmenu = db.Menu.FirstOrDefault(x => x.name == order.menu);
var price = "";
if (cmenu != null)
price = cmenu.price.ToString();
dgv.Rows.Add(order.text, order.roomId, order.menu, order.technician, price, order.number, order.money);
}
if (dgv.Rows.Count != 0)
{
BathClass.printErrorMsg("未检测到转账单或者结账单");
return;
}
PrintSeatBill.Print_DataGridView(seats_reprint, m_rooms,"", "转账确认单", dgv, printCols, money.ToString(), co_name);
}
catch (System.Exception ex)
{
BathClass.printErrorMsg(ex.ToString());
}
}
}
private void MainForm_Load(object sender, EventArgs e)
{
dgv.ColumnHeadersDefaultCellStyle.Font = new Font("宋体", 18);
dgv.RowsDefaultCellStyle.Font = new Font("宋体", 18);
dao = new DAO(LogIn.connectionString);
dgv_show();
}
//对话框载入
private void MemberForm_Load(object sender, EventArgs e)
{
dao = new DAO(LogIn.connectionString);
memberSetting = dao.get_MemberSetting();
}
//对话框载入
private void ReceptionSeatForm_Load(object sender, EventArgs e)
{
dao = new DAO(LogIn.connectionString);
seatLock = MConvert<bool>.ToTypeOrDefault(LogIn.options.启用手牌锁, false);
auto_seat_card = MConvert<bool>.ToTypeOrDefault(LogIn.options.自动感应手牌, false);
use_pad = MConvert<bool>.ToTypeOrDefault(LogIn.options.启用客房面板, false);
lock_type = LogIn.options.手牌锁类型;
tSeat.Visible = !seatLock;
this.Text = "咱家店小二-前台系统" + Constants.version + " 欢迎使用：" + LogIn.m_User.id;
currentUser.Text = "当前用户: " + LogIn.m_User.id + " " + LogIn.m_User.name;
var td = new Thread(new ThreadStart(initial_ui_thread));
td.IsBackground = true;
td.Start();
//CFormCreate.createSeat(db, seatPanel, seatTab, new EventHandler(btn_Click), seatContext);
//setStatus(db);
m_thread = new Thread(new ThreadStart(update_seats_ui));
m_thread.IsBackground = true;
m_thread.Start();
m_thread_clearMemory = new Thread(new ThreadStart(clear_Memory));
m_thread_clearMemory.IsBackground = true;
m_thread_clearMemory.Start();
if (seatLock && auto_seat_card)
{
m_thread_seatCard = new Thread(new ThreadStart(seat_card_thread));
m_thread_seatCard.IsBackground = true;
m_thread_seatCard.Start();
}
}
//对话框载入
private void MemberCardUsingForm_Load(object sender, EventArgs e)
{
dao = new DAO(LogIn.connectionString);
memberSetting = dao.get_MemberSetting();
id.Enabled = (memberSetting.cardType == "CT");
if (!MConvert<bool>.ToTypeOrDefault(LogIn.options.启用会员卡密码, false) || LogIn.options.会员卡密码类型 != "指纹")
{
m_use_finger_pwd = false;
}
btnAdd_Click(null, null);
money.Text = m_money.ToString();
}
private void tool_open_seat()
{
var db_new = new BathDBDataContext(LogIn.connectionString);
string text = tSeat.Text;
m_Seat = db_new.Seat.FirstOrDefault(x => x.text == text);
if (m_Seat == null || (m_Seat.status != 2 && m_Seat.status != 6 && m_Seat.status != 7 && m_Seat.status != 8))
{
GeneralClass.printErrorMsg("手牌不存在或者不在使用中，不可查看消费!");
return;
}
var dao = new DAO(LogIn.connectionString);
var s = dao.get_seat("text", m_Seat.text);
OrderCheckForm orderCheckForm = new OrderCheckForm(s, LogIn.connectionString, LogIn.options);
orderCheckForm.ShowDialog();
tSeat.Text = "";
}
//对话框载入
private void InputSeatForm_Load(object sender, EventArgs e)
{
dao = new DAO(LogIn.connectionString);
}
//对话框载入
private void ReceptionSeatForm_Load(object sender, EventArgs e)
{
dao = new DAO(LogIn.connectionString);
//var db = new BathDBDataContext(LogIn.connectionString);
this.Text = Constants.appName + "-吧台" + Constants.version + " 欢迎使用：" + LogIn.m_User.id;
currentUser.Text = "当前用户:" + LogIn.m_User.id + " " + LogIn.m_User.name;
//CFormCreate.createSeat(db, seatPanel, seateTab, new System.EventHandler(btn_Click), null);
var td = new Thread(new ThreadStart(initial_ui_thread));
td.IsBackground = true;
td.Start();
if (MConvert<bool>.ToTypeOrDefault(LogIn.options.启用客房面板, false))
{
msg_delay = LogIn.options.包房等待时限.HasValue ?
LogIn.options.包房等待时限.Value : 10;
m_thread_msg = new Thread(new ThreadStart(msgTimer_Elapsed));
m_thread_msg.IsBackground = true;
m_thread_msg.Start();
m_thread_wait_over = new Thread(new ThreadStart(room_wait_over_detect));
m_thread_wait_over.IsBackground = true;
m_thread_wait_over.Start();
btnCab.Visible = false;
cabL.Visible = false;
}
else
{
roomL.Visible = false;
btnRoom.Visible = false;
callL.Visible = false;
toolCall.Visible = false;
toolMsg.Visible = false;
msgL.Visible = false;
toolWarn.Visible = false;
}
m_thread_update_seat = new Thread(new ThreadStart(update_seats_ui));
m_thread_update_seat.IsBackground = true;
m_thread_update_seat.Start();
m_thread_clearMemory = new Thread(new ThreadStart(clear_Memory));
m_thread_clearMemory.IsBackground = true;
m_thread_clearMemory.Start();
}
//对话框载入
private void MemberStopForm_Load(object sender, EventArgs e)
{
dao = new DAO(LogIn.connectionString);
}
public double get_combo_price(DAO dao)
{
double combo_price = 0;
if (this._priceType == "免项目" || this._priceType == "消费满免项目")
{
var freeIds = disAssemble_freeIds();
var pars = new List<string>();
var vals = new List<string>();
int count = freeIds.Count;
for (int i = 0; i < count; i++)
{
pars.Add("id");
vals.Add(freeIds[i].ToString());
}
var freeMenus = dao.get_Menus(pars, vals, "or");
//var freeMenus = db.Menu.Where(x => freeIds.Contains(x.id));
var freeMoney = freeMenus.Sum(x => x.price);
combo_price = freeMoney;
}
else if (this._priceType == "减金额")
combo_price = this._originPrice - this._price.Value;
return combo_price;
}
//对话框载入
private void ReceptionSeatForm_Load(object sender, EventArgs e)
{
dao = new DAO(LogIn.connectionString);
this.Text = "咱家店小二-客房系统" + Constants.version + " 欢迎使用：" + LogIn.m_User.id;
currentUser.Text = "当前用户: " + LogIn.m_User.id + " " + LogIn.m_User.name;
int rt = RoomProRFL.initializeUSB(1);
if (rt != 0)
{
BathClass.printErrorMsg("打开USB失败!");
//this.Close();
//return;
}
var td = new Thread(new ThreadStart(initial_ui_thread));
td.IsBackground = true;
td.Start();
m_thread = new Thread(new ThreadStart(update_seats_ui));
m_thread.IsBackground = true;
m_thread.Start();
}
//��ӡ̨λ������Ϣ
public static void print_seat_information(System.Drawing.Printing.PrintPageEventArgs e)
{
List<string> infor = new List<string>();
List<string> m_rooms=new List<string>();
DAO dao = new DAO(LogIn.connectionString);
int i = 0;
//string str = "̨ ��:";
string str = "̨��/�����:";
string s_str = "\n ";
bool first = true;
//var sarray = m_Act.text.Split('|').ToArray();
var sarray = m_seats.Select(x => x.text);
foreach ( var s in m_seats)
{
m_rooms.Add(dao.get_seat_room(s.text));
}
foreach (var t in sarray)
{
if (first)
str += t + " " + m_rooms[i];
else
str += s_str + t+ " " + m_rooms[i];
first = false;
i++;
}
//+ string.Join("\n", );
infor.Add(str);
str = "����ʱ��:" + m_seats[0].openTime;
infor.Add(str);
str = "��ʱ��:" + BathClass.Now(LogIn.connectionString).ToString();
infor.Add(str);
str = "��ҵԱ��:" + LogIn.m_User.name;
infor.Add(str);
//����ԭ��Ϊ13F,���ڸ�Ϊ11F,��������2014-04-15
foreach (string st in infor)
{
print_str(e, st, 11F, e.MarginBounds.Left, tmpTop);
tmpTop += str_h(e, 11F, st);
}
}
//对话框载入
private void MemberResumForm_Load(object sender, EventArgs e)
{
dao = new DAO(LogIn.connectionString);
cardType = MemberForm.memberSetting.cardType;
id.ReadOnly = !(cardType == "CT");
}
//对话框载入
private void Form1_Load(object sender, EventArgs e)
{
connectionIP = IOUtil.get_config_by_key(ConfigKeys.KEY_CONNECTION_IP);
if (connectionIP == "")
{
PCListForm pCListForm = new PCListForm();
if (pCListForm.ShowDialog() != DialogResult.OK)
{
this.Close();
return;
}
connectionIP = pCListForm.ip;
IOUtil.set_config_by_key(ConfigKeys.KEY_CONNECTION_IP, connectionIP);
}
dao = new DAO(connectionString);
if (!dao.check_net())
{
BathClass.printErrorMsg("连接IP不对或者网络不通，请重试!");
this.Close();
return;
}
_options = dao.get_options();
m_company = _options.companyName;
print_tech_msg = MConvert<bool>.ToTypeOrDefault(options.打印技师派遣单, false);
user_card = MConvert<bool>.ToTypeOrDefault(options.启用员工服务卡, false);
IPHostEntry ipe = Dns.GetHostEntry(Dns.GetHostName());
foreach (var ip in ipe.AddressList)
{
m_ip = ip.ToString();
if (System.Text.RegularExpressions.Regex.IsMatch(m_ip, "[0-9]{1,3}//.[0-9]{1,3}//.[0-9]{1,3}//.[0-9]{1,3}"))
break;
}
setMax();
//dgv.ColumnHeadersDefaultCellStyle.Font = new Font("宋体", 20);
//dgv.RowsDefaultCellStyle.Font = new Font("宋体", 20);
//dgv_show();
m_thread = new Thread(new ThreadStart(detect_msg));
m_thread.IsBackground = true;
m_thread.Start();
m_thread_tech = new Thread(new ThreadStart(detect_tech_index));
m_thread_tech.IsBackground = true;
m_thread_tech.Start();
clock_timer = new System.Timers.Timer();
clock_timer.Interval = 1000;
clock_timer.Elapsed += new System.Timers.ElapsedEventHandler(clock_timer_Elapsed);
clock_timer.Enabled = true;
m_player = new SoundPlayer();
techId.Focus();
m_thread_clearMemory = new Thread(new ThreadStart(clear_Memory));
m_thread_clearMemory.IsBackground = true;
m_thread_clearMemory.Start();
SplitGender.SplitterDistance = SplitGender.Width*2 / 3;
create_tech_panel();
}
private void OpenDepositForm_Load(object sender, EventArgs e)
{
//db = new BathDBDataContext(LogIn.connectionString);
//m_seatType = db.SeatType.FirstOrDefault(x => x.id == m_seat.typeId);
dao = new DAO(LogIn.connectionString);
m_seatType = dao.get_seattype("id", m_seat.typeId);
depositMin.Text = m_seatType.depositeAmountMin.ToString();
}
//对话框载入
private void ReceptionSeatForm_Load(object sender, EventArgs e)
{
dao = new DAO(LogIn.connectionString);
//var db = new BathDBDataContext(LogIn.connectionString);
seat_length = dao.get_seat_length();
seat_start = (seat_length == 3) ? 17 : 16;
//var ops = db.Options.FirstOrDefault();
seatLock = MConvert<bool>.ToTypeOrDefault(LogIn.options.启用手牌锁, false);
auto_seat_card = MConvert<bool>.ToTypeOrDefault(LogIn.options.自动感应手牌, false);
use_pad = MConvert<bool>.ToTypeOrDefault(LogIn.options.启用客房面板, false);
lock_type = LogIn.options.手牌锁类型;
has_double_department = dao.has_hotel_department();
tSeat.Visible = (!seatLock || has_double_department);
this.Text = Constants.appName + "-前台系统" + Constants.version + " 欢迎使用：" + LogIn.m_User.id;
currentUser.Text = "当前用户: " + LogIn.m_User.id + " " + LogIn.m_User.name;
var td = new Thread(new ThreadStart(initial_ui_thread));
td.IsBackground = true;
td.Start();
m_thread = new Thread(new ThreadStart(update_seats_ui));
m_thread.IsBackground = true;
m_thread.Start();
m_thread_clearMemory = new Thread(new ThreadStart(clear_Memory));
m_thread_clearMemory.IsBackground = true;
m_thread_clearMemory.Start();
if (seatLock && auto_seat_card)
{
m_thread_seatCard = new Thread(new ThreadStart(seat_card_thread));
m_thread_seatCard.IsBackground = true;
m_thread_seatCard.Start();
}
if (has_double_department)
{
m_thread_detect_reserve_over_due = new Thread(new ThreadStart(detect_reserve_over_due));
m_thread_detect_reserve_over_due.IsBackground = true;
m_thread_detect_reserve_over_due.Start();
}
}
private void OpenSeatForm_Load(object sender, EventArgs e)
{
roomNumber.Text = m_seat.text;
TextName.Text = m_seat.name;
TextPhone.Text = m_seat.phone;
TextDeposit.Text = m_seat.deposit.ToString();
TextDepositBank.Text = m_seat.depositBank.ToString();
days.CustomFormat = "yyyy-MM-dd-HH:mm";
days.Value = m_seat.dueTime.Value;
DateOpenTime.Value = m_seat.openTime.Value;
//chainId = BathClass.chainId(db, LogIn.connectionString);
dao = new DAO(LogIn.connectionString);
chainId = dao.chainId();
}
//构造函数
public MemberPromotionOptionForm(List<CSeat> seats)
{
dao = new DAO(LogIn.connectionString);
m_Seats = seats;
InitializeComponent();
}
private void OpenSeatForm_Load(object sender, EventArgs e)
{
roomNumber.Text = m_seat.text;
name.Text = m_seat.name;
phone.Text = m_seat.phone;
days.CustomFormat = "yyyy-MM-dd-HH:mm";
days.Value = Convert.ToDateTime(DateTime.Now.AddDays(1).ToString("yyyy-MM-dd") + " 12:00:00");
//chainId = BathClass.chainId(db, LogIn.connectionString);
dao = new DAO(LogIn.connectionString);
chainId = dao.chainId();
}
