JCApi.git - Gitblit

			@@ -12,7 +12,7 @@
			{
			public static ToMessage mes = new ToMessage(); //定义全局返回信息对象

			#region[车间看板,上生产信息]
			#region[嘉驰车间看板,上生产信息]
			public static ToMessage WorkShopProduceTopData(string wkshopcode)
			{
			string sql = "";
			@@ -38,7 +38,7 @@
			}
			#endregion

			#region[车间看板,下左近一周不良趋势]
			#region[嘉驰车间看板,下左近一周不良趋势]
			public static ToMessage WorkShopProduceBottomLeftData(string wkshopcode)
			{
			string sql = "";
			@@ -71,7 +71,7 @@
			}
			#endregion

			#region[车间看板,下右近一月不良统计]
			#region[嘉驰车间看板,下右近一月不良统计]
			public static ToMessage WorkShopProduceBottomRightData(string wkshopcode)
			{
			string sql = "";
			@@ -331,5 +331,99 @@
			return mes;
			}
			#endregion



			#region[嘉驰仓库看板左上,采购待入库]
			public static ToMessage ProcureOutsourcLeftTop()
			{
			var sql = "";
			try
			{
			sql = @"select * from h_v_JCKanBan_ProcureNotReceived";
			var data = DapperHelper.selecttable(sql);
			mes.code = "200";
			mes.message = "查询成功!";
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion

			#region[嘉驰仓库看板左下,产品代发货]
			public static ToMessage ProductConsignmentLeftBottom()
			{
			var sql = "";
			try
			{
			sql = @"select * from h_v_JCKanBan_ProductionNotDeliver";
			var data = DapperHelper.selecttable(sql);
			mes.code = "200";
			mes.message = "查询成功!";
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion

			#region[嘉驰仓库看板右上,近一周采购待入库物料排行TOP5]
			public static ToMessage ProcureOutsourcRightTop()
			{
			var sql = "";
			try
			{
			sql = @"select * from h_v_JCKanBan_ProcureNotReceivedSumTop";
			var data = DapperHelper.selecttable(sql);
			mes.code = "200";
			mes.message = "查询成功!";
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion

			#region[嘉驰仓库看板右下,近一周销售待发货产品排行TOP5]
			public static ToMessage ProductionStockedInRightBottom()
			{
			var sql = "";
			try
			{
			sql = @"select * from h_v_JCKanBan_ProductionNotDeliverSumTop";
			var data = DapperHelper.selecttable(sql);
			mes.code = "200";
			mes.message = "查询成功!";
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion
			}
			}