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();
}
