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);
}
