/// <summary> /// 向数据库中添加一条记录 /// </summary> /// <param name="model">要添加的实体</param> /// <returns>插入数据的ID</returns> public int Insert(MPrintMain model) { #region SQL语句 const string sql = @" INSERT INTO [T_PrintMain] ( [UUID] ,[TemplateName] ,[BackImage] ,[TemplateType] ) VALUES ( @UUID ,@TemplateName ,@BackImage ,@TemplateType );"; #endregion var res = SqlHelper.ExecuteScalar(CommandType.Text, sql, new SQLiteParameter("@UUID", SqlHelper.ToNullDBValue(model.UUID)), new SQLiteParameter("@TemplateName", SqlHelper.ToNullDBValue(model.TemplateName)), new SQLiteParameter("@BackImage", SqlHelper.ToNullDBValue(model.BackImage)), new SQLiteParameter("@TemplateType", SqlHelper.ToNullDBValue(model.TemplateType)) ); return(res == null ? 0 : Convert.ToInt32(res)); }
/// <summary> /// 根据主键ID更新一条记录 /// </summary> /// <param name="model">更新后的实体</param> /// <returns>执行结果受影响行数</returns> public int Update(MPrintMain model) { #region SQL语句 const string sql = @" UPDATE [T_PrintMain] SET [UUID] = @UUID ,[TemplateName] = @TemplateName ,[BackImage] = @BackImage ,[TemplateType] = @TemplateType WHERE [UUID] = @UUID"; #endregion return(SqlHelper.ExecuteNonQuery(CommandType.Text, sql, new SQLiteParameter("@UUID", SqlHelper.ToNullDBValue(model.UUID)), new SQLiteParameter("@TemplateName", SqlHelper.ToNullDBValue(model.TemplateName)), new SQLiteParameter("@BackImage", SqlHelper.ToNullDBValue(model.BackImage)), new SQLiteParameter("@TemplateType", SqlHelper.ToNullDBValue(model.TemplateType)) )); }
/// <summary> /// 根据主键ID更新一条记录 /// </summary> /// <param name="model">更新后的实体</param> /// <returns>执行结果受影响行数</returns> public int Update(MPrintMain model) { return(_dao.Update(model)); }
/// <summary> /// 向数据库中添加一条记录 /// </summary> /// <param name="model">要添加的实体</param> /// <returns>插入数据的ID</returns> public int Insert(MPrintMain model) { return(_dao.Insert(model)); }