public String insert(BQueue p, String userId) { String re = ""; String sql = ""; p.active = "1"; //p.ssdata_id = ""; int chk = 0; chkNull(p); sql = "Insert Into " + que.table + " set " + //" " + que.queue_date + "= now() " + //" " + que.row_1 + "='" + p.row_1 + "' " + " " + que.active + "='1' " + "," + que.queue_start + "='" + p.queue_start.Replace("'", "''") + "' " + //"," + que.status_queue + "='1' " + "," + que.status_everyday + "='" + p.status_everyday.Replace("'", "''") + "' " + "," + que.date_create + "= now() " + "," + que.user_create + "='" + userId.Replace("'", "''") + "' " + "," + que.queue_prefix + "='" + p.queue_prefix.Replace("'", "''") + "' " + "," + que.queue_code + "='" + p.queue_code.Replace("'", "''") + "' " + "," + que.queue_name + "='" + p.queue_name.Replace("'", "''") + "' " + ""; try { re = conn.ExecuteNonQuery(conn.conn, sql); } catch (Exception ex) { sql = ex.Message + " " + ex.InnerException; } return(re); }
private void chkNull(BQueue 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_code = p.queue_code == null ? "" : p.queue_code; p.queue_name = p.queue_name == null ? "" : p.queue_name; p.queue_date = p.queue_date == null ? "" : p.queue_date; p.queue_prefix = p.queue_prefix == null ? "" : p.queue_prefix; p.active = p.active == null ? "" : p.active; p.status_queue = p.status_queue == null ? "" : p.status_queue; p.staff_name = p.staff_name == null ? "" : p.staff_name; p.date_begin = p.date_begin == null ? "" : p.date_begin; p.date_finish = p.date_finish == null ? "" : p.date_finish; p.queue_start = p.queue_start == null ? "" : p.queue_start; p.queue = p.queue == null ? "" : p.queue; p.status_everyday = p.status_everyday == null ? "0" : p.status_everyday; //p.staff_id = long.TryParse(p.staff_id, out chk) ? chk.ToString() : "0"; }
private void initConfig() { pageLoad = true; fEdit = new Font(bqc.iniC.grdQueFontName, bqc.grdQueFontSize, FontStyle.Regular); fEditB = new Font(bqc.iniC.grdQueFontName, bqc.grdQueFontSize, FontStyle.Bold); theme1 = new C1ThemeController(); que = new BQueue(); btnQueAdd.Click += BtnQueAdd_Click; btnQueDel.Click += BtnQueDel_Click; btnQueUpdate.Click += BtnQueUpdate_Click; initGrfQue(); setGrfQueue(); initGrfQueToday(); setGrfQueueToday(); String date = ""; date = DateTime.Now.Year + DateTime.Now.ToString("-MM-dd"); txtDate.Value = date; this.ClientSize = new Size(1200, 600); txtQueNum.Value = "0"; pnQueAdd.SizeRatio = 40; pnQueToday.SizeRatio = 30; pnQue.SizeRatio = 30; rbStatus.Text = ""; lbStatus.Text = ""; pageLoad = false; }
private void initConfig() { que = new BQueue(); que.b_queue_id = "queue_id"; que.queue_code = "queue_code"; que.queue_name = "queue_name"; //que.staff_id = "staff_id"; //que.queue_date = "queue_date"; //que.row_1 = "row_1"; que.active = "active"; que.date_create = "date_create"; que.date_modi = "date_modi"; que.date_cancel = "date_cancel"; que.user_create = "user_create"; que.user_modi = "user_modi"; que.user_cancel = "user_cancel"; que.queue_prefix = "queue_prefix"; que.queue_start = "queue_start"; que.status_everyday = "status_everyday"; //que.date_finish = "date_finish"; //que.queue = "queue"; que.table = "b_queue"; que.pkField = "queue_id"; lStf = new List <BQueue>(); }
public String update(BQueue p, String userId) { String re = ""; String sql = ""; int chk = 0; chkNull(p); sql = "Update " + que.table + " Set " + //" " + que.queue_date + "='" + p.queue_date + "' " + //"," + que.row_1 + "='" + p.row_1 + "' " + //" " + que.active + "='" + p.active + "' " + " " + que.date_modi + "=now() " + "," + que.user_modi + "='" + userId.Replace("'", "''") + "' " + "," + que.queue_prefix + "='" + p.queue_prefix.Replace("'", "''") + "' " + "," + que.queue_start + "='" + p.queue_start.Replace("'", "''") + "' " + "," + que.status_everyday + "='" + p.status_everyday.Replace("'", "''") + "' " + "," + que.queue_code + "='" + p.queue_code.Replace("'", "''") + "' " + "," + que.queue_name + "='" + p.queue_name.Replace("'", "''") + "' " + "Where " + que.pkField + "='" + p.b_queue_id + "'" ; try { re = conn.ExecuteNonQuery(conn.conn, sql); } catch (Exception ex) { sql = ex.Message + " " + ex.InnerException; } return(re); }
public BQueue setQueue(DataTable dt) { BQueue stf1 = new BQueue(); if (dt.Rows.Count > 0) { stf1.b_queue_id = dt.Rows[0][que.b_queue_id].ToString(); stf1.queue_start = dt.Rows[0][que.queue_start].ToString(); stf1.queue_code = dt.Rows[0][que.queue_code].ToString(); stf1.queue_name = dt.Rows[0][que.queue_name].ToString(); stf1.date_create = dt.Rows[0][que.date_create].ToString(); stf1.date_modi = dt.Rows[0][que.date_modi].ToString(); stf1.date_cancel = dt.Rows[0][que.date_cancel].ToString(); stf1.user_create = dt.Rows[0][que.user_create].ToString(); stf1.user_modi = dt.Rows[0][que.user_modi].ToString(); stf1.user_cancel = dt.Rows[0][que.user_cancel].ToString(); stf1.queue_prefix = dt.Rows[0][que.queue_prefix].ToString(); stf1.active = dt.Rows[0][que.active].ToString(); stf1.status_everyday = dt.Rows[0][que.status_everyday].ToString(); //stf1.staff_name = dt.Rows[0][que.staff_name].ToString(); //stf1.date_begin = dt.Rows[0][que.date_begin].ToString(); //stf1.date_finish = dt.Rows[0][que.date_finish].ToString(); //stf1.queue = dt.Rows[0][que.queue].ToString(); } else { setQueue1(stf1); } return(stf1); }
private Boolean saveBQueue() { Boolean chk = false; BQueue que = new BQueue(); String id = "", name = "", num = "", code = "", prefix = "", start = "", everyday = ""; id = grfQue[grfQue.Row, colQueId] != null ? grfQue[grfQue.Row, colQueId].ToString():""; name = grfQue[grfQue.Row, colQueName] != null ? grfQue[grfQue.Row, colQueName].ToString() : ""; prefix = grfQue[grfQue.Row, colQuePrefix] != null ? grfQue[grfQue.Row, colQuePrefix].ToString() : ""; code = grfQue[grfQue.Row, colQueCode] != null ? grfQue[grfQue.Row, colQueCode].ToString() : ""; start = grfQue[grfQue.Row, colQueStart] != null ? grfQue[grfQue.Row, colQueStart].ToString() : ""; everyday = grfQue[grfQue.Row, colEveryDay] != null ? grfQue[grfQue.Row, colEveryDay].ToString() : ""; que.b_queue_id = id; que.queue_name = name.Trim(); que.queue = num; que.queue_code = code.Trim(); que.queue_prefix = prefix.Trim(); que.queue_start = start; que.status_everyday = everyday; String re = bqc.bquDB.queDB.insertQueue(que, ""); int chk1 = 0; if (int.TryParse(re, out chk1)) { chk = true; } else { lbStatus.Text = re; } return(chk); }
public BQueue selectBQueueByPk(String tqueid) { TQueue stf1 = new TQueue(); BQueue que = new BQueue(); stf1 = bquDB.tqueDB.selectByPk(tqueid); que = bquDB.queDB.selectByPk(stf1.queue_id); return(que); }
private void BtnQueNext_Click(object sender, EventArgs e) { //throw new NotImplementedException(); String stfid = "", bqueid = ""; stfid = bqc.getIdCombo(cboStf, cboStf.Text); if (stfid.Equals("")) { MessageBox.Show("", ""); return; } String date = System.DateTime.Now.Year + "-" + System.DateTime.Now.ToString("MM-dd"); bqueid = bqc.bquDB.queDateDB.selectBQueIdByStfQueDate(stfid, date); String[] bqueid1 = bqueid.Split('@'); //String bqueid1 = "", quecurr = ""; if (bqueid1.Length > 1) { } BQueue que = new BQueue(); que.b_queue_id = ""; que.queue_start = stfid; que.queue_date = ""; que.queue_prefix = "1"; que.active = ""; que.status_queue = ""; que.staff_name = ""; que.date_begin = ""; que.date_finish = ""; que.queue = ""; long chk = 0; String re = bqc.bquDB.queDB.insertQueue(que, ""); if (long.TryParse(re, out chk)) { int chk1 = 0; String re1 = ""; re1 = bqc.bquDB.queDateDB.updateQueueMax(bqueid1[0]); if (int.TryParse(re1, out chk1)) { if (chk1 > 0) { String re2 = bqc.bquDB.queDB.updateQue(re, re1); lbQueCurr.Text = bqueid1[1]; lbQue.Text = chk1.ToString(); printQueue(); } } } }
public BQueue selectQueByStfQueDate(String stfid, String date) { BQueue stf1 = new BQueue(); String re = ""; DataTable dt = new DataTable(); String sql = "select que.* " + "From " + que.table + " que " + " " + "Where que.queue_date >= '" + date + " 00:00:00' and que.queue_date <= '" + date + " 23:59:59' and que.staff_id = '" + stfid + "' and que." + que.status_queue + "='1' " + "Order By que." + que.b_queue_id + " asc"; dt = conn.selectData(conn.conn, sql); stf1 = setQueue(dt); return(stf1); }
public String insertQueue(BQueue p, String userId) { String re = ""; if (p.b_queue_id.Equals("")) { re = insert(p, ""); } else { re = update(p, ""); } return(re); }
public BQueue selectByPk(String queid) { BQueue stf1 = new BQueue(); String re = ""; DataTable dt = new DataTable(); String sql = "select que.* " + "From " + que.table + " que " + " " + "Where que.queue_id = '" + queid + "' " + "Order By que." + que.b_queue_id + " asc"; dt = conn.selectData(conn.conn, sql); stf1 = setQueue(dt); return(stf1); }
public BQueue selectByTQueId(String tqueid) { BQueue stf1 = new BQueue(); String re = ""; DataTable dt = new DataTable(); String sql = "select que.* " + "From " + que.table + " que " + //"inner join b_queue_date qued on qued.queue_id = que.queue_id " + "inner join t_queue tque on tque.queue_id = que.queue_id " + "Where tque.t_queue_id = '" + tqueid + "' " + "Order By que." + que.b_queue_id + " asc"; dt = conn.selectData(conn.conn, sql); stf1 = setQueue(dt); return(stf1); }
public String prefixQue(TQueue tque) { String code = "", prefix = ""; BQueue que = new BQueue(); que = bquDB.queDB.selectByTQueId(tque.t_queue_id); prefix = que.queue_prefix.Length > 0 ? que.queue_prefix : ""; if (que.queue_code.Length > 0) { for (int i = 0; i < que.queue_code.Length; i++) { code += "0"; } code = code + tque.queue; code = code.Substring(tque.queue.Length); } return(prefix + code); }
private BQueue setQueue1(BQueue stf1) { stf1.b_queue_id = ""; stf1.queue_code = ""; stf1.queue_name = ""; stf1.date_create = ""; stf1.active = ""; stf1.date_modi = ""; stf1.date_cancel = ""; stf1.user_create = ""; stf1.user_modi = ""; stf1.user_cancel = ""; stf1.queue = ""; stf1.queue_prefix = ""; stf1.queue_start = ""; stf1.status_everyday = ""; return(stf1); }
public void getlStf() { //lDept = new List<Position>(); lStf.Clear(); DataTable dt = new DataTable(); dt = selectAll(); foreach (DataRow row in dt.Rows) { BQueue stf1 = new BQueue(); stf1.b_queue_id = row[que.b_queue_id].ToString(); stf1.queue_name = row[que.queue_name].ToString(); stf1.queue_prefix = row[que.queue_prefix].ToString(); stf1.queue_code = row[que.queue_code].ToString(); stf1.queue_start = row[que.queue_start].ToString(); stf1.status_everyday = row[que.status_everyday].ToString(); lStf.Add(stf1); } }
public BQueue updateStatusQue(String stfid, String date) { String re = ""; String sql = ""; int chk = 0; BQueue stf1 = new BQueue(); BQueue stf2 = new BQueue(); stf1 = selectQueByStfQueDate(stfid, date); sql = "Update " + que.table + " Set " + //" " + que.queue_date + "='" + p.queue_date + "' " + //"," + que.row_1 + "='" + p.row_1 + "' " + //"," + que.active + "='" + p.active + "' " + //"," + que.staff_id + "='" + p.staff_id.Replace("'", "''") + "' " + " " + que.status_queue + "='2' " + //"," + que.staff_name + "='" + p.staff_name.Replace("'", "''") + "' " + //"," + que.date_begin + "='" + p.date_begin.Replace("'", "''") + "' " + "," + que.date_finish + "= now() " + "Where " + que.pkField + "='" + stf1.b_queue_id + "'" ; try { re = conn.ExecuteNonQuery(conn.conn, sql); if (int.TryParse(re, out chk)) { stf2 = selectQueByStfQueDate(stfid, date); } } catch (Exception ex) { sql = ex.Message + " " + ex.InnerException; } return(stf2); }