/// <summary>
/// Get r_wo_type object by wo
/// </summary>
/// <param name="db"></param>
/// <param name="wo"></param>
/// <returns></returns>
public R_WO_TYPE GetWOTypeByWO(OleExec db, string order_type)
{
R_WO_TYPE woType = new R_WO_TYPE();
string sql = "";
try
{
sql = $@"select * from R_WO_TYPE where order_type='{order_type}'";
DataSet ds = db.ExecSelect(sql);
if (ds.Tables[0].Rows.Count > 0)
{
Row_R_WO_TYPE rowWOType = (Row_R_WO_TYPE)this.NewRow();
rowWOType.loadData(ds.Tables[0].Rows[0]);
woType = rowWOType.GetDataObject();
}
else
{
woType = null;
}
}
catch (Exception ex)
{
throw ex;
}
return(woType);
}
public R_WO_TYPE GetDataObject()
{
R_WO_TYPE DataObject = new R_WO_TYPE();
DataObject.ID = this.ID;
DataObject.WORKORDER_TYPE = this.WORKORDER_TYPE;
DataObject.CATEGORY = this.CATEGORY;
DataObject.PREFIX = this.PREFIX;
DataObject.ORDER_TYPE = this.ORDER_TYPE;
DataObject.PRODUCT_TYPE = this.PRODUCT_TYPE;
DataObject.DESCRIPTION = this.DESCRIPTION;
DataObject.EDIT_EMP = this.EDIT_EMP;
DataObject.EDIT_TIME = this.EDIT_TIME;
return(DataObject);
}
