Epicor工序添加与BOM信息处理

 //3
            //Capp 工序
            String bsql3 = "select * from CAPP_PART_TITLE_INFO";
            SqlDataAdapter badapter3 = new SqlDataAdapter(bsql3, conn);
            SqlCommandBuilder bscb3 = new SqlCommandBuilder(badapter3);
            DataSet bpds3 = new System.Data.DataSet();
            badapter3.Fill(bpds3, "Cpart_info");
            int caCount = bpds3.Tables["Cpart_info"].Rows.Count;
            workBench = new Epicor.Mfg.BO.EngWorkBench(E9Session.ConnectionPool);
            partOnHand = new Epicor.Mfg.BO.PartOnHandWhse(E9Session.ConnectionPool);

            parentNum = "";
            sonpartNum = "";
            versionNum = "";
            //String sonversionNum = "";
            //ceshi-----
            theSameBom = 0;
            for (int i = 0; i < caCount; i++)
            {

                sonpartNum = bpds3.Tables["Cpart_info"].Rows[i]["MATERIAL_NUMBER"].ToString();
                //如果parentNumber不是同一个物料号
                if (!parentNum.Equals(bpds3.Tables["Cpart_info"].Rows[i]["PART_NUMBER"].ToString()))
                {
                    theSameBom = 0;
                    workbenchds = new Epicor.Mfg.BO.EngWorkBenchDataSet();
                    //不是第一条数据,就要把上一个物料BOM核准并保存。
                    if (i != 0)
                    {

                        workBench.GroupUnLock("PLM", parentNum, versionNum, "", System.DateTime.Now, false, false, true, false, workbenchds);
                        workbenchds = workBench.GetDatasetForTree("PLM", parentNum, versionNum,
                             "", System.DateTime.Now, false, false);
                        workbenchds.Tables["ECORev"].Rows[0]["Approved"] = "True";
                        workBench.ChangeECORevApproved(true, workbenchds);
                        workBench.Update(workbenchds);
                        String opm1 = "";
                        workbenchds = workBench.CheckIn("PLM", parentNum, versionNum, "", System.DateTime.Now, false, false, true, true, false, "ECO 群组 PLM PLM群组", out opm1);
                        workBench.Update(workbenchds);

                        //调用存储过程 删除数据
                        System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter("Delete_CAPP", conn);
                        da.SelectCommand.CommandType = CommandType.StoredProcedure;
                        da.SelectCommand.Parameters.Add(new SqlParameter("partNum", parentNum));//在此添加参数
                        DataSet ds = new DataSet();
                        da.Fill(ds);
                    }
                    //查询到PLM传来一条BOM数据，查看Epicor中该物料是否已经存在BOM，
                    parentNum = bpds3.Tables["Cpart_info"].Rows[i]["PART_NUMBER"].ToString();
                    //工序
                    String sqlp = "select * from CAPP_PART_PROCESS_INFO where PART_NUMBER='" + parentNum + "' order by PROCESS_NUMBER";
                    SqlDataAdapter adapterp = new SqlDataAdapter(sqlp, conn);
                    SqlCommandBuilder bscbp = new SqlCommandBuilder(adapterp);
                    DataSet poDs = new System.Data.DataSet();
                    adapterp.Fill(poDs, "Cpo_info");
                    int pcount = poDs.Tables["Cpo_info"].Rows.Count;

                    //通过id，得到partDataset对象
                    PartDs = PartBo.GetByID(parentNum);
                    int countVersin = PartDs.Tables["PartRev"].Rows.Count;