public virtual int Update(UserUpdatePowerType uupt, UserUpdateIndex uui, DB_OPT dbo) { return this.Update(uupt, uui, dbo); }
public override int Update(UserUpdatePowerType uupt, UserUpdateIndex uui, DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append("update DB_Users set "); Hashtable ht = null; switch (uupt) { case UserUpdatePowerType.BranchAndRole: builder.Append("BranchPK='" + base.BranchPK + "',"); builder.Append("RolePK='" + base.RolePK + "',"); break; case UserUpdatePowerType.DataRowPower: builder.Append("Power=:Power,"); builder.Append("DataPower=:DataPower,"); builder.Append("RowPower=:RowPower,"); builder.Append("ServicesPower=:ServicesPower,"); builder.Append("CompanyPower=:CompanyPower,"); ht = new Hashtable(); ht.Add("Power", base.Power); ht.Add("DataPower", base.DataPower); ht.Add("RowPower", base.RowPower); ht.Add("ServicesPower", base.ServicesPower); ht.Add("CompanyPower", base.CompanyPower); break; case UserUpdatePowerType.All: builder.Append("BranchPK='" + base.BranchPK + "',"); builder.Append("RolePK='" + base.RolePK + "',"); builder.Append("Power=:Power,"); builder.Append("DataPower=:DataPower,"); builder.Append("RowPower=:RowPower,"); builder.Append("ServicesPower=:ServicesPower,"); builder.Append("CompanyPower=:CompanyPower,"); ht = new Hashtable(); ht.Add("Power", base.Power); ht.Add("DataPower", base.DataPower); ht.Add("RowPower", base.RowPower); ht.Add("ServicesPower", base.ServicesPower); ht.Add("CompanyPower", base.CompanyPower); break; } builder.Append("UserName='******',"); builder.Append("TrueName='" + base.TrueName + "',"); builder.Append("pk_corp='" + base.pk_corp + "',"); if (base.Password != "") { builder.Append("Password='******'"); } switch (uui) { case UserUpdateIndex.AllowEmployeePK: builder.Append(" where EmployeePK='" + base.EmployeePK + "'"); break; case UserUpdateIndex.AllowUserPK: builder.Append(" where UserPK='" + base.UserPK + "'"); break; } return dbo.ExecutionIsSucess(builder.ToString(), ht); }