protected void btDel_Click(object sender, EventArgs e) { lbErr.Visible = false; CheckBox ch; LabMS.BLL.OpentProject bopentproject = new LabMS.BLL.OpentProject(); ExtendBLL.ProjectAppointment extendprojectapp = new ExtendBLL.ProjectAppointment(); try { for (int i = 0; i < gv_OpenProjectList.Rows.Count; i++) { ch = (CheckBox)gv_OpenProjectList.Rows[i].FindControl("checkdel"); if (ch.Checked) { extendprojectapp.Del(" where OP_ProjectCode='" + gv_OpenProjectList.DataKeys[i]["OP_ProjectCode"].ToString() + "'"); string CID = gv_OpenProjectList.DataKeys[i]["ID"].ToString(); bopentproject.Delete(int.Parse(CID)); } } //checkall.Checked = false; if (lbIsSearch.Text == "0") { bind(""); } else { string strWhere = " 1=1 "; if (ddlLab.SelectedValue != "0") { strWhere += "and Project_Lab = '" + ddlLab.SelectedValue + "'"; } if (ddlStatus.SelectedValue != "-1") { strWhere += "and OP_Audit = '" + ddlStatus.SelectedValue + "'"; } if (ddlYear.SelectedValue != "0") { strWhere += "and SYear = '" + ddlYear.SelectedValue + "'"; } if (ddlSemester.SelectedValue != "-1") { strWhere += "and Semester = '" + ddlSemester.SelectedValue + "'"; } if (!tbProjectName.Text.Trim().Equals("")) { strWhere += "and OP_ProjectName like '%" + tbProjectName.Text.Trim() + "%'"; } bind(strWhere); } Common.JShelper.JSAlert(Page, "success", "删除成功!"); } catch (Exception ex) { Common.JShelper.JSAlert(Page, "err", "删除失败!"); lbErr.Visible = true; lbErr.Text = ex.Message; } }
protected void bnSave_Click(object sender, EventArgs e) { LabMS.BLL.OpentProject boproject = new LabMS.BLL.OpentProject(); LabMS.Model.OpentProject moproject = new LabMS.Model.OpentProject(); lbErr.Visible = false; #region 验证 if (string.IsNullOrEmpty(tbProjectName.Text.Trim())) { LabMS.Common.JShelper.JSAlert(Page, "err", "实验项目名称不能为空!"); return; } if (string.IsNullOrEmpty(tbProjectCode.Text.Trim())) { LabMS.Common.JShelper.JSAlert(Page, "err", "实验项目编号不能为空!"); return; } List<LabMS.Model.OpentProject> listmoproject = new List<LabMS.Model.OpentProject>(); listmoproject = boproject.GetModelList("OP_ProjectCode = '" + tbProjectCode.Text + "'"); if (listmoproject.Count > 0) { LabMS.Common.JShelper.JSAlert(Page, "err", "实验项目编号已存在!"); return; } if (string.IsNullOrEmpty(tbProjectStartWeek.Text.Trim()) || string.IsNullOrEmpty(tbProjectEndWeek.Text.Trim())) { LabMS.Common.JShelper.JSAlert(Page, "err", "实验周次不能为空!"); return; } int iStartWeek = 0; int iEndWeek = 0; if (!(int.TryParse(tbProjectStartWeek.Text.Trim(), out iStartWeek) && int.TryParse(tbProjectEndWeek.Text.Trim(), out iEndWeek))) { LabMS.Common.JShelper.JSAlert(Page, "err", "实验周次只能输入数字!"); return; } if (iStartWeek > iEndWeek) { LabMS.Common.JShelper.JSAlert(Page, "err", "实验周次开始时间大于结束时间!"); return; } if (iStartWeek > 20 || iEndWeek > 20) { LabMS.Common.JShelper.JSAlert(Page, "err", "实验周次过大!"); return; } if (string.IsNullOrEmpty(tbTeacherCode.Value.Trim())) { LabMS.Common.JShelper.JSAlert(Page, "err", "指导老师不能为空!"); return; } if (string.IsNullOrEmpty(tb_StudentIDs.Value.Trim())) { LabMS.Common.JShelper.JSAlert(Page, "err", "实验学生不能为空!"); return; } #endregion moproject.OP_ProjectName = tbProjectName.Text.Trim(); moproject.OP_ProjectCode = tbProjectCode.Text.Trim(); moproject.Project_Category = ddlProjectCategory.SelectedValue; moproject.Project_EndWeek = iEndWeek; moproject.Project_Lab = ddlLabName.SelectedValue; moproject.Project_PartnerType = ddlProjectPartnerType.SelectedValue; moproject.Project_Require = ddlProjectRequire.SelectedValue; moproject.Project_StartWeek = iStartWeek; moproject.Project_Subject = tbProjectSubjectCode.Value; moproject.Project_Type = ddlProjectType.SelectedValue; moproject.OP_AppIntro = tbOPReason.Text.Trim(); moproject.OP_ProSource = ddlProjectComFrom.SelectedValue; moproject.OP_Professioanl = tbOPProfessioanl.Text.Trim(); moproject.OP_PlanningCourseTime = tbOPPlanningCourseTime.Text.Trim(); moproject.OP_Phone = tbOPPhone.Text.Trim(); moproject.OP_InCharge = tbOPInCharge.Text.Trim(); moproject.OP_Grade = ddlOPGrade.SelectedValue; moproject.OP_AppIntro = tbOPContent.Text.Trim(); moproject.OP_Teacher = tbTeacherCode.Value.Trim(); moproject.OP_OpenType = tbOPContent.Text.Trim();//实验内容 LabMS.Model.SysSetting msys = new LabMS.Model.SysSetting(); ExtendBLL.SysSetting extendsys = new ExtendBLL.SysSetting(); msys = extendsys.GetCurrentSetting(); moproject.SYear = msys.CurrentYear; moproject.Semester = msys.CurrentSemester; string strAlertContent = "保存成功!"; moproject.OP_Audit = "0"; if (((Button)sender).ID == "btnApp") { strAlertContent = "申请成功!"; moproject.OP_Audit = "1"; } moproject.OP_AppTime = DateTime.Now; moproject.OP_Applicant = lbAppPerson.Text; int iOpenProjectID = 0; ////添加文件 int Attach_ID = AttachmentSave(); try { if (Attach_ID != 0) { moproject.Attachment = Attach_ID; } iOpenProjectID = boproject.Add(moproject); } catch(Exception ex) { lbErr.Visible = true; lbErr.Text = ex.Message; return; } String [] listsID = tb_StudentIDs.Value.Split(','); for (int i = 0; i < listsID.Length; ++i) { LabMS.Model.ProjectAppointment projectapp = new LabMS.Model.ProjectAppointment(); ExtendBLL.ProjectAppointment bprojectapp = new ExtendBLL.ProjectAppointment(); projectapp.Appoint_ClassID = "0"; projectapp.Appoint_ProID = 0; projectapp.OP_Appoint_ID = listsID[i].ToString(); projectapp.OP_ProjectCode = moproject.OP_ProjectCode; projectapp.OP_Score = ""; try { bprojectapp.Add(projectapp); } catch (Exception ex) { lbErr.Visible = true; lbErr.Text = ex.Message; bprojectapp.Del(" where OP_ProjectCode ='" + moproject.OP_ProjectCode + "'"); boproject.Delete(iOpenProjectID); return; } } Common.JShelper.JSAlertAndRedirect(Page, "success", strAlertContent, "currentopenprojectlist.aspx"); }