public void ModifyMapping(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
        {
            T_C_SKU_VER_MAPPING skuVerMapping = null;
            OleExec             sfcdb         = null;

            try
            {
                string result;
                string id        = Data["ID"].ToString().Trim().ToUpper();
                string custSkuno = Data["CUST_SKUNO"].ToString().Trim().ToUpper();
                string foxVer1   = Data["FOX_VER1"].ToString().Trim().ToUpper();
                string foxVer2   = Data["FOX_VER2"].ToString().Trim().ToUpper();
                string custVer   = Data["CUST_VER"].ToString().Trim().ToUpper();
                sfcdb = this.DBPools["SFCDB"].Borrow();
                sfcdb.ThrowSqlExeception = true;
                skuVerMapping            = new T_C_SKU_VER_MAPPING(sfcdb, DB_TYPE_ENUM.Oracle);
                Row_C_SKU_VER_MAPPING rowMapping = (Row_C_SKU_VER_MAPPING)skuVerMapping.GetObjByID(id, sfcdb);
                rowMapping.FOX_VERSION1     = foxVer1;
                rowMapping.FOX_VERSION2     = foxVer2;
                rowMapping.CUSTOMER_SKUNO   = custSkuno;
                rowMapping.CUSTOMER_VERSION = custVer;
                rowMapping.EDIT_EMP         = this.LoginUser.EMP_NO;
                rowMapping.EDIT_TIME        = GetDBDateTime();
                result = sfcdb.ExecSQL(rowMapping.GetUpdateString(this.DBTYPE));

                if (Convert.ToInt32(result) > 0)
                {
                    StationReturn.Message = "";
                    StationReturn.MessagePara.Add(Convert.ToInt32(result));
                    StationReturn.MessageCode = "MES00000035";
                    StationReturn.Status      = StationReturnStatusValue.Pass;
                    StationReturn.Data        = "";
                }
                else
                {
                    StationReturn.Message = "";
                    StationReturn.MessagePara.Add(result);
                    StationReturn.MessageCode = "MES00000025";
                    StationReturn.Status      = StationReturnStatusValue.Fail;
                    StationReturn.Data        = "";
                }
                this.DBPools["SFCDB"].Return(sfcdb);
            }
            catch (Exception e)
            {
                this.DBPools["SFCDB"].Return(sfcdb);
                StationReturn.MessagePara.Add(e.Message);
                StationReturn.Message     = e.Message;
                StationReturn.MessageCode = "MES00000025";
                StationReturn.Status      = StationReturnStatusValue.Fail;
            }
        }
        public void DeleteMapping(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
        {
            T_C_SKU_VER_MAPPING skuVerMapping = null;
            OleExec             sfcdb         = null;

            try
            {
                string result;
                string id = Data["ID"].ToString().Trim().ToUpper();
                sfcdb = this.DBPools["SFCDB"].Borrow();
                sfcdb.ThrowSqlExeception = true;
                skuVerMapping            = new T_C_SKU_VER_MAPPING(sfcdb, DB_TYPE_ENUM.Oracle);
                Row_C_SKU_VER_MAPPING rowMapping = (Row_C_SKU_VER_MAPPING)skuVerMapping.GetObjByID(id, sfcdb);
                result = sfcdb.ExecSQL(rowMapping.GetDeleteString(this.DBTYPE));

                if (Convert.ToInt32(result) > 0)
                {
                    StationReturn.Message     = "";
                    StationReturn.MessageCode = "MES00000004";
                    StationReturn.Status      = StationReturnStatusValue.Pass;
                    StationReturn.Data        = "";
                }
                else
                {
                    StationReturn.Message = "";
                    StationReturn.MessagePara.Add(result);
                    StationReturn.MessageCode = "MES00000023";
                    StationReturn.Status      = StationReturnStatusValue.Fail;
                    StationReturn.Data        = "";
                }
                this.DBPools["SFCDB"].Return(sfcdb);
            }
            catch (Exception e)
            {
                this.DBPools["SFCDB"].Return(sfcdb);
                StationReturn.Message = e.Message;
                StationReturn.MessagePara.Add(e.Message);
                StationReturn.MessageCode = "MES00000023";
                StationReturn.Status      = StationReturnStatusValue.Fail;
            }
        }