Ejemplo n.º 1
0
        public ResponseMessage <object> TeacherTestTrans_D()
        {
            dynamic result;
            var     teacher = new T_Teacher()
            {
                F_TeacherName = $"Test_{ (DateTime.Now.Ticks - 621356256000000000) / 10000}"
            };


            var bl = _SqlDB.ExecuteWithTransaction((conn, trans) =>
            {
                var r = conn.Execute($"INSERT INTO T_Teacher (F_TeacherName) VALUES(@F_TeacherName);", teacher, trans, null, null);
                r    += conn.Execute("delete from T_Teacher where f_id=@id", new { id = 1 }, trans, null, null);

                return(r);
            });

            if (bl)
            {
                result = CreateResult.For();
            }
            else
            {
                result = CreateResult.For("00001", "新增出现错误");
            }

            return(result);
        }
Ejemplo n.º 2
0
        public ResponseMessage <object> InsertTeacher_D()
        {
            dynamic result;
            var     teacher = new T_Teacher()
            {
                F_TeacherName = $"Test_{ (DateTime.Now.Ticks - 621356256000000000) / 10000}"
            };
            var n = _SqlDB.Excute($"INSERT INTO T_Teacher (F_TeacherName) VALUES(@F_TeacherName)",
                                  teacher);

            if (n > 0)
            {
                result = CreateResult.For();
            }
            else
            {
                result = CreateResult.For("00001", "新增出现错误");
            }

            return(result);
        }
Ejemplo n.º 3
0
        public void setBatch()
        {
            string teacherid = "";

            try
            {
                if (Session["RoleID"].ToString() == "3")//辅导员
                {
                    teacherid = Session["UserID"].ToString();
                    T_Teacher teacher       = db.T_Teacher.Find(teacherid);
                    string    teacher_name  = teacher.Name.ToString();
                    string    teacher_grade = teacher.Grade.ToString() + "级";
                    ViewBag.lblTName  = teacher_name.ToString();
                    ViewBag.lblTGrade = teacher_grade.ToString();
                }
                else if (Session["RoleID"].ToString() == "1")//学生
                {
                    string ST_Num  = Session["UserID"].ToString();
                    var    student = from vw_Student in db.vw_Student where vw_Student.ST_Num == ST_Num select vw_Student;
                    teacherid = student.ToList().First().ST_TeacherID.ToString();
                    T_Teacher teacher       = db.T_Teacher.Find(teacherid);
                    string    teacher_name  = teacher.Name.ToString();
                    string    teacher_grade = teacher.Grade.ToString() + "级";
                    ViewBag.lblTName  = teacher_name.ToString();
                    ViewBag.lblTGrade = teacher_grade.ToString();
                }
            }
            catch
            {
                ViewBag.lblTName  = "未设定";
                ViewBag.lblTGrade = "未设定";
            }

            if (teacherid != "")
            {
                ViewBag.IsTeacherIDExist = "1";
                try
                {
                    for (int i = 1; i <= 3; i++)
                    {
                        var classes = from c in db.vw_ClassBatch
                                      where c.TeacherID == teacherid && c.Batch == i
                                      select c;
                        StringBuilder str_class = new StringBuilder();
                        string        time;
                        if (classes.Count() > 0)
                        {
                            foreach (var item in classes)
                            {
                                str_class.Append(item.ClassName.ToString());
                                str_class.Append(";");
                            }
                            time = classes.First().Datetime.ToString();
                        }
                        else
                        {
                            str_class.Append("无");
                            time = "无";
                        }
                        switch (i)
                        {
                        case 1:
                        {
                            ViewBag.lblTimeFirst  = time;
                            ViewBag.lblClassFirst = str_class.ToString();
                            break;
                        }

                        case 2:
                        {
                            ViewBag.lblTimeSecond  = time;
                            ViewBag.lblClassSecond = str_class.ToString();
                            break;
                        }

                        case 3:
                        {
                            ViewBag.lblTimeThird  = time;
                            ViewBag.lblClassThird = str_class.ToString();
                            break;
                        }

                        default:
                            break;
                        }
                    }

                    string deadline_time = "辅导员尚未设定";

                    //此处TypeID = 2 代表晚点名请假截止时间、TypeID = 1 代表节假日请假截止时间
                    var deadline = from d in db.T_Deadline
                                   where d.TeacherID == teacherid && d.TypeID == 2
                                   select d.Time;
                    if (deadline.Count() > 0)
                    {
                        deadline_time = deadline.First().ToString();
                    }

                    ViewBag.lblDeadlineNight = deadline_time;
                }
                catch
                {
                    ViewBag.lblTimeFirst     = "未设定晚点名批次";
                    ViewBag.lblClassFirst    = "未设定晚点名时间";
                    ViewBag.lblTimeSecond    = "未设定晚点名批次";
                    ViewBag.lblClassSecond   = "未设定晚点名时间";
                    ViewBag.lblTimeThird     = "未设定晚点名批次";
                    ViewBag.lblClassThird    = "未设定晚点名时间";
                    ViewBag.lblDeadlineNight = "未设定截止时间";
                }
            }
            else
            {
                //学生端口   尚未绑定辅导员
                ViewBag.IsTeacherIDExist = "0";
            }
        }
Ejemplo n.º 4
0
        /// <summary>
        /// 初始化晚点名设置
        /// </summary>
        public void LoadData()
        {
            string teacherid = Session["UserID"].ToString();
            int    batch_num = 0;
            int    i         = 0;

            string[][] selected = new string[3][];
            ViewBag.selected_first  = "";
            ViewBag.selected_second = "";
            ViewBag.selected_thrid  = "";
            ViewBag.tpFirst         = "";
            ViewBag.tpSecond        = "";
            ViewBag.tpThird         = "";
            ViewBag.dpDate          = "";

            T_Teacher teacher       = db.T_Teacher.Find(teacherid);
            string    teacher_name  = teacher.Name.ToString();
            string    teacher_grade = teacher.Grade.ToString() + "级";

            ViewBag.lblNameAGrade = "辅导员:" + teacher_name + "      " + "年级:" + teacher_grade;

            var batch = from b in db.T_Batch
                        where b.TeacherID == teacherid
                        orderby b.Batch
                        select new
            {
                b.ID,
                b.Datetime
            };

            if (batch.Count() > 0)
            {
                Guid   batch_id;
                string time;
                ViewBag.dpDate = batch.First().Datetime;
                foreach (var item in batch)
                {
                    i        = 0;
                    batch_id = item.ID;
                    time     = item.Datetime.ToString("yyyy-MM-dd HH:mm").Substring(11, 5);
                    var list = db.T_Class.Where(c => c.Batch == batch_id).Where(b => b.TeacherID == teacherid).Select(b => b.ID);
                    selected[batch_num] = new string[list.Count()];
                    foreach (var classes in list)
                    {
                        selected[batch_num][i] = classes.ToString();
                        i++;
                    }
                    switch (batch_num)
                    {
                    case 0:
                    {
                        ViewBag.selected_first = selected[batch_num];
                        ViewBag.tpFirst        = time;
                        break;
                    }

                    case 1:
                    {
                        ViewBag.selected_second = selected[batch_num];
                        ViewBag.tpSecond        = time;
                        break;
                    }

                    case 2:
                    {
                        ViewBag.selected_thrid = selected[batch_num];
                        ViewBag.tpThird        = time;
                        break;
                    }

                    default:
                        break;
                    }
                    batch_num++;
                }
            }
        }
Ejemplo n.º 5
0
        public ActionResult login(string txbAccount, string txbAccountPass)
        {
            var user = from T_Account in db.T_Account where (T_Account.ID == txbAccount.ToString().Trim()) && (T_Account.Psd == txbAccountPass.ToString().Trim()) select T_Account;

            if (user.Any() && user.Count() == 1)
            {
                #region 登录成功、将用户信息写入Session
                //从数据集中提取
                Session["UserID"]  = user.First().ID;
                Session["UserPsd"] = user.First().Psd;
                Session["RoleID"]  = user.First().RoleID;

                //从表单中提取
                //Session["UserID"] = tbxUserName.ToString().Trim();
                //Session["UserPsd"] = tbxPassword.ToString().Trim();
                #endregion

                #region 检查学生是否完善个人信息、辅导员的信息是否更新
                if (Session["RoleID"].ToString() == "1")//学生
                {
                    T_Student student = db.T_Student.Find(Session["UserID"].ToString());
                    if (student.ContactOne == "" || student.ContactOne == null || student.OneTel == "" || student.OneTel == null)//信息不完善
                    {
                        //FineUI登陆成功提示框、完善个人信息
                        ShowNotify("成功登陆!请完善个人信息", MessageBoxIcon.Success);
                        return(RedirectToAction("Index", "UserInfo", new { area = "UserInfo" }));
                        //此处需要以Areas的ID作为参数才能实现从Controller到Areas中的Controller的跳转
                    }
                    else//信息已完善
                    {
                        //FineUI登陆成功提示框
                        ShowNotify("成功登录!", MessageBoxIcon.Success);
                        return(RedirectToAction("Index", "Home"));
                    }
                }
                else if (Session["RoleID"].ToString() == "3")//辅导员
                {
                    string    UserID      = Session["UserID"].ToString();
                    var       TeacherInfo = from T_Teacher in db.T_Teacher where (T_Teacher.ID == UserID) select T_Teacher;
                    T_Teacher teacher     = TeacherInfo.ToList().First();
                    Session["Grade"] = teacher.Grade;

                    //辅导员登录-更新晚点名时间
                    if (UpdateTime(Session["UserID"].ToString()))
                    {
                        //更新了时间
                        return(RedirectToAction("Index", "Home", new { updatetime = "true" }));
                    }
                    else
                    {
                        //未更新时间
                        return(RedirectToAction("Index", "Home"));
                    }
                }
                else if (Session["RoleID"].ToString() == "2")
                {
                    //FineUI登陆成功提示框
                    ShowNotify("成功登录!", MessageBoxIcon.Success);
                    return(RedirectToAction("Index", "Home"));
                }
                else
                {
                    //未知错误
                    return(null);
                }
                #endregion
            }
            else if (!user.Any())
            {
                //FineUI登录失败提示框
                //ShowNotify("用户名或密码错误!", MessageBoxIcon.Error);
                alertInfo("登录提示", "用户名或密码错误!", "Information");
                return(RedirectToAction("Index", "Account"));
            }
            else
            {
                alertInfo("登录提示", "用户名或密码错误!", "Information");
                return(RedirectToAction("Index", "Account"));
            }
        }