protected void btnSubmit_Click(object sender, EventArgs e) { if (this.IsValid) { IUserService service = ServiceFactory.GetService<IUserService>(); UserInfo entity = null; if (this.IsInsert) { entity = new UserInfo() { UserAccount = this.txtUserAccount.Text.Trim(), UserPwd = this.txtUserPwd.Text.DESEncrypt(), UserNickName = this.txtUserNickName.Text.Trim(), UserEmail = this.txtUserEmail.Text.Trim(), UserPhone = this.txtUserPhone.Text.Trim(), UserStatus = this.ddlUserStatus.SelectedValue.ToByte(0), RoleId = this.ddlUserRole.SelectedValue.ToByte(0), OrgId = this.hfOrgId.Value.ToInt(0) }; if (service.CheckExists_Info(entity)) { this.JscriptMsg("用户帐户已存在", null, "Error"); return; } } else { entity = service.GetObject_Info(this.PkId); if (entity != null) { entity.UserPwd = this.txtUserPwd.Text.DESEncrypt(); entity.UserNickName = this.txtUserNickName.Text.Trim(); entity.UserEmail = this.txtUserEmail.Text.Trim(); entity.UserPhone = this.txtUserPhone.Text.Trim(); entity.UserStatus = this.ddlUserStatus.SelectedValue.ToByte(0); entity.RoleId = this.ddlUserRole.SelectedValue.ToByte(0); entity.OrgId = this.hfOrgId.Value.ToInt(0); } } service.Save_Info(entity); if (this.IsInsert && (sender as Button).CommandName == "SubmitContinue") { this.ReturnUrl = this.Request.Url.PathAndQuery; } this.JscriptMsg("数据保存成功", this.ReturnUrl, "Success"); } UserConvert.ClearCache(); }
public bool CheckExists(UserInfo objUserInfo) { string sql = null; List<DbParameter> parameterList = new List<DbParameter>(); sql = " select count(*) from tbl_user_info where UserAccount=:UserAccount "; parameterList.Add(new OracleParameter(":UserAccount", objUserInfo.UserAccount)); return int.Parse(DbHelper.ExecuteScalar(sql, CommandType.Text, parameterList.ToArray()).ToString()) > 0; }
public bool CheckExists_Info(UserInfo objUserInfo) { var repository = ServiceFactory.GetService<IUserInfoRepository>(); return repository.CheckExists(objUserInfo); }
public void Save_Info(UserInfo objUserInfo) { var repository = ServiceFactory.GetService<IUserInfoRepository>(); repository.Save(objUserInfo); }
public void Save(UserInfo objUserInfo) { string sql = null; List<DbParameter> parameterList = new List<DbParameter>(); if (objUserInfo.PkId == 0) { sql = " insert into tbl_user_info(PkId, UserAccount, UserPwd, UserNickName, UserEmail, UserPhone, UserStatus, RoleId, OrgId) " + " values(TUI_PKID.NEXTVAL, :UserAccount, :UserPwd, :UserNickName, :UserEmail, :UserPhone, :UserStatus, :RoleId, :OrgId) "; parameterList.Add(new OracleParameter(":UserAccount", objUserInfo.UserAccount)); parameterList.Add(new OracleParameter(":UserPwd", objUserInfo.UserPwd)); parameterList.Add(new OracleParameter(":UserNickName", objUserInfo.UserNickName)); parameterList.Add(new OracleParameter(":UserEmail", objUserInfo.UserEmail)); parameterList.Add(new OracleParameter(":UserPhone", objUserInfo.UserPhone)); parameterList.Add(new OracleParameter(":UserStatus", objUserInfo.UserStatus)); parameterList.Add(new OracleParameter(":RoleId", objUserInfo.RoleId)); parameterList.Add(new OracleParameter(":OrgId", objUserInfo.OrgId)); } else { sql = " update tbl_user_info set UserAccount=:UserAccount, UserPwd=:UserPwd, UserNickName=:UserNickName, " + " UserEmail=:UserEmail, UserPhone=:UserPhone, UserStatus=:UserStatus, RoleId=:RoleId, " + " OrgId=:OrgId where PkId=:PkId "; parameterList.Add(new OracleParameter(":UserAccount", objUserInfo.UserAccount)); parameterList.Add(new OracleParameter(":UserPwd", objUserInfo.UserPwd)); parameterList.Add(new OracleParameter(":UserNickName", objUserInfo.UserNickName)); parameterList.Add(new OracleParameter(":UserEmail", objUserInfo.UserEmail)); parameterList.Add(new OracleParameter(":UserPhone", objUserInfo.UserPhone)); parameterList.Add(new OracleParameter(":UserStatus", objUserInfo.UserStatus)); parameterList.Add(new OracleParameter(":RoleId", objUserInfo.RoleId)); parameterList.Add(new OracleParameter(":OrgId", objUserInfo.OrgId)); parameterList.Add(new OracleParameter(":PkId", objUserInfo.PkId)); } DbHelper.ExecuteNonQuery(sql, CommandType.Text, parameterList.ToArray()); }
public void Save(UserInfo objUserInfo) { string sql = null; List<DbParameter> parameterList = new List<DbParameter>(); if (objUserInfo.PkId == 0) { sql = " insert into tbl_user_info(UserAccount, UserPwd, UserNickName, UserEmail, UserPhone, UserStatus, RoleId, OrgId) " + " values(@UserAccount, @UserPwd, @UserNickName, @UserEmail, @UserPhone, @UserStatus, @RoleId, @OrgId) "; parameterList.Add(new MySqlParameter("@UserAccount", objUserInfo.UserAccount)); parameterList.Add(new MySqlParameter("@UserPwd", objUserInfo.UserPwd)); parameterList.Add(new MySqlParameter("@UserNickName", objUserInfo.UserNickName)); parameterList.Add(new MySqlParameter("@UserEmail", objUserInfo.UserEmail)); parameterList.Add(new MySqlParameter("@UserPhone", objUserInfo.UserPhone)); parameterList.Add(new MySqlParameter("@UserStatus", objUserInfo.UserStatus)); parameterList.Add(new MySqlParameter("@RoleId", objUserInfo.RoleId)); parameterList.Add(new MySqlParameter("@OrgId", objUserInfo.OrgId)); } else { sql = " update tbl_user_info set UserAccount=@UserAccount, UserPwd=@UserPwd, UserNickName=@UserNickName, " + " UserEmail=@UserEmail, UserPhone=@UserPhone, UserStatus=@UserStatus, RoleId=@RoleId, " + " OrgId=@OrgId where PkId=@PkId "; parameterList.Add(new MySqlParameter("@PkId", objUserInfo.PkId)); parameterList.Add(new MySqlParameter("@UserAccount", objUserInfo.UserAccount)); parameterList.Add(new MySqlParameter("@UserPwd", objUserInfo.UserPwd)); parameterList.Add(new MySqlParameter("@UserNickName", objUserInfo.UserNickName)); parameterList.Add(new MySqlParameter("@UserEmail", objUserInfo.UserEmail)); parameterList.Add(new MySqlParameter("@UserPhone", objUserInfo.UserPhone)); parameterList.Add(new MySqlParameter("@UserStatus", objUserInfo.UserStatus)); parameterList.Add(new MySqlParameter("@RoleId", objUserInfo.RoleId)); parameterList.Add(new MySqlParameter("@OrgId", objUserInfo.OrgId)); } DbHelper.ExecuteNonQuery(sql, CommandType.Text, parameterList.ToArray()); }