Exemple #1
0
 /// <summary>
 /// 向数据库中添加一条记录
 /// </summary>
 /// <param name="model">要添加的实体</param>
 /// <returns>插入数据的ID</returns>
 public int Insert(GagModel model)
 {
     #region SQL语句
     const string sql = @"
     INSERT INTO [dbo].[Gag] (
     [UId]
     ,[GagDate]
     )
     VALUES (
     @UId
     ,@GagDate
     );select @@IDENTITY";
     #endregion
     var res = SqlHelper.ExecuteScalar(sql,
             new SqlParameter("@UId", model.UId),
             new SqlParameter("@GagDate", model.GagDate)
         );
     return res == null ? 0 : Convert.ToInt32(res);
 }
Exemple #2
0
 /// <summary>
 /// 根据主键ID更新一条记录
 /// </summary>
 /// <param name="model">更新后的实体</param>
 /// <returns>执行结果受影响行数</returns>
 public int Update(GagModel model)
 {
     return _dao.Update(model);
 }
Exemple #3
0
 /// <summary>
 /// 根据主键ID更新一条记录
 /// </summary>
 /// <param name="model">更新后的实体</param>
 /// <returns>执行结果受影响行数</returns>
 public int Update(GagModel model)
 {
     #region SQL语句
     const string sql = @"
     UPDATE [dbo].[Gag]
     SET
     [UId] = @UId
     ,[GagDate] = @GagDate
     WHERE [GId] = @GId";
     #endregion
     return SqlHelper.ExecuteNonQuery(sql,
             new SqlParameter("@GId", model.GId),
             new SqlParameter("@UId", model.UId),
             new SqlParameter("@GagDate", model.GagDate)
         );
 }
Exemple #4
0
 /// <summary>
 /// 向数据库中添加一条记录
 /// </summary>
 /// <param name="model">要添加的实体</param>
 /// <returns>插入数据的ID</returns>
 public int Insert(GagModel model)
 {
     return _dao.Insert(model);
 }