Exemple #1
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public void Add(tdps.Model.PrintHistory model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into PrintHistory(");
            strSql.Append("SbxxID,PrintUser,PrintTime,Items)");
            strSql.Append(" values (");
            strSql.Append("@SbxxID,@PrintUser,@PrintTime,@Items)");
            SQLiteParameter[] parameters =
            {
                new SQLiteParameter("@SbxxID",    DbType.Int32,   4),
                new SQLiteParameter("@PrintUser", DbType.String, 40),
                new SQLiteParameter("@PrintTime", DbType.String, 40),
                new SQLiteParameter("@Items",     DbType.String, 2)
            };
            parameters[0].Value = model.SbxxID;
            parameters[1].Value = model.PrintUser;
            parameters[2].Value = model.PrintTime;
            parameters[3].Value = model.Items;

            SQLiteHelper.ExecuteNonQuery(strSql.ToString(), parameters);
        }
Exemple #2
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public void Add(tdps.Model.PrintHistory model)
 {
     dal.Add(model);
 }