void rptContents_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
var contentInfo = new ConferenceContentInfo(e.Item.DataItem);
var ltlItemIndex = e.Item.FindControl("ltlItemIndex") as Literal;
var ltlRealName = e.Item.FindControl("ltlRealName") as Literal;
var ltlMobile = e.Item.FindControl("ltlMobile") as Literal;
var ltlEmail = e.Item.FindControl("ltlEmail") as Literal;
var ltlCompany = e.Item.FindControl("ltlCompany") as Literal;
var ltlPosition = e.Item.FindControl("ltlPosition") as Literal;
var ltlNote = e.Item.FindControl("ltlNote") as Literal;
var ltlWXOpenID = e.Item.FindControl("ltlWXOpenID") as Literal;
var ltlIPAddress = e.Item.FindControl("ltlIPAddress") as Literal;
var ltlAddDate = e.Item.FindControl("ltlAddDate") as Literal;
ltlItemIndex.Text = (e.Item.ItemIndex + 1).ToString();
ltlRealName.Text = contentInfo.RealName;
ltlMobile.Text = contentInfo.Mobile;
ltlEmail.Text = contentInfo.Email;
ltlCompany.Text = contentInfo.Company;
ltlPosition.Text = contentInfo.Position;
ltlNote.Text = contentInfo.Note;
ltlWXOpenID.Text = contentInfo.WXOpenID;
ltlIPAddress.Text = contentInfo.IPAddress;
ltlAddDate.Text = DateUtils.GetDateAndTimeString(contentInfo.AddDate);
}
}
public void Insert(ConferenceContentInfo contentInfo)
{
IDataParameter[] parms = null;
var SQL_INSERT = BaiRongDataProvider.TableStructureDao.GetInsertSqlString(contentInfo.ToNameValueCollection(), ConnectionString, TABLE_NAME, out parms);
ExecuteNonQuery(SQL_INSERT, parms);
}
public static void AddContent(int publishmentSystemID, int conferenceID, string realName, string mobile, string email, string company, string position, string note, string ipAddress, string cookieSN, string wxOpenID, string userName)
{
DataProviderWx.ConferenceDao.AddUserCount(conferenceID);
var contentInfo = new ConferenceContentInfo {
Id = 0, PublishmentSystemId = publishmentSystemID, ConferenceId = conferenceID, IpAddress = ipAddress, CookieSn = cookieSN, WxOpenId = wxOpenID, UserName = userName, RealName = realName, Mobile = mobile, Email = email, Company = company, Position = position, Note = note, AddDate = DateTime.Now
};
DataProviderWx.ConferenceContentDao.Insert(contentInfo);
}
public List <ConferenceContentInfo> GetConferenceContentInfoList(int publishmentSystemID, int conferenceID)
{
var conferenceContentInfoList = new List <ConferenceContentInfo>();
string SQL_WHERE =
$" AND {ConferenceContentAttribute.PublishmentSystemID} = {publishmentSystemID} AND {ConferenceContentAttribute.ConferenceID} = {conferenceID}";
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 conferenceContentInfo = new ConferenceContentInfo(rdr);
conferenceContentInfoList.Add(conferenceContentInfo);
}
rdr.Close();
}
return(conferenceContentInfoList);
}
public List <ConferenceContentInfo> GetConferenceContentInfoList(int publishmentSystemId, int conferenceId)
{
var conferenceContentInfoList = new List <ConferenceContentInfo>();
string sqlWhere =
$" AND {ConferenceContentAttribute.PublishmentSystemId} = {publishmentSystemId} AND {ConferenceContentAttribute.ConferenceId} = {conferenceId}";
var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, null);
using (var rdr = ExecuteReader(sqlSelect))
{
while (rdr.Read())
{
var conferenceContentInfo = new ConferenceContentInfo(rdr);
conferenceContentInfoList.Add(conferenceContentInfo);
}
rdr.Close();
}
return(conferenceContentInfoList);
}
