public int ArticleInfoPost(ArticleInfoEntity ArticleInfo)//发布文章方法 { string sSQLText = "insert into ArticleInfo values('" + ArticleInfo.sarticleTitle + "','" + ArticleInfo.larticleAutherID + "','" + ArticleInfo.sarticleContent + "','" + ArticleInfo.iarticleReadCount + "','" + ArticleInfo.iarticleLikedCount + "','" + ArticleInfo.iarticleDislikedCount + "')"; int iReturnedValue = DAL.DataBaseAccess.ExecuteSql(sSQLText); return(iReturnedValue); }
private long GetArticleAutherID() { long ArticleAutherID; long lArticleID = long.Parse(Request.QueryString["ArticleID"].ToString()); ArticleInfoBusiness GetArticleInfoByArticleID = new ArticleInfoBusiness(); ArticleInfoEntity ArticleInfo = new ArticleInfoEntity(); ArticleInfo = GetArticleInfoByArticleID.GetArticleInfoByID(lArticleID); ArticleAutherID = ArticleInfo.larticleAutherID; return(ArticleAutherID); }
public ArticleManagementSettingForm() { InitializeComponent(); MainForm = (Form)this.Parent; pageControl1.MainForm = MainForm; pageControl1.PageSize = Convert.ToInt32(AppContext.AppConfig.pagesize); cmd = new Xr.Common.Controls.OpaqueCommand(AppContext.Session.waitControl); cmd.ShowOpaqueLayer(225, false); First(); ArticleCategoryCollection(); cmd.HideOpaqueLayer(); CickInfo = new ArticleInfoEntity(); CickInfo.id = ""; }
public ArticleInfoEntity GetArticleInfoByID(long lArtcleID)//展示全部信息方法 { string sSQLText = "select * from ArticleInfo where ArticleID='" + lArtcleID + "'"; DataTable dataTable = DAL.DataBaseAccess.GetDataSet(sSQLText); //得到多值 ArticleInfoEntity ArticleInfo = new ArticleInfoEntity(); // if (dataTable.Rows.Count > 0) { ArticleInfo.larticleID = long.Parse("" + dataTable.Rows[0][0]); ArticleInfo.sarticleTitle = "" + dataTable.Rows[0][1]; ArticleInfo.larticleAutherID = long.Parse("" + dataTable.Rows[0][2]); ArticleInfo.sarticleContent = "" + dataTable.Rows[0][3]; ArticleInfo.iarticleReadCount = int.Parse("" + dataTable.Rows[0][4]); ArticleInfo.iarticleLikedCount = int.Parse("" + dataTable.Rows[0][5]); ArticleInfo.iarticleDislikedCount = int.Parse("" + dataTable.Rows[0][6]); } return(ArticleInfo); }
protected void BTNPostArticle_Click(object sender, EventArgs e) { ArticleInfoBusiness ArticlePost = new ArticleInfoBusiness(); ArticleInfoEntity ArticleInfo = new ArticleInfoEntity(); ArticleInfo.sarticleTitle = TBArticleTitle.Text; ArticleInfo.larticleAutherID = 0; ArticleInfo.sarticleContent = TBArticleContent.Text; ArticleInfo.iarticleReadCount = 0; ArticleInfo.iarticleLikedCount = 0; ArticleInfo.iarticleDislikedCount = 0; int iReturnValue = ArticlePost.ArticleInfoPost(ArticleInfo); if (iReturnValue > 0) { Response.Write("<script>alert('文章发布成功!')</script>"); } }
private void ArticleInfoDisplay(long lArticleID) { //获得文章信息 ArticleInfoBusiness GetArticleInfoByArticleID = new ArticleInfoBusiness(); ArticleInfoEntity ArticleInfo = new ArticleInfoEntity(); ArticleInfo = GetArticleInfoByArticleID.GetArticleInfoByID(lArticleID); LBLArticleTitle.Text = ArticleInfo.sarticleTitle; LBLArticleReadCountNumber.Text = ArticleInfo.iarticleReadCount.ToString(); LBLArticleLikedCount.Text = ArticleInfo.iarticleLikedCount.ToString(); LBLArticleDislikedCount.Text = ArticleInfo.iarticleDislikedCount.ToString(); LBLArticleContent.Text = ArticleInfo.sarticleContent; //获得作者信息 CounsellorInfoBusiness GetArticleAutherInfo = new CounsellorInfoBusiness(); CounsellorInfoEntity ArticleAutherInfo = new CounsellorInfoEntity(); long lAuthorID = ArticleInfo.larticleAutherID; if (lAuthorID == 0L) { BTNArticleDisliked.Visible = false; LBLArticleDisliked.Visible = false; LBLArticleDislikedCount.Visible = false; IMGArticleAuthorImage.Visible = false; LBLAuthorName.Text = "管理员"; LBAutherInfoDetails.Visible = false; LBLAuthorTips.Text = "此文章由管理员发布"; } else { ArticleAutherInfo = GetArticleAutherInfo.GetCounsellorInfoByID(lAuthorID); LBLAuthorName.Text = ArticleAutherInfo.scounsellorName; IMGArticleAuthorImage.ImageUrl = ArticleAutherInfo.scounsellorImage; LBLAuthorTips.Text = ArticleAutherInfo.scounsellorSelfIntroduction; } }
private void PostArticle() { long lCounsellorID = long.Parse(Session["UsersID"].ToString()); ArticleInfoBusiness PostArticle = new ArticleInfoBusiness(); ArticleInfoEntity ArticleInfo = new ArticleInfoEntity(); ArticleInfo.sarticleTitle = TBArticleTitle.Text; ArticleInfo.sarticleContent = TBArticleContent.Text; ArticleInfo.larticleAutherID = lCounsellorID; ArticleInfo.iarticleReadCount = 0; ArticleInfo.iarticleLikedCount = 0; ArticleInfo.iarticleDislikedCount = 0; int iResultJudgement = PostArticle.ArticleInfoPost(ArticleInfo); if (iResultJudgement > 0) { Response.Write("<script>alert('成功发布文章!')</script>"); } else { Response.Write("<script>alert('抱歉,发布失败!')</script>"); } }
private void gv_Article_RowClick(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e) { cmd.ShowOpaqueLayer(225, true); CickInfo = gv_Article.GetFocusedRow() as ArticleInfoEntity; SelectInfoPage(1, pageControl1.PageSize, CickInfo.id); }
/// <summary> /// 文章类别集合 /// </summary> public void ArticleCategoryCollection() { try { list = new List <ArticleInfoEntity>(); String url = AppContext.AppConfig.serverUrl + "cms/articleCategory/findAll?hospitalId=" + AppContext.Session.hospitalId; String data = HttpClass.httpPost(url); JObject objT = JObject.Parse(data); if (string.Compare(objT["state"].ToString(), "true", true) == 0) { if (objT["result"].ToString() == "" || objT["result"].ToString() == "{}") { this.gc_Article.DataSource = null; return; } Woqu = objT; list = objT["result"].ToObject <List <ArticleInfoEntity> >(); for (int i = 0; i < list.Count; i++) { switch (list[i].isUse) { case "0": list[i].isUse = "启用"; break; case "1": list[i].isUse = "禁用"; break; } } this.gc_Article.DataSource = list; gc_Article.RefreshDataSource(); } else { MessageBoxUtils.Show(objT["message"].ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MainForm); } } catch (Exception) { ArticleInfoEntity two = Newtonsoft.Json.JsonConvert.DeserializeObject <ArticleInfoEntity>(Woqu["result"].ToString()); list.Add(two); for (int i = 0; i < list.Count; i++) { switch (list[i].isUse) { case "0": list[i].isUse = "启用"; break; case "1": list[i].isUse = "禁用"; break; } } this.gc_Article.DataSource = list; gc_Article.RefreshDataSource(); } finally { //list lookUpEdit2.Properties.DataSource = list; lookUpEdit2.Properties.DisplayMember = "name"; lookUpEdit2.Properties.ValueMember = "id"; } }
private void gc_Article_Click(object sender, EventArgs e) { cmd.ShowOpaqueLayer(225, true); CickInfo = gv_Article.GetFocusedRow() as ArticleInfoEntity; SelectInfoPage(1, pageControl1.PageSize, CickInfo.id); }