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); } }