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