public int Insert(AlbumContentInfo albumContentInfo) { var albumId = 0; IDataParameter[] parms = null; var sqlInsert = BaiRongDataProvider.TableStructureDao.GetInsertSqlString(albumContentInfo.ToNameValueCollection(), ConnectionString, TableName, out parms); using (var conn = GetConnection()) { conn.Open(); using (var trans = conn.BeginTransaction()) { try { albumId = ExecuteNonQueryAndReturnId(trans, sqlInsert, parms); trans.Commit(); } catch { trans.Rollback(); throw; } } } return(albumId); }
public override void Submit_OnClick(object sender, EventArgs e) { try { if (id == 0) { var albumContentInfo = new AlbumContentInfo(); albumContentInfo.PublishmentSystemID = PublishmentSystemId; albumContentInfo.AlbumID = albumID; albumContentInfo.ParentID = 0; albumContentInfo.Title = tbTitle.Text; albumContentInfo.LargeImageUrl = imageUrl.Value; DataProviderWX.AlbumContentDAO.Insert(albumContentInfo); } else { var albumContentInfo = DataProviderWX.AlbumContentDAO.GetAlbumContentInfo(id); albumContentInfo.Title = tbTitle.Text; albumContentInfo.LargeImageUrl = imageUrl.Value; DataProviderWX.AlbumContentDAO.Update(albumContentInfo); } PageUtils.CloseModalPage(Page); } catch (Exception ex) { FailMessage(ex, "失败:" + ex.Message); } }
public void Update(AlbumContentInfo albumContentInfo) { IDataParameter[] parms = null; var sqlUpdate = BaiRongDataProvider.TableStructureDao.GetUpdateSqlString(albumContentInfo.ToNameValueCollection(), ConnectionString, TableName, out parms); ExecuteNonQuery(sqlUpdate, parms); }
public int Insert(AlbumContentInfo albumContentInfo) { var albumID = 0; IDataParameter[] parms = null; var SQL_INSERT = BaiRongDataProvider.TableStructureDao.GetInsertSqlString(albumContentInfo.ToNameValueCollection(), ConnectionString, TABLE_NAME, out parms); using (var conn = GetConnection()) { conn.Open(); using (var trans = conn.BeginTransaction()) { try { ExecuteNonQuery(trans, SQL_INSERT, parms); albumID = BaiRongDataProvider.DatabaseDao.GetSequence(trans, TABLE_NAME); trans.Commit(); } catch { trans.Rollback(); throw; } } } return(albumID); }
public override void Submit_OnClick(object sender, EventArgs e) { if (Page.IsPostBack && Page.IsValid) { var albumContentIdList = new List <int>(); if (_parentId > 0) { albumContentIdList = DataProviderWx.AlbumContentDao.GetAlbumContentIdList(PublishmentSystemId, _albumId, _parentId); } var photoCount = TranslateUtils.ToInt(Request.Form["Photo_Count"]); if (photoCount > 0) { for (var index = 1; index <= photoCount; index++) { var id = TranslateUtils.ToInt(Request.Form["ID_" + index]); var smallUrl = Request.Form["SmallUrl_" + index]; var largeUrl = Request.Form["LargeUrl_" + index]; var title = Request.Form["imgTitle_" + index]; if (!string.IsNullOrEmpty(smallUrl) && !string.IsNullOrEmpty(largeUrl)) { if (id > 0) { var albumContentInfo = DataProviderWx.AlbumContentDao.GetAlbumContentInfo(id); if (albumContentInfo != null) { albumContentInfo.ImageUrl = smallUrl; albumContentInfo.LargeImageUrl = largeUrl; albumContentInfo.Title = title; DataProviderWx.AlbumContentDao.Update(albumContentInfo); } albumContentIdList.Remove(id); } else { var albumContentInfo = new AlbumContentInfo(); albumContentInfo.PublishmentSystemId = PublishmentSystemId; albumContentInfo.AlbumId = _albumId; albumContentInfo.ParentId = _parentId; albumContentInfo.ImageUrl = smallUrl; albumContentInfo.LargeImageUrl = largeUrl; albumContentInfo.Title = title; DataProviderWx.AlbumContentDao.Insert(albumContentInfo); } } } } if (albumContentIdList.Count > 0) { DataProviderWx.AlbumContentDao.Delete(PublishmentSystemId, albumContentIdList); } PageUtils.CloseModalPage(Page); } }
public AlbumContentInfo GetAlbumContentInfo(int albumContentId) { AlbumContentInfo albumContentInfo = null; string sqlWhere = $"WHERE ID = {albumContentId}"; var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, null); using (var rdr = ExecuteReader(sqlSelect)) { if (rdr.Read()) { albumContentInfo = new AlbumContentInfo(rdr); } rdr.Close(); } return(albumContentInfo); }
public AlbumContentInfo GetAlbumContentInfo(int albumContentID) { AlbumContentInfo albumContentInfo = null; string SQL_WHERE = $"WHERE ID = {albumContentID}"; var SQL_SELECT = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TABLE_NAME, 0, SqlUtils.Asterisk, SQL_WHERE, null); using (var rdr = ExecuteReader(SQL_SELECT)) { if (rdr.Read()) { albumContentInfo = new AlbumContentInfo(rdr); } rdr.Close(); } return(albumContentInfo); }
public List <AlbumContentInfo> GetAlbumContentInfoList(int publishmentSystemId) { var list = new List <AlbumContentInfo>(); string sqlWhere = $"WHERE {AlbumContentAttribute.PublishmentSystemId} = {publishmentSystemId}"; var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, null); using (var rdr = ExecuteReader(sqlSelect)) { while (rdr.Read()) { var albumContentInfo = new AlbumContentInfo(rdr); list.Add(albumContentInfo); } rdr.Close(); } return(list); }
public List <AlbumContentInfo> GetAlbumContentInfoList(int publishmentSystemID) { var list = new List <AlbumContentInfo>(); string SQL_WHERE = $"WHERE {AlbumContentAttribute.PublishmentSystemID} = {publishmentSystemID}"; var SQL_SELECT = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TABLE_NAME, 0, SqlUtils.Asterisk, SQL_WHERE, null); using (var rdr = ExecuteReader(SQL_SELECT)) { while (rdr.Read()) { var albumContentInfo = new AlbumContentInfo(rdr); list.Add(albumContentInfo); } rdr.Close(); } return(list); }