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)); }