/// <summary>
/// 排序
/// </summary>
/// <param name="ID"></param>
/// <param name="IsUp"></param>
public void Sort(int ID, bool IsUp)
{
using (var ct = new DS_DiyProCategoryDataContext(DbHelperSQL.Connection))
{
var md = ct.DS_DiyProCategory.Single(a => a.ID == ID);
ct.ExecuteCommand("update DS_DiyProCategory set px=(select RowNumber from (select (ROW_NUMBER() OVER (ORDER BY px)) AS RowNumber,id from DS_DiyProCategory where MemberID={0}) as p2 where id=DS_DiyProCategory.id) where MemberID={0}", md.MemberID);
if (IsUp)
{
DS_DiyProCategory p = ct.DS_DiyProCategory.Single(a => a.ID == ID);
DS_DiyProCategory p1;
if (p.Px > 1)
{
p1 = ct.DS_DiyProCategory.Single(a => a.Px == (p.Px - 1) && a.MemberID == md.MemberID);
p.Px--;
p1.Px++;
}
}
else
{
DS_DiyProCategory p = ct.DS_DiyProCategory.Single(a => a.ID == ID);
DS_DiyProCategory p1;
if (p.Px < ct.DS_DiyProCategory.Where(a => a.MemberID == md.MemberID).Count())
{
p1 = ct.DS_DiyProCategory.Single(a => a.Px == (p.Px + 1) && a.MemberID == md.MemberID);
p.Px++;
p1.Px--;
}
}
ct.SubmitChanges();
}
}
public void Update(DS_DiyProCategory DiyProCategory)
{
using (var ct = new DS_DiyProCategoryDataContext(DbHelperSQL.Connection))
{
ct.DS_DiyProCategory.Attach(DiyProCategory, true);
ct.SubmitChanges();
}
}
public void Add(DS_DiyProCategory DiyProCategory)
{
using (var ct = new DS_DiyProCategoryDataContext(DbHelperSQL.Connection))
{
ct.DS_DiyProCategory.InsertOnSubmit(DiyProCategory);
ct.SubmitChanges();
}
}
