private void BtnQueNext_Click(object sender, EventArgs e)
{
//throw new NotImplementedException();
String stfid = "", queid = "", prefix = "", code = "";
//stfid = bqc.getIdCombo(cboStf, cboStf.Text);
if (queCaller == null)
{
MessageBox.Show("ไม่พบ caller", "");
return;
}
if (queCaller.queue_call_id == null)
{
MessageBox.Show("ไม่พบ caller", "");
return;
}
if (queCaller.queue_call_id.Length <= 0)
{
MessageBox.Show("ไม่พบ caller", "");
return;
}
btnQueNext.Enabled = false;
//if (tque.t_queue_id == null)
//{
// MessageBox.Show("ไม่พบเลขที่คิว", "");
// return;
//}
//if (tque.t_queue_id.Length <= 0)
//{
// MessageBox.Show("ไม่พบเลขที่คิว", "");
// return;
//}
String date = System.DateTime.Now.Year + "-" + System.DateTime.Now.ToString("MM-dd");
//que = bqc.bquDB.queDB.selectQueByStfQueDate(stfid, date);
//เรียกคิว
tque.t_queue_id = tque.t_queue_id == null ? "" : tque.t_queue_id;
tque = bqc.bquDB.tqueDB.LockQueue(bqued.b_queue_date_id, tque.t_queue_id, queCaller.queue_call_id);
//tque = new TQueue();
if (tque.t_queue_id.Equals("-1"))
{
lbStatus.Text = tque.queue_name;
}
else if (tque.t_queue_id.Length > 3)
{
lbStatus.Text = "OK";
}
code = bqc.prefixQue(tque);
bqued = bqc.bquDB.queDateDB.selectByPk1(bqued.b_queue_date_id);
lbQue.Text = bqc.prefixQue1(bqued.queuecode, bqued.queueprefix, bqued.queue);
lbQueCur.Text = tque.queue_current;
lbTQueId.Text = tque.t_queue_id;
//lbStatus.Text = "";
chkQueSend.Checked = false;
chkQueVoid.Checked = false;
cboQueSend.Text = "";
playSound();
}
private void setControl()
{
String date = System.DateTime.Now.Year + "-" + System.DateTime.Now.ToString("MM-dd");
bqued = new BQueueDate();
String stfid = "", caller = "", call = "";
stfid = bqc.getIdCombo(cboQueDate, cboQueDate.Text);
bqued = bqc.bquDB.queDateDB.selectByPk1(stfid);
call = bqc.iniF.getIni("app", "QueueCaller");
//new LogWriter("d", "FrmQueueNext call " + call);
queCaller = bqc.bquDB.quecDB.selectByName(bqc.iniF.getIni("app", "QueueCaller"));
//new LogWriter("d", "FrmQueueNext queCaller " + queCaller.queue_call_id+" "+ queCaller.queue_call_name);
//queCaller.queue_call_id = grf[grf.Row, 1] != null ? grf[grf.Row, 1].ToString() : "";
//queCaller.queue_call_name = grf[grf.Row, 2] != null ? grf[grf.Row, 2].ToString() : "";
rbCaller.Text = "caller [" + queCaller.queue_call_name + "]";
lbQue.Text = "";
lbQueCur.Text = "";
btnQueVoid.Visible = false;
setControlQueSend(false);
chkQueSend.Checked = false;
chkQueVoid.Checked = false;
}
public String update(BQueueDate p, String userId)
{
String re = "";
String sql = "";
int chk = 0;
chkNull(p);
sql = "Update " + bque.table + " Set " +
" " + bque.queue_date + "='" + p.queue_date + "' " +
//"," + bque.queue_current + "='" + p.queue_current + "' " +
//"," + bque.queue + "='" + p.queue + "' " +
"," + bque.queue_id + "='" + p.queue_id.Replace("'", "''") + "' " +
"Where " + bque.pkField + "='" + p.b_queue_date_id + "'"
;
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
private void BtnQueAdd_Click(object sender, EventArgs e)
{
//throw new NotImplementedException();
String date = "";
date = DateTime.Now.Year + DateTime.Now.ToString("-MM-dd");
que.b_queue_id = txtQueId.Text;
que.queue_name = txtQueName.Text;
que.queue = txtQueNum.Text;
BQueueDate quetoday = new BQueueDate();
quetoday.b_queue_date_id = "";
quetoday.queue_id = que.b_queue_id;
quetoday.queue_current = txtQueNum.Text.Trim();
quetoday.queue_date = date;
quetoday.queue = txtQueNum.Text.Trim();
String re = bqc.bquDB.queDateDB.insertBQueue(quetoday, "");
int chk = 0;
if (int.TryParse(re, out chk))
{
setGrfQueueToday();
setGrfQueue();
lbStatus.Text = "Save success ";
}
}
public String insert(BQueueDate p, String userId)
{
String re = "";
String sql = "";
p.active = "1";
//p.ssdata_id = "";
int chk = 0;
chkNull(p);
sql = "Insert Into " + bque.table + " set " +
" " + bque.queue_date + "='" + p.queue_date + "' " +
"," + bque.queue_current + "='" + p.queue_current + "' " +
"," + bque.queue + "='" + p.queue + "' " +
"," + bque.queue_id + "='" + p.queue_id.Replace("'", "''") + "' " +
"";
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
private void setControl()
{
String date = System.DateTime.Now.Year + "-" + System.DateTime.Now.ToString("MM-dd");
bque = new BQueueDate();
String stfid = "";
stfid = bqc.getIdCombo(cboStf, cboStf.Text);
bque = bqc.bquDB.queDateDB.selectByPk1(date, stfid);
lbQueCurr.Text = bque.queue_current;
//lbQue.Text = bque.queue;
}
public BQueueDate selectByPk1(String date, String stfid)
{
BQueueDate stf1 = new BQueueDate();
DataTable dt = new DataTable();
String sql = "select qued.*, que.queue_name,que.queue_code,que.queue_prefix,que.status_everyday " +
"From " + bque.table + " qued " +
"inner Join b_queue que on que.queue_id = qued.queue_id " +
"Where qued.queue_date = '" + date + "' and qued." + bque.queue_id + "='" + stfid + "'";
dt = conn.selectData(conn.conn, sql);
stf1 = setBQueue(dt);
return(stf1);
}
private BQueueDate setBQueue1(BQueueDate stf1)
{
stf1.b_queue_date_id = "";
stf1.queue_date = "";
stf1.queue_current = "";
stf1.queuename = "";
stf1.queuename1 = "";
stf1.queue_id = "";
stf1.queue = "";
stf1.queuecode = "";
stf1.queueprefix = "";
stf1.statuseveryday = "";
return(stf1);
}
private void initConfig()
{
bque = new BQueueDate();
bque.b_queue_date_id = "b_queue_date_id";
bque.queue_id = "queue_id";
bque.queue_date = "queue_date";
bque.queue_current = "queue_current"; //ตอนนี้ ถึงคิว ที่เท่าไร จะได้รู้ว่าต้องรอ อีกกี่คิว
bque.queue = "queue"; //คิวที่กดได้ เลขที่คิว
bque.table = "b_queue_date";
bque.pkField = "b_queue_date_id";
lStf = new List <BQueueDate>();
}
public String insertBQueue(BQueueDate p, String userId)
{
String re = "";
if (p.b_queue_date_id.Equals(""))
{
re = insert(p, "");
}
else
{
re = update(p, "");
}
return(re);
}
private void showFrmNewDay()
{
frmQueNew = new Form();
frmQueNew.Size = new System.Drawing.Size(800, 600);
frmQueNew.WindowState = FormWindowState.Normal;
frmQueNew.FormBorderStyle = FormBorderStyle.FixedDialog;
frmQueNew.StartPosition = FormStartPosition.CenterScreen;
pnQueNewBotton = new Panel();
pnQuenewTop = new Panel();
pnQueNewBotton.Dock = DockStyle.Bottom;
pnQuenewTop.Dock = DockStyle.Fill;
btnQueNewOK = new C1Button();
bqc.setControlC1Button(ref btnQueNewOK, fEdit, "SAVE", "btnQueNewOK", pnQueNewBotton.Width - btnQueNewOK.Width - 20, 20);
//btnQueNewOK.Width =
btnQueNewOK.Click += BtnQueNewOK_Click;
initGrfQueNew();
frmQueNew.Controls.Add(pnQuenewTop);
frmQueNew.Controls.Add(pnQueNewBotton);
pnQueNewBotton.Controls.Add(btnQueNewOK);
String date = "";
date = DateTime.Now.Year + DateTime.Now.ToString("-MM-dd");
DataTable dt = new DataTable();
dt = bqc.bquDB.queDB.selectAllStatusEveryDay();
foreach (DataRow drow in dt.Rows)
{
BQueueDate quetoday = new BQueueDate();
quetoday.b_queue_date_id = "";
quetoday.queue_id = drow["queue_id"].ToString();
quetoday.queue_current = "0";
quetoday.queue_date = date;
quetoday.queue = "0";
String re = bqc.bquDB.queDateDB.insertBQueue(quetoday, "");
int chk = 0;
if (int.TryParse(re, out chk))
{
//setGrfQueue();
lbStatus.Text = "Save success ";
}
}
setGrfQueueToday();
frmQueNew.ShowDialog(this);
}
private void BtnQuePlus_Click(object sender, EventArgs e)
{
//throw new NotImplementedException();
int screenWidth = Screen.PrimaryScreen.Bounds.Width;
int screenHeight = Screen.PrimaryScreen.Bounds.Height;
int que = 0, chk = 0;
String stfid = "";
DateTime dt = new DateTime();
if (!int.TryParse(txtQue.Text, out que))
{
MessageBox.Show("txtQue.Text " + txtQue.Text, "");
return;
}
stfid = bqc.getIdCombo(cboStf, cboStf.Text);
if (stfid.Equals(""))
{
MessageBox.Show("stfid " + stfid, "");
return;
}
if (!DateTime.TryParse(txtQueDate.Text, out dt))
{
MessageBox.Show("txtQueDate.Text " + txtQueDate.Text, "");
return;
}
BQueueDate bque = new BQueueDate();
//bque.b_queue_id = "";
//bque.staff_id = stfid;
bque.queue_date = dt.Year + "-" + dt.ToString("MM-dd");
bque.queue_current = "0";
//bque.queue = que.ToString();
String bquid = "";
bquid = bqc.bquDB.queDateDB.selectBQueIdByStfQueDate(stfid, bque.queue_date);
//bque.b_queue_id = bquid;
String re = bqc.bquDB.queDateDB.insertBQueue(bque, "");
if (int.TryParse(re, out chk))
{
initGrd(screenWidth, screenHeight);
setGrd();
}
}
public String selectMaxQueByPk1(String bqueid)
{
String re = "0";
int chk = 0;
BQueueDate stf1 = new BQueueDate();
DataTable dt = new DataTable();
String sql = "select bque.* " +
"From " + bque.table + " bque " +
"Where bque." + bque.pkField + " = '" + bqueid + "'";
dt = conn.selectData(conn.conn, sql);
stf1 = setBQueue(dt);
if (int.TryParse(stf1.queue_current, out chk))
{
chk++;
re = chk.ToString();
}
return(re);
}
private void chkNull(BQueueDate p)
{
long chk = 0;
p.date_modi = p.date_modi == null ? "" : p.date_modi;
p.date_cancel = p.date_cancel == null ? "" : p.date_cancel;
p.user_create = p.user_create == null ? "" : p.user_create;
p.user_modi = p.user_modi == null ? "" : p.user_modi;
p.user_cancel = p.user_cancel == null ? "" : p.user_cancel;
//p.prefix_id = int.TryParse(p.prefix_id, out chk) ? chk.ToString() : "0";
//p.posi_id = int.TryParse(p.posi_id, out chk) ? chk.ToString() : "0";
//p.posi_id = int.TryParse(p.posi_id, out chk) ? chk.ToString() : "0";
p.queue_date = p.queue_date == null ? "" : p.queue_date;
p.queue_current = p.queue_current == null ? "" : p.queue_current;
p.queue = p.queue == null ? "" : p.queue;
p.queue_id = long.TryParse(p.queue_id, out chk) ? chk.ToString() : "0";
}
public void getlStf(String date)
{
//lDept = new List<Position>();
lStf.Clear();
DataTable dt = new DataTable();
dt = selectAll(date);
foreach (DataRow row in dt.Rows)
{
BQueueDate stf1 = new BQueueDate();
stf1.b_queue_date_id = row[bque.b_queue_date_id].ToString();
stf1.queue_id = row[bque.queue_id].ToString();
stf1.queue_date = row[bque.queue_date].ToString();
stf1.queue_current = row[bque.queue_current].ToString();
stf1.queue = row[bque.queue].ToString();
stf1.queuename = row["queue_name"].ToString();
lStf.Add(stf1);
}
}
public BQueueDate setBQueue(DataTable dt)
{
BQueueDate stf1 = new BQueueDate();
if (dt.Rows.Count > 0)
{
stf1.b_queue_date_id = dt.Rows[0][bque.b_queue_date_id].ToString();
stf1.queue_date = dt.Rows[0][bque.queue_date].ToString();
stf1.queue_current = dt.Rows[0][bque.queue_current].ToString();
stf1.queuename1 = dt.Rows[0]["queue_name"].ToString();
stf1.queue_id = dt.Rows[0][bque.queue_id].ToString();
stf1.queuename = dt.Rows[0]["queue_name"].ToString();
stf1.queue = dt.Rows[0]["queue"].ToString();
stf1.queuecode = dt.Rows[0]["queue_code"].ToString();
stf1.queueprefix = dt.Rows[0]["queue_prefix"].ToString();
stf1.statuseveryday = dt.Rows[0]["status_everyday"].ToString();
}
else
{
setBQueue1(stf1);
}
return(stf1);
}
