public R_PANEL_SN GetPanelVirtualSN(string Panel, OleExec DB) { R_PANEL_SN Row = null; string StrSql = $@"SELECT B.* FROM R_SN A, R_PANEL_SN B WHERE B.PANEL='{ Panel }' AND A.ID=B.SN order by B.SEQ_NO"; DataTable Dt = DB.ExecSelect(StrSql).Tables[0]; if (Dt.Rows.Count > 0) { Row = GetRow(Dt.Rows[0]); } return(Row); }
public R_PANEL_SN GetDataObject() { R_PANEL_SN DataObject = new R_PANEL_SN(); DataObject.ID = this.ID; DataObject.SN = this.SN; DataObject.PANEL = this.PANEL; DataObject.WORKORDERNO = this.WORKORDERNO; DataObject.SEQ_NO = this.SEQ_NO; DataObject.EDIT_EMP = this.EDIT_EMP; DataObject.EDIT_TIME = this.EDIT_TIME; return(DataObject); }
public R_PANEL_SN GetPanelBySn(string SerialNo, OleExec DB) { string sql = string.Empty; DataTable dt = new DataTable(); Row_R_PANEL_SN row = (Row_R_PANEL_SN)NewRow(); R_PANEL_SN Panel = null; if (this.DBType == DB_TYPE_ENUM.Oracle) { sql = $@"SELECT * FROM R_PANEL_SN WHERE SN='{SerialNo}'"; dt = DB.ExecSelect(sql).Tables[0]; if (dt.Rows.Count > 0) { row.loadData(dt.Rows[0]); Panel = row.GetDataObject(); } } else { string errMsg = MESReturnMessage.GetMESReturnMessage("MES00000019", new string[] { DBType.ToString() }); throw new MESReturnMessage(errMsg); } return(Panel); }