public DataSet GetAuthReadSearchMenu(string asEmpRefID, string asSearchStr)
{
DataSet lDS = new DataSet();
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
try
{
Dac_lib_MenuControl dac = new Dac_lib_MenuControl();
lDS = dac.GetAuthReadSearchMenu(asEmpRefID, asSearchStr);
}
catch (Exception)
{
trx.Rollback();
conn.Close();
}
finally
{
conn.Close();
}
return(lDS);
}
/// <summary>
/// GetMenuTitle
/// : 해당페이지의 메뉴명을 리턴한다. (타이틀 표시시 사용)
/// </summary>
/// <param name="asPageUrl"></param>
/// <returns></returns>
public string GetMenuTitle(string asPageUrl)
{
string sRet = "";
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
try
{
Dac_lib_MenuControl dac = new Dac_lib_MenuControl();
sRet = dac.GetMenuTitle(asPageUrl);
}
catch (Exception)
{
trx.Rollback();
conn.Close();
}
finally
{
conn.Close();
}
return(sRet);
}
//--------------------------------------------------------------------------------------------
// 추가일 : 2007.05.30
// UserControl - LeftMenu, TopMenu의 메뉴 Data를 호출한다
//--------------------------------------------------------------------------------------------
#region
public IDataReader GetAuthReadMenu(string asEmpRefID)
{
IDataReader dr = null;
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
try
{
Dac_lib_MenuControl dac = new Dac_lib_MenuControl();
dr = dac.GetAuthReadMenu(asEmpRefID);
}
catch (Exception)
{
trx.Rollback();
conn.Close();
}
finally
{
conn.Close();
}
return(dr);
}
//public string GetTopMenuHtmlString(string asEmpRefID)
//{
// DataSet rDs = base.GetTreeMenuPerUser(asEmpRefID);
//}
/// <summary>
/// GetFinishRate
/// : KPI 실적 마감율 추출
/// </summary>
/// <param name="asFinishMonth"></param>
/// <returns></returns>
public int GetFinishRate(int estterm_ref_id, string asFinishMonth)
{
int iRet = 0;
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
try
{
Dac_lib_MenuControl dac = new Dac_lib_MenuControl();
iRet = dac.GetFinishRate(estterm_ref_id, asFinishMonth);
}
catch (Exception)
{
trx.Rollback();
conn.Close();
}
finally
{
conn.Close();
}
return(iRet);
}