Example #1
0
        internal static void SetPrincipal(string F_ID, User user)
        {
            DataClassesDataContext dc     = new DataClassesDataContext();
            ApplicantMember        member = new ApplicantMember();

            if (dc.ApplicantMember.Count(_am => _am.F_applicantID.Equals(F_ID) && _am.F_userID.Equals(user.F_ID)) > 0)
            {
                return;
            }
            member.F_applicantID = F_ID;
            member.F_ID          = Guid.NewGuid().ToString();
            member.F_userID      = user.F_ID;
            member.F_sexual      = user.F_sexual;
            member.F_degree      = user.F_highestDegree;
            member.F_education   = user.F_highestEducation;
            member.F_birthday    = user.F_birthday;
            member.F_expert      = "";
            member.F_seq         = 0;
            member.F_duty        = "项目负责人";
            member.F_realName    = user.F_realName;
            member.F_title       = user.F_title;
            member.F_workspace   = user.F_workDept;
            dc.ApplicantMember.InsertOnSubmit(member);
            dc.SubmitChanges();
        }
Example #2
0
        private void SavePage9()
        {
            DataClassesDataContext dc         = new DataClassesDataContext();
            ScienceProject         sciProject = dc.ScienceProject.SingleOrDefault(c => c.F_ID.Equals(F_ID));

            sciProject.F_recommendContent   = paras["F_recommendContent"];
            sciProject.F_recommendName      = paras["F_recommendName"];
            sciProject.F_recommendTitle     = paras["F_recommendTitle"];
            sciProject.F_recommendExpert    = paras["F_recommendExpert"];
            sciProject.F_recommendWorkspace = paras["F_recommendWorkspace"];

            var existMembers = dc.ApplicantMember.Where(am => am.F_applicantID.Equals(F_ID));

            dc.ApplicantMember.DeleteAllOnSubmit(existMembers);
            foreach (ApplicantMember member in existMembers)
            {
                User user = dc.User.SingleOrDefault(_user => _user.F_ID.Equals(member.F_userID));
                if (user != null && user.F_Role.Equals(RoleType.ProjectMember))
                {
                    dc.User.DeleteOnSubmit(user);
                }
            }
            if (!String.IsNullOrWhiteSpace(paras["F_userID"]))
            {
                String[] F_userIDs          = paras["F_userID"].Split(new char[] { ',' });
                String[] F_memberDutys      = paras["F_memberDuty"].Split(new char[] { ',' });
                String[] F_memberExperts    = paras["F_memberExpert"].Split(new char[] { ',' });
                String[] F_memberNames      = paras["F_memberName"].Split(new char[] { ',' });
                String[] F_memberTitles     = paras["F_memberTitle"].Split(new char[] { ',' });
                String[] F_memberWorkspaces = paras["F_memberWorkspace"].Split(new char[] { ',' });
                String[] F_seqs             = paras["F_seq"].Split(new char[] { ',' });
                for (int i = 0; i < F_userIDs.Length; i++)
                {
                    if (F_userIDs[i].Trim().Length == 0)
                    {
                        continue;
                    }
                    ApplicantMember member = new ApplicantMember();
                    member.F_applicantID = F_ID;
                    member.F_ID          = Guid.NewGuid().ToString();
                    member.F_userID      = F_userIDs[i];
                    member.F_expert      = F_memberExperts[i];
                    member.F_duty        = F_memberDutys[i];
                    member.F_realName    = F_memberNames[i];
                    member.F_title       = F_memberTitles[i];
                    member.F_workspace   = F_memberWorkspaces[i];
                    member.F_seq         = UtilHelper.ParseInt(F_seqs[i]);
                    dc.ApplicantMember.InsertOnSubmit(member);
                }
            }
            dc.SubmitChanges();
        }
Example #3
0
        protected void btnAdd_Click(object sender, EventArgs e)
        {
            DataClassesDataContext dc = new DataClassesDataContext();
            User user = new User();

            user.F_ID       = Guid.NewGuid().ToString();
            user.F_realName = txtRealName.Text;
            user.F_Role     = RoleType.ProjectMember;
            user.F_sexual   = ddlSexual.SelectedValue;

            user.F_highestDegree    = ddlDegree.SelectedValue;
            user.F_highestEducation = ddlEducation.SelectedValue;
            if (String.IsNullOrWhiteSpace(F_birthday.Value) == false)
            {
                user.F_birthday = DateTime.Parse(F_birthday.Value);
            }
            user.F_workspace = F_workspace.Value;
            user.F_phone     = F_phone.Value;
            user.F_position  = F_position.Value;
            user.F_title     = ddlTitle.SelectedValue;
            user.F_email     = F_email.Value;
            dc.User.InsertOnSubmit(user);
            dc.SubmitChanges();

            ApplicantMember member = new ApplicantMember();

            member.F_userID    = user.F_ID;
            member.F_realName  = user.F_realName;
            member.F_title     = user.F_title;
            member.F_expert    = F_expert.Value;
            member.F_workspace = user.F_workspace;
            member.F_birthday  = user.F_birthday;
            member.F_sexual    = user.F_sexual;
            member.F_education = user.F_highestEducation;
            member.F_degree    = user.F_highestDegree;
            String result = UtilHelper.GetJSON(member);


            Response.Write("<script> window.opener.addUser('" + result + "'); window.close();</script>");
        }
Example #4
0
        protected void btnSearch_Click(object sender, EventArgs e)
        {
            DataClassesDataContext dc = new DataClassesDataContext();
            User user = dc.User.SingleOrDefault(_user => _user.F_idType.Equals(ddlType.SelectedValue) && _user.F_idNumber.Equals(txtNo.Text));

            if (user != null)
            {
                ApplicantMember member = new ApplicantMember();
                member.F_userID    = user.F_ID;
                member.F_realName  = user.F_realName;
                member.F_title     = user.F_title;
                member.F_workspace = user.F_workspace;
                member.F_birthday  = user.F_birthday;
                member.F_sexual    = user.F_sexual;
                member.F_education = user.F_highestEducation;
                member.F_degree    = user.F_highestDegree;
                String result = UtilHelper.GetJSON(member);
                Response.Write("<script> window.opener.addUser('" + result + "'); window.close();</script>");
            }
            else
            {
                UtilHelper.AlertMsg("找不到指定用户");
            }
        }
Example #5
0
        private string SavePage3()
        {
            DataClassesDataContext dc = new DataClassesDataContext();

            EducationV2.SocialProject socialProject = dc.SocialProject.Single(c => c.F_ID.Equals(F_ID));
            socialProject.F_keywords           = paras["F_keywords"];
            socialProject.F_researchType       = paras["F_researchType"];
            socialProject.F_sexual             = paras["F_sexual"];
            socialProject.F_nationality        = paras["F_nationality"];
            socialProject.F_IDNumber           = paras["F_IDNumber"];
            socialProject.F_duty               = paras["F_duty"];
            socialProject.F_subjectDuty        = paras["F_subjectDuty"];
            socialProject.F_expertise          = paras["F_expertise"];
            socialProject.F_education          = paras["F_education"];
            socialProject.F_degree             = paras["F_degree"];
            socialProject.F_mentor             = paras["F_mentor"];
            socialProject.F_workspace          = paras["F_workspace"];
            socialProject.F_phone              = paras["F_phone"];
            socialProject.F_teamName           = paras["F_teamName"];
            socialProject.F_recommendName      = paras["F_recommendName"];
            socialProject.F_recommendTitle     = paras["F_recommendTitle"];
            socialProject.F_recommendWorkspace = paras["F_recommendWorkspace"];
            socialProject.F_achievement        = paras["F_achievement"];
            decimal number = 0;

            Decimal.TryParse(paras["F_wordCount"], out number);
            socialProject.F_wordCount = number;
            number = 0;
            Decimal.TryParse(paras["F_Fund"], out number);
            socialProject.F_Fund = number;
            if (String.IsNullOrWhiteSpace(paras["F_completeDate"]) == false)
            {
                socialProject.F_completeDate = DateTime.Parse(paras["F_completeDate"]);
            }
            var members = dc.ApplicantMember.Where(st => st.F_applicantID.Equals(F_ID));

            dc.ApplicantMember.DeleteAllOnSubmit(members);
            foreach (ApplicantMember member in members)
            {
                User user = dc.User.SingleOrDefault(_user => _user.F_ID.Equals(member.F_userID));
                if (user != null && user.F_Role.Equals(RoleType.ProjectMember))
                {
                    dc.User.DeleteOnSubmit(user);
                }
            }
            if (!String.IsNullOrWhiteSpace(paras["F_userID"]))
            {
                String[] F_memberIDs       = paras["F_userID"].Split(new char[] { ',' });
                String[] F_seqs            = paras["F_seq"].Split(new char[] { ',' });
                String[] F_memberNames     = paras["F_memberName"].Split(new char[] { ',' });
                String[] F_memberSexuals   = paras["F_memberSexual"].Split(new char[] { ',' });
                String[] F_memberBirthdays = paras["F_memberBirthday"].Split(new char[] { ',' });
                String[] F_memberTitles    = paras["F_memberTitle"].Split(new char[] { ',' });
                String[] F_memberExperts   = paras["F_memberExpert"].Split(new char[] { ',' });

                String[] F_memberEducations = paras["F_memberEducation0"].Split(new char[] { ',' });
                String[] F_memberDegrees    = paras["F_memberDegree0"].Split(new char[] { ',' });
                String[] F_memberWorkspaces = paras["F_memberWorkspace"].Split(new char[] { ',' });

                for (int i = 0; i < F_memberIDs.Length; i++)
                {
                    ApplicantMember member = new ApplicantMember();
                    member.F_applicantID = F_ID;
                    member.F_ID          = Guid.NewGuid().ToString();
                    member.F_userID      = F_memberIDs[i];
                    member.F_seq         = UtilHelper.ParseInt(F_seqs[i]);
                    member.F_realName    = F_memberNames[i];
                    member.F_sexual      = F_memberSexuals[i];
                    if (String.IsNullOrWhiteSpace(F_memberBirthdays[i]) == false)
                    {
                        member.F_birthday = DateTime.Parse(F_memberBirthdays[i]);
                    }
                    member.F_title     = F_memberTitles[i];
                    member.F_expert    = F_memberExperts[i];
                    member.F_education = F_memberEducations[i];
                    member.F_degree    = F_memberDegrees[i];
                    member.F_workspace = F_memberWorkspaces[i];
                    dc.ApplicantMember.InsertOnSubmit(member);
                }
            }

            dc.SubmitChanges();
            return("保存成功");
        }