예제 #1
0
        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;
            }
        }
예제 #2
0
        public string BL_GetMyRights1(string strUserID)
        {
            SqlDataLayer objSql    = new SqlDataLayer();
            string       strResult = string.Empty;

            try
            {
                strResult = objSql.ExecuteScalarString(SqlDataLayer.strLocal, "SELECT UTYPE FROM TBLUSER WHERE UID = '" + strUserID.Trim() + "'");

                if (strResult.Trim() != string.Empty)
                {
                    BL_Common.BL_Write(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, 2, "Fetching user rights successfully", strUserID);
                    return(strResult.Trim());
                }
                else
                {
                    BL_Common.BL_Write(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, 0, "Fetching user rights failed.", strUserID);
                    return("1~Do not have device operational rights.");
                }
            }
            catch (Exception ex)
            {
                BL_Common.BL_Write(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, 0, ex.ToString(), strUserID);
                return("1~" + objSql.getErrorMsg(ex.ToString()));
            }
            finally
            {
                objSql = null;
            }
        }
예제 #3
0
        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;
            }
        }
예제 #4
0
        public string getField(string strQuery, string strUsername)
        {
            SqlDataLayer objSql = new SqlDataLayer();

            try
            {
                return(objSql.ExecuteScalarString(SqlDataLayer.strLocal, strQuery));
            }
            catch (Exception ex)
            {
                return("1~" + objSql.getErrorMsg(ex.ToString()));
            }
            finally
            {
                objSql = null;
            }
        }
예제 #5
0
        public DataTable GetmyProcessWIP(string strSerial_barcode, string strUsername)
        {
            SqlDataLayer objSql         = new SqlDataLayer();
            DataTable    dt_Process     = new DataTable();
            DataTable    dt_Final       = new DataTable();
            string       strProcessCard = "";

            try
            {
                strProcessCard = objSql.ExecuteScalarString(SqlDataLayer.strLocal, "SELECT PROCESSCARD FROM TBLWO_INWARD WHERE TRACKING_ID = '" + strSerial_barcode.Trim() + "'");

                if (Convert.ToInt32(objSql.ExecuteScalarString(SqlDataLayer.strLocal, "SELECT CAST(COUNT(*) AS VARCHAR(50)) FROM TBLWO_INWARD WHERE PROCESSCARD = '" + strProcessCard.Trim() + "' AND TRACKING_ID = '" + strSerial_barcode.Trim() + "'")) == 0)
                {
                    throw new Exception("Invalid Process card or serial number scanned.");
                }

                dt_Process = objSql.ExecuteDataset(SqlDataLayer.strLocal, "SELECT DISTINCT PROCESSSTAGE, AUTONUM FROM VW_PRODSTAGES WHERE BARCODE = '" + strProcessCard.Trim() + "' AND STATUS = 0 ORDER BY AUTONUM ASC").Tables[0]; //UID = '" + clsInit.GstrUserID.Trim() + "' AND

                dt_Process.Columns.Add("Rework", typeof(string));

                foreach (DataRow dr in dt_Process.Rows)
                {
                    string strReworkFlag = string.Empty;
                    strReworkFlag = objSql.ExecuteScalarString(SqlDataLayer.strLocal, "SELECT CAST(RECNO AS VARCHAR(50)) FROM TBLREWORK WHERE WO_NO = '" + strProcessCard.Split('-').GetValue(0).ToString() + "' AND SER = '" + strSerial_barcode.Trim() + "' AND PROCESS = '" + dr["PROCESSSTAGE"].ToString() + "'  and Stage_Ref = " + dr["AUTONUM"] + " AND ST = 0;");
                    if (strReworkFlag.Trim() == "")
                    {
                        dr["Rework"] = "0";
                    }
                    else
                    {
                        dr["Rework"] = strReworkFlag;;
                    }
                }

                dt_Final.Columns.Add("Ref", typeof(int));
                dt_Final.Columns.Add("ProcessStage", typeof(string));
                dt_Final.Columns.Add("Rework", typeof(string));

                foreach (DataRow dr in dt_Process.Rows)
                {
                    if (dr["Rework"].ToString() == "0")
                    {
                        if (Convert.ToInt32(objSql.ExecuteScalarString(SqlDataLayer.strLocal, "SELECT CAST(COUNT(RECNO) AS VARCHAR(50)) FROM TBLPRODUCTION WHERE BARCODE = '" + strProcessCard.Trim() + "' AND TRACKING_ID = '" + strSerial_barcode.Trim() + "' AND PROCESSDESC = '" + dr["PROCESSSTAGE"].ToString() + "' AND CRUSER = '******' AND ST = 2 and Stage_Ref = " + dr["AUTONUM"] + "")) == 0)
                        {
                            DataRow dr_Final = dt_Final.NewRow();
                            dr_Final["Ref"]          = dr["AUTONUM"];
                            dr_Final["ProcessStage"] = dr["ProcessStage"];
                            dr_Final["Rework"]       = dr["Rework"];
                            dt_Final.Rows.Add(dr_Final);
                            dt_Final.AcceptChanges();
                        }
                    }
                    else
                    {
                        DataRow dr_Final = dt_Final.NewRow();
                        dr_Final["Ref"]          = dr["AUTONUM"];
                        dr_Final["ProcessStage"] = dr["ProcessStage"];
                        dr_Final["Rework"]       = dr["Rework"];
                        dt_Final.Rows.Add(dr_Final);
                        dt_Final.AcceptChanges();
                    }
                }
                return(dt_Final);
            }
            catch (Exception ex)
            {
                //return "1~" + objSql.getErrorMsg(ex.ToString());
                throw ex;
            }
            finally
            {
                objSql = null;
            }
        }