private void initConfig()
{
expnD = new ExpensesDraw();
fEdit = new Font(xC.iniC.grdViewFontName, xC.grdViewFontSize, FontStyle.Regular);
fEditB = new Font(xC.iniC.grdViewFontName, xC.grdViewFontSize, FontStyle.Bold);
C1ThemeController.ApplicationTheme = xC.iniC.themeApplication;
theme1.Theme = C1ThemeController.ApplicationTheme;
theme1.SetTheme(sB, "BeigeOne");
foreach (Control c in panel3.Controls)
{
theme1.SetTheme(c, "Office2013Red");
}
bg = txtDrawCode.BackColor;
fc = txtDrawCode.ForeColor;
ff = txtDrawCode.Font;
//xC.xtDB.expndDB.setC1CboExpnC(cboStaff, "");
//DateTime jobDate = DateTime.Now;
//txtExpndDrawDate.Value = jobDate.Year.ToString() + "-" + jobDate.ToString("MM-dd");
//jobDate = jobDate.AddDays(7);
//txtDrawDate.Value = jobDate.Year.ToString() + "-" + jobDate.ToString("MM-dd");
sB1.Text = "";
stt = new C1SuperTooltip();
sep = new C1SuperErrorProvider();
//stt.BackgroundGradient = C1.Win.C1SuperTooltip.BackgroundGradient.Gold;
}
//private void grfDept_AfterRowColChange(object sender, C1.Win.C1FlexGrid.RangeEventArgs e)
//{
//}
private void ContextMenu_appv(object sender, System.EventArgs e)
{
if (grfExpn.Row == null)
{
return;
}
if (grfExpn.Row < 0)
{
return;
}
String deptId = "";
xC.drawID = grfExpn[grfExpn.Row, cola] != null ? grfExpn[grfExpn.Row, cola].ToString() : "";
ExpensesDraw expn = new ExpensesDraw();
FrmExpenseDraw frm;
expn = xC.accDB.expndDB.selectByPk1(xC.drawID);
if (expn.status_pay_type.Equals("1"))
{
frm = new FrmExpenseDraw(xC, xC.drawID, FrmExpenseDraw.flagForm2.Cash, FrmExpenseDraw.flagAction.appv);
}
else
{
frm = new FrmExpenseDraw(xC, xC.drawID, FrmExpenseDraw.flagForm2.Cheque, FrmExpenseDraw.flagAction.appv);
}
//frm.drawId = xC.drawID;
//frm.flagForm = "appv";
frm.WindowState = FormWindowState.Normal;
frm.StartPosition = FormStartPosition.CenterScreen;
frm.ShowDialog(this);
}
private void initConfig()
{
jim = new JobImport();
expnD = new ExpensesDraw();
xC.xtDB.stfDB.setCboStaff(cboStaff, "");
initGrfExpnD();
txtJobCode.KeyUp += TxtJobCode_KeyUp;
}
public ExpensesDraw selectByPk1(String copId)
{
ExpensesDraw cop1 = new ExpensesDraw();
DataTable dt = new DataTable();
String sql = "select expC.* " +
"From " + expnC.table + " expC " +
//"Left Join t_ssdata_visit ssv On ssv.ssdata_visit_id = bd.ssdata_visit_id " +
"Where expC." + expnC.pkField + " ='" + copId + "' ";
dt = conn.selectData(conn.conn, sql);
cop1 = setExpenseDraw(dt);
return(cop1);
}
public String insertExpenseDraw(ExpensesDraw p, String userId)
{
String re = "";
if (p.expenses_draw_id.Equals(""))
{
re = insert(p, userId);
}
else
{
re = update(p, userId);
}
return(re);
}
public void getlexpnC()
{
//lDept = new List<Department>();
DataTable dt = new DataTable();
dt = selectAll();
foreach (DataRow row in dt.Rows)
{
ExpensesDraw curr1 = new ExpensesDraw();
curr1.expenses_draw_id = row[expnC.expenses_draw_id].ToString();
curr1.expenses_draw_date = row[expnC.expenses_draw_date].ToString();
curr1.expenses_draw_code = row[expnC.expenses_draw_code].ToString();
curr1.job_code = row[expnC.job_code].ToString();
lexpnC.Add(curr1);
}
}
public String VoidExpensesDraw(String drawId, String userid)
{
String re = "", sql = "";
ExpensesDraw expnD = new ExpensesDraw();
expnD = accDB.expndDB.selectByPk1(drawId);
if (expnD.status_pay.Equals("2"))
{
re = "ไม่สามารถยกเลิกได้ เพราะได้รับเงินไปแล้ว";
}
else
{
re = accDB.expndDB.VoidExpensesDraw(drawId, userid);
accDB.expnddDB.VoidExpensesDrawDetailByDrawId(drawId, userid);
re = "ยกเลิก เรียบร้อย";
}
return(re);
}
private void initConfig()
{
expnC = new ExpensesDraw();
expnC.expenses_draw_id = "expenses_draw_id";
expnC.expenses_draw_date = "expenses_draw_date";
expnC.job_id = "job_id";
expnC.job_code = "job_code";
expnC.draw_date = "draw_date";
expnC.staff_id = "staff_id";
expnC.active = "active";
expnC.date_create = "date_create";
expnC.date_modi = "date_modi";
expnC.date_cancel = "date_cancel";
expnC.user_create = "user_create";
expnC.user_modi = "user_modi";
expnC.user_cancel = "user_cancel";
expnC.expenses_draw_code = "expenses_draw_code";
expnC.remark = "remark";
expnC.desc1 = "desc1";
expnC.status_appv = "status_appv";
expnC.status_email = "status_email";
expnC.amount = "amount";
expnC.year = "year";
expnC.appv_amount = "appv_amount";
expnC.appv_desc = "appv_desc";
expnC.status_pay = "status_pay";
expnC.status_pay_type = "status_pay_type";
expnC.payer_id = "payer_id";
expnC.status_page = "status_page";
expnC.status_doc = "status_doc";
expnC.issue_date = "issue_date";
expnC.issue_id = "issue_id";
expnC.issue_name_t = "issue_name_t";
expnC.issue_person = "issue_person";
expnC.issue_place = "issue_place";
expnC.issue_status_express = "issue_status_express";
expnC.issue_status_time = "issue_status_time";
expnC.table = "t_expenses_draw";
expnC.pkField = "expenses_draw_id";
lexpnC = new List <ExpensesDraw>();
}
public String insert(ExpensesDraw p, String userId)
{
String re = "";
String sql = "";
p.active = "1";
//p.ssdata_id = "";
int chk = 0;
chkNull(p);
//p.prefix_id = int.TryParse(p.prefix_id, out chk) ? chk.ToString() : "0";
//p.dept_id = int.TryParse(p.dept_id, out chk) ? chk.ToString() : "0";
sql = "Insert Into " + expnC.table + "(" + expnC.expenses_draw_date + "," + expnC.expenses_draw_code + "," + expnC.job_id + "," +
expnC.date_create + "," + expnC.date_modi + "," + expnC.date_cancel + "," +
expnC.user_create + "," + expnC.user_modi + "," + expnC.user_cancel + "," +
expnC.active + "," + expnC.remark + ", " + expnC.job_code + ", " +
expnC.draw_date + "," + expnC.staff_id + "," + expnC.desc1 + ", " +
expnC.status_email + "," + expnC.status_appv + "," + expnC.amount + ", " +
expnC.year + "," + expnC.status_pay + "," + expnC.status_pay_type + "," +
expnC.payer_id + "," + expnC.status_page + "," + expnC.status_doc + " " +
") " +
"Values ('" + p.expenses_draw_date + "','" + p.expenses_draw_code.Replace("'", "''") + "','" + p.job_id.Replace("'", "''") + "'," +
"'" + p.date_create + "','" + p.date_modi + "','" + p.date_cancel + "'," +
"'" + userId + "','" + p.user_modi + "','" + p.user_cancel + "'," +
"'" + p.active + "','" + p.remark.Replace("'", "''") + "','" + p.job_code + "'," +
"'" + p.draw_date + "','" + p.staff_id.Replace("'", "''") + "','" + p.desc1.Replace("'", "''") + "'," +
"'" + p.status_email + "','" + p.status_appv.Replace("'", "''") + "','" + p.amount + "'," +
"'" + p.year + "','" + p.status_pay + "','" + p.status_pay_type + "'," +
"'" + p.payer_id + "','" + p.status_page + "','" + p.status_doc + "' " +
")";
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
public String update(ExpensesDraw p, String userId)
{
String re = "";
String sql = "";
int chk = 0;
chkNull(p);
sql = "Update " + expnC.table + " Set " +
" " + expnC.expenses_draw_date + " = '" + p.expenses_draw_date + "'" +
"," + expnC.job_id + " = '" + p.job_id.Replace("'", "''") + "'" +
"," + expnC.job_code + " = '" + p.job_code.Replace("'", "''") + "'" +
"," + expnC.remark + " = '" + p.remark.Replace("'", "''") + "'" +
"," + expnC.date_modi + " = now()" +
"," + expnC.user_modi + " = '" + userId + "' " +
"," + expnC.draw_date + " = '" + p.draw_date + "' " +
"," + expnC.staff_id + " = '" + p.staff_id + "' " +
"," + expnC.expenses_draw_code + " = '" + p.expenses_draw_code + "' " +
"," + expnC.desc1 + " = '" + p.desc1 + "' " +
"," + expnC.status_email + " = '" + p.status_email + "' " +
"," + expnC.status_appv + " = '" + p.status_appv + "' " +
"," + expnC.amount + " = '" + p.amount + "' " +
"," + expnC.year + " = '" + p.year + "' " +
"," + expnC.status_pay + " = '" + p.status_pay + "' " +
"," + expnC.status_pay_type + " = '" + p.status_pay_type + "' " +
"," + expnC.payer_id + " = '" + p.payer_id + "' " +
"," + expnC.status_page + " = '" + p.status_page + "' " +
"Where " + expnC.pkField + "='" + p.expenses_draw_id + "'"
;
try
{
re = conn.ExecuteNonQuery(conn.conn, sql);
}
catch (Exception ex)
{
sql = ex.Message + " " + ex.InnerException;
}
return(re);
}
private void chkNull(ExpensesDraw p)
{
int chk = 0;
Decimal chk1 = 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.expenses_draw_date = p.expenses_draw_date == null ? "" : p.expenses_draw_date;
p.job_code = p.job_code == null ? "" : p.job_code;
p.draw_date = p.draw_date == null ? "" : p.draw_date;
p.remark = p.remark == null ? "" : p.remark;
p.expenses_draw_code = p.expenses_draw_code == null ? "" : p.expenses_draw_code;
p.desc1 = p.desc1 == null ? "" : p.desc1;
p.status_appv = p.status_appv == null ? "0" : p.status_appv;
p.status_email = p.status_email == null ? "0" : p.status_email;
p.status_pay = p.status_pay == null ? "0" : p.status_pay;
p.year = p.year == null ? "" : p.year;
p.appv_desc = p.appv_desc == null ? "" : p.appv_desc;
p.status_pay_type = p.status_pay_type == null ? "0" : p.status_pay_type;
p.status_page = p.status_page == null ? "0" : p.status_page;
p.status_doc = p.status_doc == null ? "0" : p.status_doc;
p.issue_status_express = p.issue_status_express == null ? "0" : p.status_doc;
p.issue_status_time = p.issue_status_time == null ? "0" : p.status_doc;
p.job_id = int.TryParse(p.job_id, out chk) ? chk.ToString() : "0";
p.staff_id = int.TryParse(p.staff_id, out chk) ? chk.ToString() : "0";
p.payer_id = int.TryParse(p.payer_id, out chk) ? chk.ToString() : "0";
p.amount = Decimal.TryParse(p.amount, out chk1) ? chk1.ToString() : "0";
p.appv_amount = Decimal.TryParse(p.appv_amount, out chk1) ? chk1.ToString() : "0";
}
public ExpensesDraw setExpenseDraw(DataTable dt)
{
ExpensesDraw curr1 = new ExpensesDraw();
if (dt.Rows.Count > 0)
{
curr1.expenses_draw_id = dt.Rows[0][expnC.expenses_draw_id].ToString();
curr1.expenses_draw_date = dt.Rows[0][expnC.expenses_draw_date].ToString();
curr1.job_id = dt.Rows[0][expnC.job_id].ToString();
curr1.job_code = dt.Rows[0][expnC.job_code].ToString();
curr1.active = dt.Rows[0][expnC.active].ToString();
curr1.date_cancel = dt.Rows[0][expnC.date_cancel].ToString();
curr1.date_create = dt.Rows[0][expnC.date_create].ToString();
curr1.date_modi = dt.Rows[0][expnC.date_modi].ToString();
curr1.user_cancel = dt.Rows[0][expnC.user_cancel].ToString();
curr1.user_create = dt.Rows[0][expnC.user_create].ToString();
curr1.user_modi = dt.Rows[0][expnC.user_modi].ToString();
curr1.desc1 = dt.Rows[0][expnC.desc1].ToString();
curr1.remark = dt.Rows[0][expnC.remark].ToString();
curr1.draw_date = dt.Rows[0][expnC.draw_date].ToString();
curr1.staff_id = dt.Rows[0][expnC.staff_id].ToString();
curr1.expenses_draw_code = dt.Rows[0][expnC.expenses_draw_code].ToString();
curr1.status_appv = dt.Rows[0][expnC.status_appv].ToString();
curr1.status_email = dt.Rows[0][expnC.status_email].ToString();
curr1.amount = dt.Rows[0][expnC.amount].ToString();
curr1.year = dt.Rows[0][expnC.year].ToString();
curr1.status_pay = dt.Rows[0][expnC.status_pay].ToString();
curr1.status_pay_type = dt.Rows[0][expnC.status_pay_type].ToString();
curr1.payer_id = dt.Rows[0][expnC.payer_id].ToString();
curr1.status_page = dt.Rows[0][expnC.status_page].ToString();
curr1.status_doc = dt.Rows[0][expnC.status_doc].ToString();
}
else
{
curr1.expenses_draw_id = "";
curr1.expenses_draw_date = "";
curr1.job_id = "";
curr1.job_code = "";
curr1.draw_date = "";
curr1.staff_id = "";
curr1.active = "";
curr1.date_create = "";
curr1.date_modi = "";
curr1.date_cancel = "";
curr1.user_create = "";
curr1.user_modi = "";
curr1.user_cancel = "";
curr1.expenses_draw_code = "";
curr1.remark = "";
curr1.desc1 = "";
curr1.status_appv = "";
curr1.status_email = "";
curr1.amount = "";
curr1.year = "";
curr1.appv_amount = "";
curr1.appv_desc = "";
curr1.status_pay = "";
curr1.status_pay_type = "";
curr1.payer_id = "";
curr1.status_page = "";
curr1.status_doc = "";
}
return(curr1);
}
private void setControl(String deptId)
{
expnD = xC.accDB.expndDB.selectByPk1(deptId);
if (expnD.expenses_draw_id.Equals(""))
{
txtID.Value = "";
txtCode.Value = "";
txtJobCode.Value = "IMP" + expnD.job_code;
txtDesc.Value = "";
txtRemark.Value = "";
DateTime jobDate = DateTime.Now;
txtExpndDrawDate.Value = jobDate.Year.ToString() + "-" + jobDate.ToString("MM-dd");
jobDate = jobDate.AddDays(7);
txtDrawDate.Value = jobDate.Year.ToString() + "-" + jobDate.ToString("MM-dd");
txtAmt.Value = 0;
}
else
{
txtID.Value = expnD.expenses_draw_id;
txtCode.Value = expnD.expenses_draw_code;
txtJobCode.Value = "IMP" + expnD.job_code;
txtDesc.Value = expnD.desc1;
txtRemark.Value = expnD.remark;
txtExpndDrawDate.Value = expnD.expenses_draw_date;
txtDrawDate.Value = expnD.draw_date;
txtAmt.Value = expnD.amount;
xC.setC1Combo(cboStaff, expnD.staff_id);
imp = xC.iniDB.cusDB.selectByPk1(expnD.payer_id);
setKeyUpF2Imp1(imp);
xC.xtDB.stfDB.setCboStaff(cboStaff, expnD.staff_id);
}
setGrfDeptH();
setGrfDeptH1();
if (expnD.status_appv.Equals("0"))
{
label8.Text = "...";
}
else if (expnD.status_appv.Equals("1"))
{
label8.Text = "รออนุมัติ";
label8.ForeColor = Color.Red;
}
else if (expnD.status_appv.Equals("2"))
{
label8.Text = "อนุมัติแล้ว";
label8.ForeColor = Color.SaddleBrown;
}
if (expnD.status_pay.Equals("2"))
{
label8.Text = "จ่ายเงินแล้ว";
label8.ForeColor = Color.Gray;
setControlAppv();
setControlEnablePay();
}
if (flagfom2 == flagForm2.Cash)
{
label9.Show();
txtAmtOnhand.Show();
}
else
{
label9.Hide();
txtAmtOnhand.Hide();
}
}
private void initConfig()
{
expnD = new ExpensesDraw();
fEdit = new Font(xC.iniC.grdViewFontName, xC.grdViewFontSize, FontStyle.Regular);
fEditB = new Font(xC.iniC.grdViewFontName, xC.grdViewFontSize, FontStyle.Bold);
C1ThemeController.ApplicationTheme = xC.iniC.themeApplication;
theme1.Theme = C1ThemeController.ApplicationTheme;
theme1.SetTheme(sB, "BeigeOne");
foreach (Control c in panel3.Controls)
{
theme1.SetTheme(c, "Office2013Red");
}
foreach (Control c in panel2.Controls)
{
theme1.SetTheme(c, "Office2013Red");
}
theme1.SetTheme(panel2, "Office2013Red");
bg = txtCode.BackColor;
fc = txtCode.ForeColor;
ff = txtCode.Font;
xC.xtDB.stfDB.setCboStaff(cboStaff, xC.userId);
xC.xtDB.stfDB.setCboStaff(cboDraw, "");
xC.iniDB.issDB.setCboCusC1(cboIssue, "");
DateTime jobDate = DateTime.Now;
txtExpndDrawDate.Value = jobDate.Year.ToString() + "-" + jobDate.ToString("MM-dd");
jobDate = jobDate.AddDays(7);
txtDrawDate.Value = jobDate.Year.ToString() + "-" + jobDate.ToString("MM-dd");
txtPasswordVoid.KeyUp += TxtPasswordVoid_KeyUp;
txtJobCode.KeyUp += TxtJobCode_KeyUp;
btnNew.Click += BtnNew_Click;
btnEdit.Click += BtnEdit_Click;
btnSave.Click += BtnSave_Click;
btnDoc.Click += BtnDoc_Click;
btnAppv.Click += BtnAppv_Click;
c1Button1.Click += C1Button1_Click;
btnDNew.Click += BtnDNew_Click;
btnDEdit.Click += BtnDEdit_Click;
cboStaff.DropDownClosed += CboStaff_DropDownClosed;
txtImpNameT.KeyUp += TxtImpNameT_KeyUp;
chkVoid.Click += ChkVoid_Click;
btnVoid.Click += BtnVoid_Click;
initGrfDept();
initGrfDept1();
setGrfDeptH();
setGrfDeptH1();
//setFocusColor();
setControl(drawId);
setControlEnable(false);
setControlAppv();
sB1.Text = "";
btnVoid.Hide();
txtPasswordVoid.Hide();
stt = new C1SuperTooltip();
sep = new C1SuperErrorProvider();
//stt.BackgroundGradient = C1.Win.C1SuperTooltip.BackgroundGradient.Gold;
imp = new Customer();
txtAmtOnhand.Value = xC.accDB.expnddDB.selectPayAmountByStf(xC.userId);
}
