//修改分类
protected void btnChange_Click(object sender, EventArgs e)
{
string title = txtChangeTitle.Text;
string link = txtChangeLink.Text;
string order = (txtChangeOrder.Text);
if (title.Length == 0 || link.Length == 0 || order.Length == 0)
{
JSHelper.ShowAlert("输入不能为空！");
}
else if (Convert.ToInt16(order) > 4 || Convert.ToInt16(order) <= 0)
{
JSHelper.ShowAlert("请正确输入列数！");
}
else
{
using (var db = new TeachingCenterEntities())
{
int id = Convert.ToInt32(lbID.Text);
FriendsLink cate = db.FriendsLink.Single(a => a.id == id);
cate.title = title;
cate.link = link;
cate.orders = Convert.ToInt16(order);
db.SaveChanges();
Server.Transfer("FriendsLink.aspx");
//JSHelper.AlertThenRedirect("修改成功！", "FriendsLink.aspx");
}
}
}
//添加分类
protected void btnSubAdd_Click(object sender, EventArgs e)
{
string title = txtCategory.Text;
string link = txtLink.Text;
string order = (txtOrder.Text);
if (title.Length == 0 || link.Length == 0 || order.Length == 0)
{
JSHelper.ShowAlert("输入不能为空！");
}
else if (Convert.ToInt16(order) > 4 || Convert.ToInt16(order) <= 0)
{
JSHelper.ShowAlert("请正确输入列数！");
}
else
{
using (var db = new TeachingCenterEntities())
{
var cate = new FriendsLink();
cate.title = title;
cate.link = link;
cate.orders = Convert.ToInt16(order);
db.FriendsLink.Add(cate);
db.SaveChanges();
Server.Transfer("FriendsLink.aspx");
//JSHelper.AlertThenRedirect("添加成功！", "FriendsLink.aspx");
}
}
}
protected void rptCategory_ItemCommand(object source, RepeaterCommandEventArgs e)
{
//删除专题分类
if (e.CommandName == "Delete")
{
int id = Convert.ToInt32(e.CommandArgument.ToString());
using (var db = new TeachingCenterEntities())
{
FriendsLink sc = db.FriendsLink.Single(a => a.id == id);
db.FriendsLink.Remove(sc);
db.SaveChanges();
//JSHelper.AlertThenRedirect("删除成功！", "FriendsLink.aspx");
Server.Transfer("FriendsLink.aspx");
}
}
//修改分类
if (e.CommandName == "Editor")
{
int id = Convert.ToInt32(e.CommandArgument.ToString());
lbID.Text = id.ToString();
using (var db = new TeachingCenterEntities())
{
FriendsLink sc = db.FriendsLink.Single(a => a.id == id);
txtChangeTitle.Text = sc.title;
txtChangeOrder.Text = sc.orders.ToString();
txtChangeLink.Text = sc.link;
}
divEditor.Visible = true;
}
}
//批量删除
protected void btnDelete_Click(object sender, EventArgs e)
{
using (var db = new TeachingCenterEntities())
{
int count = 0;
for (int i = 0; i < this.rptCategory.Items.Count; i++)
{
CheckBox cbx = (CheckBox)rptCategory.Items[i].FindControl("chbCheck");
if (cbx != null)
{
if (cbx.Checked == true)
{
count++;
}
}
}
var list = from it in db.FriendsLink select it;
if (list.Count() == count)
{
JSHelper.ShowAlert("请至少留有一个分类！");
}
else
{
for (int i = 0; i < rptCategory.Items.Count; i++)
{
CheckBox cbx = (CheckBox)rptCategory.Items[i].FindControl("chbCheck");
int name = Convert.ToInt16(((Label)rptCategory.Items[i].FindControl("lbItemID")).Text);
if (cbx != null)
{
if (cbx.Checked == true)
{
FriendsLink sc = db.FriendsLink.Single(a => a.id == name);
db.FriendsLink.Remove(sc);
db.SaveChanges();
}
}
}
Server.Transfer("FriendsLink.aspx");
// JSHelper.AlertThenRedirect("删除成功！", "FriendsLink.aspx");
}
}
}
