using Dapper;
|
using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Data.SqlClient;
|
using System.Linq;
|
using System.Threading.Tasks;
|
using VueWebCoreApi.Models;
|
using VueWebCoreApi.Tools;
|
|
namespace VueWebCoreApi.DLL.DAL
|
{
|
public class HomeIndexDAL
|
{
|
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 HomeIndexTopSearch(string paydatestartdate, string paydateenddate, User us)
|
{
|
var dynamicParams = new DynamicParameters();
|
string sql = "";
|
try
|
{
|
sql = @"h_p_HomeIndexTopGetSum";
|
dynamicParams.Add("@StartTime", paydatestartdate + " 00:00:00");
|
dynamicParams.Add("@EndTime", paydateenddate + " 23:59:59");
|
var dt = DapperHelper.selectProcedure(sql, dynamicParams);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.count = dt.Rows.Count;
|
mes.data = dt;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region[首页中间工序完成进度,不良品排行]
|
public static ToMessage HomeIndexCenterLeftSearch(string paydatestartdate, string paydateenddate, User us)
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
Dictionary<object, object> dir = new Dictionary<object, object>();
|
try
|
{
|
//工序完成进度
|
sql = @"h_p_HomeIndexCenterLeftGetSum";
|
dynamicParams.Add("@StartTime", paydatestartdate + " 00:00:00");
|
dynamicParams.Add("@EndTime", paydateenddate + " 23:59:59");
|
var dt = DapperHelper.selectProcedure(sql, dynamicParams);
|
dir.Add("CenterLeft", dt);
|
|
//不良排名
|
sql = @"h_p_HomeIndexCenterRightGetSum";
|
dynamicParams.Add("@StartTime", paydatestartdate + " 00:00:00");
|
dynamicParams.Add("@EndTime", paydateenddate + " 23:59:59");
|
var dt1 = DapperHelper.selectProcedure(sql, dynamicParams);
|
dir.Add("CenterRight", dt1);
|
|
|
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 HomeIndexCenterRightSearch(string paydatestartdate, string paydateenddate, string defect_code, User us)
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
Dictionary<object, object> dir = new Dictionary<object, object>();
|
try
|
{
|
//不良排名明细
|
sql = @"h_p_HomeIndexCenterRightGetSubSum";
|
dynamicParams.Add("@Defect_code", defect_code);
|
dynamicParams.Add("@StartTime", paydatestartdate + " 00:00:00");
|
dynamicParams.Add("@EndTime", paydateenddate + " 23:59:59");
|
dt = DapperHelper.selectProcedure(sql, dynamicParams);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = dt;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region[首页中间工序完成进度物料明细]
|
public static ToMessage HomeIndexCenterLeftSubSearch(string stepcode, string type, string paydatestartdate, string paydateenddate, User us)
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
DataTable dt = new DataTable();
|
try
|
{
|
sql = @"h_p_HomeIndexCenterLeftLeftSubSum";
|
dynamicParams.Add("@Stepcode", stepcode);
|
dynamicParams.Add("@Stype", type);
|
dynamicParams.Add("@StartTime", paydatestartdate + " 00:00:00");
|
dynamicParams.Add("@EndTime", paydateenddate + " 23:59:59");
|
dt = DapperHelper.selectProcedure(sql, dynamicParams);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = dt;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region[首页中下销售信息]
|
public static ToMessage HomeIndexCenterSaOrderSearch(string type, string paydatestartdate, string paydateenddate, User us)
|
{
|
var sql = "";
|
var dynamicParams = new DynamicParameters();
|
DataTable dt = new DataTable();
|
try
|
{
|
sql = @"h_p_HomeIndexCenterSaOrderSum";
|
dynamicParams.Add("@Stype", type);
|
dynamicParams.Add("@StartTime", paydatestartdate + " 00:00:00");
|
dynamicParams.Add("@EndTime", paydateenddate + " 23:59:59");
|
dt = DapperHelper.selectProcedure(sql, dynamicParams);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = dt;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
|
#region[首页底部库存信息]
|
public static ToMessage HomeIndexBottomSearch(User us)
|
{
|
var dynamicParams = new DynamicParameters();
|
Dictionary<object, object> dir = new Dictionary<object, object>();
|
string sql = "";
|
try
|
{
|
//毛坯库存
|
sql = @"h_p_HomeIndexBottomOneGetSum";
|
DataTable dt = DapperHelper.IsProcedureNoData(sql);
|
dir.Add("BottomOne", dt);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.count = dir.Count;
|
mes.data = dir;
|
|
//产成品库存
|
sql = @"h_p_HomeIndexBottomTwoGetSum";
|
DataTable dt1 = DapperHelper.IsProcedureNoData(sql);
|
dir.Add("BottomTwo", dt1);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.count = dir.Count;
|
mes.data = dir;
|
|
|
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
}
|
}
|
