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