public PagedResults GetEQPGroupMoveDetail(EQPGroupPerformanceSubPageInput Input)
{
if (Input.RECORD_DATE != null && Input.RECORD_DATE.Length > 0)
{
string startTime = string.Empty;
string endTime = string.Empty;
startTime = Input.RECORD_DATE + " 080000000";
endTime = DateTime.ParseExact(Input.RECORD_DATE, "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture).AddDays(1).ToString("yyyyMMdd");
endTime = endTime + " 080000000";
filter1 = string.Format("And hs.txntimestamp >= '{0}' AND hs.txntimestamp < '{1}'", startTime, endTime);
}
if (Input.AREA != null && Input.AREA.Length > 0)
{
filter2 = string.Format("And svp.valdata = '{0}' ", Input.AREA);
}
if (Input.CAPABILITY != null && Input.CAPABILITY.Length > 0)
{
filter3 = string.Format("And svn.requiredcapability = '{0}' ", Input.CAPABILITY);
}
if (Input.EQPTYPE != null && Input.EQPTYPE.Length > 0)
{
filter4 = string.Format("And sv.resourcetype = '{0}' ", Input.EQPTYPE);
}
filter = filter1 + filter2 + filter3 + filter4;
sql = string.Format(MoveDetailSQL, filter);
return(base.PagingQueryDataTable(sql, Input));
}
public DataTable QueryEQPGroupAvailInfo(EQPGroupPerformanceSubPageInput Input)
{
if (Input.StartTime != null && Input.StartTime.Length > 0)
{
filter1 = string.Format("AND sum_list.run_day||' 080000000' > '{0}' AND sum_list.run_day||' 080000000' < '{1}' ", Input.StartTime, Input.EndTime);
}
if (Input.AREA != null && Input.AREA.Length > 0)
{
filter2 = string.Format("And eqpext.area = '{0}' ", Input.AREA);
}
if (Input.CAPABILITY != null && Input.CAPABILITY.Length > 0)
{
filter3 = string.Format("And cap.capabilityname = '{0}' ", Input.CAPABILITY);
}
if (Input.EQPTYPE != null && Input.EQPTYPE.Length > 0)
{
filter4 = string.Format("And tp.name = '{0}' ", Input.EQPTYPE);
}
filter = filter1 + filter2 + filter3 + filter4;
sql = string.Format(AvailInfoSQL, filter);
return(base.QueryDataTable(sql, "Summary", Input));
}
public DataTable QueryEQPGroupMoveInfo(EQPGroupPerformanceSubPageInput Input)
{
if (Input.StartTime != null && Input.StartTime.Length > 0)
{
filter1 = string.Format("AND m.txntimestamp > '{0}' AND m.txntimestamp < '{1}' ", Input.StartTime, Input.EndTime);
}
if (Input.AREA != null && Input.AREA.Length > 0)
{
filter2 = string.Format("And m.area = '{0}' ", Input.AREA);
}
if (Input.CAPABILITY != null && Input.CAPABILITY.Length > 0)
{
filter3 = string.Format("And m.capability = '{0}' ", Input.CAPABILITY);
}
if (Input.EQPTYPE != null && Input.EQPTYPE.Length > 0)
{
filter4 = string.Format("And m.eqptype = '{0}' ", Input.EQPTYPE);
}
filter = filter1 + filter2 + filter3 + filter4;
sql = string.Format(MoveInfoSQL, filter);
return(base.QueryDataTable(sql, "Summary", Input));
}
public ChartOption GetEQPGroupWipMoveChart(EQPGroupPerformanceSubPageInput input)
{
input.StartTime = input.StartTime.Replace("-", "").Replace(":", "") + "000";
input.EndTime = input.EndTime.Replace("-", "").Replace(":", "") + "000";
var WipData = _Repository.QueryEQPGroupWipInfo(input);
var MoveData = _Repository.QueryEQPGroupMoveInfo(input);
var percentData = _Repository.QueryEQPGroupAvailInfo(input);
string chartTitle = "EQPGroup WIP & MOVE Chart";
string firstAxisName = "Wafer Qty";
string secondAxisName = "EQP Avail";
ChartOption optionSummary = WipData.ToChartOption(ChartType.Bar, chartTitle, "", "name", "Series", "value", "", ChartDirection.Vertical, "", firstAxisName);
ChartOption addtionOption = MoveData.AddToChartOption(optionSummary, ChartType.Bar, "name", "Series", "value", "", "", firstAxisName);
ChartOption addtionOption1 = percentData.AddToChartOption(addtionOption, ChartType.Line, "name", "Series", "value", "", "", secondAxisName);
addtionOption1.xAxis[0].axisLabel = new AxisLabel()
{
interval = 0
};
addtionOption1.yAxis[1].axisLabel = new AxisLabel()
{
interval = 0
};
addtionOption1.title.x = "left";
return(addtionOption1);
}
public PagedResults GetEQPGroupWipDetail(EQPGroupPerformanceSubPageInput Input)
{
if (Input.AREA != null && Input.AREA.Length > 0)
{
filter2 = string.Format("And svp.valdata = '{0}' ", Input.AREA);
}
if (Input.CAPABILITY != null && Input.CAPABILITY.Length > 0)
{
filter3 = string.Format("And svn.requiredcapability = '{0}' ", Input.CAPABILITY);
}
if (Input.EQPTYPE != null && Input.EQPTYPE.Length > 0)
{
filter4 = string.Format("And sv.resourcetype = '{0}' ", Input.EQPTYPE);
}
filter = filter1 + filter2 + filter3 + filter4;
sql = string.Format(WipDetailSQL, filter);
return(base.PagingQueryDataTable(sql, Input));
}
public JsonResult GetEQPGroupWipMoveData(EQPGroupPerformanceSubPageInput input)
{
return(Json(_Logic.GetEQPGroupWipMoveChart(input)));
}
public JsonResult GetEQPGroupWipMoveDetail(EQPGroupPerformanceSubPageInput input)
{
return(JsonForGridPaging(_Logic.GetEQPGroupWipMoveDetail(input)));
}
public PagedResults GetEQPGroupWipMoveDetail(EQPGroupPerformanceSubPageInput input)
{
var pageResults = _Repository.GetEQPGroupWipMoveDetail(input);
return(pageResults);
}
