protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if ((e.Item.ItemType == ListItemType.Item) || (e.Item.ItemType == ListItemType.AlternatingItem))
{
long iID = Convert.ToInt64(DataBinder.Eval(e.Item.DataItem, "ID"));
Literal ltTypeName = (Literal)e.Item.FindControl("ltTypeName");
lgk.Model.tb_news newsInfo = newsBLL.GetModel(iID);
if (newsInfo.NewType == 1)//1系统公告，2公司简介,3新闻中心,4疑问解答,5商城公告
{
ltTypeName.Text = "系统公告";
}
else if (newsInfo.NewType == 2)
{
ltTypeName.Text = "关于奖励分";
}
else if (newsInfo.NewType == 3)
{
ltTypeName.Text = "奖励分帮助";
}
//else if (newsInfo.NewType == 4)
// ltTypeName.Text = "疑问解答";
//else if (newsInfo.NewType == 5)
// ltTypeName.Text = "商城公告";
}
}
/// <summary>
/// 填充数据
/// </summary>
protected void BindData()
{
lgk.Model.tb_news newInfo = newsBLL.GetModelList("NewType=3").OrderByDescending(s => s.PublishTime).FirstOrDefault();
if (newInfo != null)
{
ltTitle.Text = newInfo.NewsTitle;
ltContent.Text = newInfo.NewsContent;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public long Add(lgk.Model.tb_news model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_news(");
strSql.Append("NewsTitle,NewsContent,NewsType,PublishTime,Publisher,ImageURL,NewType,Classify,Tags,Click,New01,New02,New03,New04,New05,New06)");
strSql.Append(" values (");
strSql.Append("@NewsTitle,@NewsContent,@NewsType,@PublishTime,@Publisher,@ImageURL,@NewType,@Classify,@Tags,@Click,@New01,@New02,@New03,@New04,@New05,@New06)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@NewsTitle", SqlDbType.VarChar, 100),
new SqlParameter("@NewsContent", SqlDbType.Text),
new SqlParameter("@NewsType", SqlDbType.Int, 4),
new SqlParameter("@PublishTime", SqlDbType.DateTime),
new SqlParameter("@Publisher", SqlDbType.VarChar, 50),
new SqlParameter("@ImageURL", SqlDbType.VarChar, 50),
new SqlParameter("@NewType", SqlDbType.Int, 4),
new SqlParameter("@Classify", SqlDbType.VarChar, 100),
new SqlParameter("@Tags", SqlDbType.VarChar, 500),
new SqlParameter("@Click", SqlDbType.Int, 4),
new SqlParameter("@New01", SqlDbType.Int, 4),
new SqlParameter("@New02", SqlDbType.Int, 4),
new SqlParameter("@New03", SqlDbType.Decimal, 9),
new SqlParameter("@New04", SqlDbType.Decimal, 9),
new SqlParameter("@New05", SqlDbType.VarChar, 500),
new SqlParameter("@New06", SqlDbType.VarChar, 500)
};
parameters[0].Value = model.NewsTitle;
parameters[1].Value = model.NewsContent;
parameters[2].Value = model.NewsType;
parameters[3].Value = model.PublishTime;
parameters[4].Value = model.Publisher;
parameters[5].Value = model.ImageURL;
parameters[6].Value = model.NewType;
parameters[7].Value = model.Classify;
parameters[8].Value = model.Tags;
parameters[9].Value = model.Click;
parameters[10].Value = model.New01;
parameters[11].Value = model.New02;
parameters[12].Value = model.New03;
parameters[13].Value = model.New04;
parameters[14].Value = model.New05;
parameters[15].Value = model.New06;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt64(obj));
}
}
/// <summary>
/// 填充数据
/// </summary>
protected void BindData(string id)
{
lgk.Model.tb_news newInfo = newsBLL.GetModel(Convert.ToInt64(id));
lblTitle.Text = newInfo.NewsTitle;
lblAuthor.Text = newInfo.Publisher;
lblDate.Text = newInfo.PublishTime.ToString("yyyy-MM-dd HH:mm:ss");
lilContent.Text = newInfo.NewsContent;
newInfo.Click += 1;
newsBLL.Update(newInfo);
}
/// <summary>
/// 填充数据
/// </summary>
protected void BindData(string id)
{
lgk.Model.tb_news newInfo = newsBLL.GetModel(Convert.ToInt64(id));
if (newInfo != null)
{
ltTitle.Text = newInfo.NewsTitle;
LitPublishTime.Text = newInfo.PublishTime.ToString("yyyy-MM-dd");
LitPublisher.Text = newInfo.Publisher;
ltContent.Text = newInfo.NewsContent;
}
}
public NoticeModel NoticeDetail(int id)
{
lgk.Model.tb_news newInfo = newsBLL.GetModel(Convert.ToInt64(id));
NoticeModel news = new NoticeModel();
news.ID = newInfo.ID.ToString();
news.NewsTitle = newInfo.NewsTitle;
news.NewsContent = newInfo.NewsContent;
news.PublishTime = newInfo.PublishTime.ToString();
news.Publisher = newInfo.Publisher;
return(news);
}
/// <summary>
/// 填充信息
/// </summary>
protected void BindData()
{
//lgk.Model.tb_wealth wealth = wealthBLL.GetModel();
string cnen = GetLanguage("LoginLable");
int langType = cnen.Equals("zh-cn") ? 0 : 1;
lgk.Model.tb_news data = newsBLL.GetModelByNewType(7, langType);
if (data == null)
{
lbTitle.Text = GetLanguage("terms");//服务条款
lilContent.Text = "<span style='color:red;'>" + GetLanguage("Manager") + "</span>";
}
else
{
lbTitle.Text = data.NewsTitle;
lilContent.Text = data.NewsContent;
}
}
/// <summary>
/// 填充信息
/// </summary>
protected void BindData()
{
lgk.Model.tb_news newInfo = newsBLL.GetModel(iNoticeID);
txtTitle.Text = newInfo.NewsTitle;
textPubContext.Value = newInfo.NewsContent;
txtTime.Text = newInfo.PublishTime.ToString();
dropNewType.SelectedValue = newInfo.NewType.ToString();
if (newInfo.New01 == 0)
{
rdoZH.Checked = true;
rdoEn.Checked = false;
}
else
{
rdoEn.Checked = true;
rdoZH.Checked = false;
}
}
protected void lbtnSubmit_Click(object sender, EventArgs e)
{
spd.jumpAdminUrl1(this.Page, 1);//跳转三级密码
if (validate())
{
lgk.Model.tb_news newInfo = new lgk.Model.tb_news();
newInfo.NewsTitle = txtTitle.Text;
newInfo.NewsContent = textPubContext.Value;
//newInfo.NewsType = 1;
newInfo.Publisher = getColumn(0, "TrueName", "tb_admin", "ID=" + getLoginID(), "");
DateTime dt = DateTime.Now;
DateTime.TryParse(txtTime.Text.Trim(), out dt);
newInfo.PublishTime = dt;
newInfo.NewType = int.Parse(dropNewType.SelectedValue);
if (rdoEn.Checked)
{
newInfo.New01 = 1;//英文
}
if (rdoZH.Checked)
{
newInfo.New01 = 0;//中文
}
if (iNoticeID > 0)
{
newInfo.ID = Convert.ToInt64(iNoticeID);
if (newsBLL.Update(newInfo))
{
MessageBox.ShowAndRedirect(this.Page, "修改成功", "NoticeManage.aspx");
}
}
else
{
if (newsBLL.Add(newInfo) > 0)
{
MessageBox.ShowAndRedirect(this.Page, "添加成功", "NoticeManage.aspx");
}
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(lgk.Model.tb_news model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_news set ");
strSql.Append("NewsTitle=@NewsTitle,");
strSql.Append("NewsContent=@NewsContent,");
strSql.Append("NewsType=@NewsType,");
strSql.Append("PublishTime=@PublishTime,");
strSql.Append("Publisher=@Publisher,");
strSql.Append("ImageURL=@ImageURL,");
strSql.Append("NewType=@NewType,");
strSql.Append("Classify=@Classify,");
strSql.Append("Tags=@Tags,");
strSql.Append("Click=@Click,");
strSql.Append("New01=@New01,");
strSql.Append("New02=@New02,");
strSql.Append("New03=@New03,");
strSql.Append("New04=@New04,");
strSql.Append("New05=@New05,");
strSql.Append("New06=@New06");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@NewsTitle", SqlDbType.VarChar, 100),
new SqlParameter("@NewsContent", SqlDbType.Text),
new SqlParameter("@NewsType", SqlDbType.Int, 4),
new SqlParameter("@PublishTime", SqlDbType.DateTime),
new SqlParameter("@Publisher", SqlDbType.VarChar, 50),
new SqlParameter("@ImageURL", SqlDbType.VarChar, 50),
new SqlParameter("@NewType", SqlDbType.Int, 4),
new SqlParameter("@Classify", SqlDbType.VarChar, 100),
new SqlParameter("@Tags", SqlDbType.VarChar, 500),
new SqlParameter("@Click", SqlDbType.Int, 4),
new SqlParameter("@New01", SqlDbType.Int, 4),
new SqlParameter("@New02", SqlDbType.Int, 4),
new SqlParameter("@New03", SqlDbType.Decimal, 9),
new SqlParameter("@New04", SqlDbType.Decimal, 9),
new SqlParameter("@New05", SqlDbType.VarChar, 500),
new SqlParameter("@New06", SqlDbType.VarChar, 500),
new SqlParameter("@ID", SqlDbType.BigInt, 8)
};
parameters[0].Value = model.NewsTitle;
parameters[1].Value = model.NewsContent;
parameters[2].Value = model.NewsType;
parameters[3].Value = model.PublishTime;
parameters[4].Value = model.Publisher;
parameters[5].Value = model.ImageURL;
parameters[6].Value = model.NewType;
parameters[7].Value = model.Classify;
parameters[8].Value = model.Tags;
parameters[9].Value = model.Click;
parameters[10].Value = model.New01;
parameters[11].Value = model.New02;
parameters[12].Value = model.New03;
parameters[13].Value = model.New04;
parameters[14].Value = model.New05;
parameters[15].Value = model.New06;
parameters[16].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 根据新闻类型与语音种类获取新闻
/// </summary>
/// <param name="typeId"></param>
/// <param name="langType"></param>
/// <returns></returns>
public lgk.Model.tb_news GetModelByNewType(int typeId, int langType)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,NewsTitle,NewsContent,NewsType,PublishTime,Publisher,ImageURL,NewType,Classify,Tags,Click,New01,New02,New03,New04,New05,New06 from tb_news ");
strSql.Append(" where NewType=@NewType and New01=@New01 order by PublishTime desc");
SqlParameter[] parameters =
{
new SqlParameter("@NewType", SqlDbType.BigInt),
new SqlParameter("@New01", SqlDbType.BigInt)
};
parameters[0].Value = typeId;
parameters[1].Value = langType;
lgk.Model.tb_news model = new lgk.Model.tb_news();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = long.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["NewsTitle"] != null && ds.Tables[0].Rows[0]["NewsTitle"].ToString() != "")
{
model.NewsTitle = ds.Tables[0].Rows[0]["NewsTitle"].ToString();
}
if (ds.Tables[0].Rows[0]["NewsContent"] != null && ds.Tables[0].Rows[0]["NewsContent"].ToString() != "")
{
model.NewsContent = ds.Tables[0].Rows[0]["NewsContent"].ToString();
}
if (ds.Tables[0].Rows[0]["NewsType"] != null && ds.Tables[0].Rows[0]["NewsType"].ToString() != "")
{
model.NewsType = int.Parse(ds.Tables[0].Rows[0]["NewsType"].ToString());
}
if (ds.Tables[0].Rows[0]["PublishTime"] != null && ds.Tables[0].Rows[0]["PublishTime"].ToString() != "")
{
model.PublishTime = DateTime.Parse(ds.Tables[0].Rows[0]["PublishTime"].ToString());
}
if (ds.Tables[0].Rows[0]["Publisher"] != null && ds.Tables[0].Rows[0]["Publisher"].ToString() != "")
{
model.Publisher = ds.Tables[0].Rows[0]["Publisher"].ToString();
}
if (ds.Tables[0].Rows[0]["ImageURL"] != null && ds.Tables[0].Rows[0]["ImageURL"].ToString() != "")
{
model.ImageURL = ds.Tables[0].Rows[0]["ImageURL"].ToString();
}
if (ds.Tables[0].Rows[0]["NewType"] != null && ds.Tables[0].Rows[0]["NewType"].ToString() != "")
{
model.NewType = int.Parse(ds.Tables[0].Rows[0]["NewType"].ToString());
}
if (ds.Tables[0].Rows[0]["Classify"] != null && ds.Tables[0].Rows[0]["Classify"].ToString() != "")
{
model.Classify = ds.Tables[0].Rows[0]["Classify"].ToString();
}
if (ds.Tables[0].Rows[0]["Tags"] != null && ds.Tables[0].Rows[0]["Tags"].ToString() != "")
{
model.Tags = ds.Tables[0].Rows[0]["Tags"].ToString();
}
if (ds.Tables[0].Rows[0]["Click"] != null && ds.Tables[0].Rows[0]["Click"].ToString() != "")
{
model.Click = int.Parse(ds.Tables[0].Rows[0]["Click"].ToString());
}
if (ds.Tables[0].Rows[0]["New01"] != null && ds.Tables[0].Rows[0]["New01"].ToString() != "")
{
model.New01 = int.Parse(ds.Tables[0].Rows[0]["New01"].ToString());
}
if (ds.Tables[0].Rows[0]["New02"] != null && ds.Tables[0].Rows[0]["New02"].ToString() != "")
{
model.New02 = int.Parse(ds.Tables[0].Rows[0]["New02"].ToString());
}
if (ds.Tables[0].Rows[0]["New03"] != null && ds.Tables[0].Rows[0]["New03"].ToString() != "")
{
model.New03 = decimal.Parse(ds.Tables[0].Rows[0]["New03"].ToString());
}
if (ds.Tables[0].Rows[0]["New04"] != null && ds.Tables[0].Rows[0]["New04"].ToString() != "")
{
model.New04 = decimal.Parse(ds.Tables[0].Rows[0]["New04"].ToString());
}
if (ds.Tables[0].Rows[0]["New05"] != null && ds.Tables[0].Rows[0]["New05"].ToString() != "")
{
model.New05 = ds.Tables[0].Rows[0]["New05"].ToString();
}
if (ds.Tables[0].Rows[0]["New06"] != null && ds.Tables[0].Rows[0]["New06"].ToString() != "")
{
model.New06 = ds.Tables[0].Rows[0]["New06"].ToString();
}
return(model);
}
else
{
return(null);
}
}
