/// <summary>
/// 添加
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Add(T_SYSSEC_ROLE_Model m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("INSERT INTO T_SYSSEC_ROLE(ROLENAME, ROLENOTE, SYSFLAG,ROLELEVEL, ORDERBY)");
sb.AppendFormat("VALUES(");
sb.AppendFormat("'{0}'", ClsSql.EncodeSql(m.ROLENAME));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.ROLENOTE));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.SYSFLAG));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.ROLELEVEL));
sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.ORDERBY));
sb.AppendFormat(")");
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "添加成功!", ""));
}
else
{
return(new Message(false, "添加失败，请检查各输入框是否正确!", ""));
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Mdy(T_SYSSEC_ROLE_Model m)
{
StringBuilder sb = new StringBuilder();
//(ORGNO,LOGINUSERNAME,USERNAME,USERPWD,REGISTERTIME,LOGINNUM,NOTE)
sb.AppendFormat("UPDATE T_SYSSEC_ROLE");
sb.AppendFormat(" set ");
sb.AppendFormat("ROLENAME='{0}'", ClsSql.EncodeSql(m.ROLENAME));
sb.AppendFormat(",ROLENOTE='{0}'", ClsSql.EncodeSql(m.ROLENOTE));
sb.AppendFormat(",ROLELEVEL='{0}'", ClsSql.EncodeSql(m.ROLELEVEL));
sb.AppendFormat(",ORDERBY='{0}'", ClsSql.EncodeSql(m.ORDERBY));
sb.AppendFormat(" where ROLEID= '{0}'", ClsSql.EncodeSql(m.ROLEID));
sb.AppendFormat(" and SYSFLAG= '{0}'", ClsSql.EncodeSql(m.SYSFLAG));
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "修改成功!", ""));
}
else
{
return(new Message(false, "修改失败，请检查各输入框是否正确!", ""));
}
}
