/// <summary> /// 获取教师信息给主页面表格 /// </summary> /// <param name="pageSize"></param> /// <param name="pageNumber"></param> /// <returns></returns> public JsonResult GetList(int pageSize, int pageNumber, string TeacherWorkNum, string TeacherName, string CourseName) { BLL.Teacher bll = new BLL.Teacher(); int count = bll.GetCount(); return(Json(new { total = count, rows = bll.GetList(pageSize, pageNumber, TeacherWorkNum, TeacherName, CourseName) })); }
private void btnAllDelete_Click(object sender, EventArgs e) { string message = ""; if (rbTeacher.Checked) { string id = (string)dgvAllTeacher.CurrentRow.Cells[0].Value; if (id != null) { message = new BLL.Teacher().Delete(id); labelMsg1.Text = message; } if (message != "") { dgvAllTeacher.DataSource = new BLL.Teacher().GetAllTeachers(); } } else if (rbStudent.Checked) { string id = (string)dgvAll.CurrentRow.Cells[0].Value; if (id != null) { message = new BLL.Student().Delete(id); labelMsg1.Text = message; } if (message != "") { dgvAll.DataSource = new BLL.Student().GetAllStudents(); } } }
public ActionResult Info() { int Tid = Convert.ToInt32(HttpContext.Session["userid"]); Danyl.SnnuURP.Model.Teacher teacher = new BLL.Teacher().GetModel(Tid); try { Danyl.SnnuURP.Model.Depart depart = new BLL.Depart().GetModel(teacher.DeptId); Danyl.SnnuURP.Model.TeacherType TType = new BLL.TeacherType().GetModel(teacher.TeacherTypeId); Danyl.SnnuURP.Model.UserInfo userInfo = new BLL.UserInfo().GetModel(Tid); ViewBag.Tid = teacher.Tid; ViewBag.Tname = teacher.Tname; ViewBag.Sex = teacher.Sex ? '男' : '女'; ViewBag.IdNumber = teacher.IdNumber; ViewBag.Depart = depart.DeptName; ViewBag.Degree = teacher.Degree; ViewBag.TeacherType = TType.TeacherTypes; ViewBag.Phone = userInfo.UserPhone; ViewBag.Email = userInfo.UserEmail; return View(ViewBag); } catch (Exception ex) { return Redirect("~/Teacher/Account/Login"); } }
/// <summary> /// 删除选择的教师信息 /// </summary> /// <param name="Ids"></param> /// <returns></returns> public JsonResult Delete(string[] Ids) { BLL.Teacher bll = new BLL.Teacher(); int result = bll.Delete(Ids); if (result <= 0) { return(Json("删除失败")); } else { return(Json("删除" + result + "记录")); } }
/// <summary> /// 保存修改后教师信息 /// </summary> /// <param name="EditTeacherName"></param> /// <param name="EditTeacherWorkNum"></param> /// <param name="EditSex"></param> /// <param name="EditIsLeader"></param> /// <param name="EditSchool"></param> /// <param name="EditCourse"></param> /// <param name="EditTeacherPWD"></param> /// <returns></returns> public JsonResult EditSave(int EditId, string EditTeacherName, string EditTeacherWorkNum, int EditSex, int EditIsLeader, int EditSchool, int EditCourse, string EditTeacherPWD) { BLL.Teacher bll = new BLL.Teacher(); int result = bll.EditSave(EditId, EditTeacherName, EditTeacherWorkNum, EditSex, EditIsLeader, EditSchool, EditCourse, EditTeacherPWD); if (result == 1) { return(Json("修改成功")); } else { return(Json("修改失败")); } }
private void ShowInfo(int ID) { JiaJiao.BLL.ClassSetting bll = new JiaJiao.BLL.ClassSetting(); JiaJiao.Model.ClassSetting model = bll.GetModel(ID); this.lblID.Text = model.ID.ToString(); this.lblTotal.Text = model.Total.ToString(); this.lblCount.Text = model.Count.ToString(); JiaJiao.BLL.Class bll1 = new BLL.Class(); var model1 = bll1.GetModel(model.DayId.Value); JiaJiao.BLL.Teacher bll2 = new BLL.Teacher(); var model2 = bll2.GetModel(model.TeacherId); this.lblDayId.Text = model1.Day + " " + model1.Time ; this.lblTeacherId.Text = model2.TeacherName; }
public JsonResult AddSave(string AddTeacherName, string AddTeacherWorkNum, int AddSex, int AddIsLeader, int AddSchool, int AddCourse, string AddTeacherPWD) { BLL.Teacher bll = new BLL.Teacher(); int result = bll.AddSave(AddTeacherName, AddTeacherWorkNum, AddSex, AddIsLeader, AddSchool, AddCourse, AddTeacherPWD); if (result == 1) { return(Json("添加成功")); } else { return(Json("添加失败")); } }
private void 教师信息管理_Load(object sender, EventArgs e) { dataGridView2.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; printDocument1.PrinterSettings.DefaultPageSettings.Landscape = true;//纸张横向 printDocument1.DefaultPageSettings.Landscape = true; string grade = Grade.Text; string major = Major.Text; BLL.Teacher b_teacher = new BLL.Teacher(); DataTable dt = b_teacher.getTeachers(Grade.Text, Major.Text); dataGridView2.DataSource = dt; bs.DataSource = dt; dtInfo = dt.Copy(); InitDataSet(); int width = 0; for (int i = 0; i < this.dataGridView2.Columns.Count; i++) { //将每一列都调整为自动适应模式 this.dataGridView2.AutoResizeColumn(i, DataGridViewAutoSizeColumnMode.AllCellsExceptHeader); //记录整个DataGridView的宽度 width += this.dataGridView2.Columns[i].Width; } //判断调整后的宽度与原来设定的宽度的关系,如果是调整后的宽度大于原来设定的宽度, //则将DataGridView的列自动调整模式设置为显示的列即可, //如果是小于原来设定的宽度,将模式改为填充。 if (width > this.dataGridView2.Size.Width) { this.dataGridView2.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells; } else { this.dataGridView2.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; } //冻结某列 从左开始 0,1,2 dataGridView2.Columns[1].Frozen = true; //内容居中 dataGridView2.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; printDocument1.PrintPage += new PrintPageEventHandler(printdoc_PrintPage); }
private void AddData(HttpContext context) { var teaModel = new Models.Teacher(); teaModel.TeacherId = Guid.NewGuid(); SetModelValue(teaModel, context); teaModel.CreateTime = DateTime.Now; teaModel.LastModifyTime = DateTime.Now; var teaBll = new BLL.Teacher(); var result = false; var msg = ""; try { //var sysUserMo = new Models.SysUser(); //var sysuserbll = new BLL.SysUser(); //sysUserMo.UserRole = (int)EnumUserRole.Student; //sysUserMo.UserName = teaModel.TeacherName; //sysUserMo.UserId = teaModel.TeacherId; //sysUserMo.UserPassWord = Common.defaultPwd; //sysUserMo.UserAccount = teaModel.IdentityNo; //sysuserbll.Add(sysUserMo); result = teaBll.Add(teaModel); if (!result) { msg = "保存失败!"; } } catch (Exception ex) { LogHelper.WriteLogofExceptioin(ex); result = false; msg = ex.Message; } // var str = JsonConvert.SerializeObject(new { success = result, errorMsg = msg}); context.Response.Write(msg); }
private void DelData(string id, HttpContext context) { var teaBll = new BLL.Teacher(); var result = false; var msg = ""; try { result = teaBll.Delete(new Guid(id)); var sysuserbll = new BLL.SysUser(); sysuserbll.Delete(new Guid(id)); if (!result) { msg = "保存失败!"; } } catch (Exception ex) { LogHelper.WriteLogofExceptioin(ex); result = false; msg = ex.Message; } // var str = JsonConvert.SerializeObject(new { success = result, errorMsg = msg}); context.Response.Write(msg); }
private void ShowInfo(int ID) { JiaJiao.BLL.ClassSetting bll = new JiaJiao.BLL.ClassSetting(); JiaJiao.Model.ClassSetting model = bll.GetModel(ID); this.lblID.Text = model.ID.ToString(); this.txtTotal.Text = model.Total.ToString(); this.txtCount.Text = model.Count.ToString(); JiaJiao.BLL.Class bll1 = new BLL.Class(); var classModel1 = bll1.GetModel(model.DayId.Value); JiaJiao.BLL.Teacher bll2 = new BLL.Teacher(); var teacherModel2 = bll2.GetModel(model.TeacherId); JiaJiao.BLL.Teacher t = new BLL.Teacher(); var ds = t.GetAllList(); this.ddlTeacher.DataSource = ds.Tables[0]; this.ddlTeacher.DataBind(); ddlTeacher.SelectedValue = model.TeacherId.ToString(); JiaJiao.BLL.Class c = new BLL.Class(); var clist = c.GetModelList(""); this.ddlDay.DataSource = clist.GroupBy(d => d.Day).Select(g => g.Key); this.ddlDay.DataBind(); ddlDay.SelectedValue = classModel1.Day; this.ddlTime.DataSource = clist.Where(d => d.Day == classModel1.Day); this.ddlTime.DataBind(); }
private void Query(HttpContext context) { var teachName = context.Request["name"].Trim(); var school = context.Request["sch"].Trim(); var gender = context.Request["gender"].Trim(); var title = context.Request["title"].Trim(); var idno = context.Request["idno"].Trim(); var ds = new DataSet(); var teaBll = new BLL.Teacher(); var strWhere = ""; if (!string.IsNullOrEmpty(teachName)) { strWhere = string.Format(" TeacherName like '%" + teachName + "%' "); } if (!string.IsNullOrEmpty(school)) { if (!string.IsNullOrEmpty(strWhere)) { strWhere += string.Format(" and Dept like '%" + school + "%' "); } else { strWhere = string.Format(" Dept like '%" + school + "%' "); } } if (!string.IsNullOrEmpty(gender)&&gender!="0") { if (!string.IsNullOrEmpty(strWhere)) { strWhere += string.Format(" and Gender like '%" + gender + "%' "); } else { strWhere = string.Format(" Gender like '%" + gender + "%' "); } } if (!string.IsNullOrEmpty(title)) { if (!string.IsNullOrEmpty(strWhere)) { strWhere += string.Format(" and Title like '%" + title + "%' "); } else { strWhere = string.Format(" Title like '%" + title + "%' "); } } if (!string.IsNullOrEmpty(idno)) { if (!string.IsNullOrEmpty(strWhere)) { strWhere += string.Format(" and IdentityNo like '%" + idno + "%' "); } else { strWhere = string.Format(" IdentityNo like '%" + idno + "%' "); } } // ds = teaBll.GetList(strWhere); var page = Convert.ToInt32(context.Request["page"]); var rows = Convert.ToInt32(context.Request["rows"]); var sort = string.IsNullOrEmpty(context.Request["sort"]) ? "TeacherName" : context.Request["sort"]; var order = string.IsNullOrEmpty(context.Request["order"]) ? "asc" : context.Request["order"]; if (sort == "GenderName") { sort = "Gender"; } var startIndex = (page - 1) * rows + 1; var endIndex = startIndex + rows - 1; var num = teaBll.GetRecordCount(strWhere); ds = teaBll.GetListByPage(strWhere, sort, startIndex, endIndex,order); var str = JsonConvert.SerializeObject(new { total = num, rows = ds.Tables[0] }); context.Response.Write(str); }
private DataSet QueryDataResultForExp(HttpContext context) { var teachName = context.Request["name"].Trim(); var school = context.Request["sch"].Trim(); var gender = context.Request["gender"].Trim(); var title = context.Request["title"].Trim(); var idno = context.Request["idno"].Trim(); var post = context.Request["post"].Trim(); var research = context.Request["research"].Trim(); var mobile = context.Request["mobile"].Trim(); var description = context.Request["description"].Trim(); var ds = new DataSet(); var teaBll = new BLL.Teacher(); var strWhere = ""; if (!string.IsNullOrEmpty(teachName)) { strWhere = string.Format(" TeacherName like '%" + teachName + "%' "); } if (!string.IsNullOrEmpty(school)) { if (!string.IsNullOrEmpty(strWhere)) { strWhere += string.Format(" and Dept like '%" + school + "%' "); } else { strWhere = string.Format(" Dept like '%" + school + "%' "); } } if (!string.IsNullOrEmpty(gender) && gender != "0") { if (!string.IsNullOrEmpty(strWhere)) { strWhere += string.Format(" and Gender like '%" + gender + "%' "); } else { strWhere = string.Format(" Gender like '%" + gender + "%' "); } } if (!string.IsNullOrEmpty(title)) { if (!string.IsNullOrEmpty(strWhere)) { strWhere += string.Format(" and Title like '%" + title + "%' "); } else { strWhere = string.Format(" Title like '%" + title + "%' "); } } if (!string.IsNullOrEmpty(idno)) { if (!string.IsNullOrEmpty(strWhere)) { strWhere += string.Format(" and IdentityNo like '%" + idno + "%' "); } else { strWhere = string.Format(" IdentityNo like '%" + idno + "%' "); } } ds = teaBll.GetDataForExport(strWhere); return ds; }
private void GetDataForCombobox(HttpContext context) { var ds = new DataSet(); var teaBll = new BLL.Teacher(); ds = teaBll.GetAllList(); // [{"SUBITEM_VALUE":"1","SUBITEM_NAME":"男"},{"SUBITEM_VALUE":"2","SUBITEM_NAME":"女"}] if (ds != null && ds.Tables.Count > 0) { var str = new StringBuilder("["); foreach (DataRow row in ds.Tables[0].Rows) { str.Append("{\"TeacherId\": \"" + row["TeacherId"] + "\","); str.Append("\"TeacherName\": \"" + row["TeacherName"] + "\"},"); } str.Remove(str.Length - 1, 1); str.Append("]"); context.Response.Write(str.ToString()); } // var str = JsonConvert.SerializeObject(new { total = ds.Tables[0].Rows.Count, rows = ds.Tables[0] }); }
private string GetData(HttpContext context) { var ds = new DataSet(); var teaBll = new BLL.Teacher(); var page = Convert.ToInt32(context.Request["page"]); var rows = Convert.ToInt32(context.Request["rows"]); var sort = string.IsNullOrEmpty(context.Request["sort"]) ? "TeacherName" : context.Request["sort"]; var order = string.IsNullOrEmpty(context.Request["order"]) ? "asc" : context.Request["order"]; if (sort == "GenderName") { sort = "Gender"; } var startIndex = (page - 1) * rows + 1; var endIndex = startIndex + rows - 1; var num = teaBll.GetRecordCount(""); ds = teaBll.GetListByPage("", sort, startIndex, endIndex,order); var str = JsonConvert.SerializeObject(new { total = num, rows = ds.Tables[0] }); return str; }
private void EditData(string id, HttpContext context) { var teaBll = new BLL.Teacher(); var teaModel = teaBll.GetModel(new Guid(id)); teaModel.LastModifyTime = DateTime.Now; var result = false; var msg = ""; try { SetModelValue(teaModel, context); result = teaBll.Update(teaModel); if (!result) { msg = "保存失败!"; } } catch (Exception ex) { LogHelper.WriteLogofExceptioin(ex); result = false; msg = ex.Message; } // var str = JsonConvert.SerializeObject(new { success = result, errorMsg = msg}); context.Response.Write(msg); }
/// <summary> /// 获取编辑时单个教师的信息 /// </summary> /// <param name="Id"></param> /// <returns></returns> public JsonResult GetTeacher(int Id) { BLL.Teacher bll = new BLL.Teacher(); return(Json(bll.GetTeacher(Id))); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { txtCount.Text = "0"; JiaJiao.BLL.Teacher t = new BLL.Teacher(); var ds = t.GetAllList(); this.ddlTeacher.DataSource = ds.Tables[0]; this.ddlTeacher.DataBind(); JiaJiao.BLL.Class c = new BLL.Class(); clist= c.GetModelList(""); this.ddlDay.DataSource = clist.GroupBy(d => d.Day).Select(g => g.Key) ; this.ddlDay.DataBind(); this.ddlTime.DataSource = clist.Where(d => d.Day == "周一"); this.ddlTime.DataBind(); } }