public ChartOption GetCHART(WIPProfileInput input) { var summaryData = _HoldLotInfoRepository.QueryCWIP(input); var percentData1 = _HoldLotInfoRepository.QueryMOVE(input); var percentData2 = _HoldLotInfoRepository.QueryHoldWIP(input); var percentData3 = _HoldLotInfoRepository.QueryRunWIP(input); var percentData4 = _HoldLotInfoRepository.QueryQueueWIP(input); string chartTitle = "WIPProfile Chart"; string firstAxisName = "MOVE QTY"; string secondAxisName = "WIP"; ChartOption optionSummary = percentData1.ToChartOption(ChartType.Line, chartTitle, "", "name", "Series", "value", "", ChartDirection.Vertical, "", firstAxisName); ChartOption addtionOption = summaryData.AddToChartOption(optionSummary, ChartType.Line, "name", "Series", "value", "", "", firstAxisName); ChartOption addtionOption1 = percentData2.AddToChartOption(optionSummary, ChartType.Bar, "name", "Series", "value", "", "", secondAxisName); ChartOption addtionOption2 = percentData3.AddToChartOption(optionSummary, ChartType.Bar, "name", "Series", "value", "", "", secondAxisName); ChartOption addtionOption3 = percentData4.AddToChartOption(optionSummary, ChartType.Bar, "name", "Series", "value", "", "", secondAxisName); addtionOption1.xAxis[0].axisLabel = new AxisLabel() { interval = 0 }; addtionOption1.title.x = "left"; return(addtionOption1); }
public PagedResults GetWIPData(WIPProfileInput input) { string filter = string.Empty; filter = Getfilter(input, "data"); string sql = string.Format(listSQL, filter); return(base.PagingQueryDataTable(sql, input)); }
public string Getfilter(WIPProfileInput input, string flag) { string s1 = "1"; string s2 = "1"; string s3 = "1"; if (flag == "data") { s1 = "fwt.txntimestamp"; s2 = "ProductName"; s3 = "lot.lottype"; } else if (flag == "chart") { s1 = "RECORD_DATE"; s2 = "substr(partid,1,length(partid)-2)"; s3 = "lottype"; } string filter = string.Empty; if (input.IsIncludeEngLots == false) { filter = " AND " + s3 + " = 'P' "; } string filter2 = string.Empty; if (input.Product != null && input.Product.Length > 0) { filter2 = string.Format(" AND " + s2 + " IN ('{0}')", input.Product); } string filter6 = string.Empty; if (input.Stage != null && input.Stage.Length > 0) { filter6 = string.Format(" AND hs.stagename = ('{0}')", input.Stage); } string filter3 = string.Empty; if (flag == "data") { if (input.ByDate == "1") { // System.DateTime currentTime = new System.DateTime(); DateTime dt = DateTime.Now; // DateTime now = DateTime.Now; input.StartTime = dt.ToString(); if (dt.Hour >= 8) { filter3 = " AND to_date(substr( " + s1 + ",0,15),'yyyy-mm-dd hh24:mi:ss') between to_date(substr(:StartTime,1,10) || ' 08:00:00','yyyy-mm-dd hh24:mi:ss') and to_date(:StartTime , 'yyyy-mm-dd hh24:mi:ss') "; } else { filter3 = " AND to_date(substr(" + s1 + ",0,15),'yyyy-mm-dd hh24:mi:ss') between to_date(to_char(:StartTime-1,'yyyy-mm-dd') || ' 08:00:00','yyyy-mm-dd hh24:mi:ss') and to_date(:StartTime , 'yyyy-mm-dd hh24:mi:ss') "; } } else if (input.ByDate == "2") { filter3 = " AND to_date(substr(" + s1 + ",0,15),'yyyy-mm-dd hh24:mi:ss') between to_date(to_char(to_date(:StartTime,'yyyy-mm-dd')-1,'yyyy-mm-dd') || ' 08:00:00','yyyy-mm-dd hh24:mi:ss') and to_date(:StartTime|| ' 08:00:00', 'yyyy-mm-dd hh24:mi:ss')"; } } else if (flag == "chart") { if (input.ByDate == "1") { filter3 = " AND to_date( " + s1 + ",'yyyymmdd') = to_date(replace(:StartTime,'-',''),'yyyymmdd') "; } else if (input.ByDate == "2") { filter3 = " AND to_date( " + s1 + ",'yyyymmdd') = to_date(replace(:StartTime,'-',''),'yyyymmdd') "; } } string sumfilter = filter + filter2 + filter3 + filter6; return(sumfilter); }
public JsonResult QueryChartData(WIPProfileInput input) { return(Json(_WIPProfileLogicLogic.GetCHART(input))); }
public JsonResult QueryWIPData(WIPProfileInput input) { return(JsonForGridPaging(_WIPProfileLogicLogic.QueryWIPData(input))); }
public PagedResults QueryWIPData(WIPProfileInput input) { var pageResults = _HoldLotInfoRepository.GetWIPData(input); return(pageResults); }