using Dapper;
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Linq;
|
using System.Threading.Tasks;
|
using VueWebCoreApi.Tools;
|
|
namespace VueWebCoreApi.DLL.DAL
|
{
|
public class KanBanManagerentDAL
|
{
|
public static ToMessage mes = new ToMessage(); //定义全局返回信息对象
|
|
#region[车间看板,上生产信息]
|
public static ToMessage WorkShopProduceTopData()
|
{
|
string sql = "";
|
try
|
{
|
sql = @"select * from h_v_JLKanBan_WorkshopTop";
|
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 WorkShopProduceBottomLeftData()
|
{
|
string sql = "";
|
Dictionary<object, object> dir = new Dictionary<object, object>();
|
try
|
{
|
sql = @"h_p_JLKanBan_WorkshopBottomLeft";
|
var data = DapperHelper.lissql(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 WorkShopProduceBottomRightData()
|
{
|
string sql = "";
|
try
|
{
|
sql = @"select * from h_v_JLKanBan_WorkshopBottomRight";
|
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 WorkShopCompreLeftTop()
|
{
|
var sql = "";
|
Dictionary<object, object> dir = new Dictionary<object, object>();
|
try
|
{
|
sql = @"select * from h_v_JLKanBan_WorkShopCompreLeftTop";
|
var data = DapperHelper.selecttable(sql);
|
sql = @"select * from h_v_JLKanBan_WorkShopCompreLeftCenter";
|
var data1 = DapperHelper.selecttable(sql);
|
dir.Add("LeftTop", data);
|
dir.Add("LeftBottom", data1);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = dir;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region[车间综合看板,右上销售订单]
|
public static ToMessage WorkShopCompreRightTop()
|
{
|
var sql = "";
|
Dictionary<object, object> dir = new Dictionary<object, object>();
|
try
|
{
|
sql = @"select * from h_v_JLKanBan_WorkShopCompreRightTop";
|
var data = DapperHelper.selecttable(sql);
|
sql = @"select * from h_v_JLKanBan_WorkShopCompreRightCenter";
|
var data1 = DapperHelper.selecttable(sql);
|
dir.Add("RightTop", data);
|
dir.Add("RightBottom", data1);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = dir;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region[车间综合看板,右下库存]
|
public static ToMessage WorkShopCompreRightBottom()
|
{
|
var sql = "";
|
Dictionary<object, object> dir = new Dictionary<object, object>();
|
try
|
{
|
//存储过程名
|
sql = @"h_p_IFCLD_StockInventory";
|
var data = DapperHelper.lissql(sql);
|
if (data.Rows.Count > 0)
|
{
|
// 使用Lambda表达式对qty列进行汇总，并通过type列分组
|
var groupedData = data.AsEnumerable()
|
.GroupBy(row => row.Field<string>("FErpCls"))
|
.Select(group => new
|
{
|
Type = group.Key,
|
Qty = group.Sum(row => row.Field<decimal>("FCUUQty"))
|
}).ToList();
|
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = groupedData;
|
}
|
else
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = "暂无库存信息!";
|
mes.data = null;
|
}
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
|
|
#region[仓库看板,左上产品待入库列表]
|
public static ToMessage WareHouseTopLeftData()
|
{
|
string sql = "";
|
try
|
{
|
//获取仓库生产加工单待入库列表
|
sql = @"select * from h_v_MHKanBan_WareHouseTopLeft order by voucherdate";
|
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 WareHouseTopBottomData()
|
{
|
string sql = "";
|
try
|
{
|
//获取仓库销售订单产品待发货列表
|
sql = @"select * from h_v_MHKanBan_WareHouseTopBottom order by voucherdate";
|
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 WareHouseRightTopData()
|
{
|
string sql = "";
|
try
|
{
|
sql = @"h_p_IFCLD_SumStockInventory";
|
var data = DapperHelper.lissql(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
|
|
|
}
|
}
|
