<td><asp:LinkButton ID="delBtn" runat="Server" CommandArgument='<%#((DataRowView)Container.DataItem)["id"]%>' CommandName="del" OnClientClick="return confirm( '确认要删除吗？') ;" class="del_btn"><img src="../image/trash.gif" alt="" title="" border="0" /></asp:LinkButton></td>
protected void DataList1_ItemCommand(object source,RepeaterCommandEventArgs e)
{
int cmtid =int.Parse(e.CommandArgument.ToString());
DataTable dt = sql.ExecuteDataset("select expiry from seniority where id = '" + cmtid +"' ","a").Tables[0];
switch (e.CommandName)
{
case "del":
if (dt.Rows[0]["expiry"].ToString() == "无效")
{
sql.ExecuteDataset("delete seniority where id = '" + cmtid + "' ","a");
Response.Write("<script>alert('删除成功!') </script>");
dlBind();
}
else {
Response.Write("<script>alert('不能删除有效数据!') </script>");
}
break;
case "shengxiao":
sql.ExecuteDataset("update seniority set expiry ='有效' where id = '" + cmtid + "'","a");
dlBind();
break;
case "shixiao":
sql.ExecuteDataset("update seniority set expiry ='无效' where id = '" + cmtid + "'","a");
dlBind();
break;
default:
break;
}
