public List <PurchaseProductTypeProperty> Search(PurchaseProductTypeProperty dataItem)
{
List <PurchaseProductTypeProperty> _result = new List <PurchaseProductTypeProperty>();
try
{
_resultData = _models.Search(dataItem);
if (_resultData.StatusOnDb == true)
{
if (_resultData.ResultOnDb.Rows.Count > 0)
{
for (int i = 0; i < _resultData.ResultOnDb.Rows.Count; i++)
{
PurchaseProductTypeProperty _purchaseProductTypeProperty = new PurchaseProductTypeProperty
{
PRODUCT_TYPE = new ProductTypeProperty
{
PRODUCT_SUB_CODE = _resultData.ResultOnDb.Rows[i]["PRODUCT_SUB_CODE"].ToString(),
PRODUCT_TITLE = _resultData.ResultOnDb.Rows[i]["PRODUCT_TITLE"].ToString(),
},
PURCHASE = new PurchaseProperty
{
ID = _resultData.ResultOnDb.Rows[i]["PURCHASE_ID"].ToString(),
PURCHASE_NO = _resultData.ResultOnDb.Rows[i]["PURCHASE_NO"].ToString(),
},
MODEL = new ModelProperty
{
MODEL_NO = _resultData.ResultOnDb.Rows[i]["MODEL_NO"].ToString(),
},
PART_NO = new PartNoProperty
{
PART_NO = _resultData.ResultOnDb.Rows[i]["PART_NO"].ToString(),
},
PURCHASE_FFTCODE = new PurchaseFftCodeProperty
{
FFT_CODE = new FftCodeProperty
{
FFT_CODE = _resultData.ResultOnDb.Rows[i]["FFT_CODE"].ToString(),
}
}
};
_result.Add(_purchaseProductTypeProperty);
}
}
}
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 Search(PurchaseProductTypeProperty dataItem)
{
sql = @"SELECT tb_2.ID as PURCHASE_ID ,
tb_2.PURCHASE_NO ,
tb_3.PRODUCT_SUB_CODE ,
tb_3.PRODUCT_TITLE ,
tb_4.PART_NO ,
tb_5.MODEL_NO ,
tb_7.FFT_CODE
from purchase_product_type tb_1 inner join purchase tb_2 on tb_1.PURCHASE_ID = tb_2.ID inner join product_type tb_3 on tb_1.PRODUCT_TYPE_ID = tb_3.ID
inner join part_no tb_4 on tb_4.ID = tb_2.PART_NO_ID
inner join model tb_5 on tb_5.ID = tb_2.MODEL_ID
inner join purchase_fft_code tb_6 on tb_2.ID = tb_6.PURCHASE_ID
inner join fft_code tb_7 on tb_6.FFT_CODE_ID = tb_7.ID
where tb_3.PRODUCT_SUB_CODE ='dataItem.PRODUCT_TYPE.PRODUCT_SUB_CODE'";
sql = sql.Replace("dataItem.PRODUCT_TYPE.PRODUCT_SUB_CODE", dataItem.PRODUCT_TYPE.PRODUCT_SUB_CODE);
return(sql);
}
public OutputOnDbProperty Search(PurchaseProductTypeProperty dataItem)
{
_resultData = _services.Search(dataItem);
return(_resultData);
}
