public JsonResult GetDefectItemList(string code, string ProId, string RankId)
{
DataSet ds = new DataSet();
paras.Clear();
paras.Add(new SQLParameter {
DbType = DbType.String, Name = "@SegmentId", Value = ProId
});
paras.Add(new SQLParameter {
DbType = DbType.String, Name = "@RankId", Value = RankId
});
SrvProxy.CreateServices <ISqlCommandConfigService>().Query(code, paras, out ds);
if (ds == null || ds.Tables.Count == 0)
{
return(null);
}
return(JsonSMES(ds.Tables[0]));
}
public JsonResult QueryZsBreakMaterial(string code, string startdt, string enddt)
{
DataSet ds = new DataSet();
paras.Clear();
paras.Add(new SQLParameter {
DbType = DbType.String, Name = ":stardate", Value = startdt
});
paras.Add(new SQLParameter {
DbType = DbType.String, Name = ":enddate", Value = enddt
});
SrvProxy.CreateServices <ISqlCommandConfigService>().Query(code, paras, out ds);
if (ds == null || ds.Tables.Count == 0)
{
return(null);
}
return(JsonSMES(ds.Tables[0]));
}
/// <summary>
/// 根据sql脚本记录的code码查询业务数据
/// </summary>
/// <param name="code">脚本记录code</param>
/// <param name="paralist">参数列表</param>
/// <returns></returns>
public SMESJsonResult QueryDatasByCd(string code, List <SQLParameter> paralist)
{
try
{
DataSet ds = new DataSet();
DataTable dt;
SrvProxy.CreateServices <ISqlCommandConfigService>().Query(code, paralist, out ds);
if (ds == null || ds.Tables.Count == 0)
{
dt = null;
}
else
{
dt = ds.Tables[0];
}
return(JsonSMES(dt));
}
catch (Exception ex)
{
throw ex;
}
}
public JsonResult GetJbKtData(string code, string ParamId, string startdt, string enddt)
{
DataSet ds = new DataSet();
paras.Clear();
//893955, 911141
paras.Add(new SQLParameter {
DbType = DbType.Int32, Name = ":Paraid", Value = ParamId
});
paras.Add(new SQLParameter {
DbType = DbType.String, Name = ":Startdt", Value = startdt
});
paras.Add(new SQLParameter {
DbType = DbType.String, Name = ":Enddt", Value = enddt
});
SrvProxy.CreateServices <ISqlCommandConfigService>().Query(code, paras, out ds);
if (ds == null || ds.Tables.Count == 0)
{
return(null);
}
return(JsonSMES(ds.Tables[0]));
}
/// <summary>
/// 卷包条盒消耗
/// </summary>
/// <returns></returns>
public JsonResult GetMonth_TiaoH()
{
DataTable dt = SrvProxy.CreateServices <IJBCJ_JBConsumeKB>().Query_TiaoHConsume();
return(JsonSMES(dt));
}
/// <summary>
/// 当月班组质量对比
/// </summary>
/// <returns></returns>
public JsonResult getData_Team(string DJ)
{
DataTable dt = SrvProxy.CreateServices <IJBCJ_JBQuaFXKB>().getData_Team(DJ);
return(JsonSMES(dt));
}
public SMESJsonResult GetMaterialTransferinoutsilo(string id, int typeid)
{
DataTable dt = SrvProxy.CreateServices <ICutProduceAncestry>().GetMaterialTransferinoutsilo(id, typeid);
return(JsonSMES(dt));
}
/// <summary>
/// 当前设备有效作业率
/// </summary>
/// <returns></returns>
public JsonResult Equ_Efficiency()
{
DataTable dt = SrvProxy.CreateServices <IJBCJ_JBTotalKB>().Equ_Efficiency();
return(JsonSMES(dt));
}
public SMESJsonResult GetCutAncestryKeyParamData(string id)
{
DataTable dt = SrvProxy.CreateServices <ICutProduceAncestry>().GetCutAncestryKeyParamData(id);
return(JsonSMES(dt));
}
public SMESJsonResult QueryStoreInfoByType(int typeid)
{
DataTable dt = SrvProxy.CreateServices <ITsStockService>().QueryStoreInfoByType(typeid);
return(JsonSMES(dt));
}
/// <summary>
/// 温湿度 最大值、最小值、平均值、合格率
/// </summary>
/// <returns></returns>
public JsonResult DLCJ_WS(string ID)
{
DataTable dt = SrvProxy.CreateServices <IDLCJ_NYKB>().DLCJ_WS(ID);
return(JsonSMES(dt));
}
/// <summary>
/// 当前班次班组及其日产量
/// </summary>
/// <returns></returns>
public JsonResult Shift_Team_Prdouct()
{
DataTable dt = SrvProxy.CreateServices <IFL_JBProduce>().Shift_Team_Prdouct();
return(JsonSMES(dt));
}
public JsonResult GetEqusOutputRankingList(string code1, string EquTypeNm, string code2, string StartDate, string EndDate)
{
DataSet ds1 = new DataSet();
paras.Clear();
paras.Add(new SQLParameter {
DbType = DbType.String, Name = "@TypeName", Value = EquTypeNm
});
SrvProxy.CreateServices <ISqlCommandConfigService>().Query(code1, paras, out ds1);
if (ds1 == null || ds1.Tables.Count == 0)
{
return(null);
}
DataTable dt = ds1.Tables[0];
paras.Clear();
DataTable resultDt = new DataTable();
resultDt.Columns.Add("EquModelNm", typeof(string));
resultDt.Columns.Add("StartFirst", typeof(string));
resultDt.Columns.Add("StartSecond", typeof(string));
resultDt.Columns.Add("StartThird", typeof(string));
resultDt.Columns.Add("StartFourth", typeof(string));
resultDt.Columns.Add("StartFifty", typeof(string));
resultDt.Columns.Add("EndFirst", typeof(string));
resultDt.Columns.Add("EndSecond", typeof(string));
resultDt.Columns.Add("EndThird", typeof(string));
resultDt.Columns.Add("EndtFourth", typeof(string));
resultDt.Columns.Add("EndFifty", typeof(string));
resultDt.Columns.Add("StartFirstQTY", typeof(string));
resultDt.Columns.Add("StartSecondQTY", typeof(string));
resultDt.Columns.Add("StartThirdQTY", typeof(string));
resultDt.Columns.Add("StartFourthQTY", typeof(string));
resultDt.Columns.Add("StartFiftyQTY", typeof(string));
resultDt.Columns.Add("EndFirstQTY", typeof(string));
resultDt.Columns.Add("EndSecondQTY", typeof(string));
resultDt.Columns.Add("EndThirdQTY", typeof(string));
resultDt.Columns.Add("EndtFourthQTY", typeof(string));
resultDt.Columns.Add("EndFiftyQTY", typeof(string));
if (dt == null || dt.Rows.Count == 0)
{
return(JsonSMES(resultDt));
}
for (int a = 0; a < dt.Rows.Count; a++)
{
string[,] rangeList = new string[5, 4];
for (int i = 0; i < 5; i++)
{
for (int j = 0; j < 4; j++)
{
rangeList[i, j] = "";
}
}
DataSet ds = new DataSet();
paras.Add(new SQLParameter {
DbType = DbType.Int32, Name = "@EquModelId", Value = Convert.ToInt32(dt.Rows[a]["ID"])
});
paras.Add(new SQLParameter {
DbType = DbType.String, Name = "@StartDate", Value = StartDate
});
paras.Add(new SQLParameter {
DbType = DbType.String, Name = "@EndDate", Value = EndDate
});
SrvProxy.CreateServices <ISqlCommandConfigService>().Query(code2, paras, out ds);
paras.Clear();
if (ds != null && ds.Tables.Count > 0)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
if (ds.Tables[0].Rows.Count == 0)
{
resultDt.Rows.Add(resultDt.NewRow());
}
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (!dic.Keys.Contains(dt.Rows[a]["NAME"].ToString()))
{
dic.Add(dt.Rows[a]["NAME"].ToString(), dt.Rows[a]["NAME"].ToString());
DataRow drnew = resultDt.NewRow();
drnew[0] = dt.Rows[a]["NAME"].ToString();
DataRow[] drs = ds.Tables[0].Select("", " TOTAL desc,SHORTNAME asc");
int countQ = 5;
int countH = 5;
int countall = drs.Count();
if (countall < 10)
{
countQ = int.Parse(Math.Ceiling(countall / 2.0).ToString());
countH = int.Parse(Math.Floor(countall / 2.0).ToString());
}
for (int i = 0; i < countQ; i++)
{//前五
drnew[i + 1] = drs[i]["SHORTNAME"].ToString();
//if (EquTypeNm == "%包装机%")
//{
drnew[i + 11] = Math.Round(decimal.Parse(drs[i]["TOTAL"].ToString()), 0, MidpointRounding.AwayFromZero);
//}
//else
//{
// drnew[i + 11] = Math.Round(decimal.Parse(drs[i]["TOTAL"].ToString()), 2, MidpointRounding.AwayFromZero);
//}
}
DataRow[] drsh = ds.Tables[0].Select("", " TOTAL asc,SHORTNAME desc");
for (int i = 0; i < countH; i++)
{//后五
drnew[i + 6] = drsh[i]["SHORTNAME"].ToString();
//if (EquTypeNm == "%包装机%")
//{
drnew[i + 16] = Math.Round(decimal.Parse(drsh[i]["TOTAL"].ToString()), 0, MidpointRounding.AwayFromZero);
//}
//else
//{
// drnew[i + 16] = Math.Round(decimal.Parse(drsh[i]["TOTAL"].ToString()), 2, MidpointRounding.AwayFromZero);
//}
}
resultDt.Rows.Add(drnew);
}
}
}
}
return(JsonSMES(resultDt));
}
public SMESJsonResult QueryFeedWoInfo(string plancode, string teamid, string plandate, string feedwo)
{
DataTable dt = SrvProxy.CreateServices <ICutProduceAncestry>().QueryFeedWoInfo(plancode, teamid, plandate, feedwo);
return(JsonSMES(dt));
}
public SMESJsonResult QueryEQUInfo(string plancode, string teamid, string plandate, int typeid, string pronm)
{
DataTable dt = SrvProxy.CreateServices <ICutProduceAncestry>().QueryEQUInfo(plancode, teamid, plandate, typeid, pronm);
return(JsonSMES(dt));
}
public SMESJsonResult QueryWorkOrderOutPut(string batchid)
{
DataTable dt = SrvProxy.CreateServices <ICutProduceAncestry>().QueryWorkOrderOutPut(batchid);
return(JsonSMES(dt));
}
public SMESJsonResult GetAllWorkorderPramQL(string woid)
{
DataTable dt = SrvProxy.CreateServices <ICutProduceAncestry>().GetCutWorkOrderAllProductPramQL(woid);
return(JsonSMES(dt));
}
/// <summary>
/// 获取合格率
/// </summary>
/// <param name="strCon"></param>
/// <returns></returns>
public JsonResult GetQua(string strCon)
{
DataTable dt = SrvProxy.CreateServices <IFL_CutQua>().QueryQua(strCon);
return(JsonSMES(dt));
}
/// <summary>
/// 能源区域 YM
/// </summary>
/// <returns></returns>
public JsonResult DLCJ_NYJS_1()
{
DataTable dt = SrvProxy.CreateServices <IDLCJ_NYKB>().DLCJ_NYJS_1();
return(JsonSMES(dt));
}
/// <summary>
/// 当班机台产量
/// </summary>
/// <returns></returns>
public JsonResult Team_Equ_Product()
{
DataTable dt = SrvProxy.CreateServices <IJBCJ_JBProductKB>().Team_Equ_Product();
return(JsonSMES(dt));
}
public SMESJsonResult QueryStoreType()
{
DataTable dt = SrvProxy.CreateServices <ITsStockService>().QueryStoreType();
return(JsonSMES(dt));
}
/// <summary>
/// 当月质量缺陷
/// </summary>
/// <returns></returns>
public JsonResult Month_Qua_QX()
{
DataTable dt = SrvProxy.CreateServices <IJBCJ_JBTotalKB>().Month_Qua_QX();
return(JsonSMES(dt));
}
public JsonResult GetEqusOutputRankingList(string code1, string EquTypeNm, string code2, string StartDate, string EndDate)
{
DataSet ds1 = new DataSet();
paras.Clear();
paras.Add(new SQLParameter {
DbType = DbType.String, Name = "@TypeName", Value = EquTypeNm
});
SrvProxy.CreateServices <ISqlCommandConfigService>().Query(code1, paras, out ds1);
if (ds1 == null || ds1.Tables.Count == 0)
{
return(null);
}
DataTable dt = ds1.Tables[0];
paras.Clear();
DataTable resultDt = new DataTable();
resultDt.Columns.Add("EquModelNm", typeof(string));
resultDt.Columns.Add("StartFirst", typeof(string));
resultDt.Columns.Add("StartSecond", typeof(string));
resultDt.Columns.Add("StartThird", typeof(string));
resultDt.Columns.Add("StartFourth", typeof(string));
resultDt.Columns.Add("StartFifty", typeof(string));
resultDt.Columns.Add("EndFirst", typeof(string));
resultDt.Columns.Add("EndSecond", typeof(string));
resultDt.Columns.Add("EndThird", typeof(string));
resultDt.Columns.Add("EndtFourth", typeof(string));
resultDt.Columns.Add("EndFifty", typeof(string));
if (dt == null || dt.Rows.Count == 0)
{
return(JsonSMES(resultDt));
}
for (int a = 0; a < dt.Rows.Count; a++)
{
string[,] rangeList = new string[5, 2];
for (int i = 0; i < 5; i++)
{
for (int j = 0; j < 2; j++)
{
rangeList[i, j] = "";
}
}
DataSet ds = new DataSet();
paras.Add(new SQLParameter {
DbType = DbType.Int32, Name = "@EquModelId", Value = Convert.ToInt32(dt.Rows[a]["ID"])
});
paras.Add(new SQLParameter {
DbType = DbType.String, Name = "@StartDate", Value = StartDate
});
paras.Add(new SQLParameter {
DbType = DbType.String, Name = "@EndDate", Value = EndDate
});
SrvProxy.CreateServices <ISqlCommandConfigService>().Query(code2, paras, out ds);
paras.Clear();
if (ds != null && ds.Tables.Count > 0)
{
int rows = ds.Tables[0].Rows.Count;
DataRow dr = resultDt.NewRow();
for (int i = 0; i < rows / 2 && i < 5 && i < rows - i - 1; i++)
{
rangeList[i, 0] = ds.Tables[0].Rows[i]["SHORTNAME"].ToString();
rangeList[i, 1] = ds.Tables[0].Rows[rows - i - 1]["SHORTNAME"].ToString();
}
dr["EquModelNm"] = dt.Rows[a]["NAME"].ToString();
dr["StartFirst"] = rangeList[0, 0];
dr["EndFirst"] = rangeList[0, 1];
dr["StartSecond"] = rangeList[1, 0];
dr["EndSecond"] = rangeList[1, 1];
dr["StartThird"] = rangeList[2, 0];
dr["EndThird"] = rangeList[2, 1];
dr["StartFourth"] = rangeList[3, 0];
dr["EndtFourth"] = rangeList[3, 1];
dr["StartFifty"] = rangeList[4, 0];
dr["EndFifty"] = rangeList[4, 1];
resultDt.Rows.Add(dr);
}
}
return(JsonSMES(resultDt));
}
public SMESJsonResult GetCutWorkorderConsume(string id)
{
DataTable dt = SrvProxy.CreateServices <ICutProduceAncestry>().GetCutWorkorderConsume(id);
return(JsonSMES(dt));
}
/// <summary>
/// 当月产量、计划量
/// </summary>
/// <returns></returns>
public JsonResult Month_Prdouct()
{
DataTable dt = SrvProxy.CreateServices <IJBCJ_JBProductKB>().Month_Prdouct();
return(JsonSMES(dt));
}
//年度停机趋势图
public JsonResult JBCJ_Year()
{
DataTable dt = SrvProxy.CreateServices <IJBCJ_EquStop>().JBCJ_Year();
return(JsonSMES(dt));
}
/// <summary>
/// 当日车间精品率
/// </summary>
/// <returns></returns>
public JsonResult Day_Rate()
{
DataTable dt = SrvProxy.CreateServices <IJBCJ_JBTotalKB>().Day_Rate();
return(JsonSMES(dt));
}
/// <summary>
/// 月度停机趋势图
/// </summary>
/// <returns></returns>
public JsonResult JBCJ_Month(string DATE)
{
DataTable dt = SrvProxy.CreateServices <IJBCJ_EquStop>().JBCJ_Month(DATE);
return(JsonSMES(dt));
}
/// <summary>
/// 年度产量对比
/// </summary>
/// <returns></returns>
public JsonResult Year_Product()
{
DataTable dt = SrvProxy.CreateServices <IJBCJ_JBTotalKB>().Year_Product();
return(JsonSMES(dt));
}
/// <summary>
/// 天度停机次数统计图
/// </summary>
/// <param name="CODE"></param>
/// <param name="DATE"></param>
/// <returns></returns>
public JsonResult JBCJ_JT_Day(string CODE, string DATE)
{
DataTable dt = SrvProxy.CreateServices <IJBCJ_EquStop>().JBCJ_JT_Day(CODE, DATE);
return(JsonSMES(dt));
}
