예제 #1
0
        /// <summary>
        /// 短信发送
        /// </summary>
        /// <param name="m"></param>
        /// <returns></returns>
        public static Message SEND(SendMessage_Model m)
        {
            string name        = SystemCls.getCookieInfo().trueName;
            string title       = m.MessageTitle;
            string MessageName = m.MessageName;
            string phone       = m.PHONE;

            if (string.IsNullOrEmpty(phone))
            {
                return(new Message(false, "该成员未录入号码", m.URL));
            }
            string phonelist = "";

            string[]      arr  = m.PHONE.Split(',');
            string[]      brr  = arr.Where(s => !string.IsNullOrEmpty(s)).ToArray();
            List <string> list = new List <string>();

            foreach (string eachString in brr)//去掉重复的手机号码
            {
                if (!list.Contains(eachString))
                {
                    list.Add(eachString);
                }
            }
            brr = list.ToArray();
            for (int i = 0; i < brr.Length; i++)
            {
                if (i == brr.Length - 1)
                {
                    phonelist += brr[i];
                }
                else
                {
                    phonelist += brr[i] + ",";
                }
            }
            string content = m.MessageContent;
            var    ms      = SmsHelp.SmsCom.SendMsg(content, phonelist);

            return(new Message(ms.Success, ms.Msg, m.URL));
        }
예제 #2
0
        /// <summary>
        /// 获取所有系统菜单
        /// </summary>
        /// <param name="sw">参见T_SYS_MENU_SW</param>
        /// <returns>参见SystemMenu_Model</returns>
        public static IEnumerable <SystemMenu_Model> getT_SYS_MENUModel(T_SYS_MENU_SW sw)
        {
            var result = new List <SystemMenu_Model>();

            if (string.IsNullOrEmpty(SystemCls.getUserID()))
            {
                return(result);
            }
            StringBuilder sb = new StringBuilder(1000);

            sb.AppendFormat(" FROM T_SYS_MENU WHERE 1=1");
            sb.AppendFormat(" AND  SYSFLAG='{0}' ", sw.SYSFLAG);
            sb.AppendFormat(" AND MENURIGHTFLAG in (select RIGHTID from T_SYSSEC_ROLE_RIGHT where (ROLEID in (select ROLEID from T_SYSSEC_USER_ROLE where USERID={0} ) and RIGHTID in(select RIGHTID from T_SYSSEC_RIGHT where SYSFLAG='{1}')) and roleid in (select roleid from T_SYSSEC_ROLE where SYSFLAG='{1}') )", SystemCls.getUserID(), ConfigCls.getSystemFlag());
            if (string.IsNullOrEmpty(sw.MENUCODE) == false)
            {
                sb.AppendFormat(" AND  left(MENUCODE,3) in({0}) ", sw.MENUCODE);
            }
            if (string.IsNullOrEmpty(sw.MenuCodeList) == false)
            {
                sb.AppendFormat(" AND  left(MENUCODE,3) in({0}) ", sw.MenuCodeList);
            }
            string    sql = "SELECT MENUID,MENUCODE,MENUNAME,MENUURL,MENUICO,LICLASS,ORDERBY,MENURIGHTFLAG,SYSFLAG,MENUOPENMETHOD, MENULINKMODE, MENUDROWMTHOD, ISTOPMENU   " + sb.ToString() + " ";
            DataSet   ds  = DataBaseClass.FullDataSet(sql);
            DataTable dt  = ds.Tables[0];

            DataRow[] dr = dt.Select("len(MENUCODE)=3", "ORDERBY");
            //获取上报数据
            DataTable dtR = BaseDT.T_IPSRPT_REPORT.getDT(new T_IPSRPT_REPORT_SW {
                MANSTATE = "0", orgNo = SystemCls.getCurUserOrgNo()
            });
            CookieModel cookieInfo = SystemCls.getCookieInfo();//登录用户信息

            for (int i = 0; i < dr.Length; i++)
            {
                SystemMenu_Model m = new SystemMenu_Model();
                m.MENUCODE       = dr[i]["MENUCODE"].ToString();
                m.MENUICO        = dr[i]["MENUICO"].ToString();
                m.MENUNAME       = dr[i]["MENUNAME"].ToString();
                m.LICLASS        = dr[i]["LICLASS"].ToString();
                m.MENUOPENMETHOD = dr[i]["MENUOPENMETHOD"].ToString();
                m.MENULINKMODE   = dr[i]["MENULINKMODE"].ToString();
                m.MENUDROWMTHOD  = dr[i]["MENUDROWMTHOD"].ToString();
                m.ISTOPMENU      = dr[i]["ISTOPMENU"].ToString();
                long      mShowCount = 0;//一级菜单显示数量
                var       SubM       = new List <T_SYS_MENU_Model>();
                DataRow[] dr1        = dt.Select("len(MENUCODE)=6 and SUBSTRING(MENUCODE,1,3)='" + dr[i]["MENUCODE"].ToString() + "'", "ORDERBY");
                for (int k = 0; k < dr1.Length; k++)
                {
                    T_SYS_MENU_Model mm = new T_SYS_MENU_Model();
                    mm.MENUCODE = dr1[k]["MENUCODE"].ToString();
                    mm.MENUURL  = dr1[k]["MENUURL"].ToString().Replace("[USERID]", cookieInfo.UID).Replace("[LOGINUSERNAME]", cookieInfo.userName);
                    mm.MENUNAME = dr1[k]["MENUNAME"].ToString();
                    mm.MENUICO  = dr1[k]["MENUICO"].ToString();
                    mm.LICLASS  = dr1[k]["LICLASS"].ToString();
                    //获取需要显示提醒数量的菜单
                    string MENUCODE = dr1[k]["MENUCODE"].ToString();
                    string count    = "0";
                    if (MENUCODE == "001004")
                    {
                        count = BaseDT.T_IPS_ALARM.getDT(new T_IPS_ALARM_SW {
                            orgNo = SystemCls.getCurUserOrgNo(), MANSTATE = "0"
                        }).Rows.Count.ToString();
                    }
                    if (MENUCODE == "001003")
                    {
                        count = BaseDT.T_IPS_HOTS.getDT(new T_IPS_HOTS_SW {
                            MANSTATE = "0"
                        }).Rows.Count.ToString();
                    }
                    if (MENUCODE.Substring(0, 3) == "002")
                    {
                        string tmpCode = MENUCODE.Substring(3, 3);
                        if (tmpCode.Substring(0, 2) == "00")
                        {
                            tmpCode = tmpCode.Substring(2, 1);
                        }
                        else if (tmpCode.Substring(0, 1) == "0")
                        {
                            tmpCode = tmpCode.Substring(1, 2);
                        }
                        else
                        {
                            tmpCode = tmpCode.Substring(2, 1);
                        }
                        count  = BaseDT.T_IPSRPT_REPORT.getCountByType(dtR, tmpCode);
                        mm.TID = tmpCode;//类别ID 上报序号
                    }
                    if (MENUCODE.Substring(0, 3) == "003")
                    {
                        string tmpCode = MENUCODE.Substring(3, 3);
                        if (tmpCode.Substring(0, 2) == "00")
                        {
                            tmpCode = tmpCode.Substring(2, 1);
                        }
                        else if (tmpCode.Substring(0, 1) == "0")
                        {
                            tmpCode = tmpCode.Substring(1, 2);
                        }
                        else
                        {
                            tmpCode = tmpCode.Substring(2, 1);
                        }
                        //count = BaseDT.T_IPSRPT_REPORT.getCountByType(dtR, tmpCode);
                        mm.TID = tmpCode; //类别ID 上报序号
                    }
                    mShowCount += Convert.ToInt64(count);
                    if (count == "0")
                    {
                        count = "";
                    }
                    mm.showCount = count;
                    SubM.Add(mm);
                }
                m.showCount    = (mShowCount == 0) ? "" : mShowCount.ToString();
                m.subMenuModel = SubM;
                result.Add(m);
            }
            ds.Clear();
            ds.Dispose();
            dt.Clear();
            dt.Dispose();
            return(result);
        }
예제 #3
0
        /// <summary>
        /// 增、删
        /// </summary>
        /// <param name="m">参见模型</param>
        /// <returns>参见模型</returns>
        public static Message Manager(E_SUBJECT_Model m)
        {
            if (m.opMethod == "Add")//保存为草稿
            {
                //没有附件
                if (string.IsNullOrEmpty(m.EMAILID) == true)
                {
                    Message msg = BaseDT.E_SUBJECT.Add(m);
                    //获取主题ID
                    string EMAILid = BaseDT.E_SUBJECT.getID(new E_SUBJECT_SW {
                        EMAILSENDUSERID = m.EMAILSENDUSERID, EMAILTIME = m.EMAILTIME
                    });
                    if (msg.Success == true)
                    {
                        return(new Message(msg.Success, "草稿保存成功!", m.returnUrl));
                    }
                    else
                    {
                        return(new Message(msg.Success, "草稿保存失败,请重试!", m.returnUrl));
                    }
                }
                //有附件的情况更新库
                if (string.IsNullOrEmpty(m.EMAILID) == false)
                {
                    Message msg = BaseDT.E_SUBJECT.Mdy(m);
                    if (msg.Success == true)
                    {
                        return(new Message(msg.Success, "草稿保存成功!", m.returnUrl));
                    }
                    else
                    {
                        return(new Message(msg.Success, "草稿保存失败,请重试!", m.returnUrl));
                    }
                }
            }
            if (m.opMethod == "AddToSend")//草稿直接发送
            {
                #region 草稿直接发送
                BaseDT.E_SUBJECT.Mdy(m);//主题表 修改为已发送
                if (string.IsNullOrEmpty(m.EMAILRECUSERLIST) == false)
                {
                    //接收信息表中录入数据 接收人
                    string[] arr = m.EMAILRECUSERLIST.Split(',');
                    for (int i = 0; i < arr.Length; i++)
                    {
                        BaseDT.E_RECEIVE.Add(new E_RECEIVE_Model
                        {
                            BYEMAILID          = m.EMAILID,
                            RECEIVETYPE        = "0",    //接收人类别
                            RECEIVEUSERID      = arr[i], //接收人序号
                            EMAILRECEIVESTATUS = "0",    //接收状态
                            EMAILSENDTIME      = m.EMAILTIME
                        });
                    }
                }
                if (string.IsNullOrEmpty(m.EMAILCOPYUSERLIST) == false)
                {
                    //接收信息表中录入数据 抄送人
                    string[] arr = m.EMAILCOPYUSERLIST.Split(',');
                    for (int i = 0; i < arr.Length; i++)
                    {
                        BaseDT.E_RECEIVE.Add(new E_RECEIVE_Model
                        {
                            BYEMAILID          = m.EMAILID,
                            RECEIVETYPE        = "1",    //接收人类别
                            RECEIVEUSERID      = arr[i], //接收人序号
                            EMAILRECEIVESTATUS = "0",    //接收状态
                            EMAILSENDTIME      = m.EMAILTIME
                        });
                    }
                }
                if (string.IsNullOrEmpty(m.EMAILSECRETUSERLIST) == false)
                {
                    //接收信息表中录入数据 密送人
                    string[] arr = m.EMAILSECRETUSERLIST.Split(',');
                    for (int i = 0; i < arr.Length; i++)
                    {
                        BaseDT.E_RECEIVE.Add(new E_RECEIVE_Model
                        {
                            BYEMAILID          = m.EMAILID,
                            RECEIVETYPE        = "2",    //接收人类别
                            RECEIVEUSERID      = arr[i], //接收人序号
                            EMAILRECEIVESTATUS = "0",    //接收状态
                            EMAILSENDTIME      = m.EMAILTIME
                        });
                    }
                }
                #endregion

                #region 发送短信
                string   name      = SystemCls.getCookieInfo().trueName;
                string   time      = PublicClassLibrary.ClsSwitch.SwitTM(DateTime.Now.ToString());
                string   title     = m.EMAILTITLE;
                string   userlist  = m.EMAILRECUSERLIST + "," + m.EMAILCOPYUSERLIST + "," + m.EMAILSECRETUSERLIST;
                string[] crr       = userlist.Split(',');
                string[] drr       = crr.Where(s => !string.IsNullOrEmpty(s)).ToArray(); //去掉空的用户id
                string   userlist1 = "";                                                 //定义一个去掉空的uselist
                for (int i = 0; i < drr.Length; i++)
                {
                    if (i == drr.Length - 1)
                    {
                        userlist1 += drr[i];
                    }
                    else
                    {
                        userlist1 += drr[i] + ",";
                    }
                }
                string phone  = ""; //通过userlist获取手机号码
                string phone1 = ""; //定义一个去掉空的号码
                if (string.IsNullOrEmpty(userlist1) == false)
                {
                    phone = BaseDT.T_SYSSEC_IPSUSER.getphone(new T_SYSSEC_IPSUSER_SW {
                        USERID = userlist1
                    });
                    string[]      jrr  = phone.Split(',');
                    string[]      brr  = jrr.Where(s => !string.IsNullOrEmpty(s)).ToArray(); //去掉空的手机号码
                    List <string> list = new List <string>();
                    foreach (string eachString in brr)                                       //去掉重复的电话号码
                    {
                        if (!list.Contains(eachString))
                        {
                            list.Add(eachString);
                        }
                    }
                    brr = list.ToArray();
                    for (int i = 0; i < brr.Length; i++)
                    {
                        if (i == brr.Length - 1)
                        {
                            phone1 += brr[i];
                        }
                        else
                        {
                            phone1 += brr[i] + ",";
                        }
                    }
                }
                string content = "您好:" + name + "在" + time + "给您发一封主题「" + title + "」邮件,请登陆森林保护信息指挥系统查阅!";
                SmsHelp.SmsCom.SendMsg(content, phone1);
                return(new Message(true, "发送成功!", m.returnUrl));

                #endregion
            }
            if (m.opMethod == "Send")//发送
            {
                //没有附件
                if (string.IsNullOrEmpty(m.EMAILID) == true)
                {
                    //未保存为草稿,直接发送
                    BaseDT.E_SUBJECT.Add(m);//主题表ADD
                    //获取主题ID
                    string EMAILid = BaseDT.E_SUBJECT.getID(new E_SUBJECT_SW {
                        EMAILSENDUSERID = m.EMAILSENDUSERID, EMAILTIME = m.EMAILTIME
                    });
                    if (string.IsNullOrEmpty(m.EMAILRECUSERLIST) == false)
                    {
                        //接收信息表中录入数据 接收人
                        string[] arr = m.EMAILRECUSERLIST.Split(',');
                        for (int i = 0; i < arr.Length; i++)
                        {
                            BaseDT.E_RECEIVE.Add(new E_RECEIVE_Model
                            {
                                BYEMAILID          = EMAILid,
                                RECEIVETYPE        = "0",    //接收人类别
                                RECEIVEUSERID      = arr[i], //接收人序号
                                EMAILRECEIVESTATUS = "0",    //接收状态
                                EMAILSENDTIME      = m.EMAILTIME
                            });
                        }
                    }
                    if (string.IsNullOrEmpty(m.EMAILCOPYUSERLIST) == false)
                    {
                        //接收信息表中录入数据 抄送人
                        string[] arr = m.EMAILCOPYUSERLIST.Split(',');
                        for (int i = 0; i < arr.Length; i++)
                        {
                            BaseDT.E_RECEIVE.Add(new E_RECEIVE_Model
                            {
                                BYEMAILID          = EMAILid,
                                RECEIVETYPE        = "1",    //接收人类别
                                RECEIVEUSERID      = arr[i], //接收人序号
                                EMAILRECEIVESTATUS = "0",    //接收状态
                                EMAILSENDTIME      = m.EMAILTIME
                            });
                        }
                    }
                    if (string.IsNullOrEmpty(m.EMAILSECRETUSERLIST) == false)
                    {
                        //接收信息表中录入数据 密送人
                        string[] arr = m.EMAILSECRETUSERLIST.Split(',');
                        for (int i = 0; i < arr.Length; i++)
                        {
                            BaseDT.E_RECEIVE.Add(new E_RECEIVE_Model
                            {
                                BYEMAILID          = EMAILid,
                                RECEIVETYPE        = "2",    //接收人类别
                                RECEIVEUSERID      = arr[i], //接收人序号
                                EMAILRECEIVESTATUS = "0",    //接收状态
                                EMAILSENDTIME      = m.EMAILTIME
                            });
                        }
                    }
                    //发送短信
                    string   name      = SystemCls.getCookieInfo().trueName;
                    string   time      = PublicClassLibrary.ClsSwitch.SwitTM(DateTime.Now.ToString());
                    string   title     = m.EMAILTITLE;
                    string   userlist  = m.EMAILRECUSERLIST + "," + m.EMAILCOPYUSERLIST + "," + m.EMAILSECRETUSERLIST;
                    string[] crr       = userlist.Split(',');
                    string[] drr       = crr.Where(s => !string.IsNullOrEmpty(s)).ToArray(); //去掉空的用户id
                    string   userlist1 = "";                                                 //定义一个去掉空的uselist
                    for (int i = 0; i < drr.Length; i++)
                    {
                        if (i == drr.Length - 1)
                        {
                            userlist1 += drr[i];
                        }
                        else
                        {
                            userlist1 += drr[i] + ",";
                        }
                    }
                    string phone  = ""; //通过userlist获取手机号码
                    string phone1 = ""; //定义一个去掉空的号码
                    if (string.IsNullOrEmpty(userlist1) == false)
                    {
                        phone = BaseDT.T_SYSSEC_IPSUSER.getphone(new T_SYSSEC_IPSUSER_SW {
                            USERID = userlist1
                        });
                        string[]      jrr  = phone.Split(',');
                        string[]      brr  = jrr.Where(s => !string.IsNullOrEmpty(s)).ToArray(); //去掉空的手机号码
                        List <string> list = new List <string>();
                        foreach (string eachString in brr)                                       //去掉重复的电话号码
                        {
                            if (!list.Contains(eachString))
                            {
                                list.Add(eachString);
                            }
                        }
                        brr = list.ToArray();
                        for (int i = 0; i < brr.Length; i++)
                        {
                            if (i == brr.Length - 1)
                            {
                                phone1 += brr[i];
                            }
                            else
                            {
                                phone1 += brr[i] + ",";
                            }
                        }
                    }
                    string content = "您好:" + name + "在" + time + "给您发一封主题「" + title + "」邮件,请登陆森林保护信息指挥系统查阅!";
                    SmsHelp.SmsCom.SendMsg(content, phone1);
                    return(new Message(true, "发送成功", m.returnUrl));
                }
                //有附件的情况更新库
                if (string.IsNullOrEmpty(m.EMAILID) == false)
                {
                    BaseDT.E_SUBJECT.Mdy(m);
                    if (string.IsNullOrEmpty(m.EMAILRECUSERLIST) == false)
                    {
                        //接收信息表中录入数据 接收人
                        string[] arr = m.EMAILRECUSERLIST.Split(',');
                        for (int i = 0; i < arr.Length; i++)
                        {
                            BaseDT.E_RECEIVE.Add(new E_RECEIVE_Model
                            {
                                BYEMAILID          = m.EMAILID,
                                RECEIVETYPE        = "0",    //接收人类别
                                RECEIVEUSERID      = arr[i], //接收人序号
                                EMAILRECEIVESTATUS = "0",    //接收状态
                                EMAILSENDTIME      = m.EMAILTIME
                            });
                        }
                    }
                    if (string.IsNullOrEmpty(m.EMAILCOPYUSERLIST) == false)
                    {
                        //接收信息表中录入数据 抄送人
                        string[] arr = m.EMAILCOPYUSERLIST.Split(',');
                        for (int i = 0; i < arr.Length; i++)
                        {
                            BaseDT.E_RECEIVE.Add(new E_RECEIVE_Model
                            {
                                BYEMAILID          = m.EMAILID,
                                RECEIVETYPE        = "1",    //接收人类别
                                RECEIVEUSERID      = arr[i], //接收人序号
                                EMAILRECEIVESTATUS = "0",    //接收状态
                                EMAILSENDTIME      = m.EMAILTIME
                            });
                        }
                    }
                    if (string.IsNullOrEmpty(m.EMAILSECRETUSERLIST) == false)
                    {
                        //接收信息表中录入数据 密送人
                        string[] arr = m.EMAILSECRETUSERLIST.Split(',');
                        for (int i = 0; i < arr.Length; i++)
                        {
                            BaseDT.E_RECEIVE.Add(new E_RECEIVE_Model
                            {
                                BYEMAILID          = m.EMAILID,
                                RECEIVETYPE        = "2",    //接收人类别
                                RECEIVEUSERID      = arr[i], //接收人序号
                                EMAILRECEIVESTATUS = "0",    //接收状态
                                EMAILSENDTIME      = m.EMAILTIME
                            });
                        }
                        //发送短信
                        string   name      = SystemCls.getCookieInfo().trueName;
                        string   time      = PublicClassLibrary.ClsSwitch.SwitTM(DateTime.Now.ToString());
                        string   title     = m.EMAILTITLE;
                        string   userlist  = m.EMAILRECUSERLIST + "," + m.EMAILCOPYUSERLIST + "," + m.EMAILSECRETUSERLIST;
                        string[] crr       = userlist.Split(',');
                        string[] drr       = crr.Where(s => !string.IsNullOrEmpty(s)).ToArray(); //去掉空的用户id
                        string   userlist1 = "";                                                 //定义一个去掉空的uselist
                        for (int i = 0; i < drr.Length; i++)
                        {
                            if (i == drr.Length - 1)
                            {
                                userlist1 += drr[i];
                            }
                            else
                            {
                                userlist1 += drr[i] + ",";
                            }
                        }
                        string phone  = ""; //通过userlist获取手机号码
                        string phone1 = ""; //定义一个去掉空的号码
                        if (string.IsNullOrEmpty(userlist1) == false)
                        {
                            phone = BaseDT.T_SYSSEC_IPSUSER.getphone(new T_SYSSEC_IPSUSER_SW {
                                USERID = userlist1
                            });
                            string[]      jrr  = phone.Split(',');
                            string[]      brr  = jrr.Where(s => !string.IsNullOrEmpty(s)).ToArray(); //去掉空的手机号码
                            List <string> list = new List <string>();
                            foreach (string eachString in brr)                                       //去掉重复的电话号码
                            {
                                if (!list.Contains(eachString))
                                {
                                    list.Add(eachString);
                                }
                            }
                            brr = list.ToArray();
                            for (int i = 0; i < brr.Length; i++)
                            {
                                if (i == brr.Length - 1)
                                {
                                    phone1 += brr[i];
                                }
                                else
                                {
                                    phone1 += brr[i] + ",";
                                }
                            }
                        }
                        string content = "您好:" + name + "在" + time + "给您发一封主题「" + title + "」邮件,请登陆森林保护信息指挥系统查阅!";
                        SmsHelp.SmsCom.SendMsg(content, phone1);
                    }
                    return(new Message(true, "发送成功!", m.returnUrl));
                }
            }
            if (m.opMethod == "Mdy") //草稿箱的时候修改
            {
                Message msg = BaseDT.E_SUBJECT.Mdy(m);
                return(new Message(msg.Success, msg.Msg, m.returnUrl));
            }
            if (m.opMethod == "SendMdy") //涉及到多条记录的修改;已发送的列表
            {
                Message msg = BaseDT.E_SUBJECT.SendMdy(m);
                return(new Message(msg.Success, msg.Msg, m.returnUrl));
            }
            if (m.opMethod == "Del")
            {
                Message msgUser = BaseDT.E_SUBJECT.Del(m);
                return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl));
            }
            return(new Message(false, "无效操作!", ""));
        }
예제 #4
0
        /// <summary>
        /// 获取用户自定义菜单
        /// </summary>
        /// <param name="sw">参见T_SYS_MENU_SW</param>
        /// <returns>html代码</returns>
        public static string getT_SYS_DEFINEMENU(T_SYS_MENU_SW sw)
        {
            if (string.IsNullOrEmpty(sw.UID))
            {
                return("");
            }
            StringBuilder sb = new StringBuilder(1000);

            sb.AppendFormat(" FROM T_SYS_MENU WHERE 1=1");
            bool bln = DataBaseClass.JudgeRecordExists("SELECT MENUCODE FROM T_SYS_DEFINEMENU WHERE (UID=" + sw.UID + ") AND SYSFLAG='" + sw.SYSFLAG + "'");

            if (bln)
            {
                sb.AppendFormat(" AND MENUCODE IN (SELECT  MENUCODE FROM T_SYS_DEFINEMENU WHERE UID={0} AND SYSFLAG='{1}') ", sw.UID, sw.SYSFLAG);
                sb.AppendFormat(" AND MENURIGHTFLAG in (select RIGHTID from T_SYSSEC_ROLE_RIGHT where (ROLEID in (select ROLEID from T_SYSSEC_USER_ROLE where USERID={0} )) and roleid in(select roleid from T_SYSSEC_ROLE where SYSFLAG='{1}') )", getUserID(), ConfigCls.getSystemFlag());
            }
            else
            {
                sb.AppendFormat(" AND MENUCODE IN(SELECT   MENUCODE FROM T_SYS_DEFINEMENU WHERE  UID=0 AND SYSFLAG='{1}') ", sw.UID, sw.SYSFLAG);
            }
            string sql = "SELECT MENUID,MENUCODE,MENUNAME,MENUURL,MENUICO,LICLASS,ORDERBY,MENURIGHTFLAG,SYSFLAG   " + sb.ToString() + "  ";

            DataSet       ds  = DataBaseClass.FullDataSet(sql);
            StringBuilder sb1 = new StringBuilder();
            DataTable     dtR = BaseDT.T_IPSRPT_REPORT.getDT(new T_IPSRPT_REPORT_SW {
                MANSTATE = "0", orgNo = SystemCls.getCurUserOrgNo()
            });

            sb1.AppendFormat("<ul class=\"nav ace-nav\">");
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                string MENUCODE = ds.Tables[0].Rows[i]["MENUCODE"].ToString();
                string count    = "";
                switch (MENUCODE)
                {
                case "002001":
                    count = BaseDT.T_IPSRPT_REPORT.getCountByType(dtR, "1");
                    break;

                case "002002":
                    count = BaseDT.T_IPSRPT_REPORT.getCountByType(dtR, "2");
                    break;

                case "002003":
                    count = BaseDT.T_IPSRPT_REPORT.getCountByType(dtR, "3");
                    break;

                case "001004":
                    count = BaseDT.T_IPS_ALARM.getDT(new T_IPS_ALARM_SW {
                        orgNo = SystemCls.getCurUserOrgNo(), MANSTATE = "0"
                    }).Rows.Count.ToString();
                    break;

                case "001003":
                    count = BaseDT.T_IPS_HOTS.getDT(new T_IPS_HOTS_SW {
                        MANSTATE = "0"
                    }).Rows.Count.ToString();
                    break;

                default:
                    break;
                }
                if (count == "0")
                {
                    count = "";
                }
                string liclass = ds.Tables[0].Rows[i]["LICLASS"].ToString();
                if (string.IsNullOrEmpty(liclass))
                {
                    liclass = "light-blue";
                }
                sb1.AppendFormat("<li class=\"{0}\">", liclass);
                sb1.AppendFormat("    <a class=\"dropdown-toggle\" href=\"{0}\">", ds.Tables[0].Rows[i]["MENUURL"].ToString());
                if (string.IsNullOrEmpty(count) == false)
                {
                    sb1.AppendFormat("        <i class=\"{0}   icon-spin\"></i> {1}", ds.Tables[0].Rows[i]["MENUICO"].ToString(), ds.Tables[0].Rows[i]["MENUNAME"].ToString());
                    sb1.AppendFormat("    <span class=\"badge badge-important\">{0}</span>", count);
                }
                else
                {
                    sb1.AppendFormat("        <i class=\"{0}\"></i> {1}", ds.Tables[0].Rows[i]["MENUICO"].ToString(), ds.Tables[0].Rows[i]["MENUNAME"].ToString());
                }
                sb1.AppendFormat("    </a>");
                sb1.AppendFormat("</li>");
                //T_SYS_MENU_Model m = new T_SYS_MENU_Model();
                //m.MENUID = ds.Tables[0].Rows[i]["MENUID"].ToString();
                //m.MENUCODE = ds.Tables[0].Rows[i]["MENUCODE"].ToString();
                //m.MENUNAME = ds.Tables[0].Rows[i]["MENUNAME"].ToString();
                //m.MENUURL = ds.Tables[0].Rows[i]["MENUURL"].ToString();
                //m.MENUICO = ds.Tables[0].Rows[i]["MENUICO"].ToString();
                //m.ORDERBY = ds.Tables[0].Rows[i]["ORDERBY"].ToString();
                //m.MENURIGHTFLAG = ds.Tables[0].Rows[i]["MENURIGHTFLAG"].ToString();
                //m.SYSFLAG = ds.Tables[0].Rows[i]["SYSFLAG"].ToString();
                //result.Add(m);
            }
            CookieModel cookieInfo = SystemCls.getCookieInfo();//当前登录用户姓名

            sb1.AppendFormat(" <li class=\"light-blue\">");
            sb1.AppendFormat("  <a data-toggle=\"dropdown\" href=\"#\" class=\"dropdown-toggle\">");
            sb1.AppendFormat("      <img class=\"nav-user-photo\" src=\"../Content/themes/assets/avatars/user.jpg\" alt=\"Jason's Photo\" />");
            sb1.AppendFormat("      <span class=\"user-info\">");
            sb1.AppendFormat("          <small>欢迎光临,</small>");
            sb1.AppendFormat("          <font color=\"red\">{0}</font>", cookieInfo.trueName);
            sb1.AppendFormat("      </span>");

            sb1.AppendFormat("      <i class=\"icon-caret-down\"></i>");
            sb1.AppendFormat("  </a>");
            sb1.AppendFormat("  <ul class=\"user-menu pull-right dropdown-menu dropdown-yellow dropdown-caret dropdown-close\">");
            sb1.AppendFormat("      <li class=\"divider\"></li>");
            sb1.AppendFormat("      <li>");
            sb1.AppendFormat("          <a href=\"/System/LoginOut\">");
            sb1.AppendFormat("              <i class=\"icon-off\"></i>");
            sb1.AppendFormat("              退出");
            sb1.AppendFormat("          </a>");
            sb1.AppendFormat("      </li>");
            sb1.AppendFormat("  </ul>");
            sb1.AppendFormat("</li>");
            sb1.AppendFormat("</ul>");
            ds.Clear();
            dtR.Clear();
            dtR.Dispose();
            return(sb1.ToString());
        }