/// <summary>
///
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int InsertRolePowerDetail(RolePowerDetail info)
{
string strSql = "";
if (this.Sql.GetSql("Manager.RolePowerDetails.InsertRolePowerDetail", ref strSql) == -1)
{
return(-1);
}
try
{
strSql = string.Format(strSql, info.RoleCode, info.Class2Code, info.Class2Name, info.Class3Code, info.Class3Name, this.Operator.ID, this.Operator.Name, info.Mark);
}
catch (Exception ex)
{
this.Err = ex.Message;
this.ErrCode = ex.Message;
return(-1);
}
return(this.ExecNoQuery(strSql));
}
public ArrayList SelectDetails(string roleCode)
{
string sql = PrepareSQL("Manager.RolePowerDetails.LoadDetailByRoleCode", new string[] { roleCode });
if (sql == string.Empty)
{
return(null);
}
ArrayList details = new ArrayList();
try
{
this.ExecQuery(sql);
while (this.Reader.Read())
{
RolePowerDetail detail = new RolePowerDetail();
detail.PkID = this.Reader[0].ToString();
detail.RoleCode = this.Reader[1].ToString();
detail.Class2Code = this.Reader[2].ToString();
detail.Class2Name = this.Reader[3].ToString();
detail.Class3Code = this.Reader[4].ToString();
detail.Class3Name = this.Reader[5].ToString();
detail.Mark = this.Reader[6].ToString();
detail.ID = detail.PkID;
details.Add(detail);
}
}
catch (Exception ex)
{
this.ErrCode = ex.Message;
this.Err = ex.Message;
details.Clear();
}
return(details);
}
/// <summary>
///
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int DeleteRolePowerDetail(RolePowerDetail info)
{
return(DeleteRolePowerDetail(info.PkID));
}
