public int AddAdvertisments(Propaganda_Advertising model, string datas)
{
if (string.IsNullOrEmpty(datas))
{
return(1);//缺失图片路径
}
try
{
StringBuilder sb = new StringBuilder();
//Propaganda_Advertising old = _adverDb.GetEntity("select * from Propaganda_Advertising where DATEDIFF(day,CreateTime,GETDATE())=0 and BusinessUser_Id=@BusinessUser_Id", model);
model.CreateTime = DateTime.Now;
//if (old != null)
//{
//model.Id = old.Id;
//}
//else
//{
_adverDb.Insert(model);
//}
var dataArray = datas.Split(new char[] { ',' });
for (int i = 0; i < dataArray.Length; i++)
{
sb.AppendFormat("insert Propaganda_AdverContent (Advertising_Id,[Content]) values ({0},'{1}')", model.Id, dataArray[i]);
}
_db.ExecuteSqlCommand(sb.ToString());
return(0);
}
catch (Exception)
{
return(2);
}
}
public void AddAdverAndAdverContent(int userId, string desc, int type, string path, string url)
{
Propaganda_Advertising adver = _adverDb.GetEntity("select * from Propaganda_Advertising where BusinessUser_Id=@userId and Intro=@desc", new { userId = userId, desc = desc });
if (adver == null)
{
adver = new Propaganda_Advertising()
{
BusinessUser_Id = userId, Intro = desc, CreateTime = DateTime.Now
};
_adverDb.Insert(adver);
}
var content = _db.SqlQuery <Propaganda_AdverContent>("select * from Propaganda_AdverContent where Advertising_Id=@aid and Content=@path", new { aid = adver.Id, path = path });
if (content == null || content.Count() == 0)
{
_db.ExecuteSqlCommand("insert Propaganda_AdverContent (Advertising_Id,Type,Content,Description) values (@Advertising_Id,@Type,@Content,@Description)", new { Advertising_Id = adver.Id, Type = type, Content = path, Description = url });
}
}
