MES-WEB-API.git

			@@ -61,12 +61,26 @@
			columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//获取到DataColumn列对象的列名
			}

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucess！";
			objJsonResult.data = ds.Tables[0];
			objJsonResult.list = columnNameList;
			return objJsonResult;
			if (ds.Tables[0].Rows.Count > 0 && ds != null)
			{
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucess！";
			objJsonResult.data = ds.Tables[0];
			objJsonResult.list = columnNameList;
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "没有查询到部门数据，请联系系统管理员进行核对";
			objJsonResult.data = ds.Tables[0];
			objJsonResult.list = columnNameList;
			return objJsonResult;
			}


			}
			catch (Exception e)
			{
			@@ -769,11 +783,11 @@
			oCN.RunProc("Insert Into Gy_Department " +
			"(HItemID,HNumber,HShortNumber,HName,HParentID" +
			",HLevel,HEndFlag,HRemark,HStopFlag,HUseFlag" +
			",HCREATEORGID,HUSEORGID"+
			",HCREATEORGID,HUSEORGID,HERPItemID" +
			") " +
			" values('" + lsmain[0].HItemID + "','" + lsmain[0].HNumber + "','" + lsmain[0].HShortNumber + "','" + lsmain[0].HName + "',0" +
			",'',0,'" + lsmain[0].HRemark + "',0,''" +
			"," + lsmain[0].HCreateOrgID + "," + lsmain[0].HUseOrgID + "" +
			"," + lsmain[0].HCreateOrgID + "," + lsmain[0].HUseOrgID + "," + lsmain[0].HItemID +
			") ");
			sql = "set identity_insert Gy_Department off";
			oCN.RunProc(sql);
			@@ -929,7 +943,7 @@
			,HLevel,HEndFlag,HStopflag,HRemark,HUseFlag,HMakeTime,HCREATEORGID,HUSEORGID
			)
			values
			({jsonData.HItemID},{jsonData.HERPItemID},'{jsonData.HNumber}','{jsonData.HName}',
			({jsonData.HItemID},{jsonData.HItemID},'{jsonData.HNumber}','{jsonData.HName}',
			'{jsonData.HShortNumber}',{jsonData.HParentID},{jsonData.HLevel},{jsonData.HEndFlag},{jsonData.HStopflag},'{jsonData.HRemark}','{jsonData.HUseFlag}','{jsonData.HMakeTime}',{jsonData.HCREATEORGID},{jsonData.HUSEORGID})";

			oCN.RunProc(sql);