C# (CSharp) Row_C_AQLTYPE.GetDeleteString示例

示例#1

        public void DeleteCAqltype(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
        {
            T_C_AQLTYPE cAqultype = null;
            OleExec     sfcdb     = null;

            try
            {
                sfcdb     = this.DBPools["SFCDB"].Borrow();
                cAqultype = new T_C_AQLTYPE(sfcdb, DB_TYPE_ENUM.Oracle);

                Row_C_AQLTYPE r      = (Row_C_AQLTYPE)cAqultype.GetObjByID((Data["ID"].ToString()).Trim(), sfcdb);
                string        strRet = sfcdb.ExecSQL(r.GetDeleteString(DB_TYPE_ENUM.Oracle));
                if (Convert.ToInt32(strRet) > 0)
                {
                    StationReturn.Message = "刪除成功！！";
                    StationReturn.Status  = StationReturnStatusValue.Pass;
                    StationReturn.Data    = "";
                }
                else
                {
                    StationReturn.MessageCode = "MES00000036";
                    StationReturn.Status      = StationReturnStatusValue.Fail;
                    StationReturn.Data        = "";
                }
                this.DBPools["SFCDB"].Return(sfcdb);
            }
            catch (Exception e)
            {
                this.DBPools["SFCDB"].Return(sfcdb);
                throw e;
            }
        }