private void Get_purchaseBySerial() { // Get Purchase & Flow & Process _listPurchase = new List <PurchaseProperty>(); _serialCheck = new ShipmentProperty(); _serialCheck.SERIAL_NO = txtSerial.Text.ToString().Trim(); if (rdoLastPurchase.Checked) { _listPurchase = _controllerPurchase.LastPurchase(_serialCheck); } else if (rdoUsedPurchase.Checked) { _listPurchase = _controllerPurchase.UsedPurchase(_serialCheck); } else if (rdoAllPurchase.Checked) { _listPurchase = _controllerPurchase.ListPurchasesAll(); } else { MessageBox.Show("Please Select Button Purchase", "Stop", MessageBoxButtons.OK, MessageBoxIcon.Stop); return; } this.Set_Purchase(); }
public List <PurchaseProperty> UsedPurchase(ShipmentProperty dataItem) { List <PurchaseProperty> _result = new List <PurchaseProperty>(); try { _resultData = _models.UsedPurchase(dataItem); if (_resultData.StatusOnDb == true) { if (_resultData.ResultOnDb.Rows.Count > 0) { for (int i = 0; i < _resultData.ResultOnDb.Rows.Count; i++) { PurchaseProperty _purchase = new PurchaseProperty(); _purchase.FLOW = new FlowProperty(); _purchase.PURCHASE_NO = _resultData.ResultOnDb.Rows[i]["PURCHASE_NO"].ToString(); _purchase.FLOW.FLOW_NAME = _resultData.ResultOnDb.Rows[i]["FLOW_NAME"].ToString(); _result.Add(_purchase); } } } else { MessageBox.Show(_resultData.MessageOnDb, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(_result); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return(_result); } }
public ShipmentProperty SearchSerailShippingReturn(ShipmentProperty dataItem) { ShipmentProperty _result = new ShipmentProperty(); try { _resultData = _models.SearchSerailShippingReturn(dataItem); if (_resultData.StatusOnDb == true) { if (_resultData.ResultOnDb.Rows.Count > 0) { for (int i = 0; i < _resultData.ResultOnDb.Rows.Count; i++) { _result.SERIAL_NO = _resultData.ResultOnDb.Rows[i]["SERIAL_NO"].ToString(); _result.ACTION = _resultData.ResultOnDb.Rows[i]["ACTION"].ToString(); _result.PRODUCT_CODE = _resultData.ResultOnDb.Rows[i]["PRODUCT_CODE"].ToString(); _result.SHIPMENT_DATE = _resultData.ResultOnDb.Rows[i]["SHIPMENT_DATE"].ToString(); //_test data //_result.SHIPMENT_DATE ="10/01/1995"; _result.SHIPMENT_DATE_TXT = _resultData.ResultOnDb.Rows[i]["SHIPMENT_DATE_TXT"].ToString(); } } } else { MessageBox.Show(_resultData.MessageOnDb, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(_result); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return(_result); } }
public string SearchSerailShippingReturn(ShipmentProperty dataItem) { sql = @" SELECT 'Return' AS ACTION, '' AS SO_NO, '' AS SO_LINE_NO, RE.RECEIVED_DATE AS SHIPMENT_DATE, DATE_FORMAT(RE.RECEIVED_DATE,'%d/%m/%Y') AS SHIPMENT_DATE_TXT, RE.PRODUCT_CODE, '' AS PRODUCT_DESC, '' AS PRODUCT_TYPE, '' AS PO_NO, '' AS INVOICE_NO, '' AS INNER_QTY, '' AS MIDDLE_ID, '' AS MIDDLE_BOX, '' AS OUTER_NO, '' AS OUTER_BOX, '' AS BOX_NO, '' AS PS_NO, '' AS MIDDLE_BOX_NO, RE.SERIAL_NO FROM SHIPPING_T_PACKING_DETAIL_RETURN RE WHERE RE.SERIAL_NO = '" + dataItem.SERIAL_NO + @"';"; return(sql); }
public OutputOnDbProperty SearchSerailShippingReturn(ShipmentProperty dataItem) { strConnection = ConfigurationManager.ConnectionStrings["ConnectionShipment"].ConnectionString; sql = _sqlFactory.SearchSerailShippingReturn(dataItem); resultData = base.SearchBySql(sql); strConnection = ConfigurationManager.ConnectionStrings["ConnectionStrMysql"].ConnectionString; return(resultData); }
private bool CheckSerialNOExistInShipment() { // Check Serial in Shipment // bool statusSerail = false; _serialCheck = new ShipmentProperty(); _serialCheck.SERIAL_NO = this.txtSerial.Text.ToString().Trim(); ShipmentProperty _shippingReturn = new ShipmentProperty(); ShipmentProperty _shipping = _controllersShipment.SearchSerailShipping(_serialCheck); if (_shipping.SERIAL_NO != "") { _shippingReturn = _controllersShipment.SearchSerailShippingReturn(_serialCheck); } else { MessageBox.Show("Serial_NO : " + _serialCheck.SERIAL_NO + " Not Already Shipping From " + "\n" + " Program Shipping", "Stop" , MessageBoxButtons.OK, MessageBoxIcon.Stop); this.txtSerial.Clear(); return(statusSerail); } if (_shippingReturn.SERIAL_NO != "") { DateTime dateShipping = Convert.ToDateTime(string.Format("{0:yyyy/MM/dd}", _shipping.SHIPMENT_DATE)); DateTime dateShippingReturn = Convert.ToDateTime(string.Format("{0:yyyy/MM/dd}", _shippingReturn.SHIPMENT_DATE)); if (dateShippingReturn > dateShipping) { statusSerail = true; } else { MessageBox.Show("Serial_NO : " + _shipping.SERIAL_NO + "had already been sent for customer and not return." + "/n" + "If " + _shipping.SERIAL_NO + " have receive, Please Scan Serial at the Program: shipping in Function : Return Product" + "/n" + "at the QA and the Service Center.", "Stop", MessageBoxButtons.OK, MessageBoxIcon.Stop); this.txtSerial.Clear(); return(statusSerail); } return(statusSerail); } else { MessageBox.Show("Serial_NO : " + _shipping.SERIAL_NO + "had already been sent for customer and not return." + "/n" + "If " + _shipping.SERIAL_NO + " have receive, Please Scan Serial at the Program: shipping in Function : Return Product" + "/n" + "at the QA and the Service Center.", "Stop", MessageBoxButtons.OK, MessageBoxIcon.Stop); this.txtSerial.Clear(); return(statusSerail); } }
public string SearchSerailShipping(ShipmentProperty dataItem) { sql = @"SELECT 'Shipment' AS ACTION, T_SERIAL.SERIAL_NO, T_SO.SO_NO, T_SO.SO_LINE_NO, max(T_SO.SHIPMENT_DATE) AS SHIPMENT_DATE, DATE_FORMAT(T_SO.SHIPMENT_DATE,'%d/%m/%Y') AS SHIPMENT_DATE_TXT, T_SO.PRODUCT_CODE, T_SO.PRODUCT_DESC, T_SO.PRODUCT_TYPE, T_SO.PO_NO, T_PICKUP.INVOICE_NO, T_DETAIL.INNER_QTY, T_DETAIL.MIDDLE_ID, T_DETAIL.MIDDLE_BOX, T_DETAIL.OUTER_NO, T_DETAIL.OUTER_BOX, T_PS.BOX_NO, T_PS.PS_NO, T_PACKING.BOX_NO AS MIDDLE_BOX_NO FROM SHIPPING_T_SO T_SO LEFT JOIN SHIPPING_T_MIDDLE_DETAIL T_DETAIL ON T_DETAIL.SO_NO = T_SO.SO_NO AND T_DETAIL.SO_LINE_NO = T_SO.SO_LINE_NO LEFT JOIN SHIPPING_T_PICKUP T_PICKUP ON T_SO.SO_NO = T_PICKUP.SO_NO AND T_SO.SO_LINE_NO = T_PICKUP.SO_LINE_NO LEFT JOIN SHIPPING_T_PS T_PS ON T_DETAIL.OUTER_NO = T_PS.BOX_NO LEFT JOIN SHIPPING_T_PACKING T_PACKING ON T_PACKING.PS_NO = T_PS.PS_NO LEFT JOIN SHIPPING_T_PACKING_DETAIL T_SERIAL ON T_PACKING.BOX_NO = T_SERIAL.BOX_NO WHERE T_SO.`STATUS` <> 'Delete' AND T_SERIAL.SERIAL_NO = '" + dataItem.SERIAL_NO + @"';"; return(sql); }
public string UsedPurchase(ShipmentProperty dataItem) { sql = @"SELECT tb1.FFT_ORDER_ID ,tb4.Serial ,tb1.`GROUP` ,tb5.FLOW_NAME ,tb6.PURCHASE_NO ,tb2.INPUT_TYPE ,tb3.INUSE ,(tb3.DATE) AS DATE FROM `input`As tb1 INNER JOIN input_type As tb2 ON (tb2.ID = tb1.INPUT_TYPE_ID) INNER JOIN input_serial As tb3 ON (tb3.FFT_ORDER_ID = tb1.FFT_ORDER_ID AND tb3.`GROUP` = tb1.`GROUP`) INNER JOIN serial As tb4 ON (tb4.ID = tb3.SERIAL_ID) INNER JOIN flow As tb5 ON (tb5.ID = tb3.FLOW_ID) INNER JOIN purchase As tb6 ON (tb6.ID = tb3.PURCHASE_ID) INNER JOIN process_flow As tb7 ON (tb7.FLOW_ID = tb5.ID) WHERE tb2.ID <> ('4') AND tb2.ID <> ('5') AND tb4.SERIAL = '" + dataItem.SERIAL_NO + @"' GROUP BY tb1.`FFT_ORDER_ID` ,tb1.`GROUP` ORDER BY tb3.DATE DESC "; return(sql); }
public OutputOnDbProperty SearchSerailShippingReturn(ShipmentProperty dataItem) { _resultData = _services.SearchSerailShippingReturn(dataItem); return(_resultData); }
public OutputOnDbProperty UsedPurchase(ShipmentProperty dataItem) { _resultData = _services.UsedPurchase(dataItem); return(_resultData); }
public OutputOnDbProperty UsedPurchase(ShipmentProperty dataItem) { sql = _sqlFactoryPurchase.UsedPurchase(dataItem); resultData = base.SearchBySql(sql); return(resultData); }