public RepairFailCodeDetail()
{
Inputs.Add(errorCode);
//HWD 數據庫舊的表為sfcfailuresymptominfo
string sqlErrorCode = "select * from c_error_code where 1=1";
Sqls.Add("SqlErrorCode", sqlErrorCode);
}
public TestReportBySN()
{
Inputs.Add(inputStartDate);
Inputs.Add(inputEndDate);
Inputs.Add(inputSN);
Inputs.Add(inputStationName);
Inputs.Add(inputStateType);
sqlGetSation = "select distinct te_station from c_temes_station_mapping order by te_station";
Sqls.Add("GetSation", sqlGetSation);
}
public TEST1()
{
Inputs.Add(WO);
Inputs.Add(Station);
Inputs.Add(StartTime);
Inputs.Add(EndTime);
string strGetWoSN = @"select * from r_sn where workorderno = '{0}' and rownum < 30 ";
Sqls.Add("strGetWoSN", strGetWoSN);
}
public HWDRepartReport()
{
Inputs.Add(startTime);
Inputs.Add(endTime);
Inputs.Add(type);
Inputs.Add(skuno);
Inputs.Add(line);
Inputs.Add(wo);
string sqlGetSkuno = "select 'ALL' as skuno from dual union select skuno from c_sku order by skuno";
Sqls.Add("SqlGetSkuno", sqlGetSkuno);
}
public R_7B5_XML_Treport()
{
Inputs.Add(startTime);
Inputs.Add(endTime);
Inputs.Add(taskNo);
Inputs.Add(item);
Inputs.Add(productLine);
//現在數據庫中沒有r_7b5_xml_t這個表,故直接DB Link 舊的數據庫
string sqlGetProductLine = "select 'ALL' as product_line from dual union select distinct product_line from r_7b5_xml_t@hwd";
Sqls.Add("SqlGetProductLine", sqlGetProductLine);
}
public UPHRateReport()
{
Inputs.Add(skuInput);
Inputs.Add(lineInput);
Inputs.Add(eventInput);
Inputs.Add(fromDate);
Inputs.Add(toDate);
sqlGetLine = $@" select distinct productionline from sfcruntime.sfcuphratedetail_new order by 1 ";
sqlGetEvent = $@" select distinct eventpoint from sfcruntime.sfcuphratedetail_new order by 1 ";
Sqls.Add("SqlGetLine", sqlGetLine);
Sqls.Add("SqlGetEvent", sqlGetEvent);
}
public UPHReport()
{
Inputs.Add(date);
Inputs.Add(line);
Inputs.Add(skuno);
Inputs.Add(shift);
//sqlGetLine = $@"select line_name from (select 'ALL' as line_name from dual union select distinct line_name from c_line )order by line_name";
sqlGetLine = $@" select distinct line_name from c_line order by line_name";
//sqlGetSkuno = $@"select distinct skuno from r_uph_detail where work_date=to_date('{date.Value}','YYYY/MM/DD') order by skuno";
//sqlGetShift = $@"select distinct class_name from r_uph_detail where work_date=to_date('{date.Value}','YYYY/MM/DD') order by class_name";
Sqls.Add("SqlGetLine", sqlGetLine);
//Sqls.Add("SqlGetSkuno", sqlGetSkuno);
//Sqls.Add("SqlGetShift", sqlGetShift);
}
private List <string> GetShift()
{
OleExec SFCDB = DBPools["SFCDB"].Borrow();
try
{
//System.Globalization.DateTimeFormatInfo format = new System.Globalization.DateTimeFormatInfo();
//format.ShortDatePattern = "yyyy/MM/dd";
//DateTime workDate = Convert.ToDateTime(date.Value.ToString(), format);
//sqlGetShift = $@"select class_name from (select 'ALL' as class_name from dual union
// select distinct class_name from r_uph_detail where work_date=to_date('{workDate.ToString("yyyy/MM/dd")}','YYYY/MM/DD')) order by class_name";
sqlGetShift = "select class_name from (select 'ALL' as class_name from dual union select distinct name as class_name from c_work_class ) order by class_name";
Sqls.Add("SqlGetShift", sqlGetShift);
DataTable dtShift = SFCDB.RunSelect(sqlGetShift).Tables[0];
List <string> shiftList = new List <string>();
if (SFCDB != null)
{
DBPools["SFCDB"].Return(SFCDB);
}
if (dtShift.Rows.Count > 0)
{
foreach (DataRow row in dtShift.Rows)
{
shiftList.Add(row["class_name"].ToString());
}
}
else
{
throw new Exception("no shift in system!");
}
return(shiftList);
}
catch (Exception ex)
{
if (SFCDB != null)
{
DBPools["SFCDB"].Return(SFCDB);
}
throw ex;
}
}
public SNReport()
{
Inputs.Add(SN);
//string strGetSn = @"SELECT * FROM R_SN WHERE SN='{0}' OR BOXSN='{0}'";
string strGetSn = @"select sn,skuno,workorderno,plant,route_name,current_station,next_station,started_flag,start_time,completed_flag,
completed_time,packed_flag,packdate,shipped_flag,shipdate,repair_failed_flag,po_no,cust_order_no,cust_pn,boxsn,
scraped_flag,scraped_time,product_status,rework_count,valid_flag,stock_status,stock_in_time,a.edit_time
from R_SN a,c_route b where a.route_id=b.id and (sn='{0}' or boxsn='{0}')";
Sqls.Add("strGetSN", strGetSn);
string strGetSnDetail = @"SELECT c.panel,a.sn,skuno,a.workorderno,plant,route_name,line,current_station,next_station,device_name,repair_failed_flag, started_flag,
a.edit_time,completed_flag,completed_time,packed_flag,packed_time,shipped_flag,shipdate,po_no,cust_order_no,cust_pn,boxsn,
scraped_flag,scraped_time,product_status,rework_count,valid_flag,class_name,start_time FROM R_SN_STATION_DETAIL a,c_route b ,r_panel_sn c
where a.sn=c.sn and a.route_id=b.id and a.SN IN ( SELECT SN FROM R_SN WHERE SN = '{0}' OR BOXSN ='{0}') order by a.edit_time ";
Sqls.Add("strGetSnDetail", strGetSnDetail);
string strGetSnKeypart = @"SELECT * FROM R_SN_KEYPART_DETAIL WHERE R_SN_ID IN (SELECT ID
FROM R_SN WHERE SN ='{0}' OR BOXSN = '{0}')";
Sqls.Add("strGetSnKeypart", strGetSnKeypart);
}
