/// <summary> /// 新增数据 /// </summary> /// <param name="RoleObj"></param> /// <returns></returns> public bool Add(tblRole_User Role_UserObj) { Role_UserObj.ID = System.Guid.NewGuid(); int counts = 0; //插入数据 try { using (MWDatabaseEntities MWDB = new MWDatabaseEntities()) { MWDB.tblRole_User.AddObject(Role_UserObj); counts = MWDB.SaveChanges(); if (counts > 0) { string userHostAddress = HttpContext.Current.Request.UserHostAddress; DbLoggerBLL.SysLogger.Info("Increase user and role relationship successfully! User and role relationship ID: '" + Role_UserObj.ID + "'. User host address: '" + userHostAddress + "' . "); return true; } } } catch (Exception ex) { string userHostAddress = HttpContext.Current.Request.UserHostAddress; DbLoggerBLL.SysLogger.Error("Increase user and role relationship failed! User and role relationship ID: '" + Role_UserObj.ID + "'. User host address: '" + userHostAddress + "' . Exception info:" + ex.Message); return false; } return false; }
/// <summary> /// GridView 的UpdateCommand 事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void GridUser_UpdateCommand(object sender, GridCommandEventArgs e) { GridEditableItem edittedItem = e.Item as GridEditableItem; //获取控件 RadTextBox textUserName = edittedItem.FindControl("textUserName") as RadTextBox; RadTextBox textLoginName = edittedItem.FindControl("textLoginName") as RadTextBox; RadTextBox textUserCode = edittedItem.FindControl("textUserCode") as RadTextBox; RadTextBox textEmail = edittedItem.FindControl("textEmail") as RadTextBox; RadTextBox textDesc = edittedItem.FindControl("textDesc") as RadTextBox; RadComboBox ComBoxState = edittedItem.FindControl("ComBoxState") as RadComboBox; RadComboBox ComBoxRole = edittedItem.FindControl("ComBoxRole") as RadComboBox; //*************************************************给用户配置角色 RoleUserBLL Role_UserBLLs = new RoleUserBLL(); if (ComBoxRole.SelectedItem.Value != string.Empty) { //删除关系表 Role_UserBLLs.Delete(this.strKeyID); tblRole_User tblRole_UserObj = new tblRole_User(); System.Guid gUserID = new Guid(this.strKeyID); System.Guid gRoleID = new Guid(ComBoxRole.SelectedItem.Value); tblRole_UserObj.UserID = gUserID; tblRole_UserObj.RoleID = gRoleID; Role_UserBLLs.Add(tblRole_UserObj); } //*************************************************给用户配置角色 //实例化Entity实体 UserBLL UserBLLs = new UserBLL(); tblUser UserObjs; UserObjs = UserBLLs.GetByID(this.strKeyID); UserObjs.UserName = textUserName.Text; UserObjs.LoginName = textLoginName.Text; UserObjs.UserCode = textUserCode.Text; if (ComBoxState.SelectedItem.Value == "True") { UserObjs.State = true; } else { UserObjs.State = false; } UserObjs.Email = textEmail.Text; UserObjs.Desc = textDesc.Text; UserBLLs.Update(UserObjs); this.GridViewData(); }
/// <summary> /// 用于向 tblRole_User EntitySet 添加新对象的方法,已弃用。请考虑改用关联的 ObjectSet<T> 属性的 .Add 方法。 /// </summary> public void AddTotblRole_User(tblRole_User tblRole_User) { base.AddObject("tblRole_User", tblRole_User); }
/// <summary> /// GridView的InsertCommand事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void GridUser_InsertCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e) { GridEditableItem edittedItem = e.Item.OwnerTableView.GetInsertItem(); //获取控件 RadTextBox textUserName = edittedItem.FindControl("textUserName") as RadTextBox; RadTextBox textLoginName = edittedItem.FindControl("textLoginName") as RadTextBox; RadTextBox textUserCode = edittedItem.FindControl("textUserCode") as RadTextBox; RadTextBox textEmail = edittedItem.FindControl("textEmail") as RadTextBox; RadTextBox textDesc = edittedItem.FindControl("textDesc") as RadTextBox; RadTextBox textLoginPwd = edittedItem.FindControl("textLoginPwd") as RadTextBox; RadComboBox ComBoxState = edittedItem.FindControl("ComBoxState") as RadComboBox; RadComboBox ComBoxRole = edittedItem.FindControl("ComBoxRole") as RadComboBox; System.Guid gTemp = System.Guid.NewGuid(); UserBLL UserBLLs = new UserBLL(); if (UserBLLs.ExistsLogName(textLoginName.Text)) { //The user already exists //该用户已存在 RadWindowManager1.RadAlert("The user already exists!", 300, 100, "Info", ""); return; } //实例化Entity实体 tblUser UserObj = new tblUser(); UserObj.UserName = textUserName.Text; UserObj.LoginName = textLoginName.Text; UserObj.LoginPwd = textLoginPwd.Text; UserObj.UserCode = textUserCode.Text; UserObj.State = Convert.ToBoolean(ComBoxState.SelectedItem.Value); UserObj.Email = textEmail.Text; UserObj.Desc = textDesc.Text; UserObj.UserID = gTemp; UserBLLs.Add(UserObj); //创建目录文件夹 Directory.CreateDirectory(Request.PhysicalApplicationPath + "FileUpLoad/" + gTemp); //*************************************************给用户配置角色 RoleUserBLL Role_UserBLLs = new RoleUserBLL(); if (ComBoxRole.SelectedItem.Value != string.Empty) { tblRole_User tblRole_UserObj = new tblRole_User(); System.Guid gUserID = gTemp; System.Guid gRoleID = new Guid(ComBoxRole.SelectedItem.Value); tblRole_UserObj.UserID = gUserID; tblRole_UserObj.RoleID = gRoleID; Role_UserBLLs.Add(tblRole_UserObj); } //*************************************************给用户配置角色 this.GridViewData(); }
/// <summary> /// 创建新的 tblRole_User 对象。 /// </summary> /// <param name="id">ID 属性的初始值。</param> public static tblRole_User CreatetblRole_User(global::System.Guid id) { tblRole_User tblRole_User = new tblRole_User(); tblRole_User.ID = id; return tblRole_User; }