//添加分类 protected void btnSubAdd_Click(object sender, EventArgs e) { string category = txtCategory.Text; if (category.Length == 0) { JSHelper.ShowAlert("输入不能为空!"); } else if (checkCategoryNameExit(category)) { JSHelper.ShowAlert("该分类已存在!"); } else { using (var db = new TeachingCenterEntities()) { var cate = new ProCatCategory(); cate.ProCatCategory_name = category; db.ProCatCategory.Add(cate); db.SaveChanges(); Server.Transfer("ProCatManage.aspx"); //JSHelper.AlertThenRedirect("添加成功!", "ActivityCatagoryManage.aspx"); //Server.Transfer("ActivityCatagoryManage.aspx"); } } }
//protected void btnOpen_Click(object sender, EventArgs e) //{ // plOpen.Visible = true; //} //protected void btnSubmit_Click(object sender, EventArgs e) //{ // int id = Convert.ToInt32(Request.QueryString["id"]); // using (var db = new TeachingCenterEntities()) // { // if(setIsPass()) // { // var category = db.ProjectCategory.SingleOrDefault(a => a.id == id); // DateTime now = DateTime.Now; // if(DateTime.Compare(now, Convert.ToDateTime(category.end_time)) < 0) // Response.Write("<script>alert('项目提交尚未结束,暂时无法开启下一阶段!');</script>"); // else if(DateTime.Compare(now, Convert.ToDateTime(category.judge_end_time)) < 0) // Response.Write("<script>alert('评审工作尚未结束,暂时无法开启下一阶段!');</script>"); // else // { // category.stage += 1; // category.end_time = txtTime.Text; // category.judge_end_time = txtJudgeTime.Text; // db.SaveChanges(); // //Response.Write("<script>alert('开放成功!');location.href='ProCategoryList.aspx';</script>"); // Server.Transfer("ProCategoryList.aspx"); // } // } // else // { // Response.Write("<script>alert('开放失败!');location.href='ProCategoryList.aspx';</script>"); // } // } //} //// 开启下一阶段前将尚未完善的项目和为评判结果的评审记录设置为超时 //protected bool setIsPass() //{ // try // { // // 获取当前项目类型id // int id = Convert.ToInt32(Request.QueryString["id"]); // using (var db = new TeachingCenterEntities()) // { // var category = (from it in db.ProjectCategory where it.id == id select it).FirstOrDefault(); // 当前项目类型 // DateTime end_time = Convert.ToDateTime(category.end_time); // 提交项目截止时间 // DateTime judge_end_time = Convert.ToDateTime(category.judge_end_time); // 评审评判截止时间 // // 遍历所有项目 // var project = from it in db.Project where it.is_deleted == 0 select it; // foreach (var item in project) // { // // 判断是否属于当前项目类型 // if (item.category == id) // { // // 获取该项目当前的阶段 // var pro = (from it in db.ProjectStage where it.project_id == item.project_id orderby it.stage descending select it).FirstOrDefault(); // // 若该项目当前阶段落后于项目类型的阶段,则设置为超时 // if (pro.stage < category.stage || pro.is_pass < 0) // { // pro.is_pass = -100; // } // // 遍历该项目分配至评审的所有记录 // var judge = from it in db.ProjectJudge where it.project_id == item.project_id select it; // if (judge.Count() != 0) // { // foreach (var record in judge) // { // // 若该记录当前阶段落后于项目类型的阶段,则设置为超时 // if (record.is_pass == -1) // { // record.is_pass = -100; // } // } // } // } // } // db.SaveChanges(); // } // return true; // } // catch // { // return false; // } //} public static string getCategoryName(int id) { using (var db = new TeachingCenterEntities()) { ProCatCategory pc = db.ProCatCategory.Single(a => a.ProCatCategory_id == id); return(pc.ProCatCategory_name); } }
public static int getId(string name) { using (var db = new TeachingCenterEntities()) { ProCatCategory pc = db.ProCatCategory.Single(a => a.ProCatCategory_name == name); return(pc.ProCatCategory_id); } }
//批量删除 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.ProCatCategory 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"); string name = ((Literal)rptCategory.Items[i].FindControl("ltName")).Text; if (cbx != null) { if (cbx.Checked == true) { ProCatCategory sc = db.ProCatCategory.Single(a => a.ProCatCategory_name == name); db.ProCatCategory.Remove(sc); db.SaveChanges(); } } } //JSHelper.AlertThenRedirect("删除成功!", "ActivityCatagoryManage.aspx"); Server.Transfer("ProCatManage.aspx"); } } }
//修改分类 protected void btnChange_Click(object sender, EventArgs e) { if (txtChange.Text.Length == 0) { JSHelper.ShowAlert("输入不能为空!"); } else if (checkCategoryNameExit(txtChange.Text)) { JSHelper.ShowAlert("该分类已存在!"); } else { using (var db = new TeachingCenterEntities()) { int id = Convert.ToInt32(lbID.Text); ProCatCategory sc = db.ProCatCategory.Single(a => a.ProCatCategory_id == id); sc.ProCatCategory_name = txtChange.Text; db.SaveChanges(); Server.Transfer("ProCatManage.aspx"); // JSHelper.AlertThenRedirect("修改成功!", "ActivityCatagoryManage.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()) { var list = from it in db.ProCatCategory select it; if (list.Count() == 1) { JSHelper.ShowAlert("已经是最后一个分类了!"); } else { ProCatCategory sc = db.ProCatCategory.Single(a => a.ProCatCategory_id == id); db.ProCatCategory.Remove(sc); db.SaveChanges(); //JSHelper.AlertThenRedirect("删除成功!", "ActivityCatagoryManage.aspx"); Server.Transfer("ProCatManage.aspx"); } } } //修改分类 if (e.CommandName == "Editor") { int id = Convert.ToInt32(e.CommandArgument.ToString()); lbID.Text = id.ToString(); using (var db = new TeachingCenterEntities()) { ProCatCategory sc = db.ProCatCategory.Single(a => a.ProCatCategory_id == id); txtChange.Text = sc.ProCatCategory_name; } divEditor.Visible = true; } }