internal static int SetImage(Image image) { if (image == null) { return(-1); } SafeProcedure.ExecuteNonQuery( Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.Image_Set", delegate(IParameterSet parameters) { parameters.AddWithValue("@ImageId", image.ImageId); parameters.AddWithValue("@AlbumId", image.AlbumId); parameters.AddWithValue("@ImageName", image.ImageName); parameters.AddWithValue("@ImageFile", image.ImageFile); parameters.AddWithValue("@SImageFile", image.SImageFile); parameters.AddWithValue("@AddUserId", image.AddUserID); parameters.AddWithValue("@PublishDate", image.PublishDate); parameters.AddWithValue("@Status", (int)(image.Status)); parameters.AddWithValue("@RetVal", DBNull.Value, ParameterDirectionWrap.ReturnValue); }, delegate(IParameterSet outputParameters) { image.ImageId = Convert.ToInt32(outputParameters.GetValue("@RetVal")); }); return(image.ImageId); }
internal static int SetAlbum(Album album) { if (album == null) { return(-1); } SafeProcedure.ExecuteNonQuery( Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.Album_Set", delegate(IParameterSet parameters) { parameters.AddWithValue("@AlbumId", album.AlbumId); parameters.AddWithValue("@Title", album.Title); parameters.AddWithValue("@SImage", album.SImage); parameters.AddWithValue("@LImage", album.LImage); parameters.AddWithValue("@BandId", album.BandId); parameters.AddWithValue("@PublishDate", album.PublishDate); parameters.AddWithValue("@PublishYear", album.PublishYear); parameters.AddWithValue("@PublishMonth", album.PublishMonth); parameters.AddWithValue("@AddUserId", album.AddUserID); parameters.AddWithValue("@Status", (int)(album.Status)); parameters.AddWithValue("@TotalCount", album.TotalCount); parameters.AddWithValue("@RetVal", DBNull.Value, ParameterDirectionWrap.ReturnValue); }, delegate(IParameterSet outputParameters) { album.AlbumId = Convert.ToInt32(outputParameters.GetValue("@RetVal")); }); return(album.AlbumId); }
internal static int SetShopRegion(ShopRegion item) { if (item == null) { return(-1); } SafeProcedure.ExecuteNonQuery( Database.GetDatabase(JaneDefine.DBInstanceName), "dbo.Shop_region_Set", delegate(IParameterSet parameters) { parameters.AddWithValue("@id", item.Id); parameters.AddWithValue("@Name", item.Name); parameters.AddWithValue("@ParentId", item.ParentId); parameters.AddWithValue("@TransferPrice", item.TransferPrice); parameters.AddWithValue("@TransferPrice1", item.TransferPrice1); parameters.AddWithValue("@TransferPrice2", item.TransferPrice2); parameters.AddWithValue("@RetVal", DBNull.Value, ParameterDirectionWrap.ReturnValue); }, delegate(IParameterSet outputParameters) { item.Id = Convert.ToInt32(outputParameters.GetValue("@RetVal")); }); return(item.Id); }
internal static int Insert(MessageInfo info) { var db = Database.GetDatabase(DatabaseName.AppConnect); int id = 0; SafeProcedure.ExecuteNonQuery(db, "dbo.Message_Insert", parameterMapper => { parameterMapper.AddWithValue("@BatchId", info.BatchId); parameterMapper.AddWithValue("@TenantId", info.TenantId); parameterMapper.AddWithValue("@FromUser", info.FromUser); parameterMapper.AddWithValue("@ToUser", info.ToUser); parameterMapper.AddWithValue("@ToOpenId", info.ToOpenId); parameterMapper.AddWithValue("@AppAccountId", info.AppAccountId); parameterMapper.AddWithValue("@TemplateIdShort", info.TemplateIdShort); parameterMapper.AddWithValue("@TemplateId", info.TemplateId); parameterMapper.AddWithValue("@Content", info.ContentJson); parameterMapper.AddWithValue("@State", (short)info.State); parameterMapper.AddWithValue("@MessageId", info.MessageId); parameterMapper.AddWithValue("@Result", info.Result); parameterMapper.AddTypedDbNull("@Id", ParameterDirectionWrap.Output, DbType.Int32); }, o => { id = (int)o.GetValue("@Id"); }); return(id); }
internal static int SetBandInfo(BandInfo info) { if (info == null) { return(-1); } SafeProcedure.ExecuteNonQuery( Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.BandInfo_Set", delegate(IParameterSet parameters) { parameters.AddWithValue("@BandId", info.BandId); parameters.AddWithValue("@BandName", info.BandName); parameters.AddWithValue("@Info1", info.Info1); parameters.AddWithValue("@Info2", info.Info2); parameters.AddWithValue("@Info3", info.Info3); parameters.AddWithValue("@Remark", info.Remark); parameters.AddWithValue("@DeleteFlag", info.DeleteFlag); parameters.AddWithValue("@RetVal", DBNull.Value, ParameterDirectionWrap.ReturnValue); }, delegate(IParameterSet outputParameters) { info.BandId = Convert.ToInt32(outputParameters.GetValue("@RetVal")); }); return(info.BandId); }
/// <summary> /// 增加开放平台帐号信息 /// </summary> /// <param name="info"></param> internal static int Insert(AppAccountInfo info) { var db = Database.GetDatabase(DatabaseName.AppConnect); int id = 0; SafeProcedure.ExecuteNonQuery(db, "dbo.AppAccount_Insert", parameterMapper => { parameterMapper.AddWithValue("@AppAccountId", info.AppAccountId); parameterMapper.AddWithValue("@TenantId", info.TenantId); parameterMapper.AddWithValue("@Name", info.Name); parameterMapper.AddWithValue("@Type", info.Type); parameterMapper.AddWithValue("@SourceId", info.SourceId); parameterMapper.AddWithValue("@AppId", info.AppId); parameterMapper.AddWithValue("@AppSecret", info.AppSecret); parameterMapper.AddWithValue("@AgentId", info.AgentId); parameterMapper.AddWithValue("@State", (short)info.State); parameterMapper.AddWithValue("@Tag", info.Tag); parameterMapper.AddWithValue("@UserId", info.CreateBy); parameterMapper.AddTypedDbNull("@Id", ParameterDirectionWrap.Output, DbType.Int32); }, o => { id = (int)o.GetValue("@Id"); }); return(id); }
internal static int SetShopItem(ShopItem item) { if (item == null) { return(-1); } SafeProcedure.ExecuteNonQuery( Database.GetDatabase(JaneDefine.DBInstanceName), "dbo.Shop_items_Set", delegate(IParameterSet parameters) { parameters.AddWithValue("@Id", item.Id); parameters.AddWithValue("@name", item.Name); parameters.AddWithValue("@description", item.Description); parameters.AddWithValue("@body", item.Body); parameters.AddWithValue("@price", item.Price); parameters.AddWithValue("@SImage", item.SImage); parameters.AddWithValue("@LImage", item.LImage); parameters.AddWithValue("@PublishDate", item.PublishDate); parameters.AddWithValue("@AddUserId", item.AddUserID); parameters.AddWithValue("@Status", (int)(item.Status)); parameters.AddWithValue("@Hits", (int)(item.Hits)); parameters.AddWithValue("@BaseCountEachdeliver", (int)(item.BaseCountEachdeliver)); parameters.AddWithValue("@Weight", item.Weight); parameters.AddWithValue("@RetVal", DBNull.Value, ParameterDirectionWrap.ReturnValue); }, delegate(IParameterSet outputParameters) { item.Id = Convert.ToInt32(outputParameters.GetValue("@RetVal")); }); return(item.Id); }
internal static int SetSpamKeyword(SpamKeyword keyword) { if (keyword == null) { return(-1); } SafeProcedure.ExecuteNonQuery( Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.SpamKeywords_Set", delegate(IParameterSet parameters) { parameters.AddWithValue("@Id", keyword.Id); parameters.AddWithValue("@Keyword", keyword.Keyword); parameters.AddWithValue("@Status", keyword.Status); parameters.AddWithValue("@AddUserId", keyword.AddUserID); parameters.AddWithValue("@RetVal", DBNull.Value, ParameterDirectionWrap.ReturnValue); }, delegate(IParameterSet outputParameters) { keyword.Id = Convert.ToInt32(outputParameters.GetValue("@RetVal")); }); return(keyword.Id); }
internal static void DeleteTagRelationByTagId(int tagId) { SafeProcedure.ExecuteNonQuery( Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.TagRelation_DeleteByTagId", tagId); }
internal static int SetMusicSongList(MusicSongList m) { if (m == null) { return(-1); } SafeProcedure.ExecuteNonQuery( Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.Music_SetMusicSongList", delegate(IParameterSet parameters) { parameters.AddWithValue("@ListId", m.ListId); parameters.AddWithValue("@MusicId", m.MusicId); parameters.AddWithValue("@SongName", m.SongName); parameters.AddWithValue("@SongFile", m.SongFile); parameters.AddWithValue("@SongTime", m.SongTime); parameters.AddWithValue("@AddUserId", m.AddUserID); parameters.AddWithValue("@Status", (int)(m.Status)); parameters.AddWithValue("@RetVal", DBNull.Value, ParameterDirectionWrap.ReturnValue); }, delegate(IParameterSet outputParameters) { m.ListId = Convert.ToInt32(outputParameters.GetValue("@RetVal")); }); return(m.ListId); }
internal static void DeleteTagRelationByObject(int objectId, int objectType) { SafeProcedure.ExecuteNonQuery( Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.TagRelation_DeleteByObject", objectId, objectType); }
internal static int SetShopTradelist(ShopTradelist item) { if (item == null) { return(-1); } SafeProcedure.ExecuteNonQuery( Database.GetDatabase(JaneDefine.DBInstanceName), "dbo.Shop_tradelist_Set", delegate(IParameterSet parameters) { parameters.AddWithValue("@Id", item.Id); parameters.AddWithValue("@orderid", item.OrderId); parameters.AddWithValue("@itemid", item.ItemId); parameters.AddWithValue("@itemcount", item.ItemCount); parameters.AddWithValue("@RetVal", DBNull.Value, ParameterDirectionWrap.ReturnValue); }, delegate(IParameterSet outputParameters) { item.Id = Convert.ToInt32(outputParameters.GetValue("@RetVal")); }); return(item.Id); }
internal static int SetMusicTitle(MusicTitle m) { if (m == null) { return(-1); } SafeProcedure.ExecuteNonQuery( Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.Music_SetMusicTitle", delegate(IParameterSet parameters) { parameters.AddWithValue("@MusicId", m.MusicId); parameters.AddWithValue("@Title", m.Title); parameters.AddWithValue("@Body", m.Body); parameters.AddWithValue("@SImage", m.SImage); parameters.AddWithValue("@LImage", m.LImage); parameters.AddWithValue("@BandId", m.BandId); parameters.AddWithValue("@PublishDate", m.PublishDate); parameters.AddWithValue("@PublishYear", m.PublishYear); parameters.AddWithValue("@AddUserId", m.AddUserID); parameters.AddWithValue("@Status", (int)(m.Status)); parameters.AddWithValue("@RetVal", DBNull.Value, ParameterDirectionWrap.ReturnValue); }, delegate(IParameterSet outputParameters) { m.MusicId = Convert.ToInt32(outputParameters.GetValue("@RetVal")); }); return(m.MusicId); }
internal static int SetNews(News m) { if (m == null) { return(-1); } SafeProcedure.ExecuteNonQuery( Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.News_Set", delegate(IParameterSet parameters) { parameters.AddWithValue("@NewsId", m.NewsId); parameters.AddWithValue("@Title", m.Title); parameters.AddWithValue("@Body", m.Body); parameters.AddWithValue("@Preview", m.Preview); parameters.AddWithValue("@SImage", m.SImage); parameters.AddWithValue("@LImage", m.LImage); parameters.AddWithValue("@NewsType", m.NewsType); parameters.AddWithValue("@Hits", m.Hits); parameters.AddWithValue("@PublishDate", m.PublishDate); parameters.AddWithValue("@AddUserId", m.AddUserID); parameters.AddWithValue("@Status", (int)(m.Status)); parameters.AddWithValue("@Remark", m.Remark); parameters.AddWithValue("@RetVal", DBNull.Value, ParameterDirectionWrap.ReturnValue); }, delegate(IParameterSet outputParameters) { m.NewsId = Convert.ToInt32(outputParameters.GetValue("@RetVal")); }); return(m.NewsId); }
internal static int InsertComment(Comment comment) { if (comment == null) { return(-1); } SafeProcedure.ExecuteNonQuery( Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.Comment_Insert", delegate(IParameterSet parameters) { parameters.AddWithValue("@ObjectId", comment.ObjectId); parameters.AddWithValue("@ObjectType", (int)(comment.ObjectType)); parameters.AddWithValue("@UserId", comment.UserId); parameters.AddWithValue("@UserName", comment.UserName); parameters.AddWithValue("@AddDate", comment.AddDate); parameters.AddWithValue("@Body", comment.Body); parameters.AddWithValue("@Remark", comment.Remark); parameters.AddWithValue("@Status", (int)(comment.Status)); parameters.AddWithValue("@RetVal", DBNull.Value, ParameterDirectionWrap.ReturnValue); }, delegate(IParameterSet outputParameters) { comment.CommentId = Convert.ToInt32(outputParameters.GetValue("@RetVal")); }); return(comment.CommentId); }
internal static void DeleteAddInfo(int objectId, int objectType) { SafeProcedure.ExecuteNonQuery( Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.Add_infos_Delete", objectType, objectId); }
internal static void DeleteMusicTitle(int musicId) { if (musicId > 0) { SafeProcedure.ExecuteNonQuery( Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.Music_DeleteMusicTitle", musicId); } }
internal static void DeleteMusicSongList(int listId) { if (listId > 0) { SafeProcedure.ExecuteNonQuery( Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.Music_DeleteSongList", listId); } }
internal static void DeleteKeyword(int id) { if (id > 0) { SafeProcedure.ExecuteNonQuery( Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.SpamKeywords_Delete", id); } }
internal static void DeleteCommentByObject(int objectId, int objectType) { if (objectId > 0) { SafeProcedure.ExecuteNonQuery( Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.Comment_DeleteByObject", objectId, objectType); } }
internal static void DeleteComment(int commentId) { if (commentId > 0) { SafeProcedure.ExecuteNonQuery( Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.Comment_Delete", commentId); } }
internal static void DeleteShopTradelistByOrderId(int orderid) { if (orderid > 0) { SafeProcedure.ExecuteNonQuery( Database.GetDatabase(JaneDefine.DBInstanceName), "dbo.Shop_tradelist_Deletebyorderid", orderid); } }
/// <summary> /// 删除tag /// </summary> /// <param name="tagId"></param> internal static void DeleteTag(int tagId) { if (tagId > 0) { SafeProcedure.ExecuteNonQuery( Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.Tags_DeleteTag", tagId); } }
internal static void Delete(int userId, int id) { var db = Database.GetDatabase(DatabaseName.AppConnect); SafeProcedure.ExecuteNonQuery(db, "dbo.TemplateMapping_Delete", parameterMapper => { parameterMapper.AddWithValue("@Id", id); parameterMapper.AddWithValue("@UserId", userId); }); }
/// <summary> /// 用户解绑 /// </summary> /// <param name="appId"></param> /// <param name="openId"></param> internal static void UnBind(string appId, string openId) { var db = Database.GetDatabase(DatabaseName.UserSecurity); SafeProcedure.ExecuteNonQuery(db, "dbo.AppUserAccount_UnBind", parameterMapper => { parameterMapper.AddWithValue("@AppId", appId); parameterMapper.AddWithValue("@OpenId", openId); }); }
internal static void DeleteUserLogin(int userId) { if (userId > 0) { SafeProcedure.ExecuteNonQuery( Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.UserLogin_Delete", userId); } }
/// <summary> /// 更新状态 /// </summary> /// <param name="batchId"></param> /// <param name="state"></param> public static void UpdateState(string batchId, CallbackContentState state) { var db = Database.GetDatabase(DatabaseName.AppConnect); SafeProcedure.ExecuteNonQuery(db, "dbo.CallbackContent_UpdateState", parameterMapper => { parameterMapper.AddWithValue("@BatchId", new Guid(batchId)); parameterMapper.AddWithValue("@State", (short)state); }); }
/// <summary> /// 更新主账户ID /// </summary> /// <param name="id"></param> /// <param name="masterAccountId"></param> internal static void UpdateMasterAccountId(int id, int masterAccountId) { var db = Database.GetDatabase(DatabaseName.UserSecurity); SafeProcedure.ExecuteNonQuery(db, "dbo.AppUserAccount_UpdateMasterAccountId", parameterMapper => { parameterMapper.AddWithValue("@Id", id); parameterMapper.AddWithValue("@MasterAccountId", masterAccountId); }); }
internal static void DeleteShopItem(int id) { if (id > 0) { SafeProcedure.ExecuteNonQuery( Database.GetDatabase(JaneDefine.DBInstanceName), "dbo.Shop_items__Delete", id); } }
internal static void DeleteAlbum(int albumId) { if (albumId > 0) { SafeProcedure.ExecuteNonQuery( Database.GetDatabase(D4DDefine.DBInstanceName), "dbo.Album_Delete", albumId); } }