public static List<Event> GetAllEvents(string dataName, int Page)
        {
            List<Event> Events = new List<Event>();
>>>>>>> 3aabe62cdccf29aead7c454a773c6bc3e00d87ab
            List<User> Users = new List<User>();
            Dal.DB db = new DB();

            db.Configuration.ProxyCreationEnabled = false;

<<<<<<< HEAD
            ///分页查询 按时间倒叙查询
             Events = (from e in db.Events
                           orderby e.Time descending
                           select e).ToList();
            int total = Events.Count;
            //跳过的总条数
             int totalNum = (Page) * 10;
             Events = Events.Skip(totalNum).ToList();
             if (Events.Count > 10)
            {
                Events.RemoveRange(10, total - 10);
            }

            /*Events=db.Events.OrderByDescending(e=>e.Time).Select(e => e).Skip(
                (Page) * 10).Take(Page).ToList();  
           */
            foreach (Events Event in Events)
            {
                Event.Root = db.Users.Find(Event.RootID);
            }
            return Events;
        }
示例#2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            User User = (User)Session["User"];
            if (User != null)
            {
                user_rank = User.RoleAsInt.ToString();
                user_id = User.ID.ToString();
            }

            <<<<<<< HEAD
            =======
            using (Dal.DB db = new Dal.DB())
            {
                var departments = (from d in db.Departments
                                   select d).ToList();
                foreach (var d in departments)
                {
                    ListItem item = new ListItem();
                    item.Text = d.Title;
                    item.Value = d.ID.ToString();
                    cbbDepartment.Items.Add(item);
                }
            }
            >>>>>>> 3aabe62cdccf29aead7c454a773c6bc3e00d87ab
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                int sid = Convert.ToInt32(Request.QueryString["id"]);
                Schedule Schedule=new Entity.Schedule();
                List<Department> Departments=new List<Department> ();
                List<User> Users = new List<User>();
                using (Dal.DB db = new Dal.DB())
                {
                    Departments=(from d in db.Departments select d).ToList();
                    Schedule = db.Schedules.Find(sid);
                    Users = db.Users.Where<User>(u => u.DepartmentID == Schedule.DepartmentID).ToList();
                    txtEditScheduleName.Text = Schedule.Title;
                    txtEditScheduleContent.Text = Schedule.Content;

                    foreach (Department Department in Departments)
                    {
                        ddlEditScheduleDepartment.Items.Add(Department.Title);
                        ddlEditScheduleDepartment.Items.FindByText(Department.Title).Value = Department.ID.ToString();
                    }
                    ddlEditScheduleDepartment.SelectedValue = Schedule.DepartmentID.ToString();

                    foreach (User User in Users)
                    {
                        ddlEditScheduleToUser.Items.Add(User.Username);
                        ddlEditScheduleToUser.Items.FindByText(User.Username).Value = User.ID.ToString();

                    }
                    ddlEditScheduleToUser.SelectedValue = Schedule.ToUserID.ToString();

                }
            }
        }
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         using (Dal.DB db = new Dal.DB())
         {
             var departments = (from d in db.Departments
                                select d).ToList();
             foreach (var d in departments)
             {
                 ListItem item = new ListItem();
                 item.Text = d.Title;
                 item.Value = d.ID.ToString();
                 cbbDepartment.Items.Add(item);
             }
             int uid = Convert.ToInt32(Request.QueryString["ID"]);
             var user = db.Users.Find(uid);
             txtName.Text = user.Name;
             if (user.Avatar != null)
             {
                 imgAvatar.ImageUrl = "data:image/png;base64," + Convert.ToBase64String(user.Avatar);
             }
             if (user.DepartmentID != null)
             {
                 var item = cbbDepartment.Items.FindByValue(user.DepartmentID.GetValueOrDefault().ToString());
                 cbbDepartment.SelectedIndex = cbbDepartment.Items.IndexOf(item);
             }
             var i = cbbRole.Items.FindByValue(user.RoleAsInt.ToString());
             cbbRole.SelectedIndex = cbbRole.Items.IndexOf(i);
         }
     }
 }
        public static List<File> GetFiles(string dataName, int Page, int DepartmentID)
        {
            List<File> Files = new List<File>();
            Dal.DB db = new DB();

            db.Configuration.ProxyCreationEnabled = false;
            Files = (from f in db.Files select f).ToList();

            if (dataName != "")
            {
                Files = (from f in db.Files
                         where f.User.Name == dataName
                         select f).ToList();
            }

            if (DepartmentID != 0)
            {
                Files = (from f in db.Files
                         where f.User.DepartmentID == DepartmentID
                         select f).ToList();
            }

            foreach (File File in Files)
            {
                File.User = db.Users.Find(File.UserID);
                File.User.DepartmentTitle = db.Departments.Find(File.User.ID).Title;
            }

            return Files;
        }
        public static List<Schedule> GetSchedulesList(string dataName, int Page, int DepartmentID)
        {

            List<Schedule> Schedules = new List<Schedule>();
            List<User> Users = new List<User>();
            Dal.DB db = new DB();

            db.Configuration.ProxyCreationEnabled = false;
           
            Schedules = (from s in db.Schedules select s).ToList();
            if (dataName != "")
            {
                Schedules = (from s in db.Schedules
                             where s.ToUser.Username.Contains(dataName)
                             select s).ToList();
            }

           
            
            if (DepartmentID != 0) 
            {
                Schedules = (from s in db.Schedules 
                              where s.DepartmentID==DepartmentID
                             select s).ToList();
            }

            foreach (Schedule Schedule in Schedules)
            {
                Schedule.ToUser = db.Users.Find(Schedule.ToUserID);
                Schedule.SubmittionUser = db.Users.Find(Schedule.SubmittionUserID);
                Schedule.Department = db.Departments.Find(Schedule.DepartmentID);
            }
          
            return Schedules;
        } 
        protected void Page_Load(object sender, EventArgs e)
        {
            using (Dal.DB db = new Dal.DB())
            {
               departments = (from d in db.Departments
                                   select d).ToList();

            }
        }
 protected void btnDeleteSchedule_Click(object sender, EventArgs e)
 {
     int sid = Convert.ToInt32(Request.QueryString["id"]);
     Schedule Schedule = new Schedule();
     using (Dal.DB db = new Dal.DB())
     {
         Schedule = db.Schedules.Find(sid);
         db.Schedules.Remove(Schedule);
         db.SaveChanges();
     }
     Response.Redirect("Admin_Schedules.aspx");
 }
 protected void btnSubmit_Click(object sender, EventArgs e)
 {
     using (Dal.DB db = new Dal.DB())
     {
         int did = Convert.ToInt32(Request.QueryString["ID"]);
         var Department = db.Departments.Find(did);
         Department.Title = departmentName.Text;
         Department.Description = descripment.Text;
         db.SaveChanges();
         Response.Redirect("Admin_Departments.aspx");
     }
 }
 public static List<User> GetUserByDepartment(int department_id)
 {
     List<User> Users = new List<User>();
     using (Dal.DB db = new DB())
     {
         db.Configuration.ProxyCreationEnabled = false;
         Users = (from u in db.Users
                  where u.DepartmentID == department_id
                  select u).ToList();
     }
     return Users;
 } 
示例#11
0
 protected void btnAdd_Click(object sender, EventArgs e)
 {
     using (Dal.DB db = new Dal.DB())
     {
         db.Users.Add(new Entity.User()
         {
             Name = txtAddName.Text,
             Username = txtAddUsername.Text,
             Password = SHA1.Create().ComputeHash(Encoding.UTF8.GetBytes(txtAddPassword.Text))
         });
         db.SaveChanges();
     }
 }
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         using (Dal.DB db = new Dal.DB())
         {
             int did = Convert.ToInt32(Request.QueryString["ID"]);
             var Department = db.Departments.Find(did);
             departmentName.Text = Department.Title;
             descripment.Text = Department.Description;
         }
     }
 }
示例#13
0
 protected void btnAddSign_click(object sender, EventArgs e)
 {
     string SignType = dllAddSignInKind.SelectedValue;
         SignLog Sign = new SignLog();
         Sign.UserID = user_id;
         Sign.TypeAsInt = Convert.ToInt32(SignType);
         Sign.Time = DateTime.Now;
         using (Dal.DB db = new Dal.DB())
         {
             db.SignLogs.Add(Sign);
             db.SaveChanges();
         }
         Response.Redirect("Admin_SignIn.aspx");
 }
        protected void btnAdd_Click(object sender, EventArgs e)
        {
            Department Department = new Department();
            Department.Title = departmentAddName.Text;
            Department.Description = departmentAddDecriptment.Text;

            using (Dal.DB db = new Dal.DB())
            {
                db.Departments.Add(Department);
                db.SaveChanges();
            }
            departmentAddName.Text = "";
            departmentAddDecriptment.Text = "";
        }
示例#15
0
 protected void Page_Load(object sender, EventArgs e)
 {
     using (Dal.DB db = new Dal.DB())
     {
         var departments = (from d in db.Departments
                            select d).ToList();
         foreach(var d in departments)
         {
             ListItem item = new ListItem();
             item.Text = d.Title;
             item.Value = d.ID.ToString();
             cbbDepartment.Items.Add(item);
         }
     }
 }
示例#16
0
        public static string AddEvent(int root_id, string title,string content)
        {
            Event Event = new Event();
>>>>>>> 3aabe62cdccf29aead7c454a773c6bc3e00d87ab
            Event.Title = title;
            Event.Content = content;
            Event.RootID = root_id;
            Event.Time = DateTime.Now;
            using (DB db = new DB())
            {
                db.Configuration.ProxyCreationEnabled = false;
                db.Events.Add(Event);
                db.SaveChanges();
            }

            return "ok";
        }
示例#17
0
        public static List<File> GetFilesListByUserId(int userID)
        {
            List<File> Files = new List<File>();
            Dal.DB db = new DB();

            db.Configuration.ProxyCreationEnabled = false;
            Files = (from f in db.Files
                     where f.UserID == userID
                     select f).ToList();

            foreach (File File in Files)
            {
                File.User = db.Users.Find(File.UserID);
                File.User.DepartmentTitle = db.Departments.Find(File.User.ID).Title;
            }

            return Files;
        }
示例#18
0
        protected void Upload_Click(object sender, EventArgs e)
        {
            if (upFile.HasFile)
            {
                var filename = DateTime.Now.ToString("yyMMddHHmmss") + System.IO.Path.GetExtension(upFile.FileName);
                System.IO.File.WriteAllBytes(System.Web.HttpContext.Current.Request.PhysicalApplicationPath + "\\Uploads\\" + filename, upFile.FileBytes);
            }

            File File = new File();
            File.Time = DateTime.Now;
            File.FileName = upFile.FileName;
            File.UserID =Convert.ToInt32(user_id);

            using (DB db = new DB())
            {
                db.Files.Add(File);
                db.SaveChanges();
            }
        }
        protected void btnSubmitUpdate_Click(object sender, EventArgs e)
        {
            int sid = Convert.ToInt32(Request.QueryString["id"]);
            User User=(User)Session["User"];
            Schedule Schedule = new Schedule();
            using (Dal.DB db = new Dal.DB())
            {
                Schedule = db.Schedules.Find(sid);
                Schedule.Title = txtEditScheduleName.Text;
                Schedule.Content = txtEditScheduleContent.Text;
                Schedule.Time = DateTime.Now;
                Schedule.ToUserID = Convert.ToInt32(ddlEditScheduleToUser.SelectedValue);
                Schedule.SubmittionUserID = User.ID;
                Schedule.DepartmentID = Convert.ToInt32(ddlEditScheduleDepartment.SelectedValue);

                db.SaveChanges();
            }

            Response.Redirect("Admin_Schedules.aspx");
        }
示例#20
0
        protected void Page_Load(object sender, EventArgs e)
        {
            User User = (User)Session["User"];
            if (User != null)
            {
                user_id = User.ID;
            }

            using (Dal.DB db = new Dal.DB())
            {
                var departments = (from d in db.Departments
                                   select d).ToList();
                foreach (var d in departments)
                {
                    ListItem item = new ListItem();
                    item.Text = d.Title;
                    item.Value = d.ID.ToString();
                    cbbDepartment.Items.Add(item);
                }
            }
        }
 protected void btnSubmit_Click(object sender, EventArgs e)
 {
     using (Dal.DB db = new Dal.DB())
     {
         int uid = Convert.ToInt32(Request.QueryString["ID"]);
         var user = db.Users.Find(uid);
         if (!string.IsNullOrEmpty(txtPassword.Text))
         {
             user.Password = SHA1.Create().ComputeHash(Encoding.UTF8.GetBytes(txtPassword.Text));
         }
         user.DepartmentID = Convert.ToInt32(cbbDepartment.SelectedValue);
         if (user.DepartmentID == 0)
             user.DepartmentID = null;
         user.Role = (Entity.UserRole)Convert.ToInt32(cbbRole.SelectedValue);
         user.Name = txtName.Text;
         if (FileUpload1.HasFile)
         {
             user.Avatar = FileUpload1.FileBytes;
         }
         db.SaveChanges();
         imgAvatar.ImageUrl = "data:image/png;base64," + Convert.ToBase64String(user.Avatar);
     }
 }
 protected void ddlEditScheduleDepartment_SelectedIndexChanged(object sender, EventArgs e)
 {
     List<User> Users = new List<Entity.User>();
     int? DepartmentID =Convert.ToInt32(ddlEditScheduleDepartment.SelectedValue);
     using (Dal.DB db = new Dal.DB())
     {
         Users = db.Users.Where(u => u.DepartmentID == DepartmentID).ToList();
     }
     ddlEditScheduleToUser.Items.Clear();
     if (Users.Count== 0)
     {
         ddlEditScheduleToUser.Items.Add("无");
         ddlEditScheduleToUser.Items.FindByText("无").Value = "0";
     }
     else
     {
         foreach (User User in Users)
         {
             ddlEditScheduleToUser.Items.Add(User.Username);
             ddlEditScheduleToUser.Items.FindByText(User.Username).Value = User.ID.ToString();
            // ddlEditScheduleToUser.SelectedItem.Value = Schedule.ToUserID.ToString();
         }
     }
 }
        public static List<Schedule> GetSchedulesListByUserId(int userID)
        {

            List<Schedule> Schedules = new List<Schedule>();
            List<User> Users = new List<User>();
            Dal.DB db = new DB();

            db.Configuration.ProxyCreationEnabled = false;

            Schedules = (from s in db.Schedules 
                         where s.ToUserID==userID
                         select s).ToList();
          

            foreach (Schedule Schedule in Schedules)
            {
                Schedule.ToUser = db.Users.Find(Schedule.ToUserID);
                Schedule.SubmittionUser = db.Users.Find(Schedule.SubmittionUserID);
                Schedule.Department = db.Departments.Find(Schedule.DepartmentID);
            }

            return Schedules;
        }  
 public static string AddSchedule(int submit_user_id, int to_user_id, string title, string content, int department_id)
 {
     Schedule Schedule = new Schedule();
     Schedule.ToUserID = to_user_id;
     Schedule.SubmittionUserID = submit_user_id;
     Schedule.Title = title;
     Schedule.Content = content;
     Schedule.DepartmentID = department_id;
     Schedule.Time = DateTime.Now;
     using (Dal.DB db = new DB())
     {
         db.Schedules.Add(Schedule);
         db.SaveChanges();
     }
     return "ok";
 }  
示例#25
0
        public static string DeleteEvent(int event_id)
        {
            Events Event = new Events();
            using(DB db =new DB ())
            {
                Event = db.Events.Find(event_id);
                db.Events.Remove(Event);
                db.SaveChanges();
            }

            return "ok";
           
        }