public string UpdateMaterial(HttpContext context)
{
string strResult;
string value = context.Request["Value"];
int id = !string.IsNullOrWhiteSpace(context.Request["id"]) ? Convert.ToInt32(context.Request["id"]) : 0;
try
{
using (var db = new UdowsYunPublicEntities())
{
MaterialInfo mi = db.MaterialInfo.Find(id);
if (mi != null)
{
mi.Value = value;
}
db.SaveChanges();
strResult = "{ \"result\": true,\"msg\":\"修改成功!\"}";
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return(strResult);
}
public string SelDownMaterial(HttpContext context)
{
string result = "";
try
{
var user = RequestSession.GetSessionUser();
if (user != null)
{
using (var db = new UdowsYunPublicEntities())
{
List <Material> list = db.Material.Where(p => p.companyId == user.CompanyId && p.IsDelete == 0).ToList();
if (list.Any())
{
result = JsonConvert.SerializeObject(list);
}
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return(result);
}
public string TaskManagement(HttpContext context)
{
string result = "";
try
{
var user = RequestSession.GetSessionUser();
if (user != null)
{
using (var db = new UdowsYunPublicEntities())
{
List <PublishRule> list = db.PublishRule.Where(p => p.companyId == user.CompanyId).ToList();
if (list.Any())
{
result = JsonConvert.SerializeObject(list);
}
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return(result);
}
public string Select(HttpContext context)
{
string strResult = "";
try
{
var user = RequestSession.GetSessionUser();
if (user != null)
{
using (var db = new UdowsYunPublicEntities())
{
string newsLabel = "";
var n = db.Company.Where(p => p.userId == user.id).ToList();
if (n.Any())
{
strResult = JsonConvert.SerializeObject(n);
}
}
}
else
{
strResult = "";
}
}
catch (DbEntityValidationException e)
{
LogHelper lh = new LogHelper();
lh.WriteLog(e.EntityValidationErrors.ToString());
strResult = "";
}
return(strResult);
}
public string SelDownType(HttpContext context)
{
string result = "";
try
{
var user = RequestSession.GetSessionUser();
if (user != null)
{
using (var db = new UdowsYunPublicEntities())
{
List <InfoType> list = db.InfoType.ToList();
if (list.Any())
{
result = JsonConvert.SerializeObject(list);
}
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return(result);
}
public string RankStatistics(HttpContext context)
{
string result = "";
try
{
var user = RequestSession.GetSessionUser();
pageNum = Convert.ToInt32(context.Request["limit"]);
PageSize = Convert.ToInt32(context.Request["page"]);
if (user != null)
{
using (var db = new UdowsYunPublicEntities())
{
string sql = @"select * from (select row_number() over (order by id) as rn,* from ( select a.id,a.keyword as name,b.name as urlname, a.ranking as paiming,'' as returnurl from KeywordRanking a
left join engines b
on a.engineid = b.id
where a.companyid = " + user.CompanyId + " and ranking <> '' and ranking is not null) t ) t where rn between (" + PageSize + "-1) * " + pageNum + " + 1 and " + PageSize + " * " + pageNum;
List <GetTail> list = db.Database.SqlQuery <GetTail>(sql).ToList();
if (list.Count > 0)
{
foreach (var item in list)
{
switch (item.urlname)
{
case "百度":
item.returnurl = "https://www.baidu.com/s?wd=" + item.name;
break;
case "百度移动":
item.returnurl = "https://m.baidu.com/s?word=" + item.name;
break;
default:
break;
}
}
result = "{\"code\":0,\"msg\":\"\",\"count\":" + db.KeywordRanking.Count(p => p.companyId == user.CompanyId && p.ranking != "" && p.ranking != null) + ",\"data\":" + JsonConvert.SerializeObject(list) + "}";
}
else
{
result = "{\"code\":0,\"msg\":\"\",\"count\":0,\"data\":\"\"}";
}
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return(result);
}
public string UpdateImage(HttpContext context)
{
var user = RequestSession.GetSessionUser();
string result = "";
try
{
var tag = context.Request["images"];
if (user != null)
{
string goodspath = ConfigurationManager.AppSettings["ImgUmasMapSrc"] + user.CompanyId + "\\";
string Webpath = ConfigurationManager.AppSettings["ImgUmasWebSrc"] + user.CompanyId + "/";
if (!string.IsNullOrEmpty(tag))
{
string path = Base64ToImage("data:image/jpeg;base64," + tag).Replace("\\", "/");
user = RequestSession.GetSessionUser();
if (user != null)
{
using (var db = new UdowsYunPublicEntities())
{
var id = db.Company.Where(p => p.userId == user.id).ToList();
foreach (var vals in id)
{
ApiSoapClient a = new ApiSoapClient();
string json = a.UploadLicense(vals.id, ImgaeFoByte(path));
ImgTag it = JsonConvert.DeserializeObject <ImgTag>(json);
if (it != null)
{
if (it.result == 1)
{
result = "{ \"code\": 0,\"msg\": \"\",\"data\": {\"src\": \"" + Webpath + it.name + "\"}}";
}
}
}
}
}
}
else
{
result = "{ \"code\": 1,\"msg\": \"\",\"data\": {\"src\": \"\"}}";
}
}
}
catch (Exception ex)
{
LogHelper lh = new LogHelper();
lh.WriteLog(ex.Message);
throw;
}
return(result);
}
public string SelInfoList(HttpContext context)
{
string result = "";
try
{
var user = RequestSession.GetSessionUser();
pageNum = Convert.ToInt32(context.Request["limit"]);
PageSize = Convert.ToInt32(context.Request["page"]);
if (user != null)
{
using (var db = new UdowsYunPublicEntities())
{
string sql = @"select * from (select row_number() over (order by id desc) as rn,* from (select a.id,'http://pic03.uz360.cn/UmassWebPageImage/'+b.imgPath as imgPath,c.name as b2bName,a.url,CONVERT(varchar(100), DATEADD(s,a.createTime, '1970-01-01 08:00:00'), 20) as createTime,b.title,'推送成功' as Start,a.b2bId,'' as b2bUrl from SuccessInfo a
left join Info b
on a.infoId = b.id
left join B2B c
on a.b2bId = c.id
where a.companyId = " + user.CompanyId + ") t ) t where rn between (" + PageSize + "-1) * " + pageNum + " + 1 and " + PageSize + " * " + pageNum;
List <GetInfo> list = db.Database.SqlQuery <GetInfo>(sql).ToList();
if (list.Count > 0)
{
ApiSoapClient a = new ApiSoapClient();
foreach (var val in list)
{
if (val.url.IndexOf('|') > 0)
{
val.url = val.url.Substring(0, val.url.IndexOf('|'));
}
if (val.b2bId == 2 || val.b2bId == 3 || val.b2bId == 5 || val.b2bId == 6 || val.b2bId == 8 || val.b2bId == 10)
{
val.b2bUrl = a.GetLoginUrl(Convert.ToInt32(user.CompanyId), val.b2bId);
}
}
result = "{\"code\":0,\"msg\":\"\",\"count\":" + db.SuccessInfo.Count(p => p.companyId == user.CompanyId) + ",\"data\":" + JsonConvert.SerializeObject(list) + "}";
}
else
{
result = "{\"code\":0,\"msg\":\"\",\"count\":0,\"data\":\"\"}";
}
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return(result);
}
public string AddMaterial(HttpContext context)
{
string strResult = "";
string value = context.Request["contele"];
int id = !string.IsNullOrWhiteSpace(context.Request["id"]) ? Convert.ToInt32(context.Request["id"]) : 0;
try
{
var user = RequestSession.GetSessionUser();
if (user != null)
{
using (var db = new UdowsYunPublicEntities())
{
int?started = db.Company.Find(user.CompanyId)?.stateId;
if (started == null || started != 2)
{
return("{ \"result\": false,\"msg\": \"审核没有通过!\"}");
}
int num = db.MaterialInfo.Count(p => p.M_id == id);
if (num < 50)
{
MaterialInfo mi = new MaterialInfo
{
M_id = id,
Value = value,
IsDelete = 0,
Start = 1
};
db.MaterialInfo.Add(mi);
db.SaveChanges();
strResult = "{ \"result\": true,\"msg\":\"添加成功!\"}";
}
else
{
strResult = "{ \"result\": false,\"msg\":\"不可超过50条!\"}";
}
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return(strResult);
}
public string SourceMaterialList(HttpContext context)
{
string result = "";
try
{
DataTable dt = new DataTable();
dt.Columns.Add("id");
dt.Columns.Add("Title");
dt.Columns.Add("MNum");
dt.Columns.Add("Num");
var user = RequestSession.GetSessionUser();
pageNum = Convert.ToInt32(context.Request["limit"]);
PageSize = Convert.ToInt32(context.Request["page"]);
if (user != null)
{
using (var db = new UdowsYunPublicEntities())
{
List <Material> list = db.Material.Where(p => p.companyId == user.CompanyId && p.IsDelete == 0).OrderByDescending(p => p.id).Skip((PageSize - 1) * PageSize).Take(pageNum).ToList();
if (list.Any())
{
foreach (var val in list)
{
DataRow dr = dt.NewRow();
dr["id"] = val.id;
dr["Title"] = val.title;
dr["MNum"] = db.Info.Count(p => p.materialId == val.id);
dr["Num"] = db.MaterialInfo.Count(p => p.M_id == val.id);
dt.Rows.Add(dr);
}
}
result = "{\"code\":0,\"msg\":\"\",\"count\":" + db.Material.Count(p => p.companyId == user.CompanyId) + ",\"data\":" + JsonConvert.SerializeObject(dt) + "}";
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return(result);
}
public string DeleteMaterialInfo(HttpContext context)
{
string strReult = "";
var user = RequestSession.GetSessionUser();
if (user != null)
{
int id = !string.IsNullOrWhiteSpace(context.Request["id"]) ? Convert.ToInt32(context.Request["id"]) : 0;
using (var db = new UdowsYunPublicEntities())
{
MaterialInfo mi = db.MaterialInfo.Find(id);
mi.IsDelete = 1;
mi.DeleteTime = DateTimeHelper.ConvertDateTimeInt(DateTime.Now);
mi.DeletePerson = user.CompanyId.ToString();
db.SaveChanges();
strReult = "{ \"result\": true,\"msg\":\"删除成功!\"}";
}
}
return(strReult);
}
public string SelInfoEdit(HttpContext context)
{
string result = "";
try
{
DataTable dt = new DataTable();
dt.Columns.Add("id");
dt.Columns.Add("imgPath");
dt.Columns.Add("Title");
dt.Columns.Add("Value");
var user = RequestSession.GetSessionUser();
if (user != null)
{
int id = !string.IsNullOrWhiteSpace(context.Request["id"]) ? Convert.ToInt32(context.Request["id"]) : 0;
using (var db = new UdowsYunPublicEntities())
{
List <Info> list = db.Info.Where(p => p.id == id).ToList();
if (list.Any())
{
foreach (var val in list)
{
DataRow dr = dt.NewRow();
dr["id"] = val.id;
dr["imgPath"] = ConfigurationManager.AppSettings["ImgUmasWebSrc"] + val.imgPath;
dr["Value"] = val.html;
dr["Title"] = val.title;
dt.Rows.Add(dr);
}
}
result = JsonConvert.SerializeObject(dt);
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return(result);
}
public string AddSourceMaterial(HttpContext context)
{
string strResult = "";
string title = context.Request["Title"];
try
{
var user = RequestSession.GetSessionUser();
if (user != null)
{
using (var db = new UdowsYunPublicEntities())
{
int?started = db.Company.Find(user.CompanyId)?.stateId;
if (started == null || started != 2)
{
return("{ \"result\": false,\"msg\": \"审核没有通过!\"}");
}
Material mi = new Material
{
companyId = user.CompanyId,
creatname = user.username,
IsDelete = 0,
title = title,
C__creattime = DateTimeHelper.ConvertDateTimeInt(DateTime.Now)
};
db.Material.Add(mi);
db.SaveChanges();
strResult = "{ \"result\": true,\"id\":" + mi.id + ",\"msg\":\"添加成功!\"}";
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return(strResult);
}
public string Register(HttpContext context)
{
string result = "";
string username = context.Request["username"];
string password = context.Request["password"];
try
{
using (var db = new UdowsYunPublicEntities())
{
int num = db.User.Count(p => p.username == username);
if (num > 0)
{
result = "{ \"result\": false,\"msg\": \"当前账号已存在!\"}";
}
else
{
User u = new User();
u.username = username;
u.password = password;
u.createTime = DateTimeHelper.ConvertDateTimeInt(DateTime.Now);
u.roleId = 3;
u.realName = "";
db.User.Add(u);
db.SaveChanges();
result = "{ \"result\": true,\"msg\": \"注册成功!\"}";
}
}
}
catch (DbEntityValidationException e)
{
LogHelper lh = new LogHelper();
lh.WriteLog(e.EntityValidationErrors.ToString());
result = "{ \"result\": false,\"msg\": \"" + e.EntityValidationErrors + "\"}";
}
return(result);
}
public string SelAllInfoList(HttpContext context)
{
string result = "";
try
{
var user = RequestSession.GetSessionUser();
pageNum = Convert.ToInt32(context.Request["limit"]);
PageSize = Convert.ToInt32(context.Request["page"]);
if (user != null)
{
using (var db = new UdowsYunPublicEntities())
{
string sql = @"select * from (select row_number() over (order by id desc) as rn,* from (select a.id,a.title,b.name,CONVERT(varchar(100), DATEADD(s,a.createTime, '1970-01-01 08:00:00'), 20) as createTime from Info a
left join InfoState b
on a.stateId = b.id
where companyId = " + user.CompanyId + ") t ) t where rn between (" + PageSize + "-1) * " + pageNum + " + 1 and " + PageSize + " * " + pageNum;
List <GetAllInfo> list = db.Database.SqlQuery <GetAllInfo>(sql).ToList();
if (list.Count > 0)
{
result = "{\"code\":0,\"msg\":\"\",\"count\":" + db.Info.Count(p => p.companyId == user.CompanyId) + ",\"data\":" + JsonConvert.SerializeObject(list) + "}";
}
else
{
result = "{\"code\":0,\"msg\":\"\",\"count\":0,\"data\":\"\"}";
}
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return(result);
}
public string DeleteMaterial(HttpContext context)
{
string strReult = "";
var user = RequestSession.GetSessionUser();
if (user != null)
{
int id = !string.IsNullOrWhiteSpace(context.Request["id"]) ? Convert.ToInt32(context.Request["id"]) : 0;
using (var db = new UdowsYunPublicEntities())
{
//var Mater = from u in db.Material where u.id == id select u;
//db.Material.RemoveRange(Mater);
Material m = db.Material.Find(id);
m.IsDelete = 1;
m.DeleteTime = DateTimeHelper.ConvertDateTimeInt(DateTime.Now);
m.DeletePerson = user.CompanyId.ToString();
db.SaveChanges();
//var MaterInfo = from u in db.MaterialInfo where u.M_id == id select u;
//db.MaterialInfo.RemoveRange(MaterInfo);
List <MaterialInfo> list = db.MaterialInfo.Where(p => p.M_id == id).ToList();
if (list.Any())
{
foreach (var item in list)
{
MaterialInfo mi = db.MaterialInfo.Find(item.id);
mi.IsDelete = 1;
mi.DeleteTime = DateTimeHelper.ConvertDateTimeInt(DateTime.Now);
mi.DeletePerson = user.CompanyId.ToString();
db.SaveChanges();
}
}
strReult = "{ \"result\": true,\"msg\":\"删除成功!\"}";
}
}
return(strReult);
}
public string SelectMaterial(HttpContext context)
{
string result = "";
int id = 0;
if (!string.IsNullOrWhiteSpace(context.Request["id"]))
{
id = Convert.ToInt32(context.Request["id"]);
}
try
{
var user = RequestSession.GetSessionUser();
if (user != null)
{
using (var db = new UdowsYunPublicEntities())
{
List <MaterialInfo> list = db.MaterialInfo.Where(p => p.id == id).ToList();
if (list.Any())
{
result = "{ \"result\": true,\"msg\": " + JsonConvert.SerializeObject(list) + "}";
}
else
{
result = "{ \"result\": false,\"msg\": \"\"}";
}
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return(result);
}
public string Update(HttpContext context)
{
string strResult = "";
string companyName = context.Request["companyName"];
string shortName = context.Request["shortName"];
string domain = context.Request["domain"];
string companyAddress = context.Request["companyAddress"];
string mainProducts = context.Request["mainProducts"];
string mainBrands = context.Request["mainBrands"];
string keywords = context.Request["keywords"];
string companyDesc = context.Request["companyDesc"];
string companyPhone = context.Request["companyPhone"];
string companyEmail = context.Request["companyEmail"];
string companyFax = context.Request["companyFax"];
try
{
if (companyAddress.Length < 7)
{
return("{ \"result\": false,\"msg\": \"公司地址长度不正确!\"}");
}
var user = RequestSession.GetSessionUser();
if (user != null)
{
using (var db = new UdowsYunPublicEntities())
{
int?started = db.Company.Find(user.CompanyId)?.stateId;
if (started == 2)
{
return("{ \"result\": false,\"msg\": \"已审核通过，不可修改!\"}");
}
string newsLabel = "";
var n = db.Company.Where(p => p.userId == user.id).ToList();
if (!n.Any())
{
Company c = new Company
{
//用户ID
userId = user.id,
//公司名称
companyName = companyName,
//公司简称
shortName = shortName,
//域名
domain = domain,
//公司地址
companyAddress = companyAddress,
//主营产品
mainProducts = mainProducts,
//主要品牌
mainBrands = mainBrands,
//关键词
keywords = keywords,
//公司介绍
companyDesc = companyDesc,
//公司手机号
companyPhone = companyPhone,
//公司Email
companyEmail = companyEmail,
//公司传真
companyFax = companyFax,
//审核状态
stateId = 1,
};
c.FastDefaultStringReplace <Company>();
db.Company.Add(c);
db.SaveChanges();
strResult = "{ \"result\": true,\"msg\": \"修改成功!\"}";
}
else
{
foreach (var item in n)
{
//用户ID
item.userId = user.id;
//公司名称
item.companyName = companyName;
//公司简称
item.shortName = shortName;
//域名
item.domain = domain;
//公司地址
item.companyAddress = companyAddress;
//主营产品
item.mainProducts = mainProducts;
//主要品牌
item.mainBrands = mainBrands;
//关键词
item.keywords = keywords;
//公司介绍
item.companyDesc = companyDesc;
//公司手机号
item.companyPhone = companyPhone;
//公司Email
item.companyEmail = companyEmail;
//公司传真
item.companyFax = companyFax;
db.SaveChanges();
strResult = "{ \"result\": true,\"msg\": \"修改成功!\"}";
}
}
}
}
else
{
strResult = "{ \"result\": false,\"msg\": \"登录超时,请重新登录!\"}";
}
}
catch (DbEntityValidationException e)
{
LogHelper lh = new LogHelper();
lh.WriteLog(e.EntityValidationErrors.ToString());
strResult = "{ \"result\": false,\"msg\": \"" + e.EntityValidationErrors + "\"}";
}
return(strResult);
}
public string Update(HttpContext context)
{
string strResult = "";
string realName = context.Request["realName"];
string post = context.Request["post"];
string sex = string.IsNullOrWhiteSpace(context.Request["Sexs"]) ? "男" : context.Request["Sexs"];
string mobile = context.Request["mobile"];
string phone = context.Request["phone"];
string qq = context.Request["qq"];
string email = context.Request["email"];
string address = context.Request["address"];
string zip = context.Request["zip"];
try
{
if (address.Length < 7)
{
return("{ \"result\": false,\"msg\": \"地址长度不正确!\"}");
}
var user = RequestSession.GetSessionUser();
if (user != null)
{
using (var db = new UdowsYunPublicEntities())
{
int?started = db.Company.Find(user.CompanyId)?.stateId;
if (started == 2)
{
return("{ \"result\": false,\"msg\": \"已审核通过，不可修改!\"}");
}
string newsLabel = "";
List <Company> n = db.Company.Where(p => p.userId == user.id).ToList();
if (n.Any())
{
foreach (var val in n)
{
var c = db.Company.Find(val.id);
c.realName = realName.Trim().Replace(" ", "");
c.post = post.Trim().Replace(" ", "");
c.sex = sex.Trim().Replace(" ", "");
c.mobile = mobile.Trim().Replace(" ", "");
c.phone = phone.Trim().Replace(" ", "");
c.qq = qq.Trim().Replace(" ", "");
c.email = email.Trim().Replace(" ", "");
c.address = address.Trim().Replace(" ", "");
c.zip = zip.Trim().Replace(" ", "");
c.FastDefaultStringReplace <Company>();
}
db.SaveChanges();
strResult = "{ \"result\": true,\"msg\": \"修改成功!\"}";
}
else
{
strResult = "{ \"result\": false,\"msg\": \"请先补充公司资料!\"}";
}
}
}
else
{
strResult = "{ \"result\": false,\"msg\": \"登录超时,请重新登录!\"}";
}
}
catch (DbEntityValidationException e)
{
LogHelper lh = new LogHelper();
lh.WriteLog(e.EntityValidationErrors.ToString());
strResult = "{ \"result\": false,\"msg\": \"" + e.EntityValidationErrors + "\"}";
}
return(strResult);
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string pagetype = context.Request["pageType"];
switch (pagetype)
{
case "getUser":
{
//ApiSoapClient a = new ApiSoapClient();
//string imgList = a.GetCacheList(1);
string loginname = context.Request["loginname"];
string loginpsw = context.Request["loginpsw"];
try
{
using (var db = new UdowsYunPublicEntities())
{
var loginuser = db.User.Where(p => p.username == loginname).ToList();
if (loginuser.Count > 0)
{
foreach (var val in loginuser)
{
if (loginpsw == val.password)
{
SessionUser user = new SessionUser();
user.id = val.id;
user.username = val.username;
user.password = val.password;
user.realName = val.realName;
user.roleId = val.roleId;
var intem = db.Company.Where(p => p.userId == val.id).ToList();
foreach (var iem in intem)
{
user.CompanyId = iem.id;
}
RequestSession.AddSessionUser(user);
context.Response.Write("");
}
else
{
context.Response.Write("用户密码错误！");
}
}
}
else
{
context.Response.Write("用户不存在！");
}
}
}
catch (Exception ex)
{
LogHelper lh = new LogHelper();
lh.WriteLog(ex.Message.ToString());
context.Response.Write("数据库连接出错！");
throw;
}
}
break;
case "LoginOut":
HttpContext rq = HttpContext.Current;
rq.Session["SESSION_USER"] = null;
context.Response.Write("{ \"result\": true,\"msg\": \"1\"}");
break;
}
}
public string InseInfo(HttpContext context)
{
string strResult = "";
string title = context.Request["Title"];
string infoTypeId = context.Request["InfoTypeId"];
string imagePath = context.Request["ImgPath"];
string value = context.Request["contele"];
int id = !string.IsNullOrWhiteSpace(context.Request["id"]) ? Convert.ToInt32(context.Request["id"]) : 0;
try
{
var user = RequestSession.GetSessionUser();
if (user != null)
{
using (var db = new UdowsYunPublicEntities())
{
int?started = db.Company.Find(user.CompanyId)?.stateId;
if (started == null || started != 2)
{
return("{ \"result\": false,\"msg\": \"审核没有通过!\"}");
}
if (id == 0)
{
Info ic = new Info
{
imgPath = imagePath,
createTime = DateTimeHelper.ConvertDateTimeInt(DateTime.Now),
title = title,
typeId = Convert.ToInt32(infoTypeId),
html = value,
stateId = 2,
companyId = Convert.ToInt32(user.CompanyId)
};
db.Info.Add(ic);
db.SaveChanges();
strResult = "{ \"result\": true,\"msg\":\"添加成功!\"}";
}
else
{
Info ic = db.Info.Find(id);
if (ic != null)
{
ic.imgPath = imagePath;
ic.title = title;
ic.typeId = Convert.ToInt32(infoTypeId);
ic.html = value;
}
db.SaveChanges();
strResult = "{ \"result\": true,\"msg\":\"修改成功!\"}";
}
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return(strResult);
}
public string InsertInfo(HttpContext context)
{
string strResult = "";
int mid = Convert.ToInt32(context.Request["Mid"]);
string infoNum = context.Request["InfoNum"];
string infoTypeId = context.Request["InfoTypeId"];
string precisewords = context.Request["precisewords"];
string xushu = context.Request["xushu"];
string key1 = context.Request["key1"];
string key2 = context.Request["key2"];
string key3 = context.Request["key3"];
string key4 = context.Request["key4"];
string key5 = context.Request["key5"];
string strImgPath = context.Request["ImgPath"];
try
{
var user = RequestSession.GetSessionUser();
string html = "";
string strs = "";
string strTitle = "";
string[] str = new string[] { };
if (!string.IsNullOrWhiteSpace(precisewords))
{
strs += precisewords + ",";
}
if (!string.IsNullOrWhiteSpace(xushu))
{
strs += xushu + ",";
}
if (!string.IsNullOrWhiteSpace(key1))
{
strs += key1 + ",";
}
if (!string.IsNullOrWhiteSpace(key2))
{
strs += key2 + ",";
}
if (!string.IsNullOrWhiteSpace(key3))
{
strs += key3 + ",";
}
if (!string.IsNullOrWhiteSpace(key4))
{
strs += key4 + ",";
}
if (!string.IsNullOrWhiteSpace(key5))
{
strs += key5 + ",";
}
if (!string.IsNullOrWhiteSpace(strs))
{
strs = strs.Substring(0, strs.Length - 1);
str = strs.Split(',');
}
if (str.Length < 5)
{
return("{ \"result\": false,\"msg\":\"精确词过少且不能重复!\"}");
}
string[] strImg = new string[] { };
if (!string.IsNullOrWhiteSpace(strImgPath))
{
strImg = strImgPath.Split(',');
}
if (user != null)
{
using (var db = new UdowsYunPublicEntities())
{
int?started = db.Company.Find(user.CompanyId)?.stateId;
if (started == null || started != 2)
{
return("{ \"result\": false,\"msg\": \"审核没有通过!\"}");
}
if (db.MaterialInfo.Count(p => p.M_id == mid && p.Start == 1) < 3)
{
return("{ \"result\": false,\"msg\":\"素材过少!\"}");
}
Info ic = new Info();
for (int i = 0; i < Convert.ToInt32(infoNum); i++)
{
for (int j = 0; j < 3; j++)
{
MaterialInfo list = db.MaterialInfo.Where(p => p.M_id == mid && p.Start == 1 && p.IsDelete == 0).OrderBy(_ => Guid.NewGuid()).First();
if (list != null)
{
html += list.Value + "<br />";
}
}
for (int j = 0; j < 3; j++)
{
if (str.Length > 0)
{
}
}
int num = 1;
while (num < 4)
{
if (num == 3)
{
string title = strTitle.Substring(0, strTitle.Length - 1);
if (db.Info.Count(p => p.title == title) <= 0)
{
break;
}
else
{
num = 1;
strTitle = "";
}
}
else
{
Random rnd = new Random();
int index = rnd.Next(str.Length);
if (!strTitle.Contains(str[index]))
{
strTitle += str[index] + "|";
num++;
}
else
{
num = strTitle.Split('|').Length - 1;
}
}
}
string imgPath = "";
if (strImg.Length > 0)
{
Random rd = new Random();
int ind = rd.Next(strImg.Length);
imgPath = strImg[ind];
}
ic.imgPath = imgPath;
ic.title = strTitle.Substring(0, strTitle.Length - 1);
ic.companyId = Convert.ToInt32(user.CompanyId);
ic.html = html;
ic.typeId = Convert.ToInt32(infoTypeId);
ic.materialId = mid;
ic.stateId = 2;
ic.createTime = DateTimeHelper.ConvertDateTimeInt(DateTime.Now);
db.Info.Add(ic);
db.SaveChanges();
strTitle = "";
html = "";
}
strResult = "{ \"result\": true,\"msg\":\"添加成功!\"}";
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return(strResult);
}
public string UpdatePublishRule(HttpContext context)
{
string result = "";
int intervalDay = !string.IsNullOrWhiteSpace(context.Request["intervalDay"]) ? Convert.ToInt32(context.Request["intervalDay"]) : 0;
int publishCount = !string.IsNullOrWhiteSpace(context.Request["publishCount"]) ? Convert.ToInt32(context.Request["publishCount"]) : 0;
try
{
var user = RequestSession.GetSessionUser();
if (user != null)
{
using (var db = new UdowsYunPublicEntities())
{
int?started = db.Company.Find(user.CompanyId)?.stateId;
if (started == null || started != 2)
{
return("{ \"result\": false,\"msg\": \"审核没有通过!\"}");
}
List <PublishRule> list = db.PublishRule.Where(p => p.companyId == user.CompanyId).ToList();
if (list.Any())
{
foreach (var item in list)
{
PublishRule pr = db.PublishRule.Find(item.id);
if (intervalDay != 0)
{
pr.intervalDay = intervalDay;
}
if (publishCount != 0)
{
pr.publishCount = publishCount;
}
db.SaveChanges();
result = "{ \"result\": true,\"msg\":\"修改成功!\"}";
}
}
else
{
PublishRule pr = new PublishRule();
if (intervalDay != 0)
{
pr.intervalDay = intervalDay;
}
if (publishCount != 0)
{
pr.publishCount = publishCount;
}
pr.companyId = Convert.ToInt32(user.CompanyId);
pr.startDate = DateTimeHelper.ConvertDateTimeInt(DateTime.Now);
db.PublishRule.Add(pr);
db.SaveChanges();
result = "{ \"result\": true,\"msg\":\"添加成功!\"}";
}
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return(result);
}
public string Index(HttpContext context)
{
string result = "";
string sql;
try
{
DataTable dt = new DataTable();
dt.Columns.Add("id");
dt.Columns.Add("Name");
dt.Columns.Add("Data");
var user = RequestSession.GetSessionUser();
if (user != null)
{
using (var db = new UdowsYunPublicEntities())
{
sql = "select * from Company_51sole where companyId=" + user.CompanyId;
int sole = db.Database.SqlQuery <Company_51sole>(sql).Count();
if (sole > 0)
{
DataRow dr = dt.NewRow();
dr["id"] = user.id;
dr["Name"] = "51Sole";
dr["Data"] = "是";
dt.Rows.Add(dr);
}
else
{
DataRow dr = dt.NewRow();
dr["id"] = user.id;
dr["Name"] = "51Sole";
dr["Data"] = "否";
dt.Rows.Add(dr);
}
sql = "select * from Company_99inf where companyId=" + user.CompanyId;
int inf = db.Database.SqlQuery <Company_99inf>(sql).Count();
if (inf > 0)
{
DataRow dr = dt.NewRow();
dr["id"] = user.id;
dr["Name"] = "久久信息";
dr["Data"] = "是";
dt.Rows.Add(dr);
}
else
{
DataRow dr = dt.NewRow();
dr["id"] = user.id;
dr["Name"] = "久久信息";
dr["Data"] = "否";
dt.Rows.Add(dr);
}
sql = "select * from Company_atobo where companyId=" + user.CompanyId;
int atobo = db.Database.SqlQuery <Company_atobo>(sql).Count();
if (atobo > 0)
{
DataRow dr = dt.NewRow();
dr["id"] = user.id;
dr["Name"] = "阿土伯";
dr["Data"] = "是";
dt.Rows.Add(dr);
}
else
{
DataRow dr = dt.NewRow();
dr["id"] = user.id;
dr["Name"] = "阿土伯";
dr["Data"] = "否";
dt.Rows.Add(dr);
}
sql = "select * from Company_b2b168 where companyNo=" + user.CompanyId;
int b2b = db.Database.SqlQuery <Company_b2b168>(sql).Count();
if (b2b > 0)
{
DataRow dr = dt.NewRow();
dr["id"] = user.id;
dr["Name"] = "八方资源";
dr["Data"] = "是";
dt.Rows.Add(dr);
}
else
{
DataRow dr = dt.NewRow();
dr["id"] = user.id;
dr["Name"] = "八方资源";
dr["Data"] = "否";
dt.Rows.Add(dr);
}
sql = "select * from Company_gtobal where companyNo=" + user.CompanyId;
int gtobal = db.Database.SqlQuery <Company_gtobal>(sql).Count();
if (gtobal > 0)
{
DataRow dr = dt.NewRow();
dr["id"] = user.id;
dr["Name"] = "际通宝";
dr["Data"] = "是";
dt.Rows.Add(dr);
}
else
{
DataRow dr = dt.NewRow();
dr["id"] = user.id;
dr["Name"] = "际通宝";
dr["Data"] = "否";
dt.Rows.Add(dr);
}
sql = "select * from Company_jqw where companyId=" + user.CompanyId;
int jqw = db.Database.SqlQuery <Company_jqw>(sql).Count();
if (jqw > 0)
{
DataRow dr = dt.NewRow();
dr["id"] = user.id;
dr["Name"] = "金泉网";
dr["Data"] = "是";
dt.Rows.Add(dr);
}
else
{
DataRow dr = dt.NewRow();
dr["id"] = user.id;
dr["Name"] = "金泉网";
dr["Data"] = "否";
dt.Rows.Add(dr);
}
}
}
result = "{\"code\":0,\"msg\":\"\",\"count\":6,\"data\":" + JsonConvert.SerializeObject(dt) + "}";
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return(result);
}
