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 AppAnalyticsDAL
|
{
|
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[App生产看板]
|
public static ToMessage ProductionKanban(User us, string startopendate, string endclosedate, string defecttype)
|
{
|
Dictionary<object, object> dList = new Dictionary<object, object>();
|
var dynamicParams = new DynamicParameters();
|
string search = "", torg_codelist = "", sql = "";
|
try
|
{
|
//获取当前用户所属组织及所有子节点组织
|
mes = TOrganizationRecursion.TOrgCodeSeach("SCB");
|
if (mes.code == "300")
|
{
|
return mes;
|
}
|
else
|
{
|
torg_codelist = mes.data.ToString(); //获取组织集合
|
}
|
// --------------生产总览--------------
|
string[] torglist = Array.ConvertAll<string, string>(torg_codelist.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), s => s.ToString()); //string分割转string[]
|
//存储过程名
|
// --------------查询工单任务数、报工数、计算工资收入--------------
|
sql = @"h_p_JLApp_ProductAnalysisTop";
|
dynamicParams.Add("@torglist", mes.data.ToString());
|
dynamicParams.Add("@startopendate", startopendate + " 00:00:00");
|
dynamicParams.Add("@endclosedate", endclosedate + " 23:59:59");
|
var data0 = DapperHelper.selectProcedure(sql, dynamicParams);
|
dList.Add("dt0", data0);
|
// --------------生产工单--------------
|
sql = @"h_p_JLApp_ProductAnalysisCenter";
|
dynamicParams.Add("@torglist", mes.data.ToString());
|
dynamicParams.Add("@startopendate", startopendate + " 00:00:00");
|
dynamicParams.Add("@endclosedate", endclosedate + " 23:59:59");
|
var data1 = DapperHelper.selectProcedure(sql, dynamicParams);
|
dList.Add("dt1", data1);
|
// --------------缺陷统计--------------
|
sql = @"h_p_JLApp_ProductAnalysisBottom";
|
dynamicParams.Add("@compute", defecttype);
|
dynamicParams.Add("@torglist", mes.data.ToString());
|
dynamicParams.Add("@startopendate", startopendate + " 00:00:00");
|
dynamicParams.Add("@endclosedate", endclosedate + " 23:59:59");
|
var data2 = DapperHelper.selectProcedure(sql, dynamicParams);
|
dList.Add("dt2", data2);
|
mes.code = "200";
|
mes.message = "查询成功!";
|
mes.data = dList;
|
}
|
catch (Exception e)
|
{
|
mes.code = "300";
|
mes.count = 0;
|
mes.message = e.Message;
|
mes.data = null;
|
}
|
return mes;
|
}
|
#endregion
|
}
|
}
|
