public void Delete(string Ids)
{
using (var con = DbHelperSQL.GetConnection())
{
var tran = con.BeginTransaction();
var ct = new DS_AlbumImgDataContext(con);
ct.Transaction = tran;
string[] idarray = Ids.Split(',');
var list = ct.DS_AlbumImg.Where(a => idarray.Contains(a.ID.ToString()));
var list2 = list.ToList();
ct.DS_AlbumImg.DeleteAllOnSubmit(list);
ct.SubmitChanges();
var ct2 = new DS_AlbumDataContext(con);
ct2.Transaction = tran;
var album = ct2.DS_Album.Single(a => a.ID == list2.First().AlbumID);
album.PictureNum = ct.DS_AlbumImg.Where(a => a.AlbumID == list2.First().AlbumID).Count();
ct2.SubmitChanges();
foreach (var item in list2)
{
string p = System.Web.HttpContext.Current.Server.MapPath(Common.Constant.WebConfig("AlbumRootPath") + item.ImgUrl + "/" + item.ImgName);
if (File.Exists(p))
{
File.Delete(p);
}
}
tran.Commit();
}
}
/// <summary>
/// 排序
/// </summary>
/// <param name="ID"></param>
/// <param name="IsUp"></param>
public void Sort(int ID, bool IsUp)
{
using (var ct = new DS_AlbumImgDataContext(DbHelperSQL.Connection))
{
var md = ct.DS_AlbumImg.Single(a => a.ID == ID);
ct.ExecuteCommand("update DS_AlbumImg set px=(select RowNumber from (select (ROW_NUMBER() OVER (ORDER BY px)) AS RowNumber,id from DS_AlbumImg where AlbumID={0}) as p2 where id=DS_AlbumImg.AlbumID) where memberid={0}", md.AlbumID);
if (IsUp)
{
DS_AlbumImg p = ct.DS_AlbumImg.Single(a => a.ID == ID);
DS_AlbumImg p1;
if (p.Px > 1)
{
p1 = ct.DS_AlbumImg.Single(a => a.Px == (p.Px - 1) && a.AlbumID == md.AlbumID);
p.Px--;
p1.Px++;
}
}
else
{
DS_AlbumImg p = ct.DS_AlbumImg.Single(a => a.ID == ID);
DS_AlbumImg p1;
if (p.Px < ct.DS_AlbumImg.Where(a => a.AlbumID == md.AlbumID).Count())
{
p1 = ct.DS_AlbumImg.Single(a => a.Px == (p.Px + 1) && a.AlbumID == md.AlbumID);
p.Px++;
p1.Px--;
}
}
ct.SubmitChanges();
}
}
public List <T> Query <T>(string sql, params object[] parameterValues)
{
using (var ct = new DS_AlbumImgDataContext(DbHelperSQL.Connection))
{
return(ct.ExecuteQuery <T>(sql, parameterValues).ToList());
}
}
public DS_AlbumImg GetSingle(int ID)
{
using (var ct = new DS_AlbumImgDataContext(DbHelperSQL.Connection))
{
return(ct.DS_AlbumImg.Single(a => a.ID == ID));
}
}
public void Update(DS_AlbumImg AlbumImg)
{
using (var ct = new DS_AlbumImgDataContext(DbHelperSQL.Connection))
{
ct.DS_AlbumImg.Attach(AlbumImg, true);
ct.SubmitChanges();
}
}
public void Delete(int ID)
{
using (var ct = new DS_AlbumImgDataContext(DbHelperSQL.Connection))
{
var st = ct.DS_AlbumImg.Single(a => a.ID == ID);
ct.DS_AlbumImg.DeleteOnSubmit(st);
ct.SubmitChanges();
}
}
public List <DS_AlbumImg> Query(string condition, string orderby, params object[] param)
{
using (var ct = new DS_AlbumImgDataContext(DbHelperSQL.Connection))
{
IQueryable <DS_AlbumImg> AlbumImgList = ct.DS_AlbumImg;
if (!string.IsNullOrEmpty(condition))
{
AlbumImgList = AlbumImgList.Where(condition, param);
}
if (!string.IsNullOrEmpty(orderby))
{
AlbumImgList = AlbumImgList.OrderBy(orderby);
}
return(AlbumImgList.ToList());
}
}
public List <DS_AlbumImg> Query(string condition, string orderby, int startIndex, int pageSize, ref int pageCount, params object[] param)
{
using (var ct = new DS_AlbumImgDataContext(DbHelperSQL.Connection))
{
IQueryable <DS_AlbumImg> AlbumImgList = ct.DS_AlbumImg;
if (!string.IsNullOrEmpty(condition))
{
AlbumImgList = AlbumImgList.Where(condition, param);
}
if (!string.IsNullOrEmpty(orderby))
{
AlbumImgList = AlbumImgList.OrderBy(orderby);
}
pageCount = AlbumImgList.Count();
return(AlbumImgList.Skip(startIndex).Take(pageSize).ToList());
}
}
public void Add(DS_AlbumImg AlbumImg)
{
using (var con = DbHelperSQL.GetConnection()) {
var tran = con.BeginTransaction();
var ct = new DS_AlbumImgDataContext(con);
ct.Transaction = tran;
ct.DS_AlbumImg.InsertOnSubmit(AlbumImg);
ct.SubmitChanges();
var ct2 = new DS_AlbumDataContext(con);
ct2.Transaction = tran;
var album = ct2.DS_Album.Single(a => a.ID == AlbumImg.AlbumID);
album.PictureNum = ct.DS_AlbumImg.Where(a => a.AlbumID == AlbumImg.AlbumID).Count();
ct2.SubmitChanges();
tran.Commit();
}
}
public void Update(DS_AlbumImg AlbumImg, bool FrontCover)
{
using (var con = DbHelperSQL.GetConnection())
{
var tran = con.BeginTransaction();
var ct = new DS_AlbumImgDataContext(con);
ct.Transaction = tran;
ct.DS_AlbumImg.Attach(AlbumImg, true);
ct.SubmitChanges();
var ct2 = new DS_AlbumDataContext(con);
ct2.Transaction = tran;
var album = ct2.DS_Album.Single(a => a.ID == AlbumImg.AlbumID);
album.UpdateDate = DateTime.Now;
if (FrontCover)
{
album.FrontCover = "/Resource/" + AlbumImg.ImgUrl + "/" + AlbumImg.ImgName;
}
ct2.SubmitChanges();
tran.Commit();
}
}
