/// <summary>
/// 插入图片
/// </summary>
/// <param name="object">对象</param>
public int InsertEntity(SiteGroupCms.Entity.Articleatts obj)
{
using (DbOperHandler _doh = new Common().Doh())
{
_doh.Reset();
_doh.AddFieldItem("artid", obj.Artid);
_doh.AddFieldItem("title", obj.Title);
_doh.AddFieldItem("url", obj.Url);
if (obj.Type != null)
_doh.AddFieldItem("type", obj.Type);
if (obj.Size != 0)
_doh.AddFieldItem("size", obj.Size);
int _insert = _doh.Insert("yy_articleattinfo");
return _insert;
}
}
protected void loadarticle(string id)
{
SiteGroupCms.Dal.ArticleDal artdal = new SiteGroupCms.Dal.ArticleDal();
SiteGroupCms.Entity.Article art = new SiteGroupCms.Entity.Article();
art = artdal.GetEntity(id);
SiteGroupCms.Dal.ArticlepicDal artpicdal = new SiteGroupCms.Dal.ArticlepicDal();
SiteGroupCms.Dal.ArticleattsDal artattsdal = new SiteGroupCms.Dal.ArticleattsDal();
SiteGroupCms.Entity.Articlepic artpic = new SiteGroupCms.Entity.Articlepic();
SiteGroupCms.Entity.Articleatts artatts = new SiteGroupCms.Entity.Articleatts();
List <SiteGroupCms.Entity.Articlepic> piclist = artpicdal.getEntityList(id);
List <SiteGroupCms.Entity.Articleatts> attslists = artattsdal.getEntityList(id);
//获取imglist和imgtitlelist
string imglist = "";
string imgtitlelist = "";
string attslist = "";
string attstitlelist = "";
for (int i = 0; i < piclist.Count; i++)
{
imglist += piclist[i].Url + ",";
imgtitlelist += piclist[i].Title + ",";
}
for (int i = 0; i < attslists.Count; i++)
{
attslist += attslists[i].Url + ",";
attstitlelist += attslists[i].Title + ",";
}
string _response = "";
if (art != null)
{
string isppt = art.Isppt == 1 ? "true" : "false";
string isrecommend = art.Isrecommend == 1 ? "true" : "false";
string isroll = art.Isroll == 1 ? "true" : "false";
string isshart = art.Isshare == 1 ? "true" : "false";
_response += "{\"IsError\":false,\"Message\":\"加载成功\",\"Data\":{";
_response += "\"artid\":" + art.Id + ",\"catalogid\":" + art.Catalogid + ",\"title\":" + SiteGroupCms.Utils.fastJSON.JSON.WriteString(art.Title);
_response += ",\"abstract\":" + SiteGroupCms.Utils.fastJSON.JSON.WriteString(art.Abstract) + ",\"addtime\":\"" + art.Addtime.ToString("yyyy-MM-dd") + "\",\"color\":\"" + art.Color + "\"";
_response += ",\"isppt\":" + isppt + ",\"isrecommend\":" + isrecommend + ",\"isshare\":" + isshart + ",\" isroll\":" + isroll;
_response += ",\"keywords\":" + SiteGroupCms.Utils.fastJSON.JSON.WriteString(art.Keywords) + ",\"linkurl\":" + SiteGroupCms.Utils.fastJSON.JSON.WriteString(art.Linkurl) + ",\"source\":" + SiteGroupCms.Utils.fastJSON.JSON.WriteString(art.Source) + ",\"subtitle\":" + SiteGroupCms.Utils.fastJSON.JSON.WriteString(art.Subtitle);
_response += ",\"imglist\":\"" + imglist + "\",\"imgtitlelist\":\"" + imgtitlelist + "\"";
_response += ",\"attslist\":\"" + attslist + "\",\"attstitlelist\":\"" + attstitlelist + "\",\"clickcount\":" + art.Clickcount;
_response += "}}";
}
Response.Write(_response);
}
/// <summary>
/// 取出list
/// </summary>
/// <param name="object">文章id</param>
public List<SiteGroupCms.Entity.Articleatts> getEntityList(string id)
{
using (DbOperHandler _doh = new Common().Doh())
{
_doh.Reset();
_doh.SqlCmd = "SELECT * FROM [yy_articleattinfo] WHERE [artid]=" + id;
DataTable dt = _doh.GetDataTable();
List<SiteGroupCms.Entity.Articleatts> ilist=new List<SiteGroupCms.Entity.Articleatts>();
for (int i = 0; i < dt.Rows.Count; i++)
{
SiteGroupCms.Entity.Articleatts pic = new SiteGroupCms.Entity.Articleatts();
pic.Artid = Str2Int(id);
pic.ID = Str2Int(dt.Rows[i]["id"].ToString());
pic.Url = dt.Rows[i]["url"].ToString();
pic.Title = dt.Rows[i]["title"].ToString();
ilist.Add(pic);
}
return ilist;
}
}
private void addarticle()
{
//插入article
article.Abstract = abstraction;
article.Addtime = SiteGroupCms.Utils.Validator.StrToDate(addtime, DateTime.Now);
article.Catalogid = Str2Int(catalogid);
article.Siteid = _admin.CurrentSite;
article.Author = _admin.UserName;
article.Color = color;
article.Content = content;
article.Isppt = isppt == "true"?1:0;
article.Isrecommend = isrecommend == "true" ? 1 : 0;
article.Isshare = isshare == "true" ? 1 : 0;
article.Isroll = isroll == "true" ? 1 : 0;
article.Keywords = keywords;
article.Linkurl = linkurl;
article.Source = source;
article.Subtitle = subtitle;
article.Title = title;
article.Clickcount = clickcount;
id = artobj.insertEntity(article);
artobj.updatsort(id.ToString()); //将排序号变得跟id一样
if (id != 0)
{
_response = "{\"IsError\":false,\"Message\":\"保存成功\",\"Data\":0}";
new SiteGroupCms.Dal.LogDal().SaveLog(3);
}
else
{
_response = "{\"IsError\":true,\"Message\":\"保存失败\",\"Data\":0}";
}
//插入图片库 暂时不用
if (imglist != "")
{
SiteGroupCms.Dal.ArticlepicDal picdal = new SiteGroupCms.Dal.ArticlepicDal();
SiteGroupCms.Entity.Articlepic pic = new SiteGroupCms.Entity.Articlepic();
string[] imgl = imglist.Split(',');
string[] imgtl = imgtitlelist.Split(',');
for (int i = 0; i < imgl.Length - 1; i++)
{
pic.Title = imgtl[i];
pic.Artid = id;
pic.Url = imgl[i];
pic.Istop = i == 1 ? 1 : 0;
picdal.InsertEntity(pic);
}
}
//插入附件库
if (attslist != "")
{
SiteGroupCms.Dal.ArticleattsDal attdal = new SiteGroupCms.Dal.ArticleattsDal();
SiteGroupCms.Entity.Articleatts att = new SiteGroupCms.Entity.Articleatts();
string[] attl = attslist.Split(',');
string[] atttl = attstitlelist.Split(',');
for (int i = 0; i < attl.Length - 1; i++)
{
att.Artid = id;
att.Title = atttl[i];
att.Url = attl[i];
attdal.InsertEntity(att);
}
}
}
public void updatearicle()
{
//更新article
article.Id = Str2Int(artid);
article.Abstract = abstraction;
article.Addtime = SiteGroupCms.Utils.Validator.StrToDate(addtime, DateTime.Now);
article.Catalogid = Str2Int(catalogid);
article.Siteid = _admin.CurrentSite;
//article.Author = _admin.UserName;
article.Color = color;
article.Content = content;
article.Isppt = isppt == "true" ? 1 : 0;
article.Isrecommend = isrecommend == "true" ? 1 : 0;
article.Isshare = isshare == "true" ? 1 : 0;
article.Isroll = isroll == "true" ? 1 : 0;
article.Keywords = keywords;
article.Linkurl = linkurl;
article.Source = source;
article.Subtitle = subtitle;
article.Title = title;
article.Clickcount = clickcount;
if (artobj.UpdateArticle(article))
{
_response = "{\"IsError\":false,\"Message\":\"保存成功\",\"Data\":0}";
new SiteGroupCms.Dal.LogDal().SaveLog(28);
}
else
{
_response = "{\"IsError\":true,\"Message\":\"保存失败\",\"Data\":0}";
}
//插入图片库 暂时不用
if (imglist != "")
{
SiteGroupCms.Dal.ArticlepicDal picdal = new SiteGroupCms.Dal.ArticlepicDal();
SiteGroupCms.Entity.Articlepic pic = new SiteGroupCms.Entity.Articlepic();
List <SiteGroupCms.Entity.Articlepic> piclist = picdal.getEntityList(article.Id.ToString());
string[] imgl = imglist.Split(',');
string[] imgtl = imgtitlelist.Split(',');
int[] flag0 = new int[piclist.Count]; //用来标记是否有更改
for (int k = 0; k < flag0.Length; k++)
{
flag0[k] = 0;
}
for (int i = 0; i < imgl.Length - 1; i++)
{
if (piclist.Count > 0) //包含图片时
{
for (int j = 0; j < piclist.Count; j++) //将插入的pic一一与数据库里面的对比，若存在则不改动，若不存在则插入
{
if (imgl[i] == piclist[j].Url) //存在则直接跳出这层for语句，检查下一个需要插入的
{
flag0[j] = 1; //表示没有改变
break;
}
else //不存在则插入
{
pic.Title = imgtl[i];
pic.Artid = article.Id;
pic.Url = imgl[i];
pic.Istop = i == 1 ? 1 : 0;
picdal.InsertEntity(pic);
}
}
}
else//不含图片集则直接插入进去
{
pic.Title = imgtl[i];
pic.Artid = article.Id;
pic.Url = imgl[i];
pic.Istop = i == 1 ? 1 : 0;
picdal.InsertEntity(pic);
}
//对改变了的做处理 即删除就可以了
for (int l = 0; l < flag0.Length; l++)
{
if (flag0[l] == 0)
{
picdal.DelEntity(piclist[l].ID);
}
}
}
}
else //如果传递进来的是空 则判断数据库是否含有 如果含有则全部删除
{
SiteGroupCms.Dal.ArticlepicDal picdal = new SiteGroupCms.Dal.ArticlepicDal();
List <SiteGroupCms.Entity.Articlepic> piclist = picdal.getEntityList(article.Id.ToString());
if (piclist.Count > 0)
{
picdal.DelEntityByartid(article.Id);
}
}
//插入附件库 对于删除附件不行 本来有 现在要全部删除 就不起作用了
if (attslist != "")
{
SiteGroupCms.Dal.ArticleattsDal attdal = new SiteGroupCms.Dal.ArticleattsDal();
SiteGroupCms.Entity.Articleatts att = new SiteGroupCms.Entity.Articleatts();
List <SiteGroupCms.Entity.Articleatts> attlists = attdal.getEntityList(article.Id.ToString());
string[] attl = attslist.Split(',');
string[] atttl = attstitlelist.Split(',');
int[] flag = new int[attlists.Count]; //用来标记是否有更改
for (int k = 0; k < flag.Length; k++)
{
flag[k] = 0;
}
for (int i = 0; i < attl.Length - 1; i++)
{
if (attlists.Count > 0)
{
for (int j = 0; j < attlists.Count; j++)
{
if (attlists[j].Url == attl[i]) //如果存在则继续
{
flag[j] = 1; //表示没有改变
break;
}
else
{
att.Artid = article.Id;
att.Title = atttl[i];
att.Url = attl[i];
attdal.InsertEntity(att);
}
}
}
else
{
att.Artid = article.Id;
att.Title = atttl[i];
att.Url = attl[i];
attdal.InsertEntity(att);
}
//对改变了的做处理 即删除就可以了
for (int l = 0; l < flag.Length; l++)
{
if (flag[l] == 0)
{
attdal.DelEntity(attlists[l].ID);
}
}
}
}
else //如果传递进来的是空 则判断数据库是否含有 如果含有则全部删除
{
SiteGroupCms.Dal.ArticleattsDal attdal = new SiteGroupCms.Dal.ArticleattsDal();
List <SiteGroupCms.Entity.Articleatts> attlist = attdal.getEntityList(article.Id.ToString());
if (attlist.Count > 0)
{
attdal.DelEntityByartid(article.Id);
}
}
}
