示例#1
0
        public int RecordToDatabase(DataTable dt, string userName)
        {
            int count = 0;

            //写入数据库
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                SM.YuQing.BLL.MonitorInfos   bll         = new SM.YuQing.BLL.MonitorInfos();
                SM.YuQing.Model.MonitorInfos monitorInfo = new SM.YuQing.Model.MonitorInfos();
                monitorInfo.Title       = dt.Rows[i]["Title"].ToString();
                monitorInfo.PublishDate = dt.Rows[i]["PublishDate"].ToString() == "" ? DateTime.Now : Convert.ToDateTime(dt.Rows[i]["PublishDate"].ToString());
                monitorInfo.ViewsCounts = dt.Rows[i]["ViewsCounts"].ToString() == "" ? 0 : Convert.ToInt32(dt.Rows[i]["ViewsCounts"].ToString());
                int regionid = dt.Rows[i]["RegionID"].ToString() == "" ? 0 : Convert.ToInt32(dt.Rows[i]["RegionID"].ToString());
                monitorInfo.RegionID     = regionid;
                monitorInfo.MonitorUrl   = dt.Rows[i]["MonitorUrl"].ToString();
                monitorInfo.Keyword      = dt.Rows[i]["Keyword"].ToString();
                monitorInfo.Url          = dt.Rows[i]["Url"].ToString();
                monitorInfo.Property     = "";
                monitorInfo.CreatePerson = userName;
                monitorInfo.CreateTime   = DateTime.Now;
                monitorInfo.UpdatePerson = userName;
                monitorInfo.UpdateTime   = DateTime.Now;

                if (!bll.Exists(dt.Rows[i]["Url"].ToString(), regionid))  //存在此Url+RegionID
                {
                    bll.Add(monitorInfo);
                    count++;
                }
            }
            return(count);
        }
示例#2
0
        private DataTable GetDataRow(DataTable dt, SM.YuQing.Model.Regions region, string reg, string strWhere)
        {
            int positive = 0, negative = 0, neutral = 0, empty = 0;

            try
            {
                DataRow dr = dt.NewRow();
                dr["Region"] = region == null?reg:region.Mall;

                SM.YuQing.BLL.MonitorInfos          monitorInfoBll  = new SM.YuQing.BLL.MonitorInfos();
                List <SM.YuQing.Model.MonitorInfos> monitorInfoList = monitorInfoBll.GetModelList(strWhere + " and Keyword like \'SM\'");
                foreach (SM.YuQing.Model.MonitorInfos monitorInfo in monitorInfoList)
                {
                    switch (monitorInfo.Property)
                    {
                    case "正面":
                        positive++;
                        break;

                    case "负面":
                        negative++;
                        break;

                    case "中性":
                        neutral++;
                        break;

                    case "":
                        empty++;
                        break;
                    }
                }
                dr["Positive"] = positive.ToString();
                dr["Negative"] = negative.ToString();
                dr["Neutral"]  = neutral.ToString();
                dr["Empty"]    = empty.ToString();
                dr["Total"]    = (positive + negative + neutral + empty).ToString();
                dt.Rows.Add(dr);
            }
            catch (Exception ex)
            {
                DataRow dr = dt.NewRow();
                dr["Region"]   = "Error in GetDataRow():" + ex.Message;;
                dr["Positive"] = "";
                dr["Negative"] = "";
                dr["Neutral"]  = "";
                dr["Empty"]    = "";
                dr["Total"]    = "";
                dt.Rows.Add(dr);
            }
            return(dt);
        }
示例#3
0
        public void ProcessRequest(HttpContext context)
        {
            string id = context.Request.Form["id"];

            context.Response.ContentType = "text/plain";
            context.Response.Cache.SetNoStore();

            SM.YuQing.Accounts.SiteIdentity identity = (SM.YuQing.Accounts.SiteIdentity)(new SM.YuQing.Accounts.AccountsPrincipal(context.User.Identity.Name)).Identity;
            int personid = identity.FID;

            SM.YuQing.BLL.Regions   bll    = new SM.YuQing.BLL.Regions();
            SM.YuQing.Model.Regions region = bll.GetModel(Convert.ToInt32(id));
            string mall = region.Mall;

            bool success;

            SM.YuQing.BLL.MonitorWebs  webBll  = new SM.YuQing.BLL.MonitorWebs();
            SM.YuQing.BLL.MonitorInfos infoBll = new SM.YuQing.BLL.MonitorInfos();
            if (!bll.ExistRegion(Convert.ToInt32(id), personid) && !webBll.ExistRegion(Convert.ToInt32(id)) && !infoBll.ExistRegion(Convert.ToInt32(id)))
            {
                bll.Delete(Convert.ToInt32(id));
                bll.DeletePersonRegion(personid, Convert.ToInt32(id));
                success = true;
            }
            else
            {
                success = false;
            }

            Hashtable ht = new Hashtable();

            if (success)
            {
                SM.YuQing.Model.Log log = new SM.YuQing.Model.Log();
                log.LogType    = "操作";
                log.Message    = context.User.Identity.Name + " 删除了区域 " + mall;
                log.IP         = context.Request.UserHostAddress;
                log.MenuID     = 0;
                log.PersonID   = personid;
                log.CreateTime = DateTime.Now;
                SM.YuQing.BLL.Log logBll = new SM.YuQing.BLL.Log();
                logBll.Add(log);

                ht.Add("success", true);
            }
            else
            {
                ht.Add("errorMsg", "该区域已有关联监测数据,不允许删除");
            }
            context.Response.Write(JsonConvert.SerializeObject(ht));
        }
示例#4
0
        public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType = "text/plain";
            context.Response.Cache.SetNoStore();

            string id       = context.Request.QueryString["id"];
            string property = context.Request.Form["property"];
            bool   success;

            SM.YuQing.BLL.MonitorInfos   bll         = new SM.YuQing.BLL.MonitorInfos();
            SM.YuQing.Model.MonitorInfos monitorInfo = bll.GetModel(Convert.ToInt32(id));
            string oldProperty = monitorInfo.Property;

            monitorInfo.Property     = property;
            monitorInfo.UpdatePerson = context.User.Identity.Name;
            monitorInfo.UpdateTime   = DateTime.Now;

            success = bll.Update(monitorInfo);

            Hashtable ht = new Hashtable();

            if (success)
            {
                SM.YuQing.Accounts.SiteIdentity identity = (SM.YuQing.Accounts.SiteIdentity)(new SM.YuQing.Accounts.AccountsPrincipal(context.User.Identity.Name)).Identity;
                int personid = identity.FID;

                SM.YuQing.Model.Log log = new SM.YuQing.Model.Log();
                log.LogType    = "操作";
                log.Message    = context.User.Identity.Name + " 保存了ID=" + id + "的监测记录的性质为 " + property + " (原性质为 " + (oldProperty == "" ? "空" : oldProperty) + " )";
                log.IP         = context.Request.UserHostAddress;
                log.MenuID     = 0;
                log.PersonID   = personid;
                log.CreateTime = DateTime.Now;
                SM.YuQing.BLL.Log logBll = new SM.YuQing.BLL.Log();
                logBll.Add(log);

                ht.Add("success", true);
            }
            else
            {
                ht.Add("errorMsg", "Some errors occured.");
            }
            context.Response.Write(JsonConvert.SerializeObject(ht));
        }
示例#5
0
        void Global_ExecuteTask(object sender, System.Timers.ElapsedEventArgs e)
        {
            SM.YuQing.BLL.Regions          bllRegions = new SM.YuQing.BLL.Regions();
            List <SM.YuQing.Model.Regions> regions    = bllRegions.GetModelList("");

            SM.YuQing.BLL.MonitorInfos bllInfos = new SM.YuQing.BLL.MonitorInfos();

            SM.YuQing.BLL.Config bllConfig = new SM.YuQing.BLL.Config();
            int searchLevel = bllConfig.GetSearchLevels();

            foreach (SM.YuQing.Model.Regions region in regions)
            {
                //每天下午16点监测一次
                if (DateTime.Now.Hour == 16)
                {
                    bllInfos.GetMonitorInfos(region, region.Keyword, searchLevel);
                }

                //每小时监测一次
                bllInfos.GetMonitorInfos(region, "SM", searchLevel);
            }

            //foreach (SM.YuQing.Model.MonitorInfos item in infos)
            //{
            //    bllInfos.Add(item);
            //}

            //SM.YuQing.BLL.MonitorWebs bllwebs = new SM.YuQing.BLL.MonitorWebs();
            ////SM.YuQing.Model.MonitorWebs modelwebs = bllwebs.GetModel(7);
            //List<SM.YuQing.Model.MonitorWebs> webs = bllwebs.GetModelList("");
            //SM.YuQing.BLL.MonitorInfos bllinfos = new SM.YuQing.BLL.MonitorInfos();
            //List<SM.YuQing.Model.MonitorInfos> infos = bllinfos.GetMonitorInfos(webs, "SM");
            //foreach (SM.YuQing.Model.MonitorInfos item in infos)
            //{
            //    bllinfos.Add(item);
            //}
        }
示例#6
0
        public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType = "text/plain";
            context.Response.Cache.SetNoStore();

            string regionid = context.Request.QueryString["regionid"], reg = "";
            string beginDate = context.Request.QueryString["beginDate"];
            string endDate   = context.Request.QueryString["endDate"];
            string property  = context.Request.QueryString["property"];
            string func      = context.Request.QueryString["func"];

            if (regionid == "" || regionid.Contains("-1"))
            {
                GetRegionIdHelper grih = new GetRegionIdHelper();
                regionid = grih.GetRegionID();
            }

            DataTable dt = new DataTable();

            dt.Columns.Add("ID");
            dt.Columns.Add("Title");
            dt.Columns.Add("PublishDate");
            dt.Columns.Add("ViewsCounts");
            dt.Columns.Add("Region");
            dt.Columns.Add("Property");
            dt.Columns.Add("Url");

            try
            {
                string    strWhere     = "";
                ArrayList strWhereList = new ArrayList();

                strWhereList.Add(" RegionID in (" + regionid + ")");
                strWhereList.Add(" Keyword like \'SM\'");

                if (beginDate != "" && endDate != "")
                {
                    strWhereList.Add(" PublishDate>=\'" + beginDate + "\' and PublishDate<=\'" + endDate + " 23:59:59.999\'");
                }
                if (property != "" && !property.Contains("全部"))
                {
                    //strWhereList.Add(" Property=N\'" + (property == "空" ? "" : property) + "\'");
                    //" (Property=N\'" + (p == "空" ? "" : p) + "\' or Property=N\'" + p + "\'")
                    string[] props  = property.Split(',');
                    string   tmpSql = "";
                    foreach (string p in props)
                    {
                        tmpSql += " or Property=N\'" + (p == "空" ? "" : p) + "\'";
                    }
                    tmpSql = tmpSql.Substring(tmpSql.IndexOf("or") + 2, tmpSql.Length - 3);
                    strWhereList.Add(" (" + tmpSql + ") ");
                }

                switch (strWhereList.Count)
                {
                case 2:
                    strWhere = strWhereList[0].ToString() + " and " + strWhereList[1].ToString();
                    break;

                case 3:
                    strWhere = strWhereList[0].ToString() + " and " + strWhereList[1].ToString() + " and " + strWhereList[2].ToString();
                    break;

                case 4:
                    strWhere = strWhereList[0].ToString() + " and " + strWhereList[1].ToString() + " and " + strWhereList[2].ToString() + " and " + strWhereList[3].ToString();
                    break;

                default:
                    break;
                }

                SM.YuQing.BLL.MonitorInfos          monitorInfoBll  = new SM.YuQing.BLL.MonitorInfos();
                List <SM.YuQing.Model.MonitorInfos> monitorInfoList = monitorInfoBll.GetModelList(strWhere);
                foreach (SM.YuQing.Model.MonitorInfos monitorInfo in monitorInfoList)
                {
                    DataRow dr = dt.NewRow();
                    dr["ID"]          = monitorInfo.ID;
                    dr["Title"]       = monitorInfo.Title;
                    dr["PublishDate"] = monitorInfo.PublishDate.ToString("yyyy-MM-dd");
                    dr["ViewsCounts"] = monitorInfo.ViewsCounts;
                    if (monitorInfo.RegionID > 0)
                    {
                        SM.YuQing.BLL.Regions   regionBll = new SM.YuQing.BLL.Regions();
                        SM.YuQing.Model.Regions region    = regionBll.GetModel(Convert.ToInt32(monitorInfo.RegionID));
                        reg = region.Mall;
                    }
                    else
                    {
                        reg = "";
                    }
                    dr["Region"]   = reg;
                    dr["Property"] = monitorInfo.Property;
                    dr["Url"]      = monitorInfo.Url;
                    dt.Rows.Add(dr);
                }

                if (dt.Rows.Count == 0)
                {
                    DataRow dr = dt.NewRow();
                    dr["ID"]          = "";
                    dr["Title"]       = "未查询到数据";
                    dr["PublishDate"] = "";
                    dr["ViewsCounts"] = "";
                    dr["Region"]      = "";
                    dr["Property"]    = "";
                    dr["Url"]         = "";
                    dt.Rows.Add(dr);
                }

                //context.Response.Write("<script>lert(\'ManageInfos.DoSearch\');</script>");
            }
            catch (Exception ex)
            {
                throw ex;
                //DataRow dr = dt.NewRow();
                //dr["ID"] = "";
                //dr["Title"] = "Error in ProcessRequest():" + ex.Message;
                //dr["PublishDate"] = "";
                //dr["ViewsCounts"] = "";
                //dr["Region"] = "";
                //dr["Property"] = "";
                //dr["Url"] = "";
                //dt.Rows.Add(dr);
            }

            if (func == "1")  //导出excel
            {
                ExportToExcelHelper eteh = new ExportToExcelHelper();
                eteh.ExportToExcel(dt, "ManageInfoResult.xls", "[监测管理] -> [监测数据管理]");
            }
            else
            {
                context.Response.Write(JsonConvert.SerializeObject(dt));
            }
        }
示例#7
0
        public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType = "text/plain";
            context.Response.Cache.SetNoStore();

            string regionid = context.Request.QueryString["regionid"], reg = "";
            string beginDate = context.Request.QueryString["beginDate"];
            string endDate   = context.Request.QueryString["endDate"];
            string keyword   = context.Request.QueryString["keyword"];
            string func      = context.Request.QueryString["func"];

            if (regionid == "" || regionid.Contains("-1"))
            {
                GetRegionIdHelper grih = new GetRegionIdHelper();
                regionid = grih.GetRegionID();
            }

            DataTable dt = new DataTable();

            dt.Columns.Add("ID");
            dt.Columns.Add("Title");
            dt.Columns.Add("PublishDate");
            dt.Columns.Add("ViewsCounts");
            dt.Columns.Add("Keyword");
            dt.Columns.Add("Region");
            dt.Columns.Add("Url");

            try
            {
                string    strWhere     = "";
                ArrayList strWhereList = new ArrayList();

                if (beginDate != "" && endDate != "")
                {
                    strWhereList.Add(" PublishDate>=\'" + beginDate + "\' and PublishDate<=\'" + endDate + " 23:59:59.999\'");
                }
                if (regionid != "")
                {
                    strWhereList.Add(" RegionID in (" + regionid + ")");
                }
                if (keyword != "")
                {
                    strWhereList.Add(" Keyword like N\'%" + keyword + "%\'");
                }

                switch (strWhereList.Count)
                {
                case 1:
                    strWhere = strWhereList[0].ToString();
                    break;

                case 2:
                    strWhere = strWhereList[0].ToString() + " and " + strWhereList[1].ToString();
                    break;

                case 3:
                    strWhere = strWhereList[0].ToString() + " and " + strWhereList[1].ToString() + " and " + strWhereList[2].ToString();
                    break;

                default:
                    break;
                }

                SM.YuQing.BLL.MonitorInfos          monitorInfoBll  = new SM.YuQing.BLL.MonitorInfos();
                List <SM.YuQing.Model.MonitorInfos> monitorInfoList = monitorInfoBll.GetModelList(strWhere);
                foreach (SM.YuQing.Model.MonitorInfos monitorInfo in monitorInfoList)
                {
                    DataRow dr = dt.NewRow();
                    dr["ID"]          = monitorInfo.ID;
                    dr["Title"]       = monitorInfo.Title;
                    dr["PublishDate"] = monitorInfo.PublishDate.ToString("yyyy-MM-dd");
                    dr["ViewsCounts"] = monitorInfo.ViewsCounts;
                    dr["Keyword"]     = monitorInfo.Keyword;
                    if (monitorInfo.RegionID > 0)
                    {
                        SM.YuQing.BLL.Regions   regionBll = new SM.YuQing.BLL.Regions();
                        SM.YuQing.Model.Regions region    = regionBll.GetModel(Convert.ToInt32(monitorInfo.RegionID));
                        reg = region.Mall;
                    }
                    else
                    {
                        reg = "";
                    }
                    dr["Region"] = reg;
                    dr["Url"]    = monitorInfo.Url;
                    dt.Rows.Add(dr);
                }

                if (dt.Rows.Count == 0)
                {
                    DataRow dr = dt.NewRow();
                    dr["ID"]          = "";
                    dr["Title"]       = "未查询到数据";
                    dr["PublishDate"] = "";
                    dr["ViewsCounts"] = "";
                    dr["Keyword"]     = "";
                    dr["Region"]      = "";
                    dr["Url"]         = "";
                    dt.Rows.Add(dr);
                }
            }
            catch (Exception ex)
            {
                throw ex;
                //DataRow dr = dt.NewRow();
                //dr["Title"] = "Error in ProcessRequest():" + ex.Message;
                //dr["PublishDate"] = "";
                //dr["ViewsCounts"] = "";
                //dr["Keyword"] = "";
                //dr["Region"] = "";
                //dr["Url"] = "";
                //dt.Rows.Add(dr);
            }

            if (func == "1")  //导出excel
            {
                ExportToExcelHelper eteh = new ExportToExcelHelper();
                eteh.ExportToExcel(dt, "IndustryResult.xls", "[监测管理] -> [行业监测]");
            }
            else
            {
                context.Response.Write(JsonConvert.SerializeObject(dt));
            }
        }