/// <summary> /// 展示数据 /// </summary> /// <param name="id">记录Id</param> private void ShowInfo(int id) { LAnnounceBB announceBB = new LAnnounceBB(); vLAnnounceData model = new vLAnnounceData(); try { model = announceBB.GetVModel(id); this.title.Text = model.title; this.content.Text = model.content; if (model.downFileNm != null) { this.fileNms.Text = model.downFileNm.Replace("|", "<br />"); } this.author.Text = model.author; if (model.isIndexShow) { this.isIndexShow.Text = "已发布"; } else { this.isIndexShow.Text = "未发布"; } } finally { announceBB.Dispose(); } }
/// <summary> /// 得到一个视图model /// </summary> /// <param name="id">主键值</param> /// <returns>model</returns> public vLAnnounceData GetVModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"select id,title,content,fileIds,isIndexShow,author,updtDt,updtEmpId,preFileNm,downFileNm from vLAnnounce"); strSql.Append(" where id = @id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int) }; parameters[0].Value = id; vLAnnounceData model = new vLAnnounceData(); DataSet ds = SqlHelper.ExecuteDataset(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { DataRow row =ds.Tables[0].Rows[0]; if (row["id"] != DBNull.Value) { model.id = Convert.ToInt32(row["id"]); } if (row["title"] != DBNull.Value) { model.title = Convert.ToString(row["title"]); } if (row["content"] != DBNull.Value) { model.content = Convert.ToString(row["content"]); } if (row["fileIds"] != DBNull.Value) { model.fileIds = Convert.ToString(row["fileIds"]); } if (row["isIndexShow"] != DBNull.Value) { model.isIndexShow = Convert.ToBoolean(row["isIndexShow"]); } if (row["author"] != DBNull.Value) { model.author = Convert.ToString(row["author"]); } if (row["updtDt"] != DBNull.Value) { model.updtDt = Convert.ToString(row["updtDt"]); } if (row["updtEmpId"] != DBNull.Value) { model.updtEmpId = Convert.ToInt32(row["updtEmpId"]); } if (row["preFileNm"] != DBNull.Value) { model.preFileNm = Convert.ToString(row["preFileNm"]); } if (row["downFileNm"] != DBNull.Value) { model.downFileNm = Convert.ToString(row["downFileNm"]); } return model; } else { return null; } }
/// <summary> /// 展示数据 /// </summary> /// <param name="id">记录Id</param> private void ShowInfo(int id) { LAnnounceBB announceBB = new LAnnounceBB(); vLAnnounceData model = new vLAnnounceData(); try { model = announceBB.GetVModel(id); this.title.Text = model.title; this.content.Text = model.content; this.fileIds.Value = model.fileIds; if (model.preFileNm != null) { this.fileNms.Text = model.preFileNm.Replace("|", "<br />"); } this.author.Text = model.author; if (model.isIndexShow) { this.isIndexShow.Text = "已发布"; this.btnRelease.Enabled = false; this.btnUnRelease.Enabled = true; } else { this.isIndexShow.Text = "未发布"; this.btnRelease.Enabled = true; this.btnUnRelease.Enabled = false; } } finally { announceBB.Dispose(); } }