/// <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, "修改失败!", "")); } }