新增模具管理文件夹 一个控制器

ch

2021-03-25 aae6a1a9df5b1860513f6caadc8cfd7d854c2862

 WebAPI/Controllers/WebAPIController.cs

@@ -329,6 +329,33 @@
        }


        //删除表记录
        [Route("Web/Delete_Table")]
        [HttpGet]
        public object Delete_Table(string sqlStr)
        {
            try
            {
                //SQLHelper oCn;
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                oCN.RunProc(sqlStr);
                objJsonResult.code = "0";
                objJsonResult.count = 1;
                objJsonResult.Message = "删除成功！";
                objJsonResult.data = null;
                return objJsonResult;
            }
            catch (Exception)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "删除失败！异常";
                objJsonResult.data = null;
                return objJsonResult;
            }

        }

        #region 基础资料
        /// <summary>
        /// 获取仓库列表
@@ -721,6 +748,37 @@
                return objjson;
            }
        }

        /// <summary>
        /// 获取当前数据库名
        /// </summary>
        /// <returns></returns>
        [Route("Web/GetDataBases")]
        [HttpGet]
        public object GetDataBases()
        {
            try
            {
                ClsCN oCn = new ClsCN();
                DataSet oDs = new DataSet();
                //==========
                oDs = oCn.RunProcReturn("Select Name From Master..SysDataBases Where DbId=(Select Dbid From Master..SysProcesses Where Spid = @@spid)", "SysDataBases");
                objjson.code = "1";
                objjson.count = 1;
                objjson.Message = "获取成功！";
                objjson.data = oDs.Tables[0];
                return objjson; ;
            }
            catch (Exception e)
            {

                objjson.code = "0";
                objjson.count = 0;
                objjson.Message = "获取失败！异常" + e.ToString();
                objjson.data = null;
                return objjson; ;
            }
        }
        #endregion
    }