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);
}
