public C_CONTROL GetDataObject() { C_CONTROL DataObject = new C_CONTROL(); DataObject.ID = this.ID; DataObject.CONTROL_NAME = this.CONTROL_NAME; DataObject.CONTROL_VALUE = this.CONTROL_VALUE; DataObject.CONTROL_TYPE = this.CONTROL_TYPE; DataObject.CONTROL_LEVEL = this.CONTROL_LEVEL; DataObject.CONTROL_DESC = this.CONTROL_DESC; DataObject.EDIT_EMP = this.EDIT_EMP; DataObject.EDIT_TIME = this.EDIT_TIME; return(DataObject); }
/// <summary> /// 獲取全局 MRB 管控狀態 /// </summary> /// <param name="DB"></param> /// <returns></returns> public bool GetMRBControl(OleExec DB) { bool State = false; T_C_CONTROL ControlTable = new T_C_CONTROL(DB, DBType); C_CONTROL Control = ControlTable.GetControlByName("MRB_CHECK_CTRL", DB); if (Control != null) { if (Control.CONTROL_VALUE.ToUpper().Equals("OPEN")) { State = true; } } return(State); }
public C_CONTROL GetControlByName(string controlName, OleExec db) { string strSql = $@" select * from c_control where control_name='{controlName}'"; //OleDbParameter[] paramet = new OleDbParameter[1]; ////paramet[0] = new OleDbParameter(":control_name", controlName); //DataTable table = db.ExecuteDataTable(strSql, CommandType.Text, paramet); DataTable table = db.ExecSelect(strSql).Tables[0]; C_CONTROL result = new C_CONTROL(); if (table.Rows.Count > 0) { Row_C_CONTROL ret = (Row_C_CONTROL)this.NewRow(); ret.loadData(table.Rows[0]); result = ret.GetDataObject(); } else { result = null; } return(result); }