public string Validate_WIP(string strBarcode, string strProcessCard, string strFlag)
{
SqlDataLayer objSql = new SqlDataLayer();
try
{
if (strFlag == "ProcessCard")
{
return(objSql.ExecuteScalar(SqlDataLayer.strLocal, "SELECT COUNT(BARCODE) FROM TBLPROCESSCARD WHERE BARCODE = '" + strProcessCard.Trim() + "'").ToString());
}
else if (strFlag == "Serial")
{
string strWo_No = objSql.ExecuteScalarString(SqlDataLayer.strLocal, "SELECT WONO FROM TBLPROCESSCARD WHERE BARCODE = '" + strBarcode.Trim() + "'");
return(objSql.ExecuteScalar(SqlDataLayer.strLocal, "SELECT COUNT(SER) FROM TBLWO_INWARD WHERE WO_NO= '" + strWo_No.Trim() + "' AND SER = '" + strBarcode.Trim() + "' AND PRINTST = 1").ToString());
}
else
{
return("0~" + objSql.ExecuteScalarString(SqlDataLayer.strLocal, "SELECT COUNT(BARCODE) FROM TBLSTOCK WHERE BARCODE = '" + strBarcode.Trim() + "'"));
}
}
catch (Exception ex)
{
return("1~" + objSql.getErrorMsg(ex.ToString()));
}
finally
{
objSql = null;
}
}
public DataTable Get_Processes(string strProcessCard, string strUsername)
{
SqlDataLayer objSql = new SqlDataLayer();
try
{
if (objSql.ExecuteScalar(SqlDataLayer.strLocal, "SELECT COUNT(BARCODE) FROM TBLPROCESSCARD WHERE BARCODE = '" + strProcessCard.Trim() + "'") != 0)
{
return(objSql.ExecuteDataset(SqlDataLayer.strLocal, "SELECT DISTINCT PROCESSSTAGE FROM TBLPROCESSCARD_SUBITEM INNER JOIN TBLPROCESS_ASSIGN ON TBLPROCESSCARD_SUBITEM.PROCESSSTAGE = TBLPROCESS_ASSIGN.PROCESS WHERE DBO.FNSPLIT(TBLPROCESS_ASSIGN.OPERATOR, '=', 1) = '" + strUsername.Trim() + "' AND TBLPROCESSCARD_SUBITEM.BARCODE = '" + strProcessCard.Trim() + "' AND TBLPROCESSCARD_SUBITEM.STATUS = 0").Tables[0]);
}
else
{
DataTable dt = new DataTable();
dt.Columns.Add("PROCESSSTAGE");
DataRow dtrow = dt.NewRow();
dtrow["PROCESSSTAGE"] = "Process card barcode not exist.";
dt.Rows.Add(dtrow);
return(dt);
}
}
catch (Exception ex)
{
//return "1~" + objSql.getErrorMsg(ex.ToString());
throw ex;
}
finally
{
objSql = null;
}
}
public string Validate_Tools(string strProcessType, string strProcessStage, string strAssetCode)
{
SqlDataLayer objSql = new SqlDataLayer();
try
{
int intResult = objSql.ExecuteScalar(SqlDataLayer.strLocal, "SELECT DBO.VALIDATE_CALIBRATION('" + strAssetCode.Trim() + "')");
if (intResult == 0)
{
return("1~" + "Calibration due date expired.");
}
else if (intResult == 1)
{
return("0~" + objSql.ExecuteScalarString(SqlDataLayer.strLocal, "SELECT dbo.TBLASSET.ASSETCODE + '=' + (SELECT dbo.TBLCATEGORY.CATNM FROM dbo.TBLCATEGORY INNER JOIN dbo.TBLASSET ON dbo.TBLCATEGORY.RECNO = dbo.TBLASSET.CATEGORY WHERE dbo.TBLCATEGORY.RECNO = dbo.TBLASSET.CATEGORY) FROM dbo.TBLASSET INNER JOIN dbo.TBLSTOCK ON dbo.TBLASSET.RECNO = dbo.TBLSTOCK.ASSETCODE WHERE DBO.TBLSTOCK.BARCODE = '" + strAssetCode.Trim() + "'"));
}
else
{
return("1~" + "Asset not found.");
}
//return "0~" + objSql.ExecuteScalarString(SqlDataLayer.strLocal, "SELECT CAST(COUNT(ASSETCODE) AS VARCHAR(50)) AS ASSETCODE FROM TBLTOOL_ASSIGN WHERE DBO.FNSPLIT(ASSETCODE , '=', 1) = '" + strAssetCode.Trim() + "' AND PRODUCTTYPE = '" + strProcessType.Trim() + "' AND PROCESS = '" + strProcessStage.Trim() + "'");
}
catch (Exception ex)
{
return("1~" + objSql.getErrorMsg(ex.ToString()));
}
finally
{
objSql = null;
}
}
public string Validate_Packet(string strWork_Order, string strPacketBarcode)
{
SqlDataLayer objSql = new SqlDataLayer();
try
{
return(objSql.ExecuteScalar(SqlDataLayer.strLocal, "SELECT COUNT(RECNO) FROM TBLPICKING WHERE WORK_ORDER_NO ='" + strWork_Order.Trim() + "' AND SERIALNO = '" + strPacketBarcode.Trim() + "' AND ST = 2").ToString());
}
catch (Exception ex)
{
return("1~" + objSql.getErrorMsg(ex.ToString()));
}
finally
{
objSql = null;
}
}
public string Get_Processes(string strProcessCard, string strUsername)
{
SqlDataLayer objSql = new SqlDataLayer();
try
{
if (objSql.ExecuteScalar(SqlDataLayer.strLocal, "SELECT COUNT(BARCODE) FROM TBLPROCESSCARD WHERE BARCODE = '" + strProcessCard.Trim() + "'") != 0)
{
return("0~" + BL_Common.dataTableToString(objSql.ExecuteDataset(SqlDataLayer.strLocal, "SELECT DISTINCT PROCESSSTAGE FROM TBLPROCESSCARD_SUBITEM INNER JOIN TBLPROCESS_ASSIGN ON TBLPROCESSCARD_SUBITEM.PROCESSSTAGE = TBLPROCESS_ASSIGN.PROCESS WHERE DBO.FNSPLIT(TBLPROCESS_ASSIGN.OPERATOR, '=', 1) = '" + strUsername.Trim() + "' AND TBLPROCESSCARD_SUBITEM.BARCODE = '" + strProcessCard.Trim() + "' AND TBLPROCESSCARD_SUBITEM.STATUS = 0").Tables[0]));
}
else
{
return("1~" + "Process card barcode not exist.");
}
}
catch (Exception ex)
{
return("1~" + objSql.getErrorMsg(ex.ToString()));
}
finally
{
objSql = null;
}
}
