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