コード例 #1
0
ファイル: BaseDataUserBiz.cs プロジェクト: enamewang/pms
        public void InsertBaseDataUserAndDepartmentUser(BaseDataUser baseDataUser, BaseDataDepartmentUser baseDataDepartmentUser)
        {
            try
            {
                m_PMSSqlConnection.Insert("InsertBaseDataUser", baseDataUser);

                baseDataDepartmentUser.UserId = m_PMSSqlConnection.QueryForObject <int>("SelectUserId", baseDataUser.UserEmployeeNo);
                m_PMSSqlConnection.Insert("InsertBaseDataDepartmentUser", baseDataDepartmentUser);
            }
            catch (Exception ex)
            {
                m_Logger.Error("BaseDataUserBiz/InsertBaseDataUser:"******"BaseDataUserBiz/InsertBaseDataDepartmentUser:" + ex.ToString());
                throw ex;
            }
        }
コード例 #2
0
ファイル: AddUser.aspx.cs プロジェクト: enamewang/pms
        protected void ButtonSave_Click(object sender, EventArgs e)
        {
            if (baseDataUserBiz.CheckBaseDataUser(TextBoxEmpNo.Text.Trim()) == true)
            {
                AlertMessage("EMP No:" + TextBoxEmpNo.Text.Trim() + " has exist!");
                return;
            }
            if (baseDataUserBiz.GetTfsUserListUserNameCount(TextBoxEnglishName.Text.Trim()) == true)
            {
                AlertMessage("English Name:" + TextBoxEnglishName.Text.Trim() + " has exist!");
                return;
            }

            #region Insert PMS
            BaseDataUser baseDataUser = new BaseDataUser();
            baseDataUser.UserEmployeeNo = TextBoxEmpNo.Text.Trim();
            baseDataUser.Ntdomain       = DropDownListNTDomain.SelectedValue;
            baseDataUser.UserName       = TextBoxEnglishName.Text.Trim();
            baseDataUser.MailAddress    = TextBoxEnglishName.Text.Trim() + "@qisda.com";
            baseDataUser.Password       = "******";
            baseDataUser.LoginName      = TextBoxEnglishName.Text.Trim();
            baseDataUser.DomainId       = Convert.ToInt32(DropDownListDomain.SelectedValue);
            baseDataUser.Active         = "Y";
            baseDataUser.CreateDate     = DateTime.Now;
            baseDataUser.CreateUser     = WSC.GlobalDefinition.Cookie_LoginUser.Replace(" ", ".");
            baseDataUser.MaintainUser   = WSC.GlobalDefinition.Cookie_LoginUser.Replace(" ", ".");
            baseDataUser.MaintainDate   = DateTime.Now;
            baseDataUser.Extention      = TextBoxextention.Text.Trim();
            baseDataUser.Role           = TextBoxRole.Text.Trim();

            BaseDataDepartmentUser baseDataDepartmentUser = new BaseDataDepartmentUser();
            baseDataDepartmentUser.DepartmentId = Convert.ToInt32(DropDownListDepartment.SelectedValue);
            baseDataDepartmentUser.Type         = "Master";
            baseDataDepartmentUser.Active       = "Y";
            baseDataDepartmentUser.CreateDate   = DateTime.Now;
            baseDataDepartmentUser.MaintainDate = DateTime.Now;
            baseDataDepartmentUser.CreateUser   = WSC.GlobalDefinition.Cookie_LoginUser.Replace(" ", ".");
            baseDataDepartmentUser.MaintainUser = WSC.GlobalDefinition.Cookie_LoginUser.Replace(" ", ".");

            baseDataUserBiz.InsertBaseDataUserAndDepartmentUser(baseDataUser, baseDataDepartmentUser);
            #endregion

            #region insert TFS
            TfsUserList tfsUserListmodel = new TfsUserList();

            tfsUserListmodel.UserEmpNo   = TextBoxEmpNo.Text.Trim();
            tfsUserListmodel.Domain      = DropDownListNTDomain.SelectedValue;
            tfsUserListmodel.UserName    = TextBoxEnglishName.Text.Trim();
            tfsUserListmodel.MailAddress = TextBoxEnglishName.Text.Trim() + "@qisda.com";
            tfsUserListmodel.Password    = "******";
            tfsUserListmodel.LoginName   = TextBoxEnglishName.Text.Trim();
            tfsUserListmodel.Groupid     = 1;

            if (TextBoxEnglishName.Text.Trim().Length > 4 && TextBoxEnglishName.Text.Trim().Substring(0, 4) == "ITO.")
            {
                tfsUserListmodel.Teamid = 2;
            }
            else
            {
                tfsUserListmodel.Teamid = baseDataUserBiz.GetTfsTeamForTeamid(DropDownListDepartment.SelectedItem.Text);
            }
            tfsUserListmodel.Active                = "Y";
            tfsUserListmodel.Needaic1Approved      = "Y";
            tfsUserListmodel.NeedDirectiveApproved = "Y";
            tfsUserListmodel.CreateDate            = DateTime.Now;
            tfsUserListmodel.CreateUser            = "******";
            tfsUserListmodel.MaintainDate          = DateTime.Now;
            tfsUserListmodel.MaintainUser          = "******";

            baseDataUserBiz.InsertTfsUserList(tfsUserListmodel);
            #endregion

            #region insert FramwWS
            if (baseDataUserBiz.GetWscUserRoleCount(TextBoxEnglishName.Text.Trim().Replace(" ", "").Replace(".", "")) == false)
            {
                WscUserRole wscUserRole = new WscUserRole();

                wscUserRole.SysId     = "TFSSSM";
                wscUserRole.LoginName = TextBoxEnglishName.Text.Trim();
                wscUserRole.RoleId    = "User";

                baseDataUserBiz.InsertWscUserRole(wscUserRole);
            }

            #endregion

            DropDownListDepartment.SelectedValue = "";
            DropDownListNTDomain.SelectedValue   = "";
            DropDownListDomain.SelectedValue     = "";
            TextBoxEmpNo.Text       = "";
            TextBoxEnglishName.Text = "";
            TextBoxextention.Text   = "";
            TextBoxRole.Text        = "";

            AlertMessage("Insert success!");
        }