public int Add(RoadFlow.Data.Model.UsersRelation model) { string sql = "INSERT INTO usersrelation\r\n\t\t\t\t(UserID,OrganizeID,IsMain,Sort) \r\n\t\t\t\tVALUES(@UserID,@OrganizeID,@IsMain,@Sort)"; MySqlParameter[] mySqlParameterArray = new MySqlParameter[4]; int index1 = 0; MySqlParameter mySqlParameter1 = new MySqlParameter("@UserID", MySqlDbType.VarChar, 36); mySqlParameter1.Value = (object)model.UserID; mySqlParameterArray[index1] = mySqlParameter1; int index2 = 1; MySqlParameter mySqlParameter2 = new MySqlParameter("@OrganizeID", MySqlDbType.VarChar, 36); mySqlParameter2.Value = (object)model.OrganizeID; mySqlParameterArray[index2] = mySqlParameter2; int index3 = 2; MySqlParameter mySqlParameter3 = new MySqlParameter("@IsMain", MySqlDbType.Int32, 11); mySqlParameter3.Value = (object)model.IsMain; mySqlParameterArray[index3] = mySqlParameter3; int index4 = 3; MySqlParameter mySqlParameter4 = new MySqlParameter("@Sort", MySqlDbType.Int32, 11); mySqlParameter4.Value = (object)model.Sort; mySqlParameterArray[index4] = mySqlParameter4; MySqlParameter[] parameter = mySqlParameterArray; return(this.dbHelper.Execute(sql, parameter, false)); }
public int Update(RoadFlow.Data.Model.UsersRelation model) { string sql = "UPDATE usersrelation SET \r\n\t\t\t\tIsMain=@IsMain,Sort=@Sort\r\n\t\t\t\tWHERE UserID=@UserID and OrganizeID=@OrganizeID"; MySqlParameter[] mySqlParameterArray = new MySqlParameter[4]; int index1 = 0; MySqlParameter mySqlParameter1 = new MySqlParameter("@IsMain", MySqlDbType.Int32, 11); mySqlParameter1.Value = (object)model.IsMain; mySqlParameterArray[index1] = mySqlParameter1; int index2 = 1; MySqlParameter mySqlParameter2 = new MySqlParameter("@Sort", MySqlDbType.Int32, 11); mySqlParameter2.Value = (object)model.Sort; mySqlParameterArray[index2] = mySqlParameter2; int index3 = 2; MySqlParameter mySqlParameter3 = new MySqlParameter("@UserID", MySqlDbType.VarChar, 36); mySqlParameter3.Value = (object)model.UserID; mySqlParameterArray[index3] = mySqlParameter3; int index4 = 3; MySqlParameter mySqlParameter4 = new MySqlParameter("@OrganizeID", MySqlDbType.VarChar, 36); mySqlParameter4.Value = (object)model.OrganizeID; mySqlParameterArray[index4] = mySqlParameter4; MySqlParameter[] parameter = mySqlParameterArray; return(this.dbHelper.Execute(sql, parameter, false)); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">RoadFlow.Data.Model.UsersRelation实体类</param> /// <returns>操作所影响的行数</returns> public int Add(RoadFlow.Data.Model.UsersRelation model) { string sql = @"INSERT INTO UsersRelation (UserID,OrganizeID,IsMain,Sort) VALUES(:UserID,:OrganizeID,:IsMain,:Sort)" ; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":UserID", OracleDbType.Varchar2, 40) { Value = model.UserID }, new OracleParameter(":OrganizeID", OracleDbType.Varchar2, 40) { Value = model.OrganizeID }, new OracleParameter(":IsMain", OracleDbType.Int32) { Value = model.IsMain }, new OracleParameter(":Sort", OracleDbType.Int32) { Value = model.Sort } }; return(dbHelper.Execute(sql, parameters)); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">RoadFlow.Data.Model.UsersRelation实体类</param> public int Update(RoadFlow.Data.Model.UsersRelation model) { string sql = @"UPDATE UsersRelation SET IsMain=:IsMain,Sort=:Sort WHERE UserID=:UserID and OrganizeID=:OrganizeID" ; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":IsMain", OracleDbType.Int32) { Value = model.IsMain }, new OracleParameter(":Sort", OracleDbType.Int32) { Value = model.Sort }, new OracleParameter(":UserID", OracleDbType.Varchar2, 40) { Value = model.UserID }, new OracleParameter(":OrganizeID", OracleDbType.Varchar2, 40) { Value = model.OrganizeID } }; return(dbHelper.Execute(sql, parameters)); }
public int Update(RoadFlow.Data.Model.UsersRelation model) { string sql = "UPDATE UsersRelation SET \r\n\t\t\t\tIsMain=@IsMain,Sort=@Sort\r\n\t\t\t\tWHERE UserID=@UserID and OrganizeID=@OrganizeID"; SqlParameter[] sqlParameterArray = new SqlParameter[4]; int index1 = 0; SqlParameter sqlParameter1 = new SqlParameter("@IsMain", SqlDbType.Int, -1); sqlParameter1.Value = (object)model.IsMain; sqlParameterArray[index1] = sqlParameter1; int index2 = 1; SqlParameter sqlParameter2 = new SqlParameter("@Sort", SqlDbType.Int, -1); sqlParameter2.Value = (object)model.Sort; sqlParameterArray[index2] = sqlParameter2; int index3 = 2; SqlParameter sqlParameter3 = new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, -1); sqlParameter3.Value = (object)model.UserID; sqlParameterArray[index3] = sqlParameter3; int index4 = 3; SqlParameter sqlParameter4 = new SqlParameter("@OrganizeID", SqlDbType.UniqueIdentifier, -1); sqlParameter4.Value = (object)model.OrganizeID; sqlParameterArray[index4] = sqlParameter4; SqlParameter[] parameter = sqlParameterArray; return(this.dbHelper.Execute(sql, parameter, false)); }
/// <summary> /// 更新记录 /// </summary> /// <param name="model">RoadFlow.Data.Model.UsersRelation实体类</param> public int Update(RoadFlow.Data.Model.UsersRelation model) { string sql = @"UPDATE UsersRelation SET IsMain=@IsMain,Sort=@Sort WHERE UserID=@UserID and OrganizeID=@OrganizeID" ; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@IsMain", SqlDbType.Int, -1) { Value = model.IsMain }, new SqlParameter("@Sort", SqlDbType.Int, -1) { Value = model.Sort }, new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, -1) { Value = model.UserID }, new SqlParameter("@OrganizeID", SqlDbType.UniqueIdentifier, -1) { Value = model.OrganizeID } }; return(dbHelper.Execute(sql, parameters)); }
public int Add(RoadFlow.Data.Model.UsersRelation model) { string sql = "INSERT INTO UsersRelation\r\n\t\t\t\t(UserID,OrganizeID,IsMain,Sort) \r\n\t\t\t\tVALUES(@UserID,@OrganizeID,@IsMain,@Sort)"; SqlParameter[] sqlParameterArray = new SqlParameter[4]; int index1 = 0; SqlParameter sqlParameter1 = new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, -1); sqlParameter1.Value = (object)model.UserID; sqlParameterArray[index1] = sqlParameter1; int index2 = 1; SqlParameter sqlParameter2 = new SqlParameter("@OrganizeID", SqlDbType.UniqueIdentifier, -1); sqlParameter2.Value = (object)model.OrganizeID; sqlParameterArray[index2] = sqlParameter2; int index3 = 2; SqlParameter sqlParameter3 = new SqlParameter("@IsMain", SqlDbType.Int, -1); sqlParameter3.Value = (object)model.IsMain; sqlParameterArray[index3] = sqlParameter3; int index4 = 3; SqlParameter sqlParameter4 = new SqlParameter("@Sort", SqlDbType.Int, -1); sqlParameter4.Value = (object)model.Sort; sqlParameterArray[index4] = sqlParameter4; SqlParameter[] parameter = sqlParameterArray; return(this.dbHelper.Execute(sql, parameter, false)); }
public int Update(RoadFlow.Data.Model.UsersRelation model) { string sql = "UPDATE UsersRelation SET \r\n\t\t\t\tIsMain=:IsMain,Sort=:Sort\r\n\t\t\t\tWHERE UserID=:UserID and OrganizeID=:OrganizeID"; OracleParameter[] oracleParameterArray = new OracleParameter[4]; int index1 = 0; OracleParameter oracleParameter1 = new OracleParameter(":IsMain", OracleDbType.Int32); oracleParameter1.Value = (object)model.IsMain; oracleParameterArray[index1] = oracleParameter1; int index2 = 1; OracleParameter oracleParameter2 = new OracleParameter(":Sort", OracleDbType.Int32); oracleParameter2.Value = (object)model.Sort; oracleParameterArray[index2] = oracleParameter2; int index3 = 2; OracleParameter oracleParameter3 = new OracleParameter(":UserID", OracleDbType.Varchar2, 40); oracleParameter3.Value = (object)model.UserID; oracleParameterArray[index3] = oracleParameter3; int index4 = 3; OracleParameter oracleParameter4 = new OracleParameter(":OrganizeID", OracleDbType.Varchar2, 40); oracleParameter4.Value = (object)model.OrganizeID; oracleParameterArray[index4] = oracleParameter4; OracleParameter[] parameter = oracleParameterArray; return(this.dbHelper.Execute(sql, parameter)); }
/// <summary> /// 添加记录 /// </summary> /// <param name="model">RoadFlow.Data.Model.UsersRelation实体类</param> /// <returns>操作所影响的行数</returns> public int Add(RoadFlow.Data.Model.UsersRelation model) { string sql = @"INSERT INTO UsersRelation (UserID,OrganizeID,IsMain,Sort) VALUES(@UserID,@OrganizeID,@IsMain,@Sort)" ; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@UserID", SqlDbType.UniqueIdentifier, -1) { Value = model.UserID }, new SqlParameter("@OrganizeID", SqlDbType.UniqueIdentifier, -1) { Value = model.OrganizeID }, new SqlParameter("@IsMain", SqlDbType.Int, -1) { Value = model.IsMain }, new SqlParameter("@Sort", SqlDbType.Int, -1) { Value = model.Sort } }; return(dbHelper.Execute(sql, parameters)); }
public int Add(RoadFlow.Data.Model.UsersRelation model) { string sql = "INSERT INTO UsersRelation\r\n\t\t\t\t(UserID,OrganizeID,IsMain,Sort) \r\n\t\t\t\tVALUES(:UserID,:OrganizeID,:IsMain,:Sort)"; OracleParameter[] oracleParameterArray = new OracleParameter[4]; int index1 = 0; OracleParameter oracleParameter1 = new OracleParameter(":UserID", OracleDbType.Varchar2, 40); oracleParameter1.Value = (object)model.UserID; oracleParameterArray[index1] = oracleParameter1; int index2 = 1; OracleParameter oracleParameter2 = new OracleParameter(":OrganizeID", OracleDbType.Varchar2, 40); oracleParameter2.Value = (object)model.OrganizeID; oracleParameterArray[index2] = oracleParameter2; int index3 = 2; OracleParameter oracleParameter3 = new OracleParameter(":IsMain", OracleDbType.Int32); oracleParameter3.Value = (object)model.IsMain; oracleParameterArray[index3] = oracleParameter3; int index4 = 3; OracleParameter oracleParameter4 = new OracleParameter(":Sort", OracleDbType.Int32); oracleParameter4.Value = (object)model.Sort; oracleParameterArray[index4] = oracleParameter4; OracleParameter[] parameter = oracleParameterArray; return(this.dbHelper.Execute(sql, parameter)); }
protected void Page_Load(object sender, EventArgs e) { this.Account.Attributes.Add("validate_url", "CheckAccount.ashx"); RoadFlow.Platform.Organize borganize = new RoadFlow.Platform.Organize(); RoadFlow.Platform.Users busers = new RoadFlow.Platform.Users(); string id = Request.QueryString["id"]; string name = string.Empty; string account = string.Empty; string status = string.Empty; string note = string.Empty; Guid parentID; if (IsPostBack && id.IsGuid(out parentID)) { name = Request.Form["Name"]; account = Request.Form["Account"]; status = Request.Form["Status"]; note = Request.Form["Note"]; Guid userID = Guid.NewGuid(); string userXML = string.Empty; using (System.Transactions.TransactionScope scope = new System.Transactions.TransactionScope()) { //添加人员 RoadFlow.Data.Model.Users user = new RoadFlow.Data.Model.Users(); user.Account = account.Trim(); user.Name = name.Trim(); user.Note = note.IsNullOrEmpty() ? null : note; user.Password = busers.GetUserEncryptionPassword(userID.ToString(), busers.GetInitPassword()); user.Sort = 1; user.Status = status.IsInt() ? status.ToInt() : 0; user.ID = userID; busers.Add(user); //添加关系 RoadFlow.Data.Model.UsersRelation userRelation = new RoadFlow.Data.Model.UsersRelation(); userRelation.IsMain = 1; userRelation.OrganizeID = parentID; userRelation.Sort = new RoadFlow.Platform.UsersRelation().GetMaxSort(parentID); userRelation.UserID = userID; new RoadFlow.Platform.UsersRelation().Add(userRelation); //更新父级[ChildsLength]字段 borganize.UpdateChildsLength(parentID); //更新角色 new RoadFlow.Platform.UsersRole().UpdateByUserID(userID); userXML = user.Serialize(); scope.Complete(); } RoadFlow.Platform.Log.Add("添加了人员", userXML, RoadFlow.Platform.Log.Types.组织机构); Page.ClientScript.RegisterStartupScript(Page.GetType(), "ok", "alert('添加成功!');parent.frames[0].reLoad('" + id + "');window.location=window.location;", true); } this.StatusRadios.Text = borganize.GetStatusRadio("Status", "0", "validate=\"radio\""); }
public ActionResult UserAdd(FormCollection collection) { RoadFlow.Platform.Organize borganize = new RoadFlow.Platform.Organize(); RoadFlow.Platform.Users busers = new RoadFlow.Platform.Users(); string id = Request.QueryString["id"]; string name = string.Empty; string account = string.Empty; string status = string.Empty; string note = string.Empty; Guid parentID; if (collection != null && id.IsGuid(out parentID)) { name = Request.Form["Name"]; account = Request.Form["Account"]; status = Request.Form["Status"]; note = Request.Form["Note"]; Guid userID = Guid.NewGuid(); string userXML = string.Empty; using (System.Transactions.TransactionScope scope = new System.Transactions.TransactionScope()) { //添加人员 RoadFlow.Data.Model.Users user = new RoadFlow.Data.Model.Users(); user.Account = account.Trim(); user.Name = name.Trim(); user.Note = note.IsNullOrEmpty() ? null : note; user.Password = busers.GetUserEncryptionPassword(userID.ToString(), busers.GetInitPassword()); user.Sort = 1; user.Status = status.IsInt() ? status.ToInt() : 0; user.ID = userID; busers.Add(user); //添加关系 RoadFlow.Data.Model.UsersRelation userRelation = new RoadFlow.Data.Model.UsersRelation(); userRelation.IsMain = 1; userRelation.OrganizeID = parentID; userRelation.Sort = new RoadFlow.Platform.UsersRelation().GetMaxSort(parentID); userRelation.UserID = userID; new RoadFlow.Platform.UsersRelation().Add(userRelation); //更新父级[ChildsLength]字段 borganize.UpdateChildsLength(parentID); //更新角色 new RoadFlow.Platform.UsersRole().UpdateByUserID(userID); userXML = user.Serialize(); scope.Complete(); } RoadFlow.Platform.Log.Add("添加了人员", userXML, RoadFlow.Platform.Log.Types.组织机构); ViewBag.Script = "alert('添加成功!');parent.frames[0].reLoad('" + id + "');window.location=window.location;"; } ViewBag.StatusRadios = borganize.GetStatusRadio("Status", "0", "validate=\"radio\""); return(View()); }
/// <summary> /// 将DataRedar转换为List /// </summary> private List <RoadFlow.Data.Model.UsersRelation> DataReaderToList(OracleDataReader dataReader) { List <RoadFlow.Data.Model.UsersRelation> List = new List <RoadFlow.Data.Model.UsersRelation>(); RoadFlow.Data.Model.UsersRelation model = null; while (dataReader.Read()) { model = new RoadFlow.Data.Model.UsersRelation(); model.UserID = dataReader.GetString(0).ToGuid(); model.OrganizeID = dataReader.GetString(1).ToGuid(); model.IsMain = dataReader.GetInt32(2); model.Sort = dataReader.GetInt32(3); List.Add(model); } return(List); }
public ActionResult User(FormCollection collection) { RoadFlow.Platform.Organize borganize = new RoadFlow.Platform.Organize(); RoadFlow.Platform.Users busers = new RoadFlow.Platform.Users(); RoadFlow.Platform.UsersRelation buserRelation = new RoadFlow.Platform.UsersRelation(); RoadFlow.Data.Model.Users user = null; RoadFlow.Data.Model.Organize organize = null; string id = Request.QueryString["id"]; string parentID = Request.QueryString["parentid"]; string name = string.Empty; string account = string.Empty; string status = string.Empty; string note = string.Empty; string parentString = string.Empty; Guid userID, organizeID; if (id.IsGuid(out userID)) { user = busers.Get(userID); if (user != null) { name = user.Name; account = user.Account; status = user.Status.ToString(); note = user.Note; //所在组织字符串 System.Text.StringBuilder sb = new System.Text.StringBuilder(); var userRelations = buserRelation.GetAllByUserID(user.ID).OrderByDescending(p => p.IsMain); foreach (var userRelation in userRelations) { sb.Append("<div style='margin:3px 0;'>"); sb.Append(borganize.GetAllParentNames(userRelation.OrganizeID, true)); if (userRelation.IsMain == 0) { sb.Append("<span style='color:#999'> [兼职]</span>"); } sb.Append("</div>"); } ViewBag.ParentString = sb.ToString(); var roles = new RoadFlow.Platform.UsersRole().GetByUserIDFromCache(userID); RoadFlow.Platform.Role brole = new RoadFlow.Platform.Role(); System.Text.StringBuilder rolesb = new System.Text.StringBuilder(); foreach (var role in roles) { var role1 = brole.Get(role.RoleID); if (role1 == null) { continue; } rolesb.Append(role1.Name); rolesb.Append(","); } ViewBag.RoleString = rolesb.ToString().TrimEnd(','); } } if (parentID.IsGuid(out organizeID)) { organize = borganize.Get(organizeID); } if (collection != null) { //保存 if (!Request.Form["Save"].IsNullOrEmpty() && user != null) { name = Request.Form["Name"]; account = Request.Form["Account"]; status = Request.Form["Status"]; note = Request.Form["Note"]; string oldXML = user.Serialize(); user.Name = name.Trim(); user.Account = account.Trim(); user.Status = status.ToInt(1); user.Note = note.IsNullOrEmpty() ? null : note.Trim(); busers.Update(user); RoadFlow.Platform.Log.Add("修改了用户", "", RoadFlow.Platform.Log.Types.组织机构, oldXML, user.Serialize()); ViewBag.Script = "alert('保存成功!');parent.frames[0].reLoad('" + parentID + "');"; } //删除用户 if (!Request.Form["DeleteBut"].IsNullOrEmpty() && user != null && organize != null) { using (System.Transactions.TransactionScope scope = new System.Transactions.TransactionScope()) { var urs = buserRelation.GetAllByUserID(user.ID); busers.Delete(user.ID); buserRelation.DeleteByUserID(user.ID); new RoadFlow.Platform.UsersInfo().Delete(user.ID); new RoadFlow.Platform.UsersRole().DeleteByUserID(user.ID); //更新父级[ChildsLength]字段 foreach (var ur in urs) { borganize.UpdateChildsLength(ur.OrganizeID); } scope.Complete(); } string refreshID = parentID; string url = string.Empty; var users = borganize.GetAllUsers(refreshID.ToGuid()); if (users.Count > 0) { url = "User?id=" + users.Last().ID + "&appid=" + Request.QueryString["appid"] + "&tabid=" + Request.QueryString["tabid"] + "&parentid=" + parentID; } else { refreshID = organize.ParentID == Guid.Empty ? organize.ID.ToString() : organize.ParentID.ToString(); url = "Body?id=" + parentID + "&appid=" + Request.QueryString["appid"] + "&tabid=" + Request.QueryString["tabid"] + "&parentid=" + organize.ParentID; } RoadFlow.Platform.Log.Add("删除了用户", user.Serialize(), RoadFlow.Platform.Log.Types.组织机构); ViewBag.Script = "alert('删除成功');parent.frames[0].reLoad('" + refreshID + "');window.location='" + url + "'"; new RoadFlow.Platform.AppLibrary().ClearUseMemberCache(); } //初始化密码 if (!Request.Form["InitPass"].IsNullOrEmpty() && user != null) { string initpass = busers.GetInitPassword(); busers.InitPassword(user.ID); RoadFlow.Platform.Log.Add("初始化了用户密码", user.Serialize(), RoadFlow.Platform.Log.Types.组织机构); ViewBag.Script = "alert('密码已初始化为:" + initpass + "');"; } //调动 if (!Request.Form["Move1"].IsNullOrEmpty() && user != null) { string moveto = Request.Form["movetostation"]; string movetostationjz = Request.Form["movetostationjz"]; Guid moveToID; if (moveto.IsGuid(out moveToID)) { using (System.Transactions.TransactionScope scope = new System.Transactions.TransactionScope()) { var us = buserRelation.GetAllByUserID(user.ID); if ("1" != movetostationjz) { buserRelation.DeleteByUserID(user.ID); } RoadFlow.Data.Model.UsersRelation ur = new RoadFlow.Data.Model.UsersRelation(); ur.UserID = user.ID; ur.OrganizeID = moveToID; ur.IsMain = "1" == movetostationjz ? 0 : 1; ur.Sort = buserRelation.GetMaxSort(moveToID); buserRelation.Add(ur); foreach (var u in us) { borganize.UpdateChildsLength(u.OrganizeID); } borganize.UpdateChildsLength(organizeID); borganize.UpdateChildsLength(moveToID); scope.Complete(); ViewBag.Script = "alert('调动成功!');parent.frames[0].reLoad('" + parentID + "');parent.frames[0].reLoad('" + moveto + "')"; } RoadFlow.Platform.Log.Add(("1" == movetostationjz ? "兼职" : "全职") + "调动了人员的岗位", "将人员调往岗位(" + moveto + ")", RoadFlow.Platform.Log.Types.组织机构); new RoadFlow.Platform.AppLibrary().ClearUseMemberCache(); } } } ViewBag.StatusRadios = borganize.GetStatusRadio("Status", status, "validate=\"radio\""); return(View(user)); }
/// <summary> /// 更新 /// </summary> public int Update(RoadFlow.Data.Model.UsersRelation model) { return(dataUsersRelation.Update(model)); }
/// <summary> /// 新增 /// </summary> public int Add(RoadFlow.Data.Model.UsersRelation model) { return(dataUsersRelation.Add(model)); }