private void setErf() { jim = xC.manDB.jimDB.selectByPk1(jobId); erf.expenses_refund_id = txtId.Text; erf.expense_clear_cash_id = ""; erf.expenses_pay_detail_id = pdid; erf.job_id = jim.job_import_id; erf.desc1 = txtDesc.Text; erf.amount = txtRefund.Text.Replace("$", "").Replace(",", ""); erf.active = "1"; erf.remark = txtRemark.Text; erf.date_create = ""; erf.date_modi = ""; erf.date_cancel = ""; erf.user_create = ""; erf.user_modi = ""; erf.user_cancel = ""; erf.status_page = "1"; erf.status_appv = "0"; erf.status_doc = "0"; erf.ecc_doc = erfId; erf.job_code = jim.job_import_code; erf.pay_staff_id = cboStaff.SelectedItem != null ? ((ComboBoxItem)(cboStaff.SelectedItem)).Value : ""; erf.expenses_refund_date = xC.datetoDB(txtErfDate.Text); }
private void initConfig() { 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"); sB1.Text = ""; cop = new Company(); cop = xC.xtDB.copDB.selectByCode1("001"); //bll = new Billing(); cus = new Customer(); jim = new JobImport(); bll = new Billing(); stt = new C1SuperTooltip(); sep = new C1SuperErrorProvider(); txtCusNameT.KeyUp += TxtCusNameT_KeyUp; initGrfJob(); initGrfBill(); initGrfBillD(); }
private void initConfig() { 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"); DateTime pytDate = DateTime.Now; txtPytDate.Value = pytDate.Year.ToString() + "-" + pytDate.ToString("MM-dd"); btnSave.Click += BtnSave_Click; sB1.Text = ""; cop = new Company(); cop = xC.xtDB.copDB.selectByCode1("001"); //bll = new Billing(); cus = new Customer(); jim = new JobImport(); bll = new Billing(); pyt = new Payment(); stt = new C1SuperTooltip(); sep = new C1SuperErrorProvider(); txtCusNameT.KeyUp += TxtCusNameT_KeyUp; initGrfJob(); initGrfBill(); initGrfBillD(); initGrfPay(); }
private void initConfig() { jim = new JobImport(); expnpd = new ExpensesPayDetail(); ecc = new ExpensesClearCash(); erf = new ExpensesRefund(); xC.xtDB.stfDB.setCboStaff(cboStaff, userId); xC.setCboYear(cboYear); jim = xC.manDB.jimDB.selectByPk1(jobId); ecc = xC.accDB.eccDB.selectByPk1(eccDoc); txtJobCode.Value = jim.job_import_code; DateTime erfDate = DateTime.Now; txtErfDate.Value = erfDate.Year.ToString() + "-" + erfDate.ToString("MM-dd"); btnSave.Click += BtnSave_Click; initGrfErf(); setGrfErf(); setControlEcc(eccDoc); if (!eccDoc.Equals("")) { grfErf.Enabled = false; } }
private void initConfig() { 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"); txtJobCode.KeyUp += TxtJobCode_KeyUp; btnTaxSave.Click += BtnTaxSave_Click; txtNum.ValueChanged += TxtNum_ValueChanged; txtPayerTaxNameT.KeyUp += TxtPayerTaxNameT_KeyUp; tax = new Tax(); jim = new JobImport(); DateTime jobDate = DateTime.Now; txtPayerTaxDate.Value = jobDate.Year.ToString() + "-" + jobDate.ToString("MM-dd"); txtTaxDate.Value = jobDate.Year.ToString() + "-" + jobDate.ToString("MM-dd"); sB1.Text = ""; txtNum.Value = 1; initGrfTax(); initGrfTaxJob(); setGrfTax(""); }
private void initConfig() { jim = new JobImport(); expnD = new ExpensesDraw(); xC.xtDB.stfDB.setCboStaff(cboStaff, ""); initGrfExpnD(); txtJobCode.KeyUp += TxtJobCode_KeyUp; }
private void TxtJobCode_KeyUp(object sender, KeyEventArgs e) { //throw new NotImplementedException(); if (e.KeyCode == Keys.Enter) { txtJobCode.Text = txtJobCode.Text.Replace(xC.FixJobCode, ""); jim = xC.manDB.jimDB.selectByJobCode(txtJobCode.Text); txtID.Value = jim.job_import_id; setGrfExpnD(txtID.Text); } }
private void GrfJob_DoubleClick(object sender, EventArgs e) { //throw new NotImplementedException(); cus = xC.sCus; jim = new JobImport(); jim = xC.manDB.jimDB.selectByPk1(grfJob[grfJob.Row, colID].ToString()); txtJobId.Value = jim.job_import_id; //txtCusNameT.Value = cus.cust_name_t; txtJobCode.Value = jim.job_import_code; setGrfBillView(jim.job_import_id); }
private void TxtJobCode_KeyUp(object sender, KeyEventArgs e) { //throw new NotImplementedException(); if (e.KeyCode == Keys.Enter) { txtJobCode.Text = txtJobCode.Text.Replace(xC.FixJobCode, ""); jim = xC.manDB.jimDB.selectByJobCode(txtJobCode.Text); txtJobCode.Value = xC.FixJobCode + jim.job_import_code; txtJobId.Value = jim.job_import_id; txtJobAmt.Value = xC.accDB.expnpdDB.selectSumPayAmtByJobIdStfIdNoClear(txtJobId.Text, cboStaff.SelectedItem != null ? ((ComboBoxItem)(cboStaff.SelectedItem)).Value : ""); setGrfExpnPd(txtJobId.Text, cboStaff.SelectedItem != null ? ((ComboBoxItem)(cboStaff.SelectedItem)).Value : ""); } }
private void initConfig() { jim = new JobImport(); ecc = new ExpensesClearCash(); xC.setCboYear(cboYear); chkAppvWait.Checked = true; initGrfEcc(); initGrfEccD(); initGrPd(); initGrDd(); initGrfRefund(); setGrfEcc(); }
private void setControl(String id) { Items itm = new Items(); expnpd = new ExpensesPayDetail(); ecc = new ExpensesClearCash(); JobImport jim = new JobImport(); ecc = xC.accDB.eccDB.selectByPk1(id); expnpd = xC.accDB.expnpdDB.selectByPk1(pdid); if (ecc.expense_clear_cash_id.Equals("")) { jim = xC.manDB.jimDB.selectByJobCode(jobcode); } txtItmNamePd.Value = itmPd; txtId.Value = ecc.expense_clear_cash_id; txtJobId.Value = ecc.job_id.Equals("") ? jim.job_import_id : ecc.job_id; txtJobCode.Value = ecc.job_code.Equals("") ? jobcode : ecc.job_code; txtPdId.Value = ecc.expenses_pay_detail_id.Equals("") ? pdid : ecc.expenses_pay_detail_id; txtStfId.Value = ecc.staff_id.Equals("") ? xC.userId : ecc.staff_id; txtddId.Value = ecc.expenses_draw_detail_id.Equals("") ? expnpd.expenses_draw_detail_id : ecc.expenses_draw_detail_id; //txtdid.Value = ecc.expenses_draw_id.Equals("") ? jim.job_import_id : ecc.expenses_draw_id; int row = 0, chk = 0; if (int.TryParse(rowno, out chk)) { txtRow.Value = chk; } else { txtRow.Value = ecc.row1; } //chk++; txtReceiptNo.Value = ecc.receipt_no; txtReceiptDate.Value = ecc.receipt_date; txtItmId.Value = ecc.item_id; txtItmCode.Value = ecc.item_code; txtItmNameT.Value = ecc.item_name_t; txtPayAmt.Value = ecc.pay_amount; txtPayCusId.Value = ecc.pay_to_cus_id; txtPayCusNameT.Value = ecc.pay_to_cus_name_t; //txtItmCode.Value = ecc.item_code; setImages(txtId.Text); }
private void initConfig() { 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"); theme1.SetTheme(tC1, "Office2010Green"); //btnNew.Click += BtnNew_Click; txtCusNameT1.KeyUp += TxtCusNameT1_KeyUp; btnCashOk.Click += BtnCashOk_Click; btnBNew.Click += BtnBNew_Click; btnBSave.Click += BtnBSave_Click; btnPrnRcp.Click += BtnPrnRcp_Click; btnPrnCover.Click += BtnPrnCover_Click; DateTime billDate = DateTime.Now; txtBillDate.Value = billDate.Year.ToString() + "-" + billDate.ToString("MM-dd"); sB1.Text = ""; cop = new Company(); cop = xC.xtDB.copDB.selectByCode1("001"); bll = new Billing(); cus = new Customer(); jim = new JobImport(); bllC = new BillingCover(); stt = new C1SuperTooltip(); sep = new C1SuperErrorProvider(); txtBIvat.Value = cop.vat; txtBEvat.Value = cop.vat; txtEvat.Value = cop.vat; //stt.BackgroundGradient = C1.Win.C1SuperTooltip.BackgroundGradient.Gold; //chkAll.Checked = true; //xC.setCboYear(cboYear); initGrfJob(); initGrfDrawView(); initGrfBill(); initGrfCover(); tC1.SelectedTab = tabMake; tC2.SelectedTab = tabDraw; //setGrfDeptH(); }
private void TxtJobCode_KeyUp(object sender, KeyEventArgs e) { //throw new NotImplementedException(); if (e.KeyCode == Keys.Enter) { JobImport jim = xC.manDB.jimDB.selectByJobCode(txtJobCode.Text.Replace(xC.FixJobCode, "")); if (!jim.job_import_id.Equals("")) { jobId = jim.job_import_id; imp = xC.iniDB.cusDB.selectByPk1(jim.imp_id); setKeyUpF2Imp1(imp); txtJobCode.Value = "IMP" + jim.job_import_code; setGrfDeptH1(); txtAmtOnhandJob.Value = xC.accDB.expnddDB.selectPayAmountByStf(xC.userId, jim.job_import_id); } } }
private void BtnSave_Click(object sender, EventArgs e) { //throw new NotImplementedException(); if (MessageBox.Show("ต้องการ บันทึกช้อมูล ", "", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) == DialogResult.OK) { setExpensesDraw(); String re = xC.accDB.expndDB.insertExpenseDraw(expnD, xC.user.staff_id); int chk = 0; if (int.TryParse(re, out chk)) { JobImport jim = new JobImport(); jim = xC.manDB.jimDB.selectByPk1(jobId); if (flagNew.Equals("new")) { setExpensesDrawDetail(re, jim.cust_id); } else { setExpensesDrawDetail(txtID.Text, jim.cust_id); } txtID.Value = re; if (flagaction == flagAction.autoappv) { re = ""; re = xC.updateDrawSendToApprove(txtID.Text); if (int.TryParse(re, out chk)) { re = ""; re = xC.accDB.expndDB.updateStatusApprove(txtID.Text); if (int.TryParse(re, out chk)) { Close(); } } } btnSave.Image = Resources.accept_database24; } else { btnSave.Image = Resources.accept_database24; } setGrfDeptH(); //setGrdView(); //this.Dispose(); } }
private void initConfig() { jim = new JobImport(); //fEdit = grdView.Font; fEdit = new Font(xC.iniC.grdViewFontName, xC.grdViewFontSize, FontStyle.Regular); fEditB = new Font(xC.iniC.grdViewFontName, xC.grdViewFontSize, FontStyle.Bold); initGrfView(); C1ThemeController.ApplicationTheme = xC.iniC.themeApplication; theme1.Theme = C1ThemeController.ApplicationTheme; theme1.SetTheme(panel1, theme1.Theme); cboYear.SelectedIndexChanged += CboYear_SelectedIndexChanged; //ContextMenu custommenu = new ContextMenu(); //custommenu.MenuItems.Add("&ยกเลิก", new EventHandler(ContextMenu_void)); //custommenu.MenuItems.Add("&ยกเลิก"; //grdView.ContextMenu = custommenu; }
private void initConfig() { jim = new JobImport(); ecc = new ExpensesClearCash(); xC.setCboYear(cboYear); xC.xtDB.stfDB.setCboStaff(cboStaff, ""); chkAppvWait.Checked = true; cboStaff.SelectedItemChanged += CboStaff_SelectedItemChanged; btnRefund.Click += BtnRefund_Click; btnDNew.Click += BtnDNew_Click; btnCal.Click += BtnCal_Click; btnSave.Click += BtnSave_Click; initGrfEcc(); initGrPd(); }
private void initConfig() { jim = new JobImport(); expnpd = new ExpensesPayDetail(); ecc = new ExpensesClearCash(); erf = new ExpensesRefund(); xC.xtDB.stfDB.setCboStaff(cboStaff, userId); jim = xC.manDB.jimDB.selectByPk1(jobId); ecc = xC.accDB.eccDB.selectByPk1(erfId); txtJobCode.Value = jim.job_import_code; DateTime erfDate = DateTime.Now; txtErfDate.Value = erfDate.Year.ToString() + "-" + erfDate.ToString("MM-dd"); btnSave.Click += BtnSave_Click; setControl(erfId); }
private void initConfig() { jim = new JobImport(); expnpd = new ExpensesPayDetail(); xC.xtDB.stfDB.setCboStaff(cboStaff, xC.userId); initGrfExpnD(); initGrfEcc(); txtUserAmt.Value = xC.accDB.expnpdDB.selectSumPayAmtByJobIdStfIdNoClear("", xC.userId); btnDNew.Click += BtnDNew_Click; btnDoc.Click += BtnDoc_Click; btnSave.Click += BtnSave_Click; btnRefund.Click += BtnRefund_Click; cboStaff.SelectedItemChanged += CboStaff_SelectedItemChanged; txtJobCode.KeyUp += TxtJobCode_KeyUp; setGrfExpnPd(txtJobId.Text, cboStaff.SelectedItem != null ? ((ComboBoxItem)(cboStaff.SelectedItem)).Value : ""); }
private void TxtJobCode_KeyUp(object sender, KeyEventArgs e) { //throw new NotImplementedException(); if (e.KeyCode == Keys.Enter) { txtJobCode.Text = txtJobCode.Text.Replace(xC.FixJobCode, ""); jim = xC.manDB.jimDB.selectByJobCode(txtJobCode.Text); txtJobId.Value = jim.job_import_id; txtJobCode.Value = xC.FixJobCode + jim.job_import_code; Customer cus = new Customer(); cus = xC.iniDB.cusDB.selectByPk1(jim.cust_id); txtCusTaxId.Value = cus.cust_id; txtCusTaxNameT.Value = cus.cust_name_t; Company cop = new Company(); cop = xC.xtDB.copDB.selectByCode1("001"); txtAgentTaxNameT.Value = cop.comp_name_t; txtAgentTaxId.Value = cop.comp_id; setGrfTaxJob(txtJobId.Text); } }
public void setJobImport(String jobNo) { String year = DateTime.Now.Year.ToString(); String date = DateTime.Now.ToString("yyyy-MM-dd"); JobImport jim = new JobImport(); DataTable dtJob = new DataTable(); DataTable dtJob4 = new DataTable(); DataTable dtJob3 = new DataTable(); DataTable dtJobInv = new DataTable(); CustomerDB cusDB = new CustomerDB(conn); String impId = ""; JobImportDB jimDB = new JobImportDB(conn); JobImportBlDB jblDB = new JobImportBlDB(conn); dtJob = selectJobNoImport(jobNo); if (dtJob.Rows.Count > 0) { impId = cusDB.selectImpIdByCodeLike1(dtJob.Rows[0]["importer"].ToString()); jim.job_import_id = ""; jim.job_import_code = ""; jim.job_import_date = date; jim.cust_id = ""; jim.imp_id = impId; jim.transport_mode = dtJob.Rows[0]["transmode"].ToString().Trim(); jim.staff_id = conn.user.staff_id; jim.entry_type_id = ""; jim.privi_id = ""; jim.ref_1 = ""; jim.ref_2 = ""; jim.ref_3 = ""; jim.ref_4 = ""; jim.ref_5 = ""; jim.ref_edi = ""; jim.imp_entry = ""; jim.edi_response = ""; jim.tax_method_id = ""; jim.check_exam_id = ""; jim.inv_date = ""; jim.tax_amt = ""; jim.insr_date = ""; jim.insr_id = ""; jim.policy_no = ""; jim.premium = ""; jim.policy_date = ""; jim.policy_clause = ""; jim.job_year = year; jim.date_create = ""; jim.date_modi = ""; jim.date_cancel = ""; jim.user_create = ""; jim.user_modi = ""; jim.user_cancel = ""; jim.active = "1"; jim.remark3 = ""; jim.remark1 = ""; jim.remark2 = ""; jim.jobno = dtJob.Rows[0]["jobno"].ToString().Trim(); jim.job_date = conn.dateMiotoDB(dtJob.Rows[0]["jobdate"].ToString().Trim()); jim.imp_date = conn.dateMiotoDB(dtJob.Rows[0]["imdate"].ToString().Trim()); jim.bl = dtJob.Rows[0]["bl"].ToString().Trim(); String jimId = jimDB.insertJobImport(jim); int chk = 0; if (int.TryParse(jimId, out chk)) { JobImportBl jbl = new JobImportBl(); jbl.job_import_bl_id = ""; jbl.job_import_id = jimId; jbl.forwarder_id = ""; jbl.mbl_mawb = ""; jbl.hbl_hawb = dtJob.Rows[0]["housebl"].ToString().Trim(); jbl.m_vessel = dtJob.Rows[0]["vslname"].ToString().Trim(); jbl.f_vessel = ""; jbl.etd = ""; jbl.eta = ""; jbl.port_imp_id = ""; jbl.terminal_id = ""; jbl.marsk = ""; jbl.description = ""; jbl.gw = dtJob.Rows[0]["grsww"].ToString().Trim(); jbl.gw_unit_id = dtJob.Rows[0]["grswwunit"].ToString().Trim(); jbl.packages_total = dtJob.Rows[0]["nopkg"].ToString().Trim(); jbl.unit_package1_id = dtJob.Rows[0]["pkgunit"].ToString().Trim(); jbl.total_con20 = ""; jbl.total_con40 = ""; jbl.volume1 = ""; jbl.port_of_loading_id = ""; jbl.date_check_exam = ""; jbl.date_delivery = ""; jbl.date_tofac = ""; jbl.truck_id = ""; jbl.car_number = ""; jbl.tranfer_with_job_id = ""; jbl.truck_cop_id = ""; jbl.status_doc_forrow = ""; jbl.doc_forrow = ""; jbl.date_doc_forrow = ""; jbl.status_job_forrow = ""; jbl.job_forrow_description = ""; jbl.date_finish_job_forrow = ""; jbl.status_oth_job = ""; jbl.delivery_remark = ""; jbl.container_yard = ""; jbl.date_create = ""; jbl.date_modi = ""; jbl.date_cancel = ""; jbl.user_create = ""; jbl.user_modi = ""; jbl.user_cancel = ""; jbl.active = "1"; jbl.remark = ""; jbl.oth_job_no = ""; jbl.fwdCode = ""; jbl.fwdCode = ""; jbl.ugwCode = ""; jbl.ugwNameT = ""; jbl.utpCode = ""; jbl.utpNameT = ""; jbl.polCode = ""; jbl.polNameT = ""; jbl.tmnCode = ""; jbl.tmnNameT = ""; jblDB.insertJobImportBl(jbl); } } }