/// <summary>
/// 添加
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Add(PEST_CONSULREPLY_Model m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("INSERT INTO PEST_CONSULREPLY( PEST_CONSULTATIONID, REPLYUID, REPLYTIME, REPLYCONTENT)");
sb.AppendFormat(" OUTPUT INSERTED.PEST_CONSULREPLYID");
sb.AppendFormat(" VALUES(");
sb.AppendFormat(" {0}", ClsSql.saveNullField(m.PEST_CONSULTATIONID));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.REPLYUID));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.REPLYTIME));
sb.AppendFormat(",{0}", ClsSql.saveNullField(m.REPLYCONTENT));
sb.AppendFormat(")");
try
{
string sId = DataBaseClass.ReturnSqlField(sb.ToString());
if (sId != "")
{
return(new Message(true, "添加成功!", sId));
}
else
{
return(new Message(false, "添加失败!", ""));
}
}
catch
{
return(new Message(false, "添加失败!", ""));
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="m">参见模型</param>
/// <returns>参见模型</returns>
public static Message Del(PEST_CONSULREPLY_Model m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("delete PEST_CONSULREPLY");
sb.AppendFormat(" where PEST_CONSULREPLYID= '{0}'", ClsSql.EncodeSql(m.PEST_CONSULREPLYID));
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(PEST_CONSULREPLY_Model m)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat("UPDATE PEST_CONSULREPLY SET ");
sb.AppendFormat(" PEST_CONSULTATIONID={0}", ClsSql.saveNullField(m.PEST_CONSULTATIONID));
sb.AppendFormat(",REPLYUID={0}", ClsSql.saveNullField(m.REPLYUID));
sb.AppendFormat(",REPLYTIME={0}", ClsSql.saveNullField(m.REPLYTIME));
sb.AppendFormat(",REPLYCONTENT={0}", ClsSql.saveNullField(m.REPLYCONTENT));
sb.AppendFormat(" WHERE PEST_CONSULREPLYID= '{0}'", ClsSql.EncodeSql(m.PEST_CONSULREPLYID));
bool bln = DataBaseClass.ExeSql(sb.ToString());
if (bln == true)
{
return(new Message(true, "修改成功!", m.PEST_CONSULREPLYID));
}
else
{
return(new Message(false, "修改失败!", ""));
}
}
