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