private Boolean saveQueueCaller()
{
Boolean chk = false;
DataTable dt = new DataTable();
String date = "";
date = DateTime.Now.Year + DateTime.Now.ToString("-MM-dd");
String id = "", name = "", num = "", todayid = "";
id = grfQueCaller[grfQueCaller.Row, colId] != null ? grfQueCaller[grfQueCaller.Row, colId].ToString() : "";
name = grfQueCaller[grfQueCaller.Row, colName] != null ? grfQueCaller[grfQueCaller.Row, colName].ToString() : "";
BQueueCaller quec = new BQueueCaller();
quec.queue_call_id = id;
quec.queue_call_name = name.Trim();
String re = bqc.bquDB.quecDB.insertQueueCaller(quec, "");
int chk1 = 0;
if (int.TryParse(re, out chk1))
{
chk = true;
lbStatus.Text = "บันทึกเรียบร้อย";
grfQueCaller[grfQueCaller.Row, colSave] = "";
grfQueCaller.Rows[grfQueCaller.Row].StyleNew.BackColor = Color.White;
}
else
{
lbStatus.Text = re;
}
return(chk);
}
private void initConfig()
{
pageLoad = true;
tque = new TQueue();
queCaller = new BQueueCaller();
theme1 = new C1ThemeController();
fEdit = new Font(bqc.iniC.grdViewFontName, bqc.grdViewFontSize, FontStyle.Regular);
foreach (String aaa in C1ThemeController.GetThemes())
{
rbTheme.Items.Add(aaa);
}
//rbTheme.SelectedItem.Description = "Office2016Colorful";
//bqc.bquDB.queDateDB.setCboQueDate(cboStf, bqc.iniC.queuefixid, System.DateTime.Now.Year + "-" + System.DateTime.Now.ToString("MM-dd"));
bqc.bquDB.queDateDB.setCboQueDate1(cboQueDate, bqc.iniC.queuefixid, System.DateTime.Now.Year + "-" + System.DateTime.Now.ToString("MM-dd"));
//new LogWriter("d", "FrmQueueNext initConfig ");
setControl();
//cboStf.SelectedValueChanged += CboStf_SelectedValueChanged;
cboQueDate.SelectedIndexChanged += CboQueDate_SelectedIndexChanged;
btnQueNext.Click += BtnQueNext_Click;
chkQueSend.Click += ChkQueSend_Click;
btnQueSend.Click += BtnQueSend_Click;
chkQueVoid.Click += ChkQueVoid_Click;
btnQueVoid.Click += BtnQueVoid_Click;
btnCaller.Click += BtnCaller_Click;
rbTheme.Text = "VS2013Red";
rbTheme.SelectedIndexChanged += RbTheme_SelectedIndexChanged;
setTheme1(rbTheme.Text);
pageLoad = false;
}
public String update(BQueueCaller p, String userId)
{
String re = "";
String sql = "";
int chk = 0;
chkNull(p);
sql = "Update " + quec.table + " Set " +
" " + quec.date_modi + "=now() " +
"," + quec.user_modi + "='" + userId.Replace("'", "''") + "' " +
"," + quec.queue_call_name + "='" + p.queue_call_name.Replace("'", "''") + "' " +
"Where " + quec.pkField + "='" + p.queue_call_id + "'"
;
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");
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 BQueueCaller setQueueCaller(DataTable dt)
{
BQueueCaller stf1 = new BQueueCaller();
if (dt.Rows.Count > 0)
{
stf1.queue_call_id = dt.Rows[0][quec.queue_call_id].ToString();
stf1.queue_call_name = dt.Rows[0][quec.queue_call_name].ToString();
stf1.date_create = dt.Rows[0][quec.date_create].ToString();
stf1.date_modi = dt.Rows[0][quec.date_modi].ToString();
stf1.date_cancel = dt.Rows[0][quec.date_cancel].ToString();
stf1.user_create = dt.Rows[0][quec.user_create].ToString();
stf1.user_modi = dt.Rows[0][quec.user_modi].ToString();
stf1.user_cancel = dt.Rows[0][quec.user_cancel].ToString();
stf1.status_lock = dt.Rows[0][quec.status_lock].ToString();
stf1.active = dt.Rows[0][quec.active].ToString();
}
else
{
setQueueCaller(stf1);
}
return(stf1);
}
public String insert(BQueueCaller p, String userId)
{
String re = "";
String sql = "";
p.active = "1";
//p.ssdata_id = "";
int chk = 0;
chkNull(p);
sql = "Insert Into " + quec.table + " set " +
" " + quec.active + "='1' " +
"," + quec.queue_call_name + "='" + p.queue_call_name.Replace("'", "''") + "' " +
"," + quec.date_create + "= now() " +
"," + quec.user_create + "='" + userId.Replace("'", "''") + "' " +
"," + quec.status_lock + "='" + p.status_lock.Replace("'", "''") + "' " +
"";
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
private void chkNull(BQueueCaller 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_call_name = p.queue_call_name == null ? "" : p.queue_call_name;
p.status_lock = p.status_lock == null ? "" : p.status_lock;
}
public BQueueCaller selectByName(String name)
{
BQueueCaller stf1 = new BQueueCaller();
String re = "";
DataTable dt = new DataTable();
String sql = "select que.* " +
"From " + quec.table + " que " +
" " +
"Where que.queue_call_name = '" + name + "' and que.active = '1' " +
"Order By que." + quec.queue_call_id + " asc";
dt = conn.selectData(conn.conn, sql);
stf1 = setQueueCaller(dt);
return(stf1);
}
public BQueueCaller selectByPk(String queid)
{
BQueueCaller stf1 = new BQueueCaller();
String re = "";
DataTable dt = new DataTable();
String sql = "select que.* " +
"From " + quec.table + " que " +
" " +
"Where que.queue_id = '" + queid + "' " +
"Order By que." + quec.queue_call_id + " asc";
dt = conn.selectData(conn.conn, sql);
stf1 = setQueueCaller(dt);
return(stf1);
}
public String insertQueueCaller(BQueueCaller p, String userId)
{
String re = "";
if (p.queue_call_id.Equals(""))
{
re = insert(p, "");
}
else
{
re = update(p, "");
}
return(re);
}
private BQueueCaller setQueueCaller(BQueueCaller stf1)
{
stf1.queue_call_id = "";
stf1.queue_call_name = "";
stf1.date_create = "";
stf1.active = "";
stf1.date_modi = "";
stf1.date_cancel = "";
stf1.user_create = "";
stf1.user_modi = "";
stf1.user_cancel = "";
stf1.status_lock = "";
return(stf1);
}
public void getlStf()
{
//lDept = new List<Position>();
lStf.Clear();
DataTable dt = new DataTable();
dt = selectAll();
foreach (DataRow row in dt.Rows)
{
BQueueCaller stf1 = new BQueueCaller();
stf1.queue_call_id = row[quec.queue_call_id].ToString();
stf1.queue_call_name = row[quec.queue_call_name].ToString();
lStf.Add(stf1);
}
}
private void initConfig()
{
quec = new BQueueCaller();
quec.queue_call_id = "queue_call_id";
quec.queue_call_name = "queue_call_name";
quec.active = "active";
quec.date_create = "date_create";
quec.date_modi = "date_modi";
quec.date_cancel = "date_cancel";
quec.user_create = "user_create";
quec.user_modi = "user_modi";
quec.user_cancel = "user_cancel";
quec.status_lock = "status_lock";
quec.table = "b_queue_call";
quec.pkField = "queue_call_id";
lStf = new List <BQueueCaller>();
}
private void GrfQueCaller_CellChanged(object sender, RowColEventArgs e)
{
//throw new NotImplementedException();
if (pageLoad)
{
return;
}
if (e.Row == (grfQueCaller.Rows.Count - 1))
{
grfQueCaller.Rows.Add();
grfQueCaller[e.Row, colId] = "";
grfQueCaller[e.Row, colSave] = "";
}
if (e.Col == colName)
{
if (grfQueCaller[e.Row, colName] == null)
{
return;
}
if (grfQueCaller.Row <= 0)
{
return;
}
if (grfQueCaller.Col <= 0)
{
return;
}
BQueueCaller quec = new BQueueCaller();
quec = bqc.bquDB.quecDB.selectByName(grfQueCaller[e.Row, colName].ToString());
if (quec.queue_call_id.Length > 0)
{
MessageBox.Show("ชื่อ ซ้ำ", "");
grfQueCaller[e.Row, colName] = "";
lbStatus.Text = "ชื่อ ซ้ำ";
return;
}
}
grfQueCaller.Rows[e.Row].StyleNew.BackColor = ColorTranslator.FromHtml(bqc.iniC.grfRowColor);
grfQueCaller[e.Row, colSave] = "SAVE";
}
