/// <summary>
///
/// </summary>
/// <returns></returns>
public static List <Entity.UserRole> GetAllUserRole()
{
List <Entity.UserRole> list = new List <Entity.UserRole>();
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
IDbDataParameter[] prams =
{
};
IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.StoredProcedure, "proc_UserRole_GetAll", prams);
while (dataReader.Read())
{
Entity.UserRole entity = new Entity.UserRole();
//entity.UserID = DataHelper.ParseToInt(dataReader["UserID"].ToString());
//entity.RoleID = DataHelper.ParseToInt(dataReader["RoleID"].ToString());
list.Add(entity);
}
}
catch (Exception ex)
{
}
finally
{
db.Conn.Close();
}
return(list);
}
/// <summary>
///
/// </summary>
/// <param name="UserID"> </param>
/// <param name="RoleID"> </param>
/// <returns></returns>
public static int AddUserRole(Entity.UserRole userRole)
{
int iReturn = 0;
int i = 0;
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
SqlTransactionHelper thelper = new SqlTransactionHelper(Config.con);
IDbTransaction trans = thelper.StartTransaction();
try
{
iReturn = db.ExecuteNonQueryTrans(trans, CommandType.Text, "Insert into [User]([UserName],[PassWord],[GUID],[RealName],[PwdChgDate],[CreateUser],[CreateDate],[UpdateUser],[UpdateDate],[IsStop]) values ('" + userRole.user.UserName + "','" + userRole.user.PassWord + "','" + userRole.user.GUID + "','" + userRole.user.RealName + "','" + userRole.user.PwdChgDate + "','" + userRole.user.CreateUser + "','" + userRole.user.CreateDate + "','" + userRole.user.UpdateUser + "','" + userRole.user.UpdateDate + "','" + userRole.user.IsStop + "')", null);
foreach (Entity.Role role in userRole.role)
{
iReturn = db.ExecuteNonQueryTrans(trans, CommandType.Text, "Insert into [UserRole]([UGuid],[RoleID]) values ('" + userRole.user.GUID + "','" + role.ID + "')", null);
}
thelper.CommitTransaction(trans);
iReturn = 1;
}
catch (Exception ex)
{
thelper.RollTransaction(trans);
iReturn = 0;
}
finally
{
db.Conn.Close();
}
return(iReturn);
}
private void LoadData(string sId)
{
if (sId != string.Empty)
{
txt_vPassWord1.Hidden = true;
txt_vPassWord2.Hidden = true;
Entity.UserRole userrole = DAL.UserRole.GetUserRoleByGUID(sId);
if (!string.IsNullOrEmpty(userrole.user.UserName))
{
hfGuid.Text = sId;
txt_vUserName.Text = userrole.user.UserName;
txt_RealName.Text = userrole.user.RealName;
List <Entity.Role> roles = userrole.role;
string[] Roles = new string[roles.Count];
for (int i = 0; i < roles.Count; i++)
{
Roles[i] = roles[i].ID.ToString();
OldIDs.Add(roles[i].ID);
}
Role.SelectedValueArray = Roles;
CheckStop.SelectedValue = userrole.user.IsStop.ToString();
}
}
else
{
CheckStop.SelectedValue = "True";
}
}
public IEnumerable <string> Get()
{
var user = new Entity.User
{
Id = Guid.NewGuid().ToString(),
Age = 1.2,
Name = "里斯",
Sex = 1
};
var role = new Entity.Role()
{
Id = Guid.NewGuid().ToString(),
Name = "角色",
};
var user_role = new Entity.UserRole()
{
Id = Guid.NewGuid().ToString(),
//Role = role,
//UserCurrent = user,
//UserParent = new Entity.User()
//{
// Id = Guid.NewGuid().ToString(),
// Age = 0.2,
// Name = "里da斯",
// Sex = 1
//}
};
context.Set <Entity.UserRole>().Add(user_role);
var i = context.SaveChanges();
return(new string[] { "value1", "value2" });
}
/// <summary>
/// 取得更新数据的数据库命令
/// </summary>
/// <param name="item">实体数据</param>
/// <returns></returns>
protected override DapperCommand CreateUpdateCommand(Entity.UserRole item)
{
string sql = $"UPDATE {TableName} SET WHERE UserId=@UserId And RoleId=@RoleId";
return(new DapperCommand()
{
CommandText = sql,
Parameters = item
});
}
/// <summary>
/// 取得插入数据的数据库命令
/// </summary>
/// <param name="item">实体数据</param>
/// <returns></returns>
protected override DapperCommand CreateInsertCommand(Entity.UserRole item)
{
string sql = $"INSERT INTO {TableName} (UserId,RoleId) VALUES (@UserId,@RoleId)";
return(new DapperCommand()
{
CommandText = sql,
Parameters = item
});
}
/// <summary>
/// 取得删除数据的数据库命令
/// </summary>
/// <param name="item">实体实例</param>
/// <returns></returns>
protected override DapperCommand CreateDeleteCommand(Entity.UserRole item)
{
string sql = $"DELETE FROM {TableName} WHERE UserId=@UserId And RoleId=@RoleId";
DynamicParameters dynamicParameters = new DynamicParameters();
dynamicParameters.Add("UserId", item.UserId);
dynamicParameters.Add("RoleId", item.RoleId);
return(new DapperCommand()
{
CommandText = sql,
Parameters = dynamicParameters
});
}
/// <summary>
///
/// </summary>
/// <param name="UserID"> </param>
/// <returns></returns>
public static Entity.UserRole GetUserRoleByGUID(string GUID)
{
Entity.UserRole entity = new Entity.UserRole();
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
try
{
List <Entity.Role> Roles = new List <Entity.Role>();
IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "select * from vUserRole where GUID='" + GUID + "'", null);
if (dataReader.Read())
{
//Entity.UserRole entity = new Entity.UserRole();
//entity.UserID = DataHelper.ParseToInt(dataReader["UserID"].ToString());
//entity.RoleID = DataHelper.ParseToInt(dataReader["RoleID"].ToString());
//list.Add(entity);
entity.user.ID = DataHelper.ParseToInt(dataReader["UserID"].ToString());
entity.user.UserName = dataReader["UserName"].ToString();
entity.user.PassWord = dataReader["PassWord"].ToString();
entity.user.GUID = dataReader["GUID"].ToString();
entity.user.RealName = dataReader["RealName"].ToString();
entity.user.IsStop = DataHelper.ParseToBoolean(dataReader["IsStop"].ToString());
//entity.role.ID = DataHelper.ParseToInt(dataReader["RoleID"].ToString());
//entity.role.RoleName = dataReader["RoleName"].ToString();
//entity.role.Description = dataReader["Description"].ToString();
//entity.role.IsAudit = DataHelper.ParseToBoolean(dataReader["IsAudit"].ToString());
}
dataReader = db.ExecuteReader(Config.con, CommandType.Text, "select * from vUserRole where GUID='" + GUID + "'", null);
while (dataReader.Read())
{
Entity.Role role = new Entity.Role();
role.ID = DataHelper.ParseToInt(dataReader["RoleID"].ToString());
role.RoleName = dataReader["RoleName"].ToString();
role.Description = dataReader["Description"].ToString();
Roles.Add(role);
//entity.role.IsAudit = DataHelper.ParseToBoolean(dataReader["IsAudit"].ToString());
}
entity.role = Roles;
}
catch (Exception ex)
{
}
finally
{
db.Conn.Close();
}
return(entity);
}
public static int UpdateUserRole(Entity.UserRole userRole)
{
int iReturn = 0;
int i = 0;
DBOperatorBase db = new DataBase();
IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory();
SqlTransactionHelper thelper = new SqlTransactionHelper(Config.con);
IDbTransaction trans = thelper.StartTransaction();
try
{
iReturn = db.ExecuteNonQueryTrans(trans, CommandType.Text, "Update [User] set UserName='******',RealName='" + userRole.user.RealName + "',UpdateUser='******',UpdateDate='" + userRole.user.UpdateDate + "',IsStop='" + userRole.user.IsStop + "' where GUID='" + userRole.user.GUID + "'", null);
//iReturn = db.ExecuteNonQueryTrans(trans, CommandType.Text, "Update [UserRole] set RoleID='" + userRole.role.ID + "'where UGuid='" + userRole.user.GUID + "'", null);
foreach (int a in userRole.Add)
{
iReturn = db.ExecuteNonQueryTrans(trans, CommandType.Text, "Insert into [UserRole]([UGuid],[RoleID]) values ('" + userRole.user.GUID + "','" + a + "')", null);
}
foreach (int b in userRole.Delete)
{
iReturn = db.ExecuteNonQueryTrans(trans, CommandType.Text, "Delete from [UserRole] where UGuid='" + userRole.user.GUID + "' and RoleID='" + b + "'", null);
}
thelper.CommitTransaction(trans);
iReturn = 1;
}
catch (Exception ex)
{
thelper.RollTransaction(trans);
iReturn = 0;
}
finally
{
db.Conn.Close();
}
return(iReturn);
}
protected void btn_save_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(sGuid))
{
//Add
Guid guid = Guid.NewGuid();
Md5 md5 = new Md5();
if (txt_vPassWord1.Text.Trim() != txt_vPassWord2.Text.Trim())
{
Alert.ShowInTop("2次输入的密码不一致。");
return;
}
Entity.UserRole userrole = new Entity.UserRole();
userrole.user.GUID = guid.ToString();
userrole.user.PassWord = md5.Md5Encrypt(txt_vPassWord1.Text.Trim());
userrole.user.CreateDate = DateTime.Now;
userrole.user.CreateUser = Request.Cookies["Cookies"].Values["UserName"].ToString();
userrole.user.IsStop = bool.Parse(CheckStop.SelectedValue);
userrole.user.PwdChgDate = DateTime.Now;
userrole.user.RealName = txt_RealName.Text;
userrole.user.UserName = txt_vUserName.Text;
userrole.user.UpdateDate = DateTime.Now;
userrole.user.UpdateUser = Request.Cookies["Cookies"].Values["UserName"].ToString();
List <Entity.Role> roles = new List <Entity.Role>();
foreach (string roleID in Role.SelectedValueArray)
{
Entity.Role role = new Entity.Role();
role.ID = int.Parse(roleID);
roles.Add(role);
}
userrole.role = roles;
//userrole.role.ID = int.Parse(drop_Role.SelectedValue.ToString());
int success = DAL.UserRole.AddUserRole(userrole);
if (success == 1)
{
Alert.ShowInTop(" 保存成功！", MessageBoxIcon.Information);
PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference());
//PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference("self.opener.location.reload();"));
//Response.Redirect("~/Basic/UserList.aspx");
}
else
{
Alert.ShowInTop("保存失败！", MessageBoxIcon.Warning);
}
}
else
{
//Update
//Guid guid = Guid.NewGuid();
//Md5 md5 = new Md5();
Entity.UserRole userrole = new Entity.UserRole();
userrole.user.GUID = sGuid;
userrole.user.IsStop = bool.Parse(CheckStop.SelectedValue);
//userrole.user.PwdChgDate = DateTime.Now;
userrole.user.RealName = txt_RealName.Text;
userrole.user.UserName = txt_vUserName.Text;
userrole.user.UpdateDate = DateTime.Now;
userrole.user.UpdateUser = Request.Cookies["Cookies"].Values["UserName"].ToString();
Entity.UserRole userrole2 = DAL.UserRole.GetUserRoleByGUID(sGuid);
if (!string.IsNullOrEmpty(userrole2.user.UserName))
{
List <Entity.Role> roles = userrole2.role;
string[] Roles = new string[roles.Count];
for (int i = 0; i < roles.Count; i++)
{
Roles[i] = roles[i].ID.ToString();
OldIDs.Add(roles[i].ID);
}
}
List <Entity.Role> roles2 = new List <Entity.Role>();
foreach (string roleID in Role.SelectedValueArray)
{
Entity.Role role = new Entity.Role();
role.ID = int.Parse(roleID);
NewIDs.Add(role.ID);
}
userrole.role = roles2;
//var add = NewIDs.Except(OldIDs);
//var delete = OldIDs.Except(NewIDs);
//var add = NewIDs;
//var delete = OldIDs;
List <int> Add = ListHelper.ExceptList(NewIDs, OldIDs);
List <int> Delete = ListHelper.ExceptList(OldIDs, NewIDs);
//List<int> Add = new List<int>();
//List<int> Delete = new List<int>();
//foreach(string a in add)
//{
// Add.Add(int.Parse(a));
//}
//foreach (string b in delete)
//{
// Delete.Add(int.Parse(b));
//}
userrole.Add = Add;
userrole.Delete = Delete;
int success = DAL.UserRole.UpdateUserRole(userrole);
if (success == 1)
{
Alert.ShowInTop(" 修改成功！", MessageBoxIcon.Information);
PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference());
//PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference("self.opener.location.reload();"));
//Response.Redirect("~/Basic/UserList.aspx");
}
else
{
Alert.ShowInTop("修改失败！", MessageBoxIcon.Warning);
}
}
}
