1

王 垚

2022-09-28 3f10dfbf0e3ae11fb115dbcf50d60d84af9697ef

 WebAPI/Controllers/WebAPIController.cs

@@ -631,6 +631,45 @@
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                //ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName  from h_v_IF_Group where HStopflag=0 " + sWhere + " Order by HItemID ", "h_v_IF_Group");
                ds = oCN.RunProcReturn("Select HItemID,HNumber 班组代码,HName 班组 from h_v_IF_Group where HStopflag=0 " + sWhere + " Order by HItemID ", "h_v_IF_Group");
                if (ds == null || ds.Tables[0].Rows.Count <= 0)
                {
                    objjson.code = "0";
                    objjson.count = 0;
                    objjson.Message = "获取失败";
                    objjson.data = null;
                    return objjson;
                }
                else
                {
                    objjson.code = "0";
                    objjson.count = 1;
                    objjson.Message = "获取成功!";
                    objjson.data = ds.Tables[0];
                    return objjson;
                }
            }
            catch (Exception e)
            {

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

        [Route("Web/GetGroupList_Json")]
        [HttpGet]

        public object GetGroupList_Json(string sWhere)
        {
            DataSet ds;
            try
            {
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName  from h_v_IF_Group where HStopflag=0 " + sWhere + " Order by HItemID ", "h_v_IF_Group");
                if (ds == null || ds.Tables[0].Rows.Count <= 0)
                {