public DataSet GetTableConstruct(OleExec sfcdb)
{
string strSQL = "select * from r_backflush_check where 1<1";
DataSet dtset = sfcdb.ExecuteDataSet(strSQL, CommandType.Text);
return(dtset);
}
public DataSet GetSNCountByWO(string wono, OleExec sfcdb)
{
string sqlString = $@"select count(distinct(r.sn ) ) C from r_mrb r where workorderno= '{wono}'";
DataSet dtset = sfcdb.ExecuteDataSet(sqlString, CommandType.Text);
return(dtset);
}
public DataSet GetBackFlushData(string wono, string sapstation, OleExec sfcdb)
{
string sqlString = $@"select nvl(sum(r.diff_qty),0) C
from r_backflush_history r
where r.workorderno = '{wono}'
and r.sap_station = '{sapstation}'
and r.result='Y'";
DataSet dtset = sfcdb.ExecuteDataSet(sqlString, CommandType.Text);
return(dtset);
}
public static string GetPostDate(OleExec sfcdb)
{
string strPostDATE = "";
string sqlString = $@"select to_char((to_date(a.control_value, 'mm/dd/yyyy') - sysdate)) as C,
a.control_value as DAT,
to_char(sysdate, 'mm/dd/yyyy') as NOW
from c_control a where upper(CONTROL_NAME)='BACKFLUSHPOSTEDATE'";
DataSet postDate = sfcdb.ExecuteDataSet(sqlString, CommandType.Text);
if (float.Parse(postDate.Tables[0].Rows[0]["C"].ToString()) > 0)
{
strPostDATE = postDate.Tables[0].Rows[0]["DAT"].ToString();
}
else
{
strPostDATE = postDate.Tables[0].Rows[0]["NOW"].ToString();
}
return(strPostDATE);
}
