コード例 #1
0
        public string OfflineInsertPhysicalCount(DataTable dtTemp)
        {
            SqlDataLayer objSql = new SqlDataLayer();

            SqlParameter[] objParameters = new SqlParameter[2];
            try
            {
                objParameters[0] = new SqlParameter("@TEMP", SqlDbType.Structured);
                objParameters[1] = new SqlParameter("@RESULT", SqlDbType.VarChar, 500);

                objParameters[0].Value     = dtTemp;
                objParameters[1].Direction = ParameterDirection.Output;

                if (objSql.ExecuteProcedureParam(SqlDataLayer.strLocal, "sp_Offline_Physical_count", objParameters, "@RESULT", "@RESULT") != "")
                {
                    return(objParameters[1].Value.ToString());
                }
                else
                {
                    return("1~" + string.Empty);
                }
            }
            catch (Exception ex)
            {
                return("1~" + objSql.getErrorMsg(ex.ToString()));
            }
            finally
            {
                objParameters = null;
                objSql        = null;
            }
        }
コード例 #2
0
        public string InsertProcessSetup(string strWorkOrder, string strProduction, string strStage, string strSetupTime, DataTable dt_Serial, DataTable dt_Tools, string strUserID, string strPlant)
        {
            SqlDataLayer objSql = new SqlDataLayer();

            SqlParameter[] objParameters = new SqlParameter[14];
            try
            {
                objParameters[0]  = new SqlParameter("@TEMP", SqlDbType.Structured);
                objParameters[1]  = new SqlParameter("@TEMP_SER", SqlDbType.Structured);
                objParameters[2]  = new SqlParameter("@WONO", SqlDbType.VarChar);
                objParameters[3]  = new SqlParameter("@PARTNO", SqlDbType.VarChar);
                objParameters[4]  = new SqlParameter("@DESCRIPTION", SqlDbType.VarChar);
                objParameters[5]  = new SqlParameter("@PRODTYPE", SqlDbType.VarChar);
                objParameters[6]  = new SqlParameter("@STAGE", SqlDbType.VarChar);
                objParameters[7]  = new SqlParameter("@STARTDATE", SqlDbType.VarChar);
                objParameters[8]  = new SqlParameter("@ENDDATE", SqlDbType.VarChar);
                objParameters[9]  = new SqlParameter("@STATUS", SqlDbType.Int);
                objParameters[10] = new SqlParameter("@PLANTNO", SqlDbType.VarChar);
                objParameters[11] = new SqlParameter("@USERNAME", SqlDbType.VarChar);
                objParameters[12] = new SqlParameter("@SETUPTIME", SqlDbType.VarChar);
                objParameters[13] = new SqlParameter("@RESULT", SqlDbType.VarChar, 500);

                objParameters[0].Value      = dt_Tools;
                objParameters[1].Value      = dt_Serial;
                objParameters[2].Value      = strWorkOrder.Trim();
                objParameters[3].Value      = "";
                objParameters[4].Value      = "";
                objParameters[5].Value      = strProduction.Trim();
                objParameters[6].Value      = strStage.Trim();
                objParameters[7].Value      = DateTime.Now;
                objParameters[8].Value      = DateTime.Now;
                objParameters[9].Value      = 0;
                objParameters[10].Value     = strPlant;
                objParameters[11].Value     = strUserID;
                objParameters[12].Value     = strSetupTime;
                objParameters[13].Direction = ParameterDirection.Output;

                if (objSql.ExecuteProcedureParam(SqlDataLayer.strLocal, "sp_ProcessSetup", objParameters, "@RESULT", "@RESULT") != "")
                {
                    return(objParameters[13].Value.ToString());
                }
                else
                {
                    return("1~" + "");
                }
            }
            catch (Exception ex)
            {
                return("1~" + objSql.getErrorMsg(ex.ToString()));
            }
            finally
            {
                objParameters = null;
                objSql        = null;
            }
        }
コード例 #3
0
        public string Asset_Calibration(string strBarcode, string strLastCaliDate, string strUsername)
        {
            SqlDataLayer objSql = new SqlDataLayer();

            SqlParameter[] objParameters = new SqlParameter[5];
            try
            {
                objParameters[0] = new SqlParameter("@ASSETCODE", SqlDbType.VarChar);
                objParameters[1] = new SqlParameter("@CALDATE", SqlDbType.DateTime);
                objParameters[2] = new SqlParameter("@MODE", SqlDbType.VarChar);
                objParameters[3] = new SqlParameter("@USERNAME", SqlDbType.VarChar);
                objParameters[4] = new SqlParameter("@RESULT", SqlDbType.VarChar, 600);

                objParameters[0].Value = strBarcode.Trim();
                if (strLastCaliDate == string.Empty)
                {
                    objParameters[1].Value = DateTime.Now;
                }
                else
                {
                    objParameters[1].Value = Convert.ToDateTime(strLastCaliDate.Trim());
                }
                if (strLastCaliDate == "")
                {
                    objParameters[2].Value = "GET";
                }
                else
                {
                    objParameters[2].Value = "SET";
                }
                objParameters[3].Value     = strUsername.Trim();
                objParameters[4].Direction = ParameterDirection.Output;

                if (objSql.ExecuteProcedureParam(SqlDataLayer.strLocal, "sp_ScanningCalibration", objParameters, "@RESULT", "@RESULT") != "")
                {
                    BL_Common.BL_Write(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, 2, "Executed Successfully.", strUsername);
                    return("0~" + objParameters[4].Value.ToString());
                }
                else
                {
                    BL_Common.BL_Write(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, 0, "Execution Failed.", strUsername);
                    return("1~Invalid assetcode scanned.");
                }
            }
            catch (Exception ex)
            {
                BL_Common.BL_Write(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, 0, ex.ToString(), strUsername);
                return("1~" + objSql.getErrorMsg(ex.ToString()));
            }
            finally
            {
                objParameters = null;
                objSql        = null;
            }
        }
コード例 #4
0
        public string InsertProduction(string strProcessBarcode, string strProcess, string strSerialno, DataTable dtCompBarcode, DataTable dtSerBarcode, string strRemark, string strMode, int intRework, string strUserID, string strPlant, int intRef)
        {
            SqlDataLayer objSql = new SqlDataLayer();

            SqlParameter[] objParameters = new SqlParameter[12];
            try
            {
                objParameters[0]  = new SqlParameter("@BARCODE", SqlDbType.VarChar);
                objParameters[1]  = new SqlParameter("@PROCESSDESC", SqlDbType.VarChar);
                objParameters[2]  = new SqlParameter("@TRACKING_ID", SqlDbType.VarChar);
                objParameters[3]  = new SqlParameter("@COMPBARCODE", SqlDbType.Structured);
                objParameters[4]  = new SqlParameter("@SERBARCODE", SqlDbType.Structured);
                objParameters[5]  = new SqlParameter("@REMARK", SqlDbType.VarChar);
                objParameters[6]  = new SqlParameter("@MODE", SqlDbType.VarChar);
                objParameters[7]  = new SqlParameter("@PLANTNO", SqlDbType.VarChar);
                objParameters[8]  = new SqlParameter("@USERNAME", SqlDbType.VarChar);
                objParameters[9]  = new SqlParameter("@REWORK", SqlDbType.Int);
                objParameters[10] = new SqlParameter("@STAGE_REF", SqlDbType.Int);
                objParameters[11] = new SqlParameter("@RESULT", SqlDbType.VarChar, 500);

                objParameters[0].Value      = strProcessBarcode.Trim();
                objParameters[1].Value      = strProcess.Trim();
                objParameters[2].Value      = strSerialno.Trim();
                objParameters[3].Value      = dtCompBarcode;
                objParameters[4].Value      = dtSerBarcode;
                objParameters[5].Value      = strRemark.Trim();
                objParameters[6].Value      = strMode.Trim();
                objParameters[7].Value      = strPlant;
                objParameters[8].Value      = strUserID;
                objParameters[9].Value      = intRework;
                objParameters[10].Value     = intRef;
                objParameters[11].Direction = ParameterDirection.Output;

                if (objSql.ExecuteProcedureParam(SqlDataLayer.strLocal, "sp_WIPScanning", objParameters, "@RESULT", "@RESULT") != "")
                {
                    return(objParameters[11].Value.ToString());
                }
                else
                {
                    return("1~" + string.Empty);
                }
            }
            catch (Exception ex)
            {
                return("1~" + objSql.getErrorMsg(ex.ToString()));
            }
            finally
            {
                objParameters = null;
                objSql        = null;
            }
        }
コード例 #5
0
        public string UpdatePicking(string strPackSlip, string strLocation, string strItemCode, string strQty, string strPacket, string strStatus, string strUserID)
        {
            SqlDataLayer objSql = new SqlDataLayer();

            SqlParameter[] objParameters = new SqlParameter[8];
            try
            {
                objParameters[0] = new SqlParameter("@PACKSLIP", SqlDbType.VarChar);
                objParameters[1] = new SqlParameter("@PACKBARCODE", SqlDbType.VarChar);
                objParameters[2] = new SqlParameter("@ITEMBARCODE", SqlDbType.VarChar);
                objParameters[3] = new SqlParameter("@LOCATION", SqlDbType.VarChar);
                objParameters[4] = new SqlParameter("@USERNAME", SqlDbType.VarChar);
                objParameters[5] = new SqlParameter("@QTY", SqlDbType.Float);
                objParameters[6] = new SqlParameter("@STATUS", SqlDbType.Int);
                objParameters[7] = new SqlParameter("@RESULT", SqlDbType.VarChar, 100);

                objParameters[0].Value     = strPackSlip.Trim();
                objParameters[1].Value     = strPacket.Trim();
                objParameters[2].Value     = strItemCode.Trim();
                objParameters[3].Value     = strLocation.Trim();
                objParameters[4].Value     = strUserID.Trim();
                objParameters[5].Value     = Convert.ToDouble(strQty);
                objParameters[6].Value     = Convert.ToInt32(strStatus);
                objParameters[7].Direction = ParameterDirection.Output;

                if (objSql.ExecuteProcedureParam(SqlDataLayer.strLocal, "sp_ScanningPicking", objParameters, "@RESULT", "@RESULT") != "")
                {
                    BL_Common.BL_Write(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, 2, "Material picking successfully", strUserID);
                    return("0~" + objParameters[7].Value.ToString());
                }
                else
                {
                    BL_Common.BL_Write(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, 0, "Material picking failed", strUserID);
                    return("1~Error in picking.");
                }
            }
            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
            {
                objParameters = null;
                objSql        = null;
            }
        }
コード例 #6
0
        public string InsertCompScan(string strWorkOrder, string strPartNo, string strDescription, DataTable dtPackage, string strUserID, string strPlant)
        {
            SqlDataLayer objSql = new SqlDataLayer();

            SqlParameter[] objParameters = new SqlParameter[9];
            try
            {
                objParameters[0] = new SqlParameter("@TEMP", SqlDbType.Structured);
                objParameters[1] = new SqlParameter("@WONO", SqlDbType.VarChar);
                objParameters[2] = new SqlParameter("@PARTNO", SqlDbType.VarChar);
                objParameters[3] = new SqlParameter("@DESCRIPTION", SqlDbType.VarChar);
                objParameters[4] = new SqlParameter("@REMARK", SqlDbType.VarChar);
                objParameters[5] = new SqlParameter("@STATUS", SqlDbType.Int);
                objParameters[6] = new SqlParameter("@PLANTNO", SqlDbType.VarChar);
                objParameters[7] = new SqlParameter("@USERNAME", SqlDbType.VarChar);
                objParameters[8] = new SqlParameter("@RESULT", SqlDbType.VarChar, 500);

                objParameters[0].Value     = dtPackage;
                objParameters[1].Value     = strWorkOrder.Trim();
                objParameters[2].Value     = strPartNo.Trim();
                objParameters[3].Value     = strDescription.Trim();
                objParameters[4].Value     = "";
                objParameters[5].Value     = 0;
                objParameters[6].Value     = strPlant.Trim();
                objParameters[7].Value     = strUserID.Trim();
                objParameters[8].Direction = ParameterDirection.Output;

                if (objSql.ExecuteProcedureParam(SqlDataLayer.strLocal, "sp_CompScanning", objParameters, "@RESULT", "@RESULT") != "")
                {
                    return(objParameters[8].Value.ToString());
                }
                else
                {
                    return("1~" + string.Empty);
                }
            }
            catch (Exception ex)
            {
                return("1~" + objSql.getErrorMsg(ex.ToString()));
            }
            finally
            {
                objParameters = null;
                objSql        = null;
            }
        }
コード例 #7
0
        public string Save_Rework(DataTable dtTemp, string strWorkOrder, string strSerialNumber, string strRemark, int intStatus, string strPlant, string strUsername)
        {
            SqlDataLayer objSql = new SqlDataLayer();

            SqlParameter[] objParameters = new SqlParameter[8];
            try
            {
                objParameters[0] = new SqlParameter("@TEMP", SqlDbType.Structured);
                objParameters[1] = new SqlParameter("@WONO", SqlDbType.VarChar);
                objParameters[2] = new SqlParameter("@SER", SqlDbType.VarChar);
                objParameters[3] = new SqlParameter("@REMARK", SqlDbType.VarChar);
                objParameters[4] = new SqlParameter("@PLANTNO", SqlDbType.VarChar);
                objParameters[5] = new SqlParameter("@STATUS", SqlDbType.Int);
                objParameters[6] = new SqlParameter("@USERNAME", SqlDbType.VarChar);
                objParameters[7] = new SqlParameter("@RESULT", SqlDbType.VarChar, 500);

                objParameters[0].Value     = dtTemp;
                objParameters[1].Value     = strWorkOrder.Trim();
                objParameters[2].Value     = strSerialNumber.Trim();
                objParameters[3].Value     = strRemark.Trim();
                objParameters[4].Value     = strPlant;
                objParameters[5].Value     = 0;
                objParameters[6].Value     = strUsername;
                objParameters[7].Direction = ParameterDirection.Output;

                if (objSql.ExecuteProcedureParam(SqlDataLayer.strLocal, "sp_Rework", objParameters, "@RESULT", "@RESULT") != "")
                {
                    return(objParameters[7].Value.ToString());
                }
                else
                {
                    return("1~" + string.Empty);
                }
            }
            catch (Exception ex)
            {
                return("1~" + objSql.getErrorMsg(ex.ToString()));
            }
            finally
            {
                objParameters = null;
                objSql        = null;
            }
        }
コード例 #8
0
        public string UpdateRecevingDL_Initial(string strBarcode, string strQty, string strStatus)
        {
            SqlDataLayer objSql = new SqlDataLayer();

            SqlParameter[] objParameters = new SqlParameter[4];
            try
            {
                objParameters[0] = new SqlParameter("@BARCODE", SqlDbType.VarChar);
                objParameters[1] = new SqlParameter("@QTY", SqlDbType.Float);
                objParameters[2] = new SqlParameter("@STATUS", SqlDbType.VarChar);
                objParameters[3] = new SqlParameter("@RESULT", SqlDbType.VarChar, 100);

                objParameters[0].Value     = strBarcode.Trim();
                objParameters[1].Value     = Convert.ToDouble(strQty.Trim());
                objParameters[2].Value     = Convert.ToInt32(strStatus);
                objParameters[3].Direction = ParameterDirection.Output;

                if (objSql.ExecuteProcedureParam(SqlDataLayer.strLocal, "sp_ScanningPicking_Initial", objParameters, "@RESULT", "@RESULT") != "")
                {
                    //BL_Common.BL_Write(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, 2, ex.ToString(), strUserID);
                    return("0~" + objParameters[3].Value.ToString());
                }
                else
                {
                    return("1~Error in Save.");
                }

                //BL_Common.dataTableToString(objSql.ExecuteProcedure_Table(SqlDataLayer.strLocal, "sp_ScanningPicking_Initial", objParameters));

                //return "0~" + objParameters[3].Value.ToString();
            }
            catch (Exception ex)
            {
                return("1~" + objSql.getErrorMsg(ex.ToString()));
            }
            finally
            {
                objParameters = null;
                objSql        = null;
            }
        }
コード例 #9
0
        public string BL_AuthenticateLogin(string strUsername, string strPassword)
        {
            SqlDataLayer objSql = new SqlDataLayer();

            SqlParameter[] objParameters = new SqlParameter[3];
            try
            {
                objParameters[0] = new SqlParameter("@USERNAME", SqlDbType.VarChar);
                objParameters[1] = new SqlParameter("@PASSWORD", SqlDbType.VarChar);
                objParameters[2] = new SqlParameter("@RESULT", SqlDbType.VarChar, 100);

                objParameters[0].Value     = strUsername.Trim();
                objParameters[1].Value     = strPassword.Trim();
                objParameters[2].Direction = ParameterDirection.Output;

                if (objSql.ExecuteProcedureParam(SqlDataLayer.strLocal, "sp_Login", objParameters, "@RESULT", "@RESULT") != "")
                {
                    BL_Common.BL_Write(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, 2, "Login Succesfully", strUsername);
                    return("0~" + objParameters[2].Value.ToString());
                }
                else
                {
                    BL_Common.BL_Write(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, 0, "Login Failed", strUsername);
                    return("1~Invalid login details");
                }
            }
            catch (Exception ex)
            {
                BL_Common.BL_Write(MethodBase.GetCurrentMethod().DeclaringType.Name, MethodBase.GetCurrentMethod().Name, 0, ex.ToString(), strUsername);
                return("1~" + objSql.getErrorMsg(ex.ToString()));
            }
            finally
            {
                objParameters = null;
                objSql        = null;
            }
        }
コード例 #10
0
        public string DeletePhysicalCount(string strBarcode, string strUser)
        {
            SqlDataLayer objSql = new SqlDataLayer();

            SqlParameter[] objParameters = new SqlParameter[3];
            try
            {
                objParameters[0] = new SqlParameter("@BARCODE", SqlDbType.VarChar);
                objParameters[1] = new SqlParameter("@USERNAME", SqlDbType.VarChar);
                objParameters[2] = new SqlParameter("@RESULT", SqlDbType.VarChar, 500);

                objParameters[0].Value     = strBarcode.Trim();
                objParameters[1].Value     = strUser.Trim();
                objParameters[2].Direction = ParameterDirection.Output;

                if (objSql.ExecuteProcedureParam(SqlDataLayer.strLocal, "sp_Delete_Physical_count", objParameters, "@RESULT", "@RESULT") != "")
                {
                    return(objParameters[2].Value.ToString());
                }
                else
                {
                    return("1~" + string.Empty);
                }
                //DataTable dt = objSql.ExecuteProcedureParam(SqlDataLayer.strLocal, "sp_Physical_count", objParameters);
                //return dt;
            }
            catch (Exception ex)
            {
                throw ex;
                // return "1~" + objSql.getErrorMsg(ex.ToString());
            }
            finally
            {
                objParameters = null;
                objSql        = null;
            }
        }
コード例 #11
0
        public string Update_KitMat(string strPackSlip, string strPacketNo, string strUsername)
        {
            SqlDataLayer objSql = new SqlDataLayer();

            SqlParameter[] objParameters = new SqlParameter[4];
            try
            {
                objParameters[0] = new SqlParameter("@PACKSLIP", SqlDbType.VarChar);
                objParameters[1] = new SqlParameter("@PACKBARCODE", SqlDbType.VarChar);
                objParameters[2] = new SqlParameter("@USERNAME", SqlDbType.VarChar);
                objParameters[3] = new SqlParameter("@RESULT", SqlDbType.VarChar, 100);

                objParameters[0].Value     = strPackSlip.Trim();
                objParameters[1].Value     = strPacketNo.Trim();
                objParameters[2].Value     = strUsername.Trim();
                objParameters[3].Direction = ParameterDirection.Output;

                if (objSql.ExecuteProcedureParam(SqlDataLayer.strLocal, "sp_ScanningKITMAT", objParameters, "@RESULT", "@RESULT") != "")
                {
                    return("0~" + objParameters[3].Value.ToString());
                }
                else
                {
                    return("1~" + string.Empty);
                }
            }
            catch (Exception ex)
            {
                return("1~" + objSql.getErrorMsg(ex.ToString()));
            }
            finally
            {
                objParameters = null;
                objSql        = null;
            }
        }
コード例 #12
0
        public bool Consume_Xml_Structure_PlantBOM(string strFilename)
        {
            string       strRefNo = "";
            bool         flag     = false;
            SqlDataLayer objSql   = new SqlDataLayer();

            SqlParameter[] objParameters  = new SqlParameter[4];
            SqlParameter[] objParameters1 = new SqlParameter[1];

            XmlDocument doc = new XmlDocument();

            System.IO.StreamReader sr = new System.IO.StreamReader(strFilename);
            XmlNodeList            Plant;
            XmlNodeList            Zone;
            XmlNodeList            Line;
            XmlNodeList            Station;

            StringWriter sw = new StringWriter();

            while (!sr.EndOfStream)
            {
                string strLine = sr.ReadLine();
                if (strLine.StartsWith("<") == true && strLine.EndsWith(">") == true)
                {
                    sw.WriteLine(strLine);
                }
            }

            try
            {
                doc.LoadXml(sw.ToString());
                DataSet ds = new DataSet();

                objParameters1[0] = new SqlParameter("@RESULT", SqlDbType.VarChar, 500);

                objParameters1[0].Direction = ParameterDirection.Output;

                strRefNo = objSql.ExecuteProcedureParam(SqlDataLayer.strLocal, "sp_GetRefNo", objParameters1, "@RESULT", "@RESULT");

                Plant = doc.GetElementsByTagName("Plant");
                foreach (XmlNode x in Plant)
                {
                    ds = ConverttYourXmlNodeToDataSet(x);

                    if (ds.Tables.Contains("Plant") == true)
                    {
                        if (ds.Tables["Plant"].Rows.Count == 0)
                        {
                            flag = false;
                        }
                        else
                        {
                            flag = true;
                        }
                    }
                    else
                    {
                        flag = false;
                    }
                }

                if (flag == true)
                {
                    Station = doc.GetElementsByTagName("Station");
                    foreach (XmlNode x in Station)
                    {
                        ds = ConverttYourXmlNodeToDataSet(x);

                        if (ds.Tables.Count > 0)
                        {
                            objParameters[0] = new SqlParameter("@TEMP_PARENT", SqlDbType.Structured);
                            objParameters[1] = new SqlParameter("@TEMP_CHILD", SqlDbType.Structured);
                            objParameters[2] = new SqlParameter("@FLAG", SqlDbType.VarChar);
                            objParameters[3] = new SqlParameter("@REFNO", SqlDbType.VarChar);

                            objParameters[0].Value = ds.Tables[0];
                            if (ds.Tables.Count > 1)
                            {
                                objParameters[1].Value = ds.Tables[1];
                            }
                            objParameters[2].Value = "STATION";
                            objParameters[3].Value = strRefNo;

                            objSql.ExecuteProcedure_DataSet(SqlDataLayer.strLocal, "sp_PlantBOM", objParameters);
                        }
                    }

                    Line = doc.GetElementsByTagName("Line");
                    foreach (XmlNode x in Line)
                    {
                        ds = ConverttYourXmlNodeToDataSet(x);

                        if (ds.Tables.Count > 0)
                        {
                            objParameters[0] = new SqlParameter("@TEMP_PARENT", SqlDbType.Structured);
                            objParameters[1] = new SqlParameter("@TEMP_CHILD", SqlDbType.Structured);
                            objParameters[2] = new SqlParameter("@FLAG", SqlDbType.VarChar);
                            objParameters[3] = new SqlParameter("@REFNO", SqlDbType.VarChar);

                            objParameters[0].Value = ds.Tables[0].DefaultView.ToTable(true, "ID", "NAME", "REVISION", "SUBTYPE");
                            if (ds.Tables.Count > 1)
                            {
                                objParameters[1].Value = ds.Tables[1].DefaultView.ToTable(true, "CHILD_ID");
                            }
                            objParameters[2].Value = "LINE";
                            objParameters[3].Value = strRefNo;

                            objSql.ExecuteProcedure_DataSet(SqlDataLayer.strLocal, "sp_PlantBOM", objParameters);
                        }
                    }

                    Zone = doc.GetElementsByTagName("Zone");
                    foreach (XmlNode x in Zone)
                    {
                        ds = ConverttYourXmlNodeToDataSet(x);

                        if (ds.Tables.Count > 0)
                        {
                            objParameters[0] = new SqlParameter("@TEMP_PARENT", SqlDbType.Structured);
                            objParameters[1] = new SqlParameter("@TEMP_CHILD", SqlDbType.Structured);
                            objParameters[2] = new SqlParameter("@FLAG", SqlDbType.VarChar);
                            objParameters[3] = new SqlParameter("@REFNO", SqlDbType.VarChar);

                            objParameters[0].Value = ds.Tables[0].DefaultView.ToTable(true, "ID", "NAME", "REVISION", "SUBTYPE");
                            if (ds.Tables.Count > 1)
                            {
                                objParameters[1].Value = ds.Tables[1].DefaultView.ToTable(true, "CHILD_ID");
                            }
                            objParameters[2].Value = "ZONE";
                            objParameters[3].Value = strRefNo;

                            objSql.ExecuteProcedure_DataSet(SqlDataLayer.strLocal, "sp_PlantBOM", objParameters);
                        }
                    }

                    Plant = doc.GetElementsByTagName("Plant");
                    foreach (XmlNode x in Plant)
                    {
                        ds = ConverttYourXmlNodeToDataSet(x);

                        if (ds.Tables.Count > 0)
                        {
                            objParameters[0] = new SqlParameter("@TEMP_PARENT", SqlDbType.Structured);
                            objParameters[1] = new SqlParameter("@TEMP_CHILD", SqlDbType.Structured);
                            objParameters[2] = new SqlParameter("@FLAG", SqlDbType.VarChar);
                            objParameters[3] = new SqlParameter("@REFNO", SqlDbType.VarChar);

                            objParameters[0].Value = ds.Tables[0].DefaultView.ToTable(true, "ID", "NAME", "REVISION", "SUBTYPE");
                            //objParameters[1].Value = ds.Tables[1].DefaultView.ToTable(true, "CHILD_ID");
                            objParameters[2].Value = "PLANT";
                            objParameters[3].Value = strRefNo;

                            objSql.ExecuteProcedure_DataSet(SqlDataLayer.strLocal, "sp_PlantBOM", objParameters);
                        }
                    }
                    return(flag);
                }
                else
                {
                    return(flag);
                }
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
            finally
            {
                objParameters = null;
                objSql        = null;
                doc           = null;
                sr.Close();
                sr = null;
                sw.Close();
                sw      = null;
                Plant   = null;
                Zone    = null;
                Line    = null;
                Station = null;
            }
        }
コード例 #13
0
        public bool Consume_Xml_Structure_Tool(string strFilename)
        {
            XmlDocument doc = new XmlDocument();

            System.IO.StreamReader sr = new System.IO.StreamReader(strFilename);
            XmlNodeList            Tools;

            StringWriter sw = new StringWriter();

            while (!sr.EndOfStream)
            {
                string strLine = sr.ReadLine();
                if (strLine.StartsWith("<") == true && strLine.EndsWith(">") == true)
                {
                    sw.WriteLine(strLine);
                }
            }


            DataTable @TEMP_TEMPCC = new DataTable();

            string strCCid = string.Empty;

            System.Data.DataSet ds     = new DataSet();
            SqlDataLayer        objSql = new SqlDataLayer();

            SqlParameter[] objParameters = new SqlParameter[2];
            try
            {
                doc.LoadXml(sw.ToString());

                Tools = doc.GetElementsByTagName("Tool");

                foreach (XmlElement node in Tools)
                {
                    ds = ConverttYourXmlNodeToDataSet(node);
                }

                objParameters[0] = new SqlParameter("@TEMP", SqlDbType.Structured);
                objParameters[1] = new SqlParameter("@RESULT", SqlDbType.VarChar, 1000);

                objParameters[0].Value     = ds.Tables[0];
                objParameters[1].Direction = ParameterDirection.Output;

                objSql.ExecuteProcedureParam(SqlDataLayer.strLocal, "sp_Sync_Tools", objParameters, "@RESULT", "@RESULT");

                return(true);
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
            finally
            {
                objParameters = null;
                objSql        = null;
                doc           = null;
                sr.Close();
                sr = null;
                sw.Close();
                sw    = null;
                Tools = null;
            }
        }
コード例 #14
0
        public bool Consume_Xml_Structure(string strFilename)
        {
            XmlDocument doc = new XmlDocument();

            System.IO.StreamReader sr = new System.IO.StreamReader(strFilename);
            XmlNodeList            CollaborationContext;
            XmlNodeList            Stations;
            XmlNodeList            Station;
            XmlNodeList            Track;
            XmlNodeList            Processes;
            XmlNodeList            ProcessClassList;

            StringWriter sw = new StringWriter();

            while (!sr.EndOfStream)
            {
                string strLine = sr.ReadLine();
                if (strLine.StartsWith("<") == true && strLine.EndsWith(">") == true)
                {
                    sw.WriteLine(strLine);
                }
            }

            DataTable @TEMP_TEMPCC                   = new DataTable();
            DataTable @TEMP_TEMPCC_CNFG              = new DataTable();
            DataTable @TEMP_TEMPCC_OPERATIONS        = new DataTable();
            DataTable @TEMP_TEMPCC_RESOURCES         = new DataTable();
            DataTable @TEMP_TEMPCC_STATIONS          = new DataTable();
            DataTable @TEMP_TEMPCC_TOOLS_CONSUMABLES = new DataTable();
            DataTable @TEMP_TEMPCC_PROCESSES_PROCESS = new DataTable();
            DataTable @TEMP_TEMPCC_DOCUMENTS         = new DataTable();
            DataTable @TEMP_APPLPROCESSCLASSLIST     = new DataTable();
            DataTable @TEMP_SUCCESSORS               = new DataTable();
            DataTable @TEMP_PREDECESSORS             = new DataTable();

            string strCCid         = string.Empty;
            string strStation      = string.Empty;
            string strStation_name = string.Empty;
            string strOperation    = string.Empty;
            string ProcessRoot     = string.Empty;
            string EBOMRoot        = string.Empty;
            string MBOMRoot        = string.Empty;
            string PlantBOMRoot    = string.Empty;
            string strAsmblName    = "";

            string strSEQ           = string.Empty;
            string strOperation_for = string.Empty;

            System.Data.DataSet ds     = new DataSet();
            SqlDataLayer        objSql = new SqlDataLayer();

            SqlParameter[] objParameters = new SqlParameter[13];
            try
            {
                #region Collebration Context Header Tables
                @TEMP_TEMPCC.Columns.Add("CC_ID", typeof(string));
                @TEMP_TEMPCC.Columns.Add("REVRULE", typeof(string));
                @TEMP_TEMPCC.Columns.Add("VARRULE", typeof(string));
                @TEMP_TEMPCC.Columns.Add("FILENAME", typeof(string));

                @TEMP_TEMPCC_CNFG.Columns.Add("CC_ID", typeof(string));
                @TEMP_TEMPCC_CNFG.Columns.Add("PROCESSROOT_ID", typeof(string));
                @TEMP_TEMPCC_CNFG.Columns.Add("PROCESSROOT_NAME", typeof(string));
                @TEMP_TEMPCC_CNFG.Columns.Add("PROCESSROOT_REVISION", typeof(string));
                @TEMP_TEMPCC_CNFG.Columns.Add("EBOMROOT_ID", typeof(string));
                @TEMP_TEMPCC_CNFG.Columns.Add("EBOMROOT_NAME", typeof(string));
                @TEMP_TEMPCC_CNFG.Columns.Add("EBOMROOT_REVISION", typeof(string));
                @TEMP_TEMPCC_CNFG.Columns.Add("MBOMROOT_ID", typeof(string));
                @TEMP_TEMPCC_CNFG.Columns.Add("MBOMROOT_NAME", typeof(string));
                @TEMP_TEMPCC_CNFG.Columns.Add("MBOMROOT_REVISION", typeof(string));

                @TEMP_TEMPCC_STATIONS.Columns.Add("CC_ID", typeof(string));
                @TEMP_TEMPCC_STATIONS.Columns.Add("STATION_ID", typeof(string));
                @TEMP_TEMPCC_STATIONS.Columns.Add("STATION_NAME", typeof(string));
                @TEMP_TEMPCC_STATIONS.Columns.Add("STATION_REVISION", typeof(string));

                @TEMP_TEMPCC_OPERATIONS.Columns.Add("CC_ID", typeof(string));
                @TEMP_TEMPCC_OPERATIONS.Columns.Add("STATION_ID", typeof(string));
                @TEMP_TEMPCC_OPERATIONS.Columns.Add("ID", typeof(string));
                @TEMP_TEMPCC_OPERATIONS.Columns.Add("NAME", typeof(string));
                @TEMP_TEMPCC_OPERATIONS.Columns.Add("REVISION", typeof(string));
                @TEMP_TEMPCC_OPERATIONS.Columns.Add("SEQ", typeof(string));
                @TEMP_TEMPCC_OPERATIONS.Columns.Add("URL", typeof(string));
                @TEMP_TEMPCC_OPERATIONS.Columns.Add("OCCID", typeof(string));
                @TEMP_TEMPCC_OPERATIONS.Columns.Add("OPERATIONSETUPREQUIRED", typeof(string));

                @TEMP_TEMPCC_TOOLS_CONSUMABLES.Columns.Add("CC_ID", typeof(string));
                @TEMP_TEMPCC_TOOLS_CONSUMABLES.Columns.Add("STATION_ID", typeof(string));
                @TEMP_TEMPCC_TOOLS_CONSUMABLES.Columns.Add("SEQ", typeof(string));
                @TEMP_TEMPCC_TOOLS_CONSUMABLES.Columns.Add("OP_ID", typeof(string));
                @TEMP_TEMPCC_TOOLS_CONSUMABLES.Columns.Add("TYPE", typeof(string));
                @TEMP_TEMPCC_TOOLS_CONSUMABLES.Columns.Add("ID", typeof(string));
                @TEMP_TEMPCC_TOOLS_CONSUMABLES.Columns.Add("NAME", typeof(string));
                @TEMP_TEMPCC_TOOLS_CONSUMABLES.Columns.Add("QUANTITY", typeof(string));
                @TEMP_TEMPCC_TOOLS_CONSUMABLES.Columns.Add("REVISION", typeof(string));

                @TEMP_TEMPCC_RESOURCES.Columns.Add("CC_ID", typeof(string));
                @TEMP_TEMPCC_RESOURCES.Columns.Add("STATION_ID", typeof(string));
                @TEMP_TEMPCC_RESOURCES.Columns.Add("OP_ID", typeof(string));
                @TEMP_TEMPCC_RESOURCES.Columns.Add("ID", typeof(string));
                @TEMP_TEMPCC_RESOURCES.Columns.Add("NAME", typeof(string));
                @TEMP_TEMPCC_RESOURCES.Columns.Add("REVISION", typeof(string));

                @TEMP_SUCCESSORS.Columns.Add("CC_ID", typeof(string));
                @TEMP_SUCCESSORS.Columns.Add("STATION_ID", typeof(string));
                @TEMP_SUCCESSORS.Columns.Add("OP_ID", typeof(string));
                @TEMP_SUCCESSORS.Columns.Add("TYPE", typeof(string));
                @TEMP_SUCCESSORS.Columns.Add("ID", typeof(string));

                @TEMP_PREDECESSORS.Columns.Add("CC_ID", typeof(string));
                @TEMP_PREDECESSORS.Columns.Add("STATION_ID", typeof(string));
                @TEMP_PREDECESSORS.Columns.Add("OP_ID", typeof(string));
                @TEMP_PREDECESSORS.Columns.Add("TYPE", typeof(string));
                @TEMP_PREDECESSORS.Columns.Add("ID", typeof(string));

                #endregion

                #region Process Card Tables
                @TEMP_TEMPCC_PROCESSES_PROCESS.Columns.Add("CC_ID", typeof(string));
                @TEMP_TEMPCC_PROCESSES_PROCESS.Columns.Add("TYPE", typeof(string));
                @TEMP_TEMPCC_PROCESSES_PROCESS.Columns.Add("ID", typeof(string));
                @TEMP_TEMPCC_PROCESSES_PROCESS.Columns.Add("NAME", typeof(string));
                @TEMP_TEMPCC_PROCESSES_PROCESS.Columns.Add("REVISION", typeof(string));

                @TEMP_TEMPCC_DOCUMENTS.Columns.Add("CC_ID", typeof(string));
                @TEMP_TEMPCC_DOCUMENTS.Columns.Add("TYPE", typeof(string));
                @TEMP_TEMPCC_DOCUMENTS.Columns.Add("ID", typeof(string));
                @TEMP_TEMPCC_DOCUMENTS.Columns.Add("NAME", typeof(string));
                @TEMP_TEMPCC_DOCUMENTS.Columns.Add("REVISION", typeof(string));

                @TEMP_APPLPROCESSCLASSLIST.Columns.Add("CC_ID", typeof(string));
                @TEMP_APPLPROCESSCLASSLIST.Columns.Add("CATEGORY", typeof(string));
                @TEMP_APPLPROCESSCLASSLIST.Columns.Add("SUB-CATEGORY", typeof(string));

                #endregion

                doc.LoadXml(sw.ToString());

                CollaborationContext = doc.GetElementsByTagName("CollaborationContext");

                #region Collebration Header Details
                DataRow dr_CNFG = TEMP_TEMPCC_CNFG.NewRow();
                foreach (XmlElement node in CollaborationContext)
                {
                    if (node.Attributes.Count > 0)
                    {
                        if (node.HasAttribute("name"))
                        {
                            strCCid    = node.Attributes["name"].InnerXml;
                            dr_CNFG[0] = strCCid;
                            if (string.IsNullOrEmpty(strCCid.Trim()) == true)
                            {
                                throw new Exception("Collaboration Context Number is blank.");
                            }

                            DataRow dr_CCinfo = TEMP_TEMPCC.NewRow();
                            dr_CCinfo[0] = strCCid;
                            try
                            {
                                dr_CCinfo[1] = node.Attributes["revRule"].InnerXml;
                                dr_CCinfo[2] = node.Attributes["varRule"].InnerXml;
                            }
                            catch { }
                            TEMP_TEMPCC.Rows.Add(dr_CCinfo);
                            TEMP_TEMPCC.AcceptChanges();
                        }
                    }
                }

                TEMP_TEMPCC.Rows[0]["FILENAME"] = strFilename;

                foreach (XmlElement node in doc.GetElementsByTagName("ProcessRoot"))
                {
                    if (node.Attributes.Count > 0)
                    {
                        if (node.HasAttribute("id"))
                        {
                            dr_CNFG[1] = node.Attributes["id"].InnerXml;
                            dr_CNFG[2] = node.Attributes["name"].InnerXml;
                            dr_CNFG[3] = node.Attributes["revision"].InnerXml;
                        }
                    }
                }

                foreach (XmlElement node in doc.GetElementsByTagName("EBOMRoot"))
                {
                    if (node.Attributes.Count > 0)
                    {
                        if (node.HasAttribute("id"))
                        {
                            dr_CNFG[4] = node.Attributes["id"].InnerXml;
                            dr_CNFG[5] = node.Attributes["name"].InnerXml;
                            dr_CNFG[6] = node.Attributes["revision"].InnerXml;
                        }
                    }
                }

                foreach (XmlElement node in doc.GetElementsByTagName("MBOMRoot"))
                {
                    if (node.Attributes.Count > 0)
                    {
                        if (node.HasAttribute("id"))
                        {
                            dr_CNFG[7] = node.Attributes["id"].InnerXml;
                            dr_CNFG[8] = node.Attributes["name"].InnerXml;
                            dr_CNFG[9] = node.Attributes["revision"].InnerXml;
                        }
                    }
                }
                TEMP_TEMPCC_CNFG.Rows.Add(dr_CNFG);
                TEMP_TEMPCC_CNFG.AcceptChanges();
                #endregion

                #region Station Details
                Stations = doc.GetElementsByTagName("station");

                foreach (XmlElement node in Stations)
                {
                    if (node.Attributes.Count > 0)
                    {
                        #region Stations
                        if (node.HasAttribute("id"))
                        {
                            strStation      = node.Attributes["id"].InnerXml;
                            strStation_name = node.Attributes["name"].InnerXml;
                            DataRow dr_CNFGinfo = TEMP_TEMPCC_STATIONS.NewRow();
                            dr_CNFGinfo["CC_ID"]            = strCCid;
                            dr_CNFGinfo["STATION_ID"]       = node.Attributes["id"].InnerXml;
                            dr_CNFGinfo["STATION_NAME"]     = node.Attributes["name"].InnerXml;
                            dr_CNFGinfo["STATION_REVISION"] = node.Attributes["revision"].InnerXml;
                            TEMP_TEMPCC_STATIONS.Rows.Add(dr_CNFGinfo);
                            TEMP_TEMPCC_STATIONS.AcceptChanges();
                        }
                        #endregion

                        foreach (XmlNode strST in node)
                        {
                            Track = strST.ChildNodes;
                            foreach (XmlNode sTrack in Track)
                            {
                                ds = ConverttYourXmlNodeToDataSet(sTrack);

                                if (ds.Tables.Count == 0)
                                {
                                    throw new Exception("Incomplete BOP. This BOP does not have proper details.");
                                }

                                foreach (DataTable dt_dsTemp in ds.Tables)
                                {
                                    foreach (DataRow dr_dsTemp in dt_dsTemp.Rows)
                                    {
                                        if (dt_dsTemp.TableName.ToUpper() == "OPERATION")
                                        {
                                            DataRow dr_OperationInfo = @TEMP_TEMPCC_OPERATIONS.NewRow();
                                            dr_OperationInfo["CC_ID"]      = strCCid;
                                            dr_OperationInfo["STATION_ID"] = strStation;
                                            dr_OperationInfo["ID"]         = dr_dsTemp["ID"].ToString();
                                            strOperation_for             = dr_dsTemp["ID"].ToString();
                                            dr_OperationInfo["NAME"]     = dr_dsTemp["NAME"].ToString();
                                            dr_OperationInfo["REVISION"] = dr_dsTemp["REVISION"].ToString();
                                            dr_OperationInfo["SEQ"]      = dr_dsTemp["SEQUENCE"].ToString();
                                            strSEQ = dr_dsTemp["SEQUENCE"].ToString();
                                            dr_OperationInfo["URL"]   = dr_dsTemp["URL"].ToString();
                                            dr_OperationInfo["OCCID"] = dr_dsTemp["OCCID"].ToString();
                                            try
                                            {
                                                dr_OperationInfo["OPERATIONSETUPREQUIRED"] = dr_dsTemp["OPERATIONSETUPREQUIRED"].ToString();
                                            }
                                            catch { }
                                            @TEMP_TEMPCC_OPERATIONS.Rows.Add(dr_OperationInfo);
                                            @TEMP_TEMPCC_OPERATIONS.AcceptChanges();
                                        }
                                        if (dt_dsTemp.TableName.ToUpper() == "TOOL")
                                        {
                                            DataRow dr_OperationInfo = TEMP_TEMPCC_TOOLS_CONSUMABLES.NewRow();
                                            dr_OperationInfo["CC_ID"]      = strCCid;
                                            dr_OperationInfo["STATION_ID"] = strStation;
                                            dr_OperationInfo["SEQ"]        = strSEQ;
                                            dr_OperationInfo["OP_ID"]      = strOperation_for;
                                            dr_OperationInfo["TYPE"]       = "TOOL";
                                            dr_OperationInfo["ID"]         = dr_dsTemp["id"].ToString();
                                            dr_OperationInfo["NAME"]       = dr_dsTemp["name"].ToString();
                                            dr_OperationInfo["QUANTITY"]   = dr_dsTemp["quantity"].ToString();
                                            dr_OperationInfo["REVISION"]   = dr_dsTemp["revision"].ToString();
                                            TEMP_TEMPCC_TOOLS_CONSUMABLES.Rows.Add(dr_OperationInfo);
                                            TEMP_TEMPCC_TOOLS_CONSUMABLES.AcceptChanges();
                                        }
                                        if (dt_dsTemp.TableName.ToUpper() == "WIS")
                                        {
                                            DataRow dr_OperationInfo = TEMP_TEMPCC_TOOLS_CONSUMABLES.NewRow();
                                            dr_OperationInfo["CC_ID"]      = strCCid;
                                            dr_OperationInfo["STATION_ID"] = strStation;
                                            dr_OperationInfo["SEQ"]        = strSEQ;
                                            dr_OperationInfo["OP_ID"]      = strOperation_for;
                                            dr_OperationInfo["TYPE"]       = "WIS";
                                            dr_OperationInfo["ID"]         = "";
                                            dr_OperationInfo["NAME"]       = dr_dsTemp["id"].ToString();
                                            dr_OperationInfo["QUANTITY"]   = "";
                                            dr_OperationInfo["REVISION"]   = ""; // dr_dsTemp["rev"].ToString();
                                            TEMP_TEMPCC_TOOLS_CONSUMABLES.Rows.Add(dr_OperationInfo);
                                            TEMP_TEMPCC_TOOLS_CONSUMABLES.AcceptChanges();
                                        }
                                        if (dt_dsTemp.TableName.ToUpper() == "CONSUMABLE")
                                        {
                                            DataRow dr_OperationInfo = TEMP_TEMPCC_TOOLS_CONSUMABLES.NewRow();
                                            dr_OperationInfo["CC_ID"]      = strCCid;
                                            dr_OperationInfo["STATION_ID"] = strStation;
                                            dr_OperationInfo["SEQ"]        = strSEQ;
                                            dr_OperationInfo["OP_ID"]      = strOperation_for;
                                            dr_OperationInfo["TYPE"]       = "CONSUMABLE";
                                            dr_OperationInfo["ID"]         = dr_dsTemp["id"].ToString();
                                            dr_OperationInfo["NAME"]       = dr_dsTemp["name"].ToString();
                                            dr_OperationInfo["QUANTITY"]   = dr_dsTemp["quantity"].ToString();
                                            dr_OperationInfo["REVISION"]   = dr_dsTemp["revision"].ToString();
                                            TEMP_TEMPCC_TOOLS_CONSUMABLES.Rows.Add(dr_OperationInfo);
                                            TEMP_TEMPCC_TOOLS_CONSUMABLES.AcceptChanges();
                                        }
                                        if (dt_dsTemp.TableName.ToUpper() == "ASSIGNEDPART")
                                        {
                                            DataRow dr_OperationInfo = TEMP_TEMPCC_TOOLS_CONSUMABLES.NewRow();
                                            dr_OperationInfo["CC_ID"]      = strCCid;
                                            dr_OperationInfo["STATION_ID"] = strStation;
                                            dr_OperationInfo["SEQ"]        = strSEQ;
                                            dr_OperationInfo["OP_ID"]      = strOperation_for;
                                            dr_OperationInfo["TYPE"]       = "ASSIGNEDPART";
                                            dr_OperationInfo["ID"]         = dr_dsTemp["id"].ToString();
                                            dr_OperationInfo["NAME"]       = dr_dsTemp["name"].ToString();
                                            dr_OperationInfo["QUANTITY"]   = dr_dsTemp["quantity"].ToString();
                                            dr_OperationInfo["REVISION"]   = dr_dsTemp["revision"].ToString();
                                            TEMP_TEMPCC_TOOLS_CONSUMABLES.Rows.Add(dr_OperationInfo);
                                            TEMP_TEMPCC_TOOLS_CONSUMABLES.AcceptChanges();
                                        }
                                        if (dt_dsTemp.TableName.ToUpper() == "RESOURCE")
                                        {
                                            DataRow dr_OperationInfo = TEMP_TEMPCC_RESOURCES.NewRow();
                                            dr_OperationInfo["CC_ID"]      = strCCid;
                                            dr_OperationInfo["STATION_ID"] = strStation;
                                            dr_OperationInfo["OP_ID"]      = strOperation_for;
                                            dr_OperationInfo["ID"]         = dr_dsTemp["ID"].ToString();
                                            dr_OperationInfo["NAME"]       = dr_dsTemp["NAME"].ToString();
                                            dr_OperationInfo["REVISION"]   = dr_dsTemp["REVISION"].ToString();
                                            TEMP_TEMPCC_RESOURCES.Rows.Add(dr_OperationInfo);
                                            TEMP_TEMPCC_RESOURCES.AcceptChanges();
                                        }
                                        if (dt_dsTemp.TableName.ToUpper() == "SUCCESSOR")
                                        {
                                            DataRow dr_OperationInfo = TEMP_SUCCESSORS.NewRow();
                                            dr_OperationInfo["CC_ID"]      = strCCid;
                                            dr_OperationInfo["STATION_ID"] = strStation;
                                            dr_OperationInfo["OP_ID"]      = strOperation_for;
                                            dr_OperationInfo["TYPE"]       = "SUCCESSOR";
                                            dr_OperationInfo["ID"]         = dr_dsTemp["ID"].ToString();
                                            TEMP_SUCCESSORS.Rows.Add(dr_OperationInfo);
                                            TEMP_SUCCESSORS.AcceptChanges();
                                        }
                                        if (dt_dsTemp.TableName.ToUpper() == "PREDECESSOR")
                                        {
                                            DataRow dr_OperationInfo = TEMP_PREDECESSORS.NewRow();
                                            dr_OperationInfo["CC_ID"]      = strCCid;
                                            dr_OperationInfo["STATION_ID"] = strStation;
                                            dr_OperationInfo["OP_ID"]      = strOperation_for;
                                            dr_OperationInfo["TYPE"]       = "PREDECESSOR";
                                            dr_OperationInfo["ID"]         = dr_dsTemp["ID"].ToString();
                                            TEMP_PREDECESSORS.Rows.Add(dr_OperationInfo);
                                            TEMP_PREDECESSORS.AcceptChanges();
                                        }
                                    }
                                }
                            }
                        }
                    }
                    else
                    {
                        throw new Exception("Stations not found");
                    }
                }

                #endregion


                #region Processes Details
                Processes = doc.GetElementsByTagName("process");

                foreach (XmlElement node in Processes)
                {
                    if (node.Attributes.Count > 0)
                    {
                        #region Stations
                        if (node.HasAttribute("id"))
                        {
                            strAsmblName = node.Attributes["name"].InnerXml;
                        }
                        #endregion

                        foreach (XmlNode strST in node)
                        {
                            Track = strST.ChildNodes;
                            foreach (XmlNode sTrack in Track)
                            {
                                ds = ConverttYourXmlNodeToDataSet(sTrack);

                                if (ds.Tables.Count == 0)
                                {
                                    throw new Exception("Incomplete BOP. This BOP does not have proper details.");
                                }

                                foreach (DataTable dt_dsTemp in ds.Tables)
                                {
                                    foreach (DataRow dr_dsTemp in dt_dsTemp.Rows)
                                    {
                                        if (dt_dsTemp.TableName.ToUpper() == "DOCUMENT")
                                        {
                                            DataRow dr_OperationInfo = TEMP_TEMPCC_DOCUMENTS.NewRow();
                                            dr_OperationInfo["CC_ID"]    = strCCid;
                                            dr_OperationInfo["TYPE"]     = "DOCUMENT";
                                            dr_OperationInfo["ID"]       = dr_dsTemp["ID"].ToString();
                                            dr_OperationInfo["NAME"]     = strAsmblName;
                                            dr_OperationInfo["REVISION"] = dr_dsTemp["revision"].ToString();
                                            TEMP_TEMPCC_DOCUMENTS.Rows.Add(dr_OperationInfo);
                                            TEMP_TEMPCC_DOCUMENTS.AcceptChanges();
                                        }
                                    }
                                }
                            }
                        }
                    }
                    else
                    {
                        throw new Exception("Processes not found");
                    }
                }

                #endregion

                #region Process Class Details
                ProcessClassList = doc.GetElementsByTagName("ProcessClass");

                foreach (XmlElement node in ProcessClassList)
                {
                    if (node.Attributes.Count > 0)
                    {
                        #region Stations
                        if (node.HasAttribute("Category"))
                        {
                            DataRow dr_OperationInfo = TEMP_APPLPROCESSCLASSLIST.NewRow();
                            dr_OperationInfo["CC_ID"]        = strCCid;
                            dr_OperationInfo["CATEGORY"]     = node.Attributes["Category"].InnerXml;
                            dr_OperationInfo["SUB-CATEGORY"] = node.Attributes["Sub-category"].InnerXml;
                            TEMP_APPLPROCESSCLASSLIST.Rows.Add(dr_OperationInfo);
                            TEMP_APPLPROCESSCLASSLIST.AcceptChanges();
                        }
                        #endregion
                    }
                    else
                    {
                        throw new Exception("Process Class not found");
                    }
                }

                #endregion

                objParameters[0]  = new SqlParameter("@TEMP_TEMPCC", SqlDbType.Structured);
                objParameters[1]  = new SqlParameter("@TEMP_TEMPCC_CNFG", SqlDbType.Structured);
                objParameters[2]  = new SqlParameter("@TEMP_TEMPCC_OPERATIONS", SqlDbType.Structured);
                objParameters[3]  = new SqlParameter("@TEMP_TEMPCC_RESOURCES", SqlDbType.Structured);
                objParameters[4]  = new SqlParameter("@TEMP_TEMPCC_STATIONS", SqlDbType.Structured);
                objParameters[5]  = new SqlParameter("@TEMP_TEMPCC_TOOLS_CONSUMABLES", SqlDbType.Structured);
                objParameters[6]  = new SqlParameter("@TEMP_TEMPCC_PROCESS_CARD", SqlDbType.Structured);
                objParameters[7]  = new SqlParameter("@TEMP_TEMPCC_DOCUMENTS", SqlDbType.Structured);
                objParameters[8]  = new SqlParameter("@TEMP_TEMPCC_PROCESSCLASS", SqlDbType.Structured);
                objParameters[9]  = new SqlParameter("@TEMP_SUCCESSORS", SqlDbType.Structured);
                objParameters[10] = new SqlParameter("@TEMP_PREDECESSORS", SqlDbType.Structured);
                objParameters[11] = new SqlParameter("@USERNAME", SqlDbType.VarChar);
                objParameters[12] = new SqlParameter("@RESULT", SqlDbType.VarChar, 1000);

                objParameters[0].Value      = @TEMP_TEMPCC;
                objParameters[1].Value      = @TEMP_TEMPCC_CNFG;
                objParameters[2].Value      = @TEMP_TEMPCC_OPERATIONS;
                objParameters[3].Value      = @TEMP_TEMPCC_RESOURCES;
                objParameters[4].Value      = @TEMP_TEMPCC_STATIONS;
                objParameters[5].Value      = @TEMP_TEMPCC_TOOLS_CONSUMABLES;
                objParameters[6].Value      = @TEMP_TEMPCC_PROCESSES_PROCESS;
                objParameters[7].Value      = @TEMP_TEMPCC_DOCUMENTS;
                objParameters[8].Value      = @TEMP_APPLPROCESSCLASSLIST;
                objParameters[9].Value      = @TEMP_SUCCESSORS;
                objParameters[10].Value     = @TEMP_PREDECESSORS;
                objParameters[11].Value     = "SET";
                objParameters[12].Direction = ParameterDirection.Output;

                objSql.ExecuteProcedureParam(SqlDataLayer.strLocal, "sp_SyncXML", objParameters, "@RESULT", "@RESULT");

                return(true);
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
            finally
            {
                objParameters = null;
                objSql        = null;
                doc           = null;
                sr.Close();
                sr = null;
                sw.Close();
                sw = null;
                CollaborationContext = null;
                Stations             = null;
                strStation_name      = null;
                Station   = null;
                Track     = null;
                Processes = null;

                @TEMP_TEMPCC                   = null;
                @TEMP_TEMPCC_CNFG              = null;
                @TEMP_TEMPCC_OPERATIONS        = null;
                @TEMP_TEMPCC_RESOURCES         = null;
                @TEMP_TEMPCC_STATIONS          = null;
                @TEMP_TEMPCC_TOOLS_CONSUMABLES = null;
                @TEMP_APPLPROCESSCLASSLIST     = null;
                @TEMP_SUCCESSORS               = null;
                @TEMP_PREDECESSORS             = null;
            }
        }