public void GetRole() { RoleBLL RoleBLLs = new RoleBLL(); tblRole tblRoleObj; tblRoleObj = RoleBLLs.GetByID(this.strKeyID); lbl_RoleNames.Text = tblRoleObj.RoleName; }
/// <summary> /// GridView绑定数据 /// </summary> public void GridViewData() { //实例化EntityDataSourceModel 属性类 EntityDataSourceModel eModel = new EntityDataSourceModel(); RoleBLL RoleBLLs = new RoleBLL(); eModel = RoleBLLs.GetEModel(); EntityDataSourceRole.EntitySetName = eModel.EntitySetName; if (!string.IsNullOrEmpty(eModel.Where)) { EntityDataSourceRole.Where = eModel.Where; } if (!string.IsNullOrEmpty(eModel.OrderBy)) { EntityDataSourceRole.OrderBy = eModel.OrderBy; } EntityDataSourceRole.DefaultContainerName = eModel.DefaultContainerName; EntityDataSourceRole.ConnectionString = eModel.ConnectionString; }
/// <summary> /// 删除事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void GridRole_DeleteCommand(object sender, GridCommandEventArgs e) { //获取Grid的主键值 string GridKey = e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["RoleID"].ToString(); RoleUserBLL Role_UserBLLs = new RoleUserBLL(); tblRole_User tblRole_Users = Role_UserBLLs.GetByRoleID(GridKey); if (tblRole_Users != null) { if (tblRole_Users.RoleID != null) { //正在使用不能删除! 警告Admin Can't delete! string strInfo = GetGlobalResourceObject("en_US", "RoleManagerForm_DeleteInfo").ToString(); RadWindowManager1.RadAlert(strInfo, 300, 100, "Warn", ""); return; } } RoleBLL RoleBLLs = new RoleBLL(); if (GridKey != string.Empty) { RoleBLLs.Delete(GridKey); } this.GridViewData(); }
protected void GridUser_ItemDataBound(object sender, GridItemEventArgs e) { if (e.Item is GridEditFormItem && e.Item.IsInEditMode) { //插入状态 if (e.Item.OwnerTableView.IsItemInserted) { //***********************************Role 下拉列表加载数据 RoleBLL RoleBLLs = new RoleBLL(); List<View_Role> query = null; query = RoleBLLs.GetAll("", " it.RoleName desc"); if (query != null && query.Count() > 0) { GridEditFormItem edittedItem = (GridEditFormItem)e.Item; RadComboBox ComBoxRole = edittedItem.FindControl("ComBoxRole") as RadComboBox; ComBoxRole.DataSource = query; ComBoxRole.DataTextField = "RoleName"; ComBoxRole.DataValueField = "RoleID"; ComBoxRole.DataBind(); } //***********************************Role 下拉列表加载数据 } //编辑状态 else { //获取Grid的主键值 this.strKeyID = e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["UserID"].ToString(); //判断主键是否为空 if (this.strKeyID != string.Empty) { //装换Guid类型 System.Guid Guid = new Guid(this.strKeyID); //实例化Entity实体 using (MWDatabaseEntities MWDB = new MWDatabaseEntities()) { //通过主键查询数据表获取外键字段 control tblUser tblUsers = MWDB.tblUser.FirstOrDefault(d => d.UserID == Guid); if (tblUsers != null) { //加载d_DicType GridEditFormItem edittedItem = (GridEditFormItem)e.Item; //获取控件 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; RoleBLL RoleBLLs = new RoleBLL(); //***********************************Role 下拉列表加载数据 List<View_Role> query = null; query = RoleBLLs.GetAll("", " it.RoleName desc"); if (query != null && query.Count() > 0) { ComBoxRole.DataSource = query; ComBoxRole.DataTextField = "RoleName"; ComBoxRole.DataValueField = "RoleID"; ComBoxRole.DataBind(); } //***********************************Role 下拉列表加载数据 RoleUserBLL Role_UserBLLs = new RoleUserBLL(); tblRole_User tblRole_UserObj = null; tblRole_UserObj = Role_UserBLLs.GetByID(this.strKeyID); if (tblRole_UserObj != null) { ComBoxRole.SelectedIndex = ComBoxRole.Items.IndexOf(ComBoxRole.Items.FindItemByValue(tblRole_UserObj.RoleID.ToString(), true)); } //为控件赋值 textUserName.Text = tblUsers.UserName; textLoginName.Text = tblUsers.LoginName; textUserCode.Text = tblUsers.UserCode; textEmail.Text = tblUsers.Email; textDesc.Text = tblUsers.Desc; //下拉列表编辑时选择 ComBoxState.SelectedIndex = ComBoxState.Items.IndexOf(ComBoxState.Items.FindItemByValue(tblUsers.State.ToString())); } } } } } }
/// <summary> /// GridView的InsertCommand事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void GridRole_InsertCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e) { GridEditableItem edittedItem = e.Item.OwnerTableView.GetInsertItem(); //获取控件 RadTextBox textRoleName = edittedItem.FindControl("txtRoleName") as RadTextBox; RadTextBox textRoleCode = edittedItem.FindControl("textRoleCode") as RadTextBox; RadTextBox textDesc = edittedItem.FindControl("textDesc") as RadTextBox; RadComboBox ComBoxState = edittedItem.FindControl("ComBoxState") as RadComboBox; //实例化Entity实体 tblRole roleObj = new tblRole(); roleObj.RoleName = textRoleName.Text; roleObj.RoleCode = textRoleCode.Text; roleObj.Desc = textDesc.Text; roleObj.State = Convert.ToDecimal(ComBoxState.SelectedItem.Value); RoleBLL RoleBLLs = new RoleBLL(); RoleBLLs.Add(roleObj); this.GridViewData(); }
/// <summary> /// GridView 的UpdateCommand 事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void GridRole_UpdateCommand(object sender, GridCommandEventArgs e) { GridEditableItem editedItem = e.Item as GridEditableItem; //获取控件 RadTextBox textRoleName = editedItem.FindControl("txtRoleName") as RadTextBox; RadTextBox textRoleCode = editedItem.FindControl("textRoleCode") as RadTextBox; RadTextBox textDesc = editedItem.FindControl("textDesc") as RadTextBox; RadComboBox ComBoxState = editedItem.FindControl("ComBoxState") as RadComboBox; //实例化Entity实体 RoleBLL RoleBLLs = new RoleBLL(); tblRole roleObj; roleObj = RoleBLLs.GetByID(this.strKeyID); roleObj.RoleName = textRoleName.Text; roleObj.RoleCode = textRoleCode.Text; roleObj.Desc = textDesc.Text; roleObj.State = Convert.ToDecimal(ComBoxState.SelectedItem.Value); RoleBLLs.Update(roleObj); this.GridViewData(); }