using Dapper;
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Data.SqlClient;
|
using System.Linq;
|
using System.Web;
|
using VueWebApi.DDKanBanModel;
|
using VueWebApi.Models;
|
using VueWebApi.Tools;
|
|
namespace VueWebApi.DLL.DAL
|
{
|
public class KanBanManagerentDAL
|
{
|
public static DataTable dt; //定义全局变量dt
|
public static bool res; //定义全局变量dt
|
public static ToMessage mes = new ToMessage(); //定义全局返回信息对象
|
public static string strProcName = ""; //定义全局sql变量
|
public static List<SqlParameter> listStr = new List<SqlParameter>(); //定义全局参数集合
|
public static SqlParameter[] parameters; //定义全局SqlParameter参数数组
|
|
#region[北鸣仓库看板左上,生产待入库]
|
public static ToMessage ProductionStockedInLeftTop()
|
{
|
var sql = "";
|
try
|
{
|
sql = @"select * from h_v_BMKanBan_ProductionNotReceived";
|
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_BMKanBan_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 ProductionStockedInRightTop()
|
{
|
var sql = "";
|
try
|
{
|
sql = @"select * from h_v_BMKanBan_ProductionNotReceivedSumTop";
|
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_BMKanBan_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
|
|
|
|
#region[北鸣采购委外看板左上,采购待入库]
|
public static ToMessage ProcureOutsourcLeftTop()
|
{
|
var sql = "";
|
try
|
{
|
sql = @"select * from h_v_BMKanBan_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 ProcureOutsourcLeftBottom()
|
{
|
var sql = "";
|
try
|
{
|
sql = @"select * from h_v_BMKanBan_OutSourcingNotReceived";
|
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_BMKanBan_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 ProcureOutsourcRightBottom()
|
{
|
var sql = "";
|
try
|
{
|
sql = @"select * from h_v_BMKanBan_OutSourcingNotReceivedSumTop";
|
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
|
}
|
}
|
