public TDbQueryGroupObject Get(string groupname)
{
var sqlText = @"select * from t_db_query_group where group_name = @group_name";
using (SqlCommand command = new SqlCommand(sqlText, Connection))
{
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("@group_name", groupname);
DataTable = DatabaseOps.GetDataTable(command);
_tDbQueryGroupObj = TransformerUtil.DataTableUtil.SingRowToClass <TDbQueryGroupObject>(DataTable);
if (_tDbQueryGroupObj.group_id != 0)
{
return(_tDbQueryGroupObj);
}
else
{
_tDbQueryGroupObj = null;
}
}
return(_tDbQueryGroupObj);
}
public TDbQueryGroupHandler()
{
_tDbQueryGroupObj = new TDbQueryGroupObject();
_tDbQueryGroupObjList = new List <TDbQueryGroupObject>();
}
