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