public string Load(string text)
{
long userid = AppInfoBase.UserID;
StringBuilder strbuilder = new StringBuilder();
if (text == "默认功能导航图")
{
strbuilder.Append("select svgconfig from fg3_function_navigation where userid =" + userid + " and usertype = 0 " + " and text is null");
}
else
{
strbuilder.Append("select svgconfig from fg3_function_navigation where userid =" + userid + " and usertype = 0 " + " and text = '" + text + "'");
}
string svgConfig = DbHelper.GetString(strbuilder.ToString());
if (svgConfig == null || svgConfig == "")
{
strbuilder.Remove(0, strbuilder.Length);
userid = UserConfigDac.ActorGet(userid);
if (text == "默认功能导航图")
{
strbuilder.Append("select svgconfig from fg3_function_navigation where userid =" + userid + " and usertype = 1 " + " and text is null");
}
else
{
strbuilder.Append("select svgconfig from fg3_function_navigation where userid =" + userid + " and usertype = 1 " + " and text = '" + text + "'");
}
svgConfig = DbHelper.GetString(strbuilder.ToString());
}
return(svgConfig);
}
/// <summary>
/// 我的功能分类
/// </summary>
/// <param name="rows"></param>
/// <returns></returns>
public DataTable LoadMyMenuType()
{
long userid = NG3.AppInfoBase.UserID;
string logid = NG3.AppInfoBase.LoginID;
StringBuilder strbuilder = new StringBuilder();
DataTable menudt = new DataTable();
if (String.Compare(AppInfoBase.UserType, UserType.System, true) == 0)
{
strbuilder.Append("select code,lineid,name from");
strbuilder.Append(" my_menu_type");
strbuilder.Append(" where logid = '" + logid + "'");
menudt = DbHelper.GetDataTable(strbuilder.ToString());
return(menudt);
}
strbuilder.Append("select code,lineid,name from");
strbuilder.Append(" my_menu_type");
strbuilder.Append(" where userid = '" + userid + "' and usertype = 0 order by lineid");
menudt = DbHelper.GetDataTable(strbuilder.ToString());
if (menudt.Rows.Count < 1)
{
strbuilder.Remove(0, strbuilder.Length);
userid = UserConfigDac.ActorGet(userid);
strbuilder.Append("select code,lineid,name from");
strbuilder.Append(" my_menu_type");
strbuilder.Append(" where userid = '" + userid + "' and usertype = 1 order by lineid");
menudt = DbHelper.GetDataTable(strbuilder.ToString());
}
return(menudt);
}
public DataTable LoadDefaultOpenTab(long userid)
{
StringBuilder strbuilder = new StringBuilder();
DataTable menudt = new DataTable();
strbuilder.Append("select * from ");
strbuilder.Append("(select fg3_defaultopen_tab.phid,fg3_defaultopen_tab.userid,fg3_defaultopen_tab.id,fg3_defaultopen_tab.pid,fg3_defaultopen_tab.originalcode,fg3_defaultopen_tab.seq,fg3_defaultopen_tab.name,fg3_menu.url,fg3_menu.managername,fg3_menu.rightname,fg3_menu.suite,fg3_menu.moduleno,fg3_defaultopen_tab.urlparm");
strbuilder.Append(" from fg3_defaultopen_tab,fg3_menu");
strbuilder.Append(" where fg3_menu.code = fg3_defaultopen_tab.originalcode and (originalcode <> '' or originalcode is not null) and fg3_defaultopen_tab.usertype = 0 and userid = " + userid);
strbuilder.Append(" union ");
strbuilder.Append(" select phid,userid,id,pid,originalcode,seq,name,url,null,null,null,null,urlparm");
strbuilder.Append(" from fg3_defaultopen_tab");
strbuilder.Append(" where (originalcode = '' or originalcode is null) and userid = " + userid + " and usertype = 0 ) t1");
strbuilder.Append(" order by seq");
menudt = DbHelper.GetDataTable(strbuilder.ToString());
if (menudt.Rows.Count < 1)
{
strbuilder.Remove(0, strbuilder.Length);
userid = UserConfigDac.ActorGet(userid);
strbuilder.Append("select * from ");
strbuilder.Append("(select fg3_defaultopen_tab.phid,fg3_defaultopen_tab.userid,fg3_defaultopen_tab.id,fg3_defaultopen_tab.pid,fg3_defaultopen_tab.originalcode,fg3_defaultopen_tab.seq,fg3_defaultopen_tab.name,fg3_menu.url,fg3_menu.managername,fg3_menu.rightname,fg3_menu.suite,fg3_menu.moduleno,fg3_defaultopen_tab.urlparm");
strbuilder.Append(" from fg3_defaultopen_tab,fg3_menu");
strbuilder.Append(" where fg3_menu.code = fg3_defaultopen_tab.originalcode and (originalcode <> '' or originalcode is not null) and fg3_defaultopen_tab.usertype = 1 and userid = " + userid);
strbuilder.Append(" union ");
strbuilder.Append(" select phid,userid,id,pid,originalcode,seq,name,url,null,null,null,null,urlparm");
strbuilder.Append(" from fg3_defaultopen_tab");
strbuilder.Append(" where (originalcode = '' or originalcode is null) and userid = " + userid + " and usertype = 1 ) t1");
strbuilder.Append(" order by seq");
menudt = DbHelper.GetDataTable(strbuilder.ToString());
}
return(menudt);
}
//i8web版主页取默认打开tab页
public DataTable LoadDefaultOpenTabForMainFrame()
{
long userid = AppInfoBase.UserID;
DataTable menudt = new DataTable();
string sql = string.Format(@"select * from
(select fg3_defaultopen_tab.originalcode,fg3_defaultopen_tab.name,fg3_menu.url,fg3_menu.managername,fg3_menu.rightname,fg3_menu.functionname,fg3_menu.suite,fg3_menu.moduleno,fg3_menu.rightkey,fg3_defaultopen_tab.urlparm
from fg3_defaultopen_tab,fg3_menu
where fg3_menu.code = fg3_defaultopen_tab.originalcode and (originalcode <> '' or originalcode is not null) and fg3_defaultopen_tab.usertype = 0 and userid = {0}
union
select originalcode,fg3_defaultopen_tab.name,fg3_defaultopen_tab.url,null,null,null,null,null,null,urlparm
from fg3_defaultopen_tab
where (originalcode = '' or originalcode is null) and userid = {0} and usertype = 0
) t1 ", userid);
menudt = DbHelper.GetDataTable(sql);
if (menudt.Rows.Count < 1)
{
userid = UserConfigDac.ActorGet(userid);
sql = string.Format(@"select * from
(select fg3_defaultopen_tab.originalcode,fg3_defaultopen_tab.name,fg3_menu.url,fg3_menu.managername,fg3_menu.rightname,fg3_menu.functionname,fg3_menu.suite,fg3_menu.moduleno,fg3_menu.rightkey,fg3_defaultopen_tab.urlparm
from fg3_defaultopen_tab,fg3_menu
where fg3_menu.code = fg3_defaultopen_tab.originalcode and (originalcode <> '' or originalcode is not null) and fg3_defaultopen_tab.usertype = 0 and userid = {0}
union
select originalcode,fg3_defaultopen_tab.name,fg3_defaultopen_tab.url,null,null,null,null,null,null,urlparm
from fg3_defaultopen_tab
where (originalcode = '' or originalcode is null) and userid = {0} and usertype = 0
) t1 ", userid);
menudt = DbHelper.GetDataTable(sql);
}
return(menudt);
}
public DataTable LoadTree()
{
long userid = AppInfoBase.UserID;
StringBuilder strbuilder = new StringBuilder();
strbuilder.Append("select text from fg3_function_navigation where userid =" + userid + " and usertype = 0 ");
DataTable text = DbHelper.GetDataTable(strbuilder.ToString());
if (text == null || text.Rows.Count == 0)
{
strbuilder.Remove(0, strbuilder.Length);
userid = UserConfigDac.ActorGet(userid);
strbuilder.Append("select text from fg3_function_navigation where userid =" + userid + " and usertype = 1 ");
text = DbHelper.GetDataTable(strbuilder.ToString());
}
return(text);
}
public object GetMyDesktopIdByUserID(long userid)
{
object phid = DbHelper.ExecuteScalar("select phid from fg3_mydesktop where userid = '" + userid + "' and usertype = '0'");
if (phid == null)
{
long desktopactor = UserConfigDac.ActorGet(userid);
if (desktopactor == 0)
{
return(null);
}
else
{
phid = DbHelper.ExecuteScalar("select phid from fg3_mydesktop where userid = '" + desktopactor + "' and usertype = '1'");
}
}
return(phid);
}
// #region 日志相关
// private static ILogger _logger = null;
// internal static ILogger Logger
// {
// get
// {
// if (_logger == null)
// {
// _logger = Log4NetLoggerFactory.Instance.CreateLogger(typeof(MyFuncTreeDac), LogType.logdac);
// }
// return _logger;
// }
// }
// #endregion
// 使用：
//_logger.Info(logInfo);
/// <summary>
/// 加载我的功能树
/// </summary>
/// <param name="userid"></param>
/// <returns></returns>
public DataTable LoadMenuData(long userid)
{
StringBuilder strbuilder = new StringBuilder();
DataTable menudt = new DataTable();
strbuilder.Append("select * from ");
strbuilder.Append("(select fg3_myfunctree.phid,fg3_myfunctree.userid,fg3_myfunctree.id,fg3_myfunctree.pid,fg3_myfunctree.originalcode,fg3_myfunctree.seq,fg3_myfunctree.name,fg3_menu.url,fg3_menu.managername,fg3_menu.rightname,fg3_menu.suite,fg3_menu.moduleno,fg3_menu.rightkey,fg3_menu.functionname,fg3_myfunctree.urlparm,fg3_menu.norightcontrol,fg3_menu.busphid");
strbuilder.Append(" from fg3_myfunctree,fg3_menu");
strbuilder.Append(" where fg3_menu.code = fg3_myfunctree.originalcode and (originalcode <> '' or originalcode is not null) and fg3_myfunctree.usertype = 0 and userid = " + userid + "");
strbuilder.Append(" union ");
strbuilder.Append(" select phid,userid,id,pid,originalcode,seq,name,url,null,null,null,null,null,null,urlparm,null,null");
strbuilder.Append(" from fg3_myfunctree");
strbuilder.Append(" where (originalcode = '' or originalcode is null) and userid = " + userid + " and usertype = 0 ");
strbuilder.Append(" union ");
strbuilder.Append(" select fg3_myfunctree.phid,fg3_myfunctree.userid,fg3_myfunctree.id,fg3_myfunctree.pid,fg3_myfunctree.originalcode,fg3_myfunctree.seq,fg3_myfunctree.name,fg3_myfunctree.url,null,null,null,null,null,null,fg3_myfunctree.urlparm,null,null");
strbuilder.Append(" from rw_report_main,fg3_myfunctree");
strbuilder.Append(" where (rw_report_main.rep_code = fg3_myfunctree.originalcode and fg3_myfunctree.usertype = 0 and userid = " + userid + ") or (fg3_myfunctree.originalcode = 'ReportListRoot' and fg3_myfunctree.usertype = 0 and userid = " + userid + ")) t1");
strbuilder.Append(" order by seq");
menudt = DbHelper.GetDataTable(strbuilder.ToString());
if (menudt.Rows.Count < 1)
{
strbuilder.Remove(0, strbuilder.Length);
userid = UserConfigDac.ActorGet(userid);
strbuilder.Append("select * from ");
strbuilder.Append("(select fg3_myfunctree.phid,fg3_myfunctree.userid,fg3_myfunctree.id,fg3_myfunctree.pid,fg3_myfunctree.originalcode,fg3_myfunctree.seq,fg3_myfunctree.name,fg3_menu.url,fg3_menu.managername,fg3_menu.rightname,fg3_menu.suite,fg3_menu.moduleno,fg3_menu.rightkey,fg3_menu.functionname,fg3_myfunctree.urlparm,fg3_menu.norightcontrol,fg3_menu.busphid");
strbuilder.Append(" from fg3_myfunctree,fg3_menu");
strbuilder.Append(" where fg3_menu.code = fg3_myfunctree.originalcode and (originalcode <> '' or originalcode is not null) and fg3_myfunctree.usertype = 1 and userid = " + userid);
strbuilder.Append(" union ");
strbuilder.Append(" select phid,userid,id,pid,originalcode,seq,name,url,null,null,null,null,null,null,urlparm,null,null");
strbuilder.Append(" from fg3_myfunctree");
strbuilder.Append(" where (originalcode = '' or originalcode is null) and userid = " + userid + " and usertype = 1 ");
strbuilder.Append(" union ");
strbuilder.Append(" select fg3_myfunctree.phid,fg3_myfunctree.userid,fg3_myfunctree.id,fg3_myfunctree.pid,fg3_myfunctree.originalcode,fg3_myfunctree.seq,fg3_myfunctree.name,fg3_myfunctree.url,null,null,null,null,null,null,fg3_myfunctree.urlparm,null,null");
strbuilder.Append(" from rw_report_main,fg3_myfunctree");
strbuilder.Append(" where (rw_report_main.rep_code = fg3_myfunctree.originalcode and fg3_myfunctree.usertype = 1 and userid = " + userid + ") or (fg3_myfunctree.originalcode = 'ReportListRoot' and fg3_myfunctree.usertype = 1 and userid = " + userid + ")) t1");
strbuilder.Append(" order by seq");
menudt = DbHelper.GetDataTable(strbuilder.ToString());
}
return(menudt);
}
public string Load(long userid)
{
StringBuilder strbuilder = new StringBuilder();
strbuilder.Append("select treetabconfig");
strbuilder.Append(" from fg3_mainframe_individual");
strbuilder.Append(" where userid = " + userid + " and usertype = 0 ");
string treetabconfig = DbHelper.GetString(strbuilder.ToString());
if (treetabconfig == "" || treetabconfig == null)
{
strbuilder.Remove(0, strbuilder.Length);
userid = UserConfigDac.ActorGet(userid);
strbuilder.Append("select treetabconfig");
strbuilder.Append(" from fg3_mainframe_individual");
strbuilder.Append(" where userid = " + userid + " and usertype = 1 ");
treetabconfig = DbHelper.GetString(strbuilder.ToString());
}
return(treetabconfig);
}
public DataTable LoadSysSetting(long userid)
{
StringBuilder strbuilder = new StringBuilder();
strbuilder.Append("select individualsetting,applogoname");
strbuilder.Append(" from fg3_mainframe_individual");
strbuilder.Append(" where userid = " + userid + " and usertype = 0 ");
DataTable treetabconfig = DbHelper.GetDataTable(strbuilder.ToString());
if (treetabconfig == null || treetabconfig.Rows.Count == 0)
{
strbuilder.Remove(0, strbuilder.Length);
userid = UserConfigDac.ActorGet(userid);
strbuilder.Append("select individualsetting");
strbuilder.Append(" from fg3_mainframe_individual");
strbuilder.Append(" where userid = " + userid + " and usertype = 1 ");
treetabconfig = DbHelper.GetDataTable(strbuilder.ToString());
}
return(treetabconfig);
}
//小铃铛设置存取
public string LoadAlertItem()
{
long userid = AppInfoBase.UserID;
StringBuilder strbuilder = new StringBuilder();
strbuilder.Append("select alertconfig");
strbuilder.Append(" from fg3_mainframe_individual");
strbuilder.Append(" where userid = " + userid + " and usertype = 0 ");
string alertconfig = DbHelper.GetString(strbuilder.ToString());
if (alertconfig == "" || alertconfig == null)
{
strbuilder.Remove(0, strbuilder.Length);
userid = UserConfigDac.ActorGet(userid);
strbuilder.Append("select alertconfig");
strbuilder.Append(" from fg3_mainframe_individual");
strbuilder.Append(" where userid = " + userid + " and usertype = 1 ");
alertconfig = DbHelper.GetString(strbuilder.ToString());
}
return(alertconfig);
}
public string GetUITheme(long userid)
{
StringBuilder strbuilder = new StringBuilder();
strbuilder.Append("select uitheme");
strbuilder.Append(" from fg3_mainframe_individual");
strbuilder.Append(" where userid = " + userid + " and usertype = 0 ");
string uitheme = DbHelper.GetString(strbuilder.ToString());
if (uitheme == "" || uitheme == null)
{
strbuilder.Remove(0, strbuilder.Length);
userid = UserConfigDac.ActorGet(userid);
strbuilder.Append("select uitheme");
strbuilder.Append(" from fg3_mainframe_individual");
strbuilder.Append(" where userid = " + userid + " and usertype = 1 ");
uitheme = DbHelper.GetString(strbuilder.ToString());
}
return(uitheme);
}
