protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"] == null||Request.QueryString["id"].Length>8 || !Filter.IsNumeric(Request.QueryString["id"]))
{
Response.Redirect("error.aspx");
}
using(var db=new ITStudioEntities())
{
int id = Convert.ToInt32(Request.QueryString["id"]);
if(db.notices.SingleOrDefault(a => a.id == id)==null)
{
Response.Redirect("error.aspx");
}
}
btnSubmit.Enabled = true;
if (!IsPostBack)
{
int id = Convert.ToInt16(Request.QueryString["id"]);
using (var db = new ITStudioEntities())
{
notices not = db.notices.SingleOrDefault(a => a.id == id);
txtTitle.Text = not.title;
ueditor.Value = not.content;
}
}
}
public void Application1(object sender, EventArgs e)
{
try
{
using (var db = new ITStudioEntities())
{
applications ap = new applications();
ap.name = takeMaxChar(HttpUtility.HtmlEncode(TxtName.Text.Trim()));
ap.major = takeMaxChar(HttpUtility.HtmlEncode(TxtMajor.Text.Trim()));
ap.time = DateTime.Now;
ap.gender = Convert.ToBoolean(DdlGender.SelectedValue);
ap.tel = takeMaxChar(HttpUtility.HtmlEncode(TxtTel.Text.Trim())); //####ToDo:验证格式
ap.job = takeMaxChar(HttpUtility.HtmlEncode(DdlJob.SelectedItem.Text));
ap.introduction = HttpUtility.HtmlEncode(TxtIntroduction.Value.Trim());
db.applications.Add(ap);
db.SaveChanges();
}
Response.Write("<script>alert('恭喜您，报名成功');window.window.location.href='index.aspx';</script> ");
}
catch
{
Response.Write("<script>alert('报名失败，请重试');window.window.location.href='index.aspx';</script> ");
}
finally
{
}
}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
//避免js失效，后端验证
string title = txtTitle.Text;
if (txtTitle.Text == null || txtTitle.Text.Trim() == "")
{
LblStatus.Text = "请填写标题";
LblStatus.Visible = true;
return;
}
string content = ueditor.Value;
if (content == null || content.Trim() == "")
{
LblStatus.Text = "请填写内容";
LblStatus.Visible = true;
return;
}
using (var db = new ITStudioEntities())
{
var not = new notices();
not.time = DateTime.Now;
not.title = txtTitle.Text;
not.content = ueditor.Value;
db.notices.Add(not);
db.SaveChanges();
}
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('添加成功');</script>");
txtTitle.Text = "";
ueditor.Value = "";
}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
int id = Convert.ToInt16(Request.QueryString["id"]);
using (var db = new ITStudioEntities())
{
notices not = db.notices.SingleOrDefault(a => a.id == id);
not.time = DateTime.Now;
not.title = txtTitle.Text;
not.content = ueditor.Value;
db.SaveChanges();
}
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改成功');</script>");
}
//protected void rptWorks_ItemCommand(object source, RepeaterCommandEventArgs e)
//{
// if(e.CommandName=="imgWork")
// {
// using (var db = new ITStudioEntities())
// {
// int id =Convert.ToInt32(e.CommandArgument);
// works work = db.works.SingleOrDefault(a => a.id == id);
// string site = work.link;
// System.Diagnostics.Process.Start(site);
// }
// }
//}
//protected void AspNetPager_PageChanged(object sender, EventArgs e)
//{
// using (var db = new ITStudioEntities())
// {
// PagedDataSource pd = new PagedDataSource();
// pd.DataSource = (from items in db.works
// orderby items.id descending
// select items).ToList();
// pd.AllowPaging = true;
// if (pd.DataSourceCount > AspNetPager.PageSize)
// {
// this.AspNetPager.AlwaysShow = true;
// }
// this.AspNetPager.RecordCount = pd.DataSourceCount;
// pd.PageSize = this.AspNetPager.PageSize;
// pd.CurrentPageIndex = this.AspNetPager.CurrentPageIndex - 1;
// rptWorks.DataSource = pd;
// rptWorks.DataBind();
// }
//}
/// <summary>
/// 获得作品的总页数
/// </summary>
/// <param name="pageSize">每页项目数量</param>
/// <param name="typeId">项目类型，默认值为0表示所有类型</param>
/// <returns>总页数</returns>
int getPageCount(int pageSize, int typeId = 0)
{
int pageCount = 1;
using (var db = new ITStudioEntities())
{
var dataSource = from items in db.works
where (typeId != 0 ? (items.typeId == typeId) : (1 == 1)) //判断是否有类型限制
select new { items };
int totalAmount = dataSource.Count();
pageCount = (int)Math.Ceiling((double)totalAmount / (double)pageSize); //总页数，向上取整
}
return pageCount;
}
/// <summary>
/// 增加管理员
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void BtnAddAdmin_Click(object sender, EventArgs e)
{
if (TxtNewAdminName.Text == "" || TxtNewAdminPassword.Text == "" || TxtNewAdminPasswordAgain.Text == "")
{
Response.Write("<script>alert('管理员名和密码不能为空！')</script>");
return;
}
string newName = TxtNewAdminName.Text;
if (newName.Length > 16)
{
Response.Write("<script>alert('新管理员登录名长度应小于16位')</script>");
return;
}
if (TxtNewAdminPassword.Text != TxtNewAdminPasswordAgain.Text)
{
Response.Write("<script>alert('两次密码不一致！')</script>");
return;
}
else if (TxtNewAdminPassword.Text.Length < 6 || TxtNewAdminPassword.Text.Length > 16)
{
Response.Write("<script>alert('密码位数应在6到16位！')</script>");
return;
}
using (var db = new ITStudioEntities()) //检验是否已存在此登录名
{
admins admin = db.admins.SingleOrDefault(a => a.name == newName);
if (admin != null)
{
Response.Write("<script>alert('此管理员已存在!')</script>");
return;
}
}
string sha = getHash.getSHA1(TxtNewAdminPassword.Text);
using (var db = new ITStudioEntities())
{
var a = new admins();
a.name = TxtNewAdminName.Text;
a.password = sha;
db.admins.Add(a);
db.SaveChanges();
}
adminsBind();
TxtNewAdminName.Text = "";
Response.Write("<script>alert('管理员添加成功!')</script>");
}
protected void Page_Load(object sender, EventArgs e)
{
using(var db = new ITStudioEntities())
{
var search = from it in db.members
where it.grade == 2010
orderby it.id
select it;
RptMember1.DataSource = search.Take(3).ToList();
RptMember1.DataBind();
RptMember2.DataSource = search.Skip(3).Take(3).ToList();
RptMember2.DataBind();
RptMember0.DataSource = search.ToList();
RptMember0.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
btnSubmit.Enabled = false;
btnSubmit.Text = "请填写完整";
using (var db = new ITStudioEntities())
{
//作者
ChklstAuthors.DataSource = db.members.ToList();
ChklstAuthors.DataValueField = "id";
ChklstAuthors.DataTextField = "name";
ChklstAuthors.DataBind();
}
}
}
int pageSize = 6; //页面项目数
#endregion Fields
#region Methods
protected void Page_Load(object sender, EventArgs e)
{
int currentPage = getPageNum();
int typeId = getWorkTypeId();
worksBind(currentPage, pageSize, typeId);
pageNumsBind();
using (var db = new ITStudioEntities())
{
var dataSource = from u in db.works
select new
{
u.time,
u.id,
u.title,
u.introduction,
u.picture,
};
RptWorkOnMobile.DataSource = dataSource.ToList();
RptWorkOnMobile.DataBind();
}
}
public static bool isCookieValidated(string name, string token)
{
/*
* 说明：cookie 中的 token 是 SHA-1(name + SHA-1(password) + ip + ua)
* 数据库中，password储存为 SHA-1(password)
*/
// #### 此处可以考虑使用封装的函数etc
using (var db = new ITStudioEntities())
{
admins admin = db.admins.SingleOrDefault(a => a.name == name);
if (admin == null)
{
return false;
}
string passwordHash = admin.password;
string ua = HttpContext.Current.Request.UserAgent;
if (ua == null)
{
ua = String.Empty;
}
// 如果用户通过代理服务器访问，获取到的将是代理服务器的ip。此ip不可随意伪造。
string ip = HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"];
if (ip == null) //我想一般不会有这种情况。
{
ip = String.Empty;
}
if (token != getHash.getSHA1(name + passwordHash + ip + ua))
{
return false;
}
else
{
return true;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
int ID = Convert.ToInt32(Request.QueryString["id"]);
using (var db = new ITStudioEntities())
{
var dataSource = from u in db.members
where (u.id == ID)
select new
{
u.name,
u.introduction,
u.photo,
u.grade,
u.direction,
};
RptMenber.DataSource = dataSource.ToList();
RptMenber.DataBind();
RptMember2.DataSource = dataSource.ToList();
RptMember2.DataBind();
var dataSource1 = from u in db.outWorks
where (u.memberId == ID)
orderby u.time descending
select new
{
u.picture,
u.introduction,
u.title,
u.time,
};
RptWorks.DataSource = dataSource1.Take(3).ToList();
RptWorks.DataBind();
RptWorks2.DataSource = dataSource1.Take(2).ToList();
RptWorks3.DataSource = dataSource1.Skip(2).Take(2).ToList();
}
}
/// <summary>
/// 绑定作品，可指定作品类型（默认为0表示没有所有类型）
/// </summary>
/// <param name="CurrentPage">页码</param>
/// <param name="pageSize">页面项目数</param>
/// <param name="typeId">作品类型</param>
void worksBind(int CurrentPage,int pageSize, int typeId=0)
{
using (var db = new ITStudioEntities())
{
var dataSource = from items in db.works
orderby items.time descending
where(typeId != 0? (items.typeId == typeId):(1==1)) //判断是否有类型限制
select new
{
items.id,
items.typeId,
items.title,
items.time,
items.picture,
items.link,
items.introduction
};
dataSource = dataSource.Skip(pageSize * (CurrentPage - 1)).Take(pageSize); // 分页
//if (dataSource.Count() == 0)
//{
// Response.Redirect("error.html");
//}
rptWorks.DataSource = dataSource.ToList();
rptWorks.DataBind();
}
}
/// <summary>
/// 提交修改键
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void BtnSubmit_Click(object sender, EventArgs e)
{
//避免js失效，后端验证
string title = txtTitle.Text;
if (txtTitle.Text == null || txtTitle.Text.Trim() == "")
{
LblStatus.Text = "请填写标题";
LblStatus.Visible = true;
return;
}
string content = txtIntroduction.InnerText;
if (content == null || content.Trim() == "")
{
LblStatus.Text = "请填写内容";
LblStatus.Visible = true;
return;
}
string workPicName = uploadWorkPic();
//if (workPicName == null || workPicName.Trim() == "") // 可以不修改作品图片
//{
// LblStatus.Text = "请选择作品图片";
// LblStatus.Visible = true;
// return;
//}
string time = txtTime.Text;
if (time == null || time.Trim() == "")
{
LblStatus.Text = "请填写时间";
LblStatus.Visible = true;
return;
}
int id = Convert.ToInt32(Request.QueryString["id"]);
//删除旧封面图片
if (workPicName != null) //此时：已上传新封面图片，文件名未写入数据库
{
string oldCoverPic = "";
using (var db = new ITStudioEntities())
{
works w = db.works.SingleOrDefault(a => a.id == id);
if (w == null)
{
return;
}
oldCoverPic = w.picture;
string oldCoverPicPath = "/upload/workPicture/" + oldCoverPic; //相对路径
oldCoverPicPath = Server.MapPath(oldCoverPicPath); //必须经过这一步操作才能变成有效路径
if (System.IO.File.Exists(oldCoverPicPath))//先判断文件是否存在，再执行操作
{
System.IO.File.Delete(oldCoverPicPath); //删除文件
}
}
}
// 写入数据库
using (var db = new ITStudioEntities())
{
//修改works表
works work = db.works.SingleOrDefault(a => a.id == id);
work.typeId = Convert.ToInt32(ddlType.SelectedValue);
if (workPicName != null)
{
work.picture = workPicName; // 修改了图片的情况
ImgCurrentWorkPic.ImageUrl = "/upload/workPicture/" + workPicName;
}
work.title = title;
work.introduction = content;
work.time = txtTime.Text;
work.link = ITStudioHelper.addProtocol(txtLink.Text);
//修改workmap表
for (int i = 0; i < ChklstAuthors.Items.Count; i++) // 遍历CheckBoxList
{
int memberId = Convert.ToInt32(ChklstAuthors.Items[i].Value);
workmap map = db.workmap.SingleOrDefault(a => a.workId == id && a.memberId == memberId);
if (map != null)
{
db.workmap.Remove(map);
}
}
for (int i = 0; i < ChklstAuthors.Items.Count; i++) // 遍历CheckBoxList
{
if (ChklstAuthors.Items[i].Selected == true)
{
int memberId = 1;
if (Filter.IsNumeric(ChklstAuthors.Items[i].Value))
{
memberId = Convert.ToInt32(ChklstAuthors.Items[i].Value);
}
var map = new workmap();
map.memberId = memberId;
map.workId = id;
db.workmap.Add(map);
}
}
db.SaveChanges();
}
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改成功');</script>");
}
//获得总页数
int getPageCount(int pageSize)
{
int pageCount = 1;
if (Session["pageCount"] == null)
{
using (var db = new ITStudioEntities())
{
var dataSource = from items in db.works
orderby items.id
select new { items };
int totalAmount = dataSource.Count();
pageCount = (int)Math.Ceiling((double)totalAmount / (double)pageSize); //总页数，向上取整
}
Session["pageCount"] = pageCount;
}
else
{
pageCount = Convert.ToInt32(Session["pageCount"]);
}
return pageCount;
}
/// <summary>
/// 绑定管理员列表
/// </summary>
void adminsBind()
{
using (var db = new ITStudioEntities())
{
var dataSource = from a in db.admins
orderby a.id
select new { a.id, a.name };
RptAdmins.DataSource = dataSource.ToList();
RptAdmins.DataBind();
}
}
/// <summary>
/// Admin 列表操作项目
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
protected void RptAdmins_ItemCommand(object source, RepeaterCommandEventArgs e)
{
//删除操作
if (e.CommandName == "delete_admin")
{
int ID = Convert.ToInt32(e.CommandArgument.ToString().Trim());
using (var db = new ITStudioEntities())
{
admins c1 = db.admins.SingleOrDefault(a => a.id == ID);
db.admins.Remove(c1);
db.SaveChanges();
adminsBind();
Response.Write("<script>alert('管理员删除成功!')</script>");
}
}
else //修改操作
{
TblChangePassword.Visible = true;
BtnChange.Visible = true;
int ID = Convert.ToInt32(e.CommandArgument.ToString().Trim());
TxtIdToChange.Text = ID.ToString();
}
}
protected void RptArticles_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "delete") //删除人员
{
string IDStr = e.CommandArgument.ToString().Trim();
int id = Convert.ToInt32(IDStr);
using (var db = new ITStudioEntities())
{
members mem = db.members.SingleOrDefault(a => a.id == id);
//删除封面图片
string photoPath = mem.others;//相对路径
if (photoPath != null)
{
photoPath = Server.MapPath(photoPath); //必须经过这一步操作才能变成有效路径
if (System.IO.File.Exists(photoPath))//先判断文件是否存在，再执行操作
{
System.IO.File.Delete(photoPath); //删除文件
}
}
db.members.Remove(mem);
db.SaveChanges();
}
ArticlesBind(getPageNum(), getPageSize());
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('人员删除成功');</script>");
}
}
/// <summary>
/// 存储作品到works表;存储作品和多个成员关系
/// </summary>
/// <param name="typeId">类型在type表中的id</param>
/// <param name="title">作品标题</param>
/// <param name="time">作品完成时间</param>
/// <param name="introduction">作品简介</param>
/// <param name="workPicName">作品图片文件名（不含路径）</param>
/// <param name="link">作品链接</param>
void submitWork(int typeId,string title,string time, string introduction, string workPicName,string link)
{
using (var db = new ITStudioEntities())
{
var work = new works(); // 要添加的作品
work.typeId = typeId;
work.picture = workPicName;
work.title = title;
work.introduction = introduction;
work.time = time;
work.link = link;
db.works.Add(work);
db.SaveChanges();
int workId = work.id;
// works work2 = db.works.SingleOrDefault(a => a.picture == work.picture); //意义不明，可能是为了获取刚添加的作品。
// 存储多个作者到 workmap 表
for (int i = 0; i < ChklstAuthors.Items.Count; i++) // 遍历CheckBoxList
{
if (ChklstAuthors.Items[i].Selected == true)
{
int memberId = 1;
if (Filter.IsNumeric(ChklstAuthors.Items[i].Value))
{
memberId = Convert.ToInt32(ChklstAuthors.Items[i].Value);
}
var map = new workmap();
map.memberId = memberId;
map.workId = workId;
db.workmap.Add(map);
db.SaveChanges();
}
}
}
}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
//避免js失效，后端验证
string name = txtName.Text;
if (txtName.Text == null || txtName.Text.Trim() == "")
{
LblStatus.Text = "请填写姓名";
LblStatus.Visible = true;
return;
}
string direction = txtDirection.Text;
if (direction == null || direction == "")
{
LblStatus.Text = "请填写方向";
LblStatus.Visible = true;
return;
}
string content = txtIntroduction.InnerText;
content = content.Replace("\n", "<br />"); // 尝试替换\n为<br />
if (content == null || content.Trim() == "")
{
LblStatus.Text = "请填写简介";
LblStatus.Visible = true;
return;
}
string photo = uploadMemPho();
if (photo == null || photo.Trim() == "")
{
LblStatus.Text = "请选择照片";
LblStatus.Visible = true;
return;
}
string ico = uploadMemIco();
if (photo == null || photo.Trim() == "")
{
LblStatus.Text = "请选择头像";
LblStatus.Visible = true;
return;
}
//存储成员到members表
using (var db = new ITStudioEntities())
{
var mem = new members();
mem.grade = Convert.ToInt32(ddlGrade.SelectedValue);
mem.photo = photo;
mem.ico = ico;
mem.name = name;
mem.introduction = content;
mem.direction = direction;
mem.job = ddlDeparement.SelectedValue;
db.members.Add(mem);
db.SaveChanges();
}
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('添加成功');</script>");
txtName.Text = "";
txtIntroduction.InnerText = "";
ddlDeparement.SelectedValue = "程序开发";
}
/// <summary>
/// 修改密码
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void BtnChange_Click(object sender, EventArgs e)
{
int ID = 0;
if (TxtIdToChange.Text != null && TxtIdToChange.Text.Trim() != "" && Filter.IsNumeric(TxtIdToChange.Text))
{
ID = Convert.ToInt32(TxtIdToChange.Text.Trim());
}
else
{
return;
}
string oldPassword = TxtOldPassword.Text;
string newPassword = TxtNewPassword.Text;
if (newPassword.Length < 6 || newPassword.Length > 16)
{
Response.Write("<script>alert('密码位数应在6到16位')</script>");
return;
}
string oldPasswordHash = getHash.getSHA1(oldPassword);
string newPasswordHash = getHash.getSHA1(newPassword);
using (var db = new ITStudioEntities())
{
admins c2 = db.admins.SingleOrDefault(c => c.id == ID);
if (c2 == null)
{
return;
}
if (newPassword != "" && oldPassword != "")
{
if (c2.password.ToString() == oldPasswordHash)
{
c2.password = newPasswordHash;
db.SaveChanges();
adminsBind();
Response.Write("<script>alert('密码修改成功！')</script>");
TblChangePassword.Visible = false;
BtnChange.Visible = false;
}
else
Response.Write("<script>alert('原密码错误！')</script>");
}
else
Response.Write("<script>alert('请完整输入！')</script>");
}
}
/// <summary>
/// 申请信息列表绑定
/// </summary>
/// <param name="CurrentPage">当前页码</param>
/// <param name="PageSize">页面项目总数</param>
void ApplicationBind(int CurrentPage, int PageSize)
{
using (var db = new ITStudioEntities())
{
var dataSource = from items in db.applications
orderby items.id descending
select new { items.id, items.name, items.gender, items.major, items.job, items.tel, items.time, items.introduction };
int totalAmount = dataSource.Count();
Session["pageCount"] = Math.Ceiling((double)totalAmount / (double)PageSize); //总页数，向上取整
dataSource = dataSource.Skip(PageSize * (CurrentPage - 1)).Take(PageSize); //分页
RptApplication.DataSource = dataSource.ToList();
RptApplication.DataBind();
LtlApplicationsCount.Text = totalAmount.ToString();
}
}
//从DataGrid导出
private void ExportDataGrid(string Job,string FileType, string FileName)
{
System.Web.UI.WebControls.DataGrid dg = new System.Web.UI.WebControls.DataGrid();
using (var db = new ITStudioEntities())
{
var dt = from it in db.applications
where it.job == Job
select it;
dg.DataSource = dt.ToList();
}
dg.DataBind();
//定义文档类型、字符编码
Response.Clear();
Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());
Response.Charset = "UTF-8";
Response.ContentEncoding = Encoding.Default;
Response.ContentType = FileType;
dg.EnableViewState = false;
//定义一个输入流
StringWriter tw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(tw);
//目标数据绑定到输入流输出
dg.RenderControl(hw);
//GvContract 绑定datagrid,或其他支持obj.RenderControl()属性的控件
//ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "info", tw.ToString(), false);
Response.Write(tw.ToString());
Response.End();
//Response.Flush();
//Response.Close();
}
//文章绑定
void ArticlesBind(int CurrentPage, int PageSize)
{
using (var db = new ITStudioEntities())
{
var dataSource = from items in db.works
orderby items.id descending
select new { items.id, items.title, items.time, items.link };
int totalAmount = dataSource.Count();
Session["pageCount"] = Math.Ceiling((double)totalAmount / (double)PageSize); //总页数，向上取整
dataSource = dataSource.Skip(PageSize * (CurrentPage - 1)).Take(PageSize); //分页
RptArticles.DataSource = dataSource.ToList();
RptArticles.DataBind();
LtlArticlesCount.Text = totalAmount.ToString();
}
}
protected void RptArticles_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "delete") //删除文章
{
string IDStr = e.CommandArgument.ToString().Trim();
int id = Convert.ToInt32(IDStr);
using (var db = new ITStudioEntities())
{
notices not = db.notices.SingleOrDefault(a => a.id == id);
db.notices.Remove(not);
db.SaveChanges();
}
ArticlesBind(getPageNum(), getPageSize());
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('文章删除成功');</script>");
}
}
protected void RptArticles_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "delete") //删除文章
{
string IDStr = e.CommandArgument.ToString().Trim();
int id = Convert.ToInt32(IDStr);
using (var db = new ITStudioEntities())
{
works work = db.works.SingleOrDefault(a => a.id == id);
//删除封面图片
string coverPicName = work.picture;//相对路径
if (coverPicName != null)
{
coverPicName = Server.MapPath(coverPicName); //必须经过这一步操作才能变成有效路径
if (System.IO.File.Exists(coverPicName))//先判断文件是否存在，再执行操作
{
System.IO.File.Delete(coverPicName); //删除文件
}
}
db.works.Remove(work);
var dataSource =(from items in db.workmap
orderby items.id descending
where items.workId==id
select items).ToList();
// 对 LINQ 查询而返回的结果集进行处理
// 要么使用 Single() 取出单条记录
// 要么就迭代集合进行处理
foreach (workmap o in dataSource)
{
db.workmap.Remove(o);
}
db.SaveChanges();
}
ArticlesBind(getPageNum(), getPageSize());
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('文章删除成功');</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"] == null || Request.QueryString["id"].Length > 8 || !Filter.IsNumeric(Request.QueryString["id"]))
{
Response.Redirect("error.aspx");
}
using (var db = new ITStudioEntities())
{
int id = Convert.ToInt32(Request.QueryString["id"]);
if (db.works.SingleOrDefault(a => a.id == id) == null)
{
Response.Redirect("error.aspx");
}
}
btnSubmit.Enabled = true;
if (!IsPostBack)
{
int id = Convert.ToInt16(Request.QueryString["id"]);
using (var db = new ITStudioEntities())
{
works work = db.works.SingleOrDefault(a => a.id == id);
txtTitle.Text = work.title;
txtIntroduction.InnerText = work.introduction;
txtLink.Text = work.link;
txtTime.Text = work.time;
ImgCurrentWorkPic.ImageUrl = "/upload/workPicture/" + work.picture;
ddlType.SelectedValue = work.typeId.ToString();
//作者
ChklstAuthors.DataSource = db.members.ToList();
ChklstAuthors.DataValueField = "id";
ChklstAuthors.DataTextField = "name";
ChklstAuthors.DataBind();
for (int i = 0; i < ChklstAuthors.Items.Count; i++) // 遍历CheckBoxList
{
int memberId = Convert.ToInt32(ChklstAuthors.Items[i].Value);
workmap map = db.workmap.SingleOrDefault(a => a.workId == id &&a.memberId==memberId);
if (map!=null)
{
ChklstAuthors.Items[i].Selected = true;
}
}
}
}
}
