public bool ExcuteSQL(string sql) { bool i = true; try { OracleConnection conn = new OracleConnection(StaticFunctionData.ConnString); switch (conn.State.ToString() != "Open") { case true: conn.Open(); break; } OracleCommand cmd = new OracleCommand(sql, conn); cmd.ExecuteNonQuery(); //conn.Close(); } catch (Exception ex) { i = false; Console.WriteLine("ERROR ====>"); Console.WriteLine(sql); Console.WriteLine(ex.Message); GreeterFunction.Logs(ex.Message); Console.WriteLine("END ====>"); throw ex; } return(i); }
public DataSet GetFill(string sql) { DataSet dr = new DataSet(); try { OracleConnection conn = new OracleConnection(StaticFunctionData.ConnString); switch (conn.State.ToString() != "Open") { case true: conn.Open(); break; } OracleDataAdapter da = new OracleDataAdapter(sql, conn); da.Fill(dr); //conn.Close(); } catch (Exception ex) { Console.WriteLine("ERROR ====>"); Console.WriteLine(sql); Console.WriteLine(ex); GreeterFunction.Logs(ex.Message); Console.WriteLine("END ====>"); //throw ex; } return(dr); }
public List <SetPlData> GetPlData(string refinv) { List <SetPlData> obj = new List <SetPlData>(); string sql = $"SELECT * FROM TBT_PLDIM d where d.issuingkey = '{refinv}'"; Console.WriteLine(sql); DataSet dr = new ConnDB().GetFill(sql); foreach (DataRow r in dr.Tables[0].Rows) { string pltype = new GreeterFunction().GetPlSize(r["pldim"].ToString(), int.Parse(r["ctn"].ToString())); string plno = new GreeterFunction().GetPlList(r["issuingkey"].ToString(), pltype); int plqty = new GreeterFunction().GetPlQty(r["issuingkey"].ToString(), plno); obj.Add(new SetPlData() { id = obj.Count + 1, RefInv = r["refinvoice"].ToString(), RefNo = r["issuingkey"].ToString(), plno = plno, pldim = r["pldim"].ToString(), pltype = pltype, qty = plqty, ctn = int.Parse(r["ctn"].ToString()), unit = r["unit"].ToString(), }); } return(obj); }
private void bbiPlConfirm_ItemClick(object sender, ItemClickEventArgs e) { //InvoiceConfirmInvForm frm = new InvoiceConfirmInvForm(ob.RefInv); //frm.ShowDialog(); //bool chinvconfirm = new GreeterFunction().CheckUpdateInvoice(DateTime.Parse(bbiEtd.EditValue.ToString())); //if (chinvconfirm) //{ // string invno = bbiRefInv.EditValue.ToString(); // string invoiceno = new GreeterFunction().GetLastInvoice(invno); // var result = XtraInputBox.Show("ระบุเลขที่เอกสาร", "ยืนยันการสร้าง Invoice", invoiceno); // if (result.Length > 0) // { // string sql = $"UPDATE TXP_ISSTRANSENT e SET e.REFINVOICE = '{result}' WHERE e.ISSUINGKEY = '{invno}'"; // if (new ConnDB().ExcuteSQL(sql)) // { // XtraMessageBox.Show("บันทึกข้อมูลเสร็จแล้ว"); // bbiInv.EditValue = invoiceno; // } // } //} string invno = bbiRefInv.EditValue.ToString(); string invoiceno = new GreeterFunction().GetLastInvoice(invno); var result = XtraInputBox.Show("ระบุเลขที่เอกสาร", "ยืนยันการสร้าง Invoice", invoiceno); if (result.Length > 0) { string sql = $"UPDATE TXP_ISSTRANSENT e SET e.REFINVOICE = '{result}' WHERE e.ISSUINGKEY = '{invno}'"; if (new ConnDB().ExcuteSQL(sql)) { XtraMessageBox.Show("บันทึกข้อมูลเสร็จแล้ว"); bbiInv.EditValue = invoiceno; } } }
public InvoiceAddNewPalletForm(string refinv) { InitializeComponent(); invno = refinv; this.Text = $"ADD PALLET"; List <INJPlData> obj = new GreeterFunction().GetPalletData(invno); foreach (var r in obj) { cbPlSize.Properties.Items.Add(r.PSize); } }
private void gridView_DoubleClick(object sender, EventArgs e) { OrderData obj = gridView.GetFocusedRow() as OrderData; OrderDetailForm frm = new OrderDetailForm(obj); frm.ShowDialog(); int st = new GreeterFunction().GetInvoiceStatus(obj.RefNo); gridView.SetFocusedRowCellValue("Status", st); gridView.UpdateCurrentRow(); gridView.UpdateTotalSummary(); }
private void bbiConfirm_ItemClick(object sender, ItemClickEventArgs e) { string invoiceno = new GreeterFunction().GetLastInvoice(invno); var result = XtraInputBox.Show("ระบุเลขที่เอกสาร", "ยืนยันการสร้าง Invoice", invoiceno); if (result.Length > 0) { string sql = $"UPDATE TXP_ISSTRANSENT e SET e.REFINVOICE = '{result}' WHERE e.ISSUINGKEY = '{invno}'"; if (new ConnDB().ExcuteSQL(sql)) { XtraMessageBox.Show("บันทึกข้อมูลเสร็จแล้ว"); } } }
bool UpdatePlInvoice(string refno, string plnum, string pltype, string ctn) { bool checkpl = new GreeterFunction().CheckPlDuplicate(refno, plnum); //insert string ins = $"INSERT INTO TXP_ISSPALLET(FACTORY, ISSUINGKEY, PALLETNO, PLTYPE, PLOUTSTS, UPDDTE, SYSDTE, PLTOTAL, BOOKED)\n" + $"VALUES('{StaticFunctionData.Factory}', '{refno}', '{plnum}', '{pltype}', 0, current_timestamp, current_timestamp, {ctn}, 0)"; if (checkpl) { //update ins = $"UPDATE TXP_ISSPALLET SET PLTYPE='{pltype}', UPDDTE=current_timestamp, PLTOTAL={ctn}\n" + $"WHERE ISSUINGKEY = '{refno}' AND PALLETNO = '{plnum}'"; } return(new ConnDB().ExcuteSQL(ins)); }
private void bbiConfirmInvoice_ItemClick(object sender, ItemClickEventArgs e) { string invoiceno = new GreeterFunction().GetLastInvoice(refno.Replace("'", "").Trim()); var result = XtraInputBox.Show("ระบุเลขที่เอกสาร", "ยืนยันการสร้าง Invoice", invoiceno); if (result.Length > 0) { string sql = $"UPDATE TXP_ISSTRANSENT e SET e.REFINVOICE = '{result}',e.ISSUINGSTATUS=2 WHERE e.ISSUINGKEY = '{refno.Replace("'", "").Trim()}'"; string sqlord = $"UPDATE TXP_ORDERPLAN e SET e.ORDERSTATUS=2 WHERE e.CURINV = '{refno.Replace("'", "").Trim()}'"; new ConnDB().ExcuteSQL(sqlord); if (new ConnDB().ExcuteSQL(sql)) { XtraMessageBox.Show("บันทึกข้อมูลเสร็จแล้ว"); ReloadData(); } } }
private void bbiDelete_ItemClick(object sender, ItemClickEventArgs e) { var fno = gridView.GetFocusedRowCellValue("FTicketNo"); DialogResult r = XtraMessageBox.Show($"คุณต้องการตัด Short {fno.ToString()} นี้ใช่หรือไม่", "ยืนยันคำสั่ง", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (r == DialogResult.Yes) { bool x = new ConnDB().ExcuteSQL($"UPDATE TXP_ISSPACKDETAIL d SET d.ISSUINGSTATUS = 3 WHERE d.FTICKETNO = '{fno}'"); if (x) { int ctn = int.Parse(gridView.GetFocusedRowCellValue("OrderQty").ToString()); int xn = new GreeterFunction().GetShortQty(gridView.GetFocusedRowCellValue("PartNo").ToString(), ob.RefInv, ctn); new ConnDB().ExcuteSQL($"UPDATE TXP_ISSTRANSBODY d SET d.SHORDERQTY = {xn} WHERE d.PARTNO = '{gridView.GetFocusedRowCellValue("PartNo")}' and d.ISSUINGKEY = '{ob.RefInv}'"); gridView.SetFocusedRowCellValue("Status", 3); XtraMessageBox.Show("บันทึกข้อมูลเสร็จแล้ว"); } } return; }
public async Task Test_JsonRequestBody_ReturnsOkObjectResult() { // Arrange using var stream = new MemoryStream( System.Text.Encoding.UTF8.GetBytes("{\"name\":\"jan\"}") ); Mock.Get(request) .SetupGet(r => r.Body) .Returns(stream); // Act var response = await GreeterFunction .ExecuteAsync(request, logger) .ConfigureAwait(false); // Assert Assert.IsInstanceOf <OkObjectResult>(response); }
void UpdateContainer(BookingInvoicePallet pl) { try { string sql = $"select * from txp_loadcontainer where containerno = '{bbiContainer.EditValue.ToString().ToUpper()}'"; DateTime d = DateTime.Parse(bbiRelDate.EditValue.ToString()); string txttime = $"{d.ToString("dd/MM/yyyy")} {bbiRelTimer.EditValue.ToString().Substring(10, 9).Trim()}"; DateTime dx = DateTime.Parse(bbiEtd.EditValue.ToString()); string containersize = "20F"; if (bbi4oFt.Checked) { containersize = "40F"; } DataSet dr = new ConnDB().GetFill(sql); string sqlupdate = $"update txp_loadcontainer set etddte=to_date('{dx.ToString("dd/MM/yyyy")}', 'DD/MM/YYYY')," + $"sealno='{bbiSealNo.EditValue.ToString().ToUpper()}',containersize='{containersize}'," + $"receivedte=to_date('{d.ToString("dd/MM/yyyy")}', 'DD/MM/YYYY')," + $"releasedte=to_date('{txttime}', 'DD/MM/YYYY HH24:MI:SS'),upddte=sysdate\n" + $"where containerno='{bbiContainer.EditValue.ToString().ToUpper()}'"; if (dr.Tables[0].Rows.Count <= 0) { sqlupdate = "insert into txp_loadcontainer(containerno,custname,etddte,sealno,containersize,receivedte,releasedte,sysdte,upddte) \n" + "values \n" + $"('{bbiContainer.EditValue.ToString().ToUpper()}', " + $"'{pl.custname.Trim().ToUpper()}', " + $"to_date('{dx.ToString("dd/MM/yyyy")}', 'DD/MM/YYYY'), '{bbiSealNo.EditValue.ToString().ToUpper()}', " + $"'{containersize}', to_date('{d.ToString("dd/MM/yyyy")}', 'DD/MM/YYYY'), " + $"to_date('{txttime}', 'DD/MM/YYYY HH24:MI:SS'), sysdate, sysdate)"; } new ConnDB().ExcuteSQL(sqlupdate); new ConnDB().ExcuteSQL($"UPDATE TXP_LOADPALLET SET CONTAINERNO = '{bbiContainer.EditValue.ToString().ToUpper()}' WHERE PLOUTNO = '{pl.ploutno}'"); } catch (Exception ex) { GreeterFunction.Logs(ex.Message); } }