public static Task <DataTable> GetWebSiteAwait(string webGroupId) { return(Task <DataTable> .Run(() => { return WebsiteBLL.GetWebSiteAwait(webGroupId); })); }
public ActionResult GetWebGroup() { var data = WebsiteBLL.GetWebGroup(Session["LoginUser"].ToString()); var JsonString = JsonConvert.SerializeObject(data); return(Json(JsonString)); }
public static void UpateAccount(int iHour) { var sql = string.Format(@" update [user] set isSend1=1 where {0} between startHour1 and endHour1; update [user] set isSend2=1 where {0} between startHour2 and endHour2; update [user] set isSend3=1 where {0} between startHour3 and endHour3;", iHour); WebsiteBLL.ArticleBak(sql); AccountBLL.GetAllAccount(true); }
public ActionResult GetWebSite() { var id = Request["id"] == "undefined"? null : Request["id"]; if (Request["wid"] != null) { id = Request["wid"]; } var data = WebsiteBLL.GetWebsite(Session["LoginUser"].ToString(), id); var JsonString = JsonConvert.SerializeObject(data); return(Json(JsonString)); }
public ActionResult MyArticle() { var webGroupId = Request["webGroupId"]; var data = WebsiteBLL.GetAllArticleByUserId(Session["LoginUser"].ToString(), webGroupId); string body = string.Empty; foreach (DataRow dr in data.Rows) { body += string.Format("<tr><td>{0}</td><td>{1}</td><td>{2}</td></tr>", dr["title"].ToString(), dr["seoWord"].ToString(), dr["date"].ToString()); } ViewBag.body = body; ViewBag.bodyCount = data.Rows.Count; return(View()); }
public ActionResult SaveWebSite(FormCollection form) { var host = "http://" + (form["webHost"].Replace("http://", "").Replace("/", "")); var webAdminUrl = "/" + form["webAdminUrl"].Replace("http://", "").TrimEnd('/').TrimStart('/') + "/"; if (form["webPlatformId"] == "1") { webAdminUrl = webAdminUrl.TrimEnd('/'); } var imgPath = "/" + form["webImgPath"].Replace("http://", "").TrimEnd('/').TrimStart('/') + "/"; var msg = string.Empty; var id = form["id"]; JsonResult json = new JsonResult(); if (id == "") { var rows = WebsiteBLL.GetWebsiteByHost(host); if (!"0".Equals(rows)) { msg = "该网站已经存在"; return(JavaScript("alert('" + msg + "')")); } else { var row = WebsiteBLL.AddWebsite(form["webName"], form["username"], form["password"], webAdminUrl, host, form["webPlatformId"], form["categoryCode"], form["categoryName"], form["webCategoryid"], form["webGroupId"], form["WordKey"], form["kerUrls"], imgPath); if (row > 0) { json.Data = new { result = "true", id = id }; } } } else { var row = WebsiteBLL.UpdateWebsite(form["webName"], id, form["username"], form["password"], webAdminUrl, host, form["webPlatformId"], form["categoryCode"], form["categoryName"], form["webCategoryid"], form["webGroupId"], form["WordKey"], form["kerUrls"], imgPath); if (row > 0) { json.Data = new { result = "true", id = id }; } } return(json); }
public ActionResult Index() { var webCategory = WebsiteBLL.GetwebCategory(); var sbc = string.Empty; if (webCategory != null && webCategory.Rows.Count > 0) { foreach (DataRow dr in webCategory.Rows) { sbc += "<option value='" + dr["webCategoryCode"] + "'>" + dr["webCategoryName"] + "</option>"; } } ViewBag.webCategoryid = sbc; return(View()); }
public ActionResult SaveWebSiteGroup(FormCollection form) { var msg = string.Empty; var id = form["id"]; var name = form["txtGroupName"]; var count = form["txtCount"]; var pareId = form["pareId"] == null?"0" : form["pareId"]; JsonResult json = new JsonResult(); if (id == "") { var rows = WebsiteBLL.GetWebsiteGroupByName(name); if (!"0".Equals(rows)) { msg = "该网站分组已经存在"; return(JavaScript("alert('" + msg + "')")); } else { var row = WebsiteBLL.AddWebsiteGroup(name, pareId, Session["LoginUser"].ToString(), count); if (row > 0) { json.Data = new { result = "true" }; } } } else { var row = WebsiteBLL.UpDateWebsiteGroup(name, id, count); if (row > 0) { json.Data = new { result = "true" }; } } return(json); }
public ActionResult DeleteWebKey(string id) { var data = WebsiteBLL.DeleteWebKey(id); JsonResult json = new JsonResult(); if (data > 0) { json.Data = new { result = "true" }; } else { json.Data = new { result = "false" }; } return(json); }
public ActionResult loginTest(string id) { var data = WebsiteBLL.GetWebsiteByid(id); var login = WebsiteBLL.loginTest(data.Rows[0]); JsonResult json = new JsonResult(); if (login) { json.Data = new { result = "true" }; } else { json.Data = new { result = "false" }; } return(json); }
public static string AutoWebSit(int contextNum, string userId, DataTable webData, int iHour, string webGroupId, int contextCount) { if (webData != null && webData.Rows.Count > 0) { var sql = string.Empty; var contextDataTable = WebsiteBLL.GetAllArticleByIsRead(contextNum, userId, webGroupId); if (contextDataTable != null && contextDataTable.Rows.Count > 0 && webData != null && webData.Rows.Count > 0) { foreach (DataRow context in contextDataTable.Rows) { int i = 0; foreach (DataRow h in webData.Rows) { if (i >= contextCount || i > webData.Rows.Count) { sql += string.Format(@"insert into articleBak([title],[seoWord],[content],[IsImage],[websitCategory],[contentCategoryName] ,[contentCategoryId],[userid],[date],[isRead],[webGroupid]) select [title],[seoWord],[content],[IsImage],[websitCategory],[contentCategoryName] ,[contentCategoryId],[userid],GETDATE() ,[isRead],[webGroupid] from article where article.id = {0} ;delete from article where id ={0} ;", context["id"].ToString()); break; } i++; Task.Factory.StartNew(() => { var webKeyWords = WebsiteBLL.GetWebKey(h["id"].ToString()); if (h["webPlatformId"].ToString() == "1") { var cookieTask = GetCookie(h["loginName"].ToString(), h["loginPassword"].ToString(), h["webHost"].ToString(), h["webAdminUrl"].ToString()); cookieTask.Wait(); if (cookieTask.Result != null && cookieTask.Result != "") { var webWords = string.Empty; var content = WebsiteBLL.GetWebContext(webKeyWords, context["content"].ToString(), h["webImgPath"].ToString(), out webWords); var task = AutoRelease6System(cookieTask.Result, h["webCategoryCode"].ToString(), h["sixHost"].ToString(), h["categoryCode"].ToString(), context["title"].ToString(), webWords, content, null); if (task.Result.IndexOf("发布成功") < 0) { Thread.Sleep(1000); task = AutoRelease6System(cookieTask.Result, h["webCategoryCode"].ToString(), h["sixHost"].ToString(), h["categoryCode"].ToString(), context["title"].ToString(), webWords, content, null); } } } else { var cookieTask = GetECMSCookie(h["loginName"].ToString(), h["loginPassword"].ToString(), h["webHost"].ToString(), h["webAdminUrl"].ToString()); cookieTask.Wait(); if (cookieTask.Result != null && cookieTask.Result.Count > 0) { var cookie = cookieTask.Result; var webWords = string.Empty; var content = WebsiteBLL.GetWebContext(webKeyWords, context["content"].ToString(), h["webImgPath"].ToString(), out webWords); var task = AutoReleaseECMS(cookie[0], cookie[1], cookie[2], cookie[3], h["webCategoryCode"].ToString(), h["webHost"].ToString(), h["categoryCode"].ToString(), context["title"].ToString(), webWords, content, h["webAdminUrl"].ToString(), null); if (task.Result.IndexOf("增加信息成功") < 0) { Thread.Sleep(1000); task = AutoReleaseECMS(cookie[0], cookie[1], cookie[2], cookie[3], h["webCategoryCode"].ToString(), h["webHost"].ToString(), h["categoryCode"].ToString(), context["title"].ToString(), webWords, content, h["webAdminUrl"].ToString(), null); } } } }); } } WebsiteBLL.ArticleBak(sql); } } return(string.Empty); }
public ActionResult AddWebSite() { var id = Request["id"]; ViewBag.webGroupId = Request["Gid"]; var webPlatform = WebsiteBLL.GetwebPlatform(); var webCategory = WebsiteBLL.GetwebCategory(); if (id != null) { var dt = WebsiteBLL.GetWebsiteByid(id); if (dt != null && dt.Rows.Count > 0) { var keyNames = string.Join(",", dt.AsEnumerable().Select(d => d.Field <string>("keyName")).ToArray()); var keyUrls = string.Join(",", dt.AsEnumerable().Select(d => d.Field <string>("keyUrl")).ToArray()); var webData = dt.Rows[0]; ViewBag.webName = webData["webName"]; ViewBag.loginName = webData["loginName"]; ViewBag.loginPassword = webData["loginPassword"]; ViewBag.webHost = webData["webHost"]; ViewBag.categoryCode = webData["categoryCode"]; ViewBag.categoryName = webData["categoryName"]; ViewBag.id = webData["id"]; ViewBag.webAdminUrl = webData["webAdminUrl"]; ViewBag.WordKey = keyNames; ViewBag.WordUrl = keyUrls; ViewBag.webGroupId = webData["webGroupId"]; ViewBag.webImgPath = webData["webImgPath"]; var wu = string.Empty; if (keyNames != "") { foreach (DataRow dr in dt.Rows) { wu += "<tr><td>" + dr["keyName"] + "</td><td>" + dr["keyUrl"] + "</td><td><a href='#' onclick='DeleteWebKey(this)'>删除</a></td></tr>"; } ViewBag.keylist = wu; } var sb = string.Empty; if (webPlatform != null && webPlatform.Rows.Count > 0) { foreach (DataRow dr in webPlatform.Rows) { if (dr["id"].ToString() == webData["webPlatformId"].ToString()) { sb += "<option value='" + dr["id"] + "' selected='selected'>" + dr["webPlatformName"] + "</option>"; continue; } sb += "<option value='" + dr["id"] + "'>" + dr["webPlatformName"] + "</option>"; } } ViewBag.webPlatformId = sb; var sbc = string.Empty; if (webCategory != null && webCategory.Rows.Count > 0) { foreach (DataRow dr in webCategory.Rows) { if (dr["id"].ToString() == webData["webCategoryId"].ToString()) { sbc += "<option value='" + dr["id"] + "' selected='selected'>" + dr["webCategoryName"] + "</option>"; continue; } sbc += "<option value='" + dr["id"] + "'>" + dr["webCategoryName"] + "</option>"; } } ViewBag.webCategoryid = sbc; } } else { var sb = string.Empty; if (webPlatform != null && webPlatform.Rows.Count > 0) { foreach (DataRow dr in webPlatform.Rows) { sb += "<option value='" + dr["id"] + "'>" + dr["webPlatformName"] + "</option>"; } } ViewBag.webPlatformId = sb; var sbc = string.Empty; if (webCategory != null && webCategory.Rows.Count > 0) { foreach (DataRow dr in webCategory.Rows) { sbc += "<option value='" + dr["id"] + "'>" + dr["webCategoryName"] + "</option>"; } } ViewBag.webCategoryid = sbc; } return(View()); }