public int Insert(CollectItemInfo itemInfo)
{
var itemID = 0;
using (var conn = GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
IDataParameter[] parms = null;
var SQL_INSERT = BaiRongDataProvider.TableStructureDao.GetInsertSqlString(itemInfo.ToNameValueCollection(), ConnectionString, TABLE_NAME, out parms);
ExecuteNonQuery(trans, SQL_INSERT, parms);
itemID = BaiRongDataProvider.DatabaseDao.GetSequence(trans, TABLE_NAME);
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
return(itemID);
}
public int Insert(CollectItemInfo itemInfo)
{
var itemId = 0;
using (var conn = GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
IDataParameter[] parms = null;
var sqlInsert = BaiRongDataProvider.TableStructureDao.GetInsertSqlString(itemInfo.ToNameValueCollection(), ConnectionString, TableName, out parms);
itemId = ExecuteNonQueryAndReturnId(trans, sqlInsert, parms);
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
return(itemId);
}
public void Update(CollectItemInfo itemInfo)
{
IDataParameter[] parms = null;
var SQL_UPDATE = BaiRongDataProvider.TableStructureDao.GetUpdateSqlString(itemInfo.ToNameValueCollection(), ConnectionString, TABLE_NAME, out parms);
ExecuteNonQuery(SQL_UPDATE, parms);
}
public void Update(CollectItemInfo itemInfo)
{
IDataParameter[] parms = null;
var sqlUpdate = BaiRongDataProvider.TableStructureDao.GetUpdateSqlString(itemInfo.ToNameValueCollection(), ConnectionString, TableName, out parms);
ExecuteNonQuery(sqlUpdate, parms);
}
public CollectItemInfo GetCollectItemInfo(int itemID)
{
CollectItemInfo collectItemInfo = null;
string SQL_WHERE = $"WHERE ID = {itemID}";
var SQL_SELECT = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TABLE_NAME, 0, SqlUtils.Asterisk, SQL_WHERE, null);
using (var rdr = ExecuteReader(SQL_SELECT))
{
if (rdr.Read())
{
collectItemInfo = new CollectItemInfo(rdr);
}
rdr.Close();
}
return(collectItemInfo);
}
public CollectItemInfo GetCollectItemInfo(int itemId)
{
CollectItemInfo collectItemInfo = null;
string sqlWhere = $"WHERE ID = {itemId}";
var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, null);
using (var rdr = ExecuteReader(sqlSelect))
{
if (rdr.Read())
{
collectItemInfo = new CollectItemInfo(rdr);
}
rdr.Close();
}
return(collectItemInfo);
}
public List <CollectItemInfo> GetCollectItemInfoList(int collectID)
{
var list = new List <CollectItemInfo>();
string SQL_WHERE =
$"WHERE {CollectItemAttribute.CollectID} = {collectID} AND IsChecked = 'True' order by id desc";
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 itemInfo = new CollectItemInfo(rdr);
list.Add(itemInfo);
}
rdr.Close();
}
return(list);
}
public List <CollectItemInfo> GetCollectItemInfoList(int collectId)
{
var list = new List <CollectItemInfo>();
string sqlWhere =
$"WHERE {CollectItemAttribute.CollectId} = {collectId} AND IsChecked = 'True' order by id desc";
var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, null);
using (var rdr = ExecuteReader(sqlSelect))
{
while (rdr.Read())
{
var itemInfo = new CollectItemInfo(rdr);
list.Add(itemInfo);
}
rdr.Close();
}
return(list);
}
void rptContents_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
var collectItemInfo = new CollectItemInfo(e.Item.DataItem);
var ltlItemIndex = e.Item.FindControl("ltlItemIndex") as Literal;
var ltlItemTitle = e.Item.FindControl("ltlItemTitle") as Literal;
var ltlDescription = e.Item.FindControl("ltlDescription") as Literal;
var ltlMobile = e.Item.FindControl("ltlMobile") as Literal;
var ltlIsChecked = e.Item.FindControl("ltlIsChecked") as Literal;
var ltlVoteNum = e.Item.FindControl("ltlVoteNum") as Literal;
var ltlEditUrl = e.Item.FindControl("ltlEditUrl") as Literal;
ltlItemIndex.Text = (e.Item.ItemIndex + 1).ToString();
ltlItemTitle.Text = collectItemInfo.Title;
ltlDescription.Text = collectItemInfo.Description;
ltlMobile.Text = collectItemInfo.Mobile;
ltlVoteNum.Text = collectItemInfo.VoteNum.ToString();;
ltlIsChecked.Text = StringUtils.GetTrueOrFalseImageHtml(collectItemInfo.IsChecked);
var urlEdit = GetRedirectUrl(PublishmentSystemId, collectItemInfo.Id, collectItemInfo.CollectId);
ltlEditUrl.Text = $@"<a href=""{urlEdit}"">审核</a>";
}
}
