MES-WEB-API.git

			@@ -3117,7 +3117,7 @@
			}
			string sql = "select * from h_v_Cg_POOrderBillQuerySub where hmainid = "+ hmainid;

			ds = oCN.RunProcReturn(sql + " order by hsubid desc", "h_v_Cg_POOrderBillQuerySub");
			ds = oCN.RunProcReturn(sql + " order by hsubid ASC", "h_v_Cg_POOrderBillQuerySub");


			foreach (DataColumn col in ds.Tables[0].Columns)
			@@ -3202,6 +3202,81 @@
			}
			}
			#endregion

			#region 出库汇总查询
			[Route("Xs_SeOrderOutStockSumReport/Xs_SeOrderOutStockSumReportList")]
			[HttpGet]
			public object Xs_SeOrderOutStockSumReportList(string sWhere)
			{
			try
			{
			//反序列化传递的值

			ds = oCN.RunProcReturn($"exec h_p_Xs_SeOrderOutStockSumReport " + sWhere + "", "h_p_Xs_SeOrderOutStockSumReport");

			List<object> listCol = new List<object>();
			foreach (DataColumn col in ds.Tables[0].Columns)
			{
			Type dataType = col.DataType;
			string str = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
			listCol.Add(JsonConvert.DeserializeObject(str));
			}

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucess！";
			objJsonResult.data = ds.Tables[0];
			objJsonResult.list = listCol;
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			#region 入库汇总查询
			[Route("Cg_PoOrderInStockSumReport/Cg_PoOrderInStockSumReportList")]
			[HttpGet]
			public object Cg_PoOrderInStockSumReportList(string sWhere)
			{
			try
			{
			//反序列化传递的值

			ds = oCN.RunProcReturn($"exec h_p_Cg_PoOrderInStockSumReport " + sWhere + "", "h_p_Cg_PoOrderInStockSumReport");

			List<object> listCol = new List<object>();
			foreach (DataColumn col in ds.Tables[0].Columns)
			{
			Type dataType = col.DataType;
			string str = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
			listCol.Add(JsonConvert.DeserializeObject(str));
			}

			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucess！";
			objJsonResult.data = ds.Tables[0];
			objJsonResult.list = listCol;
			return objJsonResult;
			}
			catch (Exception e)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "Exception！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}
			#endregion

			}

			}