Example #1
0
        /// <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) }));
        }
Example #2
0
        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");
     }
 }
Example #4
0
        /// <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 + "记录"));
            }
        }
Example #5
0
        /// <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("修改失败"));
            }
        }
Example #6
0
        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;
        }
Example #7
0
        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);
        }
Example #9
0
        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);
        }
Example #10
0
        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);
        }
Example #11
0
        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();
        }
Example #12
0
        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);
        }
Example #13
0
        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;
        }
Example #14
0
        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] });
        }
Example #15
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;
        }
Example #16
0
        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);
        }
Example #17
0
 /// <summary>
 ///  获取编辑时单个教师的信息
 /// </summary>
 /// <param name="Id"></param>
 /// <returns></returns>
 public JsonResult GetTeacher(int Id)
 {
     BLL.Teacher bll = new BLL.Teacher();
     return(Json(bll.GetTeacher(Id)));
 }
Example #18
0
        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();
            }
        }