public tbl_multiwoselection GetmultiselectionDet4(int HmiID, string PartNoS, string WorkOrderNoS, string OpNoS)
{
tbl_multiwoselection ddldet = new tbl_multiwoselection();
Repository <tbl_multiwoselection> lista = new Repository <tbl_multiwoselection>();
try
{
string query = "SELECT DeliveredQty from [i_facility_TSAL].[dbo].tbl_multiwoselection WHERE HMIID =" + HmiID + " and PartNo ='" + PartNoS + "' and WorkOrder ='" + WorkOrderNoS + "' and OperationNo ='" + OpNoS + "'";
ddldet = lista.GetFirstOrDefault(query, _connectionFactory.GetConnection);
}
catch (Exception ex)
{
// MessageBox.Show(ex.ToString());
}
return(ddldet);
}
public int GetmultiselectionDet3(int HmiID, string PartNoS, string WorkOrderNoS, string OpNoS)
{
int det = 0;
tbl_multiwoselection ddldet = new tbl_multiwoselection();
Repository <tbl_multiwoselection> lista = new Repository <tbl_multiwoselection>();
try
{
string query = "SELECT TargetQty from [" + ConnectionFactory.DB + "].[" + ConnectionFactory.Schema + "].tbl_multiwoselection WHERE HMIID =" + HmiID + " and PartNo ='" + PartNoS + "' and WorkOrder ='" + WorkOrderNoS + "' and OperationNo ='" + OpNoS + "'";
ddldet = lista.GetFirstOrDefault(query, _connectionFactory.GetConnection);
det = (int)ddldet.TargetQty;
}
catch (Exception ex)
{
// MessageBox.Show(ex.ToString());
}
return(det);
}
