コード例 #1
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(MODEL.CommunicationLogModel model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into communicationlog(");
            strSql.Append("dataSize,data,InsertTime)");
            strSql.Append(" values (");
            strSql.Append("@dataSize,@data,@InsertTime)");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@dataSize",   MySqlDbType.Int32,      10),
                new MySqlParameter("@data",       MySqlDbType.VarBinary),
                new MySqlParameter("@InsertTime", MySqlDbType.DateTime)
            };
            parameters[0].Value = model.dataSize;
            parameters[1].Value = model.data;
            parameters[2].Value = model.InsertTime;

            return(Common.MySQLHelper.ExecuteNonQuery(strSql.ToString(), parameters) > 0 ? true : false);
        }
コード例 #2
0
 /// <summary>
 /// 添加一条通信记录(只记录异常数据包)
 /// </summary>
 /// <param name="model"></param>
 /// <returns></returns>
 public bool Add(MODEL.CommunicationLogModel model)
 {
     return(comm_dal.Add(model));
 }