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