/// <summary> /// 发布数据取得 /// </summary> private void getPublishData() { string wheresql = "MediaType='WORDPRESS' AND 发行状态='未发行'"; if (mediaId != null) { wheresql += " and 媒体编号=" + mediaId; } if (db.GetMediaPublishVW(0, 0, "*", wheresql, "", ref ds_media) && ds_media.Tables[0].Rows.Count > 0) { CurrentIndex = 1; lblNum.Text = Convert.ToString(CurrentIndex) + "/" + Convert.ToString(ds_media.Tables[0].Rows.Count); txtTitle.Text = ds_media.Tables[0].Rows[CurrentIndex - 1]["名称"].ToString() + ds_media.Tables[0].Rows[CurrentIndex - 1]["发行期号"].ToString() + "[" + ds_media.Tables[0].Rows[CurrentIndex - 1]["发行日期"].ToString() + "]"; txtMessage.Text = ds_media.Tables[0].Rows[CurrentIndex - 1]["文本内容"].ToString(); txtPicturePath.Text = ds_media.Tables[0].Rows[CurrentIndex - 1]["本地图片"].ToString(); if (File.Exists(txtPicturePath.Text)) { pbCover.Image = new Bitmap(txtPicturePath.Text); } else { if (pbCover.Image != null) { pbCover.Image.Dispose(); } } btnPrev.Enabled = false; if (CurrentIndex < ds_media.Tables[0].Rows.Count) { btnNext.Enabled = true; } else { btnNext.Enabled = false; } btnPost.Enabled = true; string Url = ds_media.Tables[0].Rows[CurrentIndex - 1]["MediaURL"].ToString(); string userName = ds_media.Tables[0].Rows[CurrentIndex - 1]["MediaUser"].ToString(); string password = ds_media.Tables[0].Rows[CurrentIndex - 1]["MediaPassword"].ToString(); initCategroy(Url, userName, password); } else { btnNext.Enabled = false; btnPrev.Enabled = false; btnPost.Enabled = false; } }
/// <summary> /// 发布数据取得 /// </summary> private void getPublishData() { if (db.GetMediaPublishVW(0, 0, "*", "MediaType='TWITTER' AND 发行状态='未发行'", "", ref ds_media) && ds_media.Tables[0].Rows.Count > 0) { CurrentIndex = 1; lblNum.Text = Convert.ToString(CurrentIndex) + "/" + Convert.ToString(ds_media.Tables[0].Rows.Count); txtTitle.Text = ds_media.Tables[0].Rows[CurrentIndex - 1]["名称"].ToString() + ds_media.Tables[0].Rows[CurrentIndex - 1]["发行期号"].ToString() + "[" + ds_media.Tables[0].Rows[CurrentIndex - 1]["发行日期"].ToString() + "]"; txtMessage.Text = ds_media.Tables[0].Rows[CurrentIndex - 1]["文本内容"].ToString(); txtPicturePath.Text = ds_media.Tables[0].Rows[CurrentIndex - 1]["本地图片"].ToString(); if (File.Exists(txtPicturePath.Text)) { pbCover.Image = new Bitmap(txtPicturePath.Text); } else { if (pbCover.Image != null) { pbCover.Image.Dispose(); } } btnPrev.Enabled = false; if (CurrentIndex < ds_media.Tables[0].Rows.Count) { btnNext.Enabled = true; } else { btnNext.Enabled = false; } btnPost.Enabled = true; } else { btnNext.Enabled = false; btnPrev.Enabled = false; btnPost.Enabled = false; } }