Exemplo n.º 1
0
        public void GetWoReplaceKpWithSku(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
        {
            string            PartNo = Data["PARTNO"].ToString().Trim(), ReplacePartno = Data["REPLACEPARTNO"].ToString().Trim(), Sku = Data["SKUNO"].ToString().Trim();
            OleExec           oleDB        = oleDB = this.DBPools["SFCDB"].Borrow();;
            T_R_WO_KP_Repalce rWoKpReplace = null;
            T_R_WO_BASE       rWoBase      = null;

            try
            {
                rWoKpReplace = new T_R_WO_KP_Repalce(oleDB, DBTYPE);
                List <R_WO_KP_Repalce> rWoKpRepalceList = rWoKpReplace.GetWoRepalceKpBySkuPartno(Sku, PartNo, ReplacePartno, oleDB);
                StationReturn.Status      = StationReturnStatusValue.Pass;
                StationReturn.MessageCode = "MES00000002";
                StationReturn.Data        = rWoKpRepalceList;
            }
            catch (Exception e)
            {
                throw e;
            }
            finally
            {
                this.DBPools["SFCDB"].Return(oleDB);
            }
        }