/// <summary>
/// 獲取未拋賬的工單
/// </summary>
/// <param name="wo"></param>
/// <param name="confirmed_flag"></param>
/// <param name="sfcdb"></param>
/// <returns></returns>
public R_STOCK_GT GetNotGTbjByWO(string wo, string confirmed_flag, OleExec sfcdb)
{
string sql = $@"select * from R_STOCK_GT where workorderno='{wo}' and sap_flag='0' and confirmed_flag='{confirmed_flag}' and backflush_time is null ";
DataTable dt = sfcdb.ExecSelect(sql).Tables[0];
if (dt.Rows.Count > 0)
{
Row_R_STOCK_GT rowObj = (Row_R_STOCK_GT)this.NewRow();
rowObj.loadData(dt.Rows[0]);
return(rowObj.GetDataObject());
}
else
{
return(null);
}
}
/// <summary>
/// 獲取未拋賬的工單list
/// </summary>
/// <param name="confirmed_flag"></param>
/// <param name="sfcdb"></param>
/// <returns></returns>
public List <R_STOCK_GT> GetNotGTListByConfirmedFlag(string confirmed_flag, OleExec sfcdb)
{
string sql = $@"select * from R_STOCK_GT where 1=1 and sap_flag='0' and confirmed_flag='{confirmed_flag}' ";
List <R_STOCK_GT> GTList = new List <R_STOCK_GT>();
DataTable dt = sfcdb.ExecSelect(sql).Tables[0];
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
Row_R_STOCK_GT rowObj = (Row_R_STOCK_GT)this.NewRow();
rowObj.loadData(row);
GTList.Add(rowObj.GetDataObject());
}
}
return(GTList);
}