/// <summary> /// 初始化 /// </summary> private void init() { DataSet ds = new DataSet(); if (db.GetMedia(0, 0, "id,MediaType,MediaURL,MediaAppKey,MediaAppPassword,MediaUser,MediaPassword,other,createtime,published,UserID", "", "", ref ds)) { dataGridView1.DataSource = ds.Tables[0]; dataGridView1.Columns[4].Visible = false; dataGridView1.Columns[6].Visible = false; } }
/// <summary> /// 初期化 /// </summary> private void init() { DataSet ds = new DataSet(); if (db.GetMedia(0, 0, "id,MediaURL", "MediaType='WORDPRESS'", "", ref ds)) { cmbWordpress.DataSource = ds.Tables[0]; cmbWordpress.DisplayMember = "MediaURL"; ButtonStateNext |= WizardButtonState.Enabled; } }
/// <summary> /// 初始化 /// </summary> private void init() { DataSet ds = new DataSet(); if (db.GetMedia(0, 0, "id,MediaType,MediaURL,MediaAppKey,MediaAppPassword,MediaUser,MediaPassword,other,createtime,published,UserID", "MediaType='FACEBOOK'", "", ref ds)) { this.AppId = ds.Tables[0].Rows[0]["MediaAppKey"].ToString(); this.userName = ds.Tables[0].Rows[0]["MediaUser"].ToString(); this.Password = ds.Tables[0].Rows[0]["MediaPassword"].ToString(); } }
/// <summary> /// 初始化 /// </summary> private void init() { DataSet ds = new DataSet(); if (db.GetMedia(0, 0, "id,MediaType,MediaURL,MediaAppKey,MediaAppPassword,MediaUser,MediaPassword,other,createtime,published,UserID", "MediaType='TWITTER'", "", ref ds)) { string appKey = ds.Tables[0].Rows[0]["MediaAppKey"].ToString(); string appPassword = ds.Tables[0].Rows[0]["MediaAppPassword"].ToString(); service = new TwitterService(appKey, appPassword); this.userName = ds.Tables[0].Rows[0]["MediaUser"].ToString(); this.password = ds.Tables[0].Rows[0]["MediaPassword"].ToString(); } }
/// <summary> /// 期刊发行 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Publish(string magId, string sMagId, string magNo, string mediaType, string mediaId) { DataSet ds = new DataSet(); if (db.GetPublish(0, 0, "发行编号,期刊编号,发行期号,发行日期,期刊状态,文件链接,本地文件,FTP文件,图片链接,本地图片,FTP图片,文本内容,邮件内容,S期刊编号,S发行编号", "期刊编号=" + magId + " and 发行期号='" + magNo + "'", "", ref ds) && ds.Tables[0].Rows.Count == 1) { string strState = ds.Tables[0].Rows[0]["期刊状态"].ToString(); if (strState.Trim() != "新建" && strState.Trim() != "发行中") { string msg = String.Format(NCMessage.GetInstance(db.Language).GetMessageById("CM0083I", db.Language), strState); MessageBox.Show(msg); return; } string strPublishId = ds.Tables[0].Rows[0]["发行编号"].ToString(); string strMagId = magId; string strSPublishId = ds.Tables[0].Rows[0]["S发行编号"].ToString(); string txtFileLink = ds.Tables[0].Rows[0]["文件链接"].ToString(); string txtFileLocal = ds.Tables[0].Rows[0]["本地文件"].ToString(); string txtFileFTP = ds.Tables[0].Rows[0]["FTP文件"].ToString(); string txtPicLink = ds.Tables[0].Rows[0]["图片链接"].ToString(); string txtPicLocal = ds.Tables[0].Rows[0]["本地图片"].ToString(); string txtPicFTP = ds.Tables[0].Rows[0]["FTP图片"].ToString(); string txtText = ds.Tables[0].Rows[0]["文本内容"].ToString(); string txtMail = ds.Tables[0].Rows[0]["邮件内容"].ToString(); int id = 0; if (chkMailSend.Checked && db.GetCustomer(0, 0, "id", "subscripted='Y'", "", ref ds)) { foreach (DataRow row in ds.Tables[0].Rows) { String customerid = row["id"].ToString(); String fieldlist = "客户编号,期刊编号,发行编号,送信状态,UserID"; String valuelist = customerid + "," + strMagId + "," + strPublishId + ",'未送信','" + db.UserID + "'"; db.SetSend(0, 0, fieldlist, "", valuelist, out id); } } else if (chkMailSend.Checked) { string msg = NCMessage.GetInstance(db.Language).GetMessageById("CM0074I", db.Language); MessageBox.Show(msg); } ///发行同步 ds = new DataSet(); if (db.GetSPublish(0, 0, "S发行编号", "发行编号=" + strPublishId + " and 期刊编号=" + strMagId + " and S期刊编号='" + sMagId + "'", "", ref ds) && ds.Tables[0].Rows.Count > 0) { String wheresql = "S发行编号='" + ds.Tables[0].Rows[0][0].ToString() + "'"; String valuesql = "发行期号='" + magNo + "',期刊状态='" + strState + "',文件链接='" + txtFileLink + "',本地文件='" + txtFileLocal + "',FTP文件='" + txtFileFTP + "',图片链接='" + txtPicLink + "',本地图片='" + txtPicLocal + "',FTP图片='" + txtPicFTP + "',文本内容='" + txtText + "',邮件内容='" + txtMail + "'"; db.SetSPublish(0, 1, "", wheresql, valuesql, out id); } else { String fieldlist = "S发行编号,S期刊编号,期刊编号,发行编号,发行期号,发行日期,文件链接,本地文件,FTP文件,图片链接,本地图片,FTP图片,文本内容,邮件内容,期刊状态,UserID"; String valuelist = "'" + strSPublishId + "','" + sMagId + "'," + magId + "," + strPublishId + ",'" + magNo + "','" + System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss") + "','" + txtFileLink + "','" + txtFileLocal + "','" + txtFileFTP + "','" + txtPicLink + "','" + txtPicLocal + "','" + txtPicFTP + "','" + txtText + "','" + txtMail + "','新建','" + db.UserID + "'"; db.SetSPublish(0, 0, fieldlist, "", valuelist, out id); } ///启动FTP上传 if (chkFtpUpload.Checked) { ds = new DataSet(); String strWhere = "上传状态='未上传' and 期刊编号=" + magId + " and 发行编号=" + strPublishId; if (db.GetFTPUploadVW(0, 0, "*", strWhere, "", ref ds)) { NCFTP ftp = new NCFTP(); foreach (DataRow dr in ds.Tables[0].Rows) { String filename = dr["上传名称"].ToString(); String url = dr["FTP文件"].ToString(); string uploadid = dr["上传编号"].ToString(); setUpload(uploadid, "上传中"); if (ftp.uploadFile(url, filename, dr["用户"].ToString(), dr["密码"].ToString())) { setUpload(uploadid, "上传完"); } else { setUpload(uploadid, "未上传"); } } } } if (chkMediaPublish.Checked) { //媒体发布 ds = new DataSet(); string wheresql = "published='Y' and MediaType='" + mediaType + "'"; if (mediaId != null) { wheresql += " and id=" + mediaId; } if (db.GetMedia(0, 0, "*", wheresql, "", ref ds)) { foreach (DataRow row in ds.Tables[0].Rows) { String mediaId1 = row["id"].ToString(); String mediaType1 = row["MediaType"].ToString(); String fieldlist = "媒体编号,期刊编号,发行编号,发行状态,媒体名称,UserID"; String valuelist = mediaId1 + "," + strMagId + "," + strPublishId + ",'未发行','" + mediaType1 + "','" + db.UserID + "'"; db.SetMediaPublish(0, 0, fieldlist, "", valuelist, out id); } } } ///发行状态更新 String wheresql1 = "发行编号=" + strPublishId; String valuesql1 = "期刊状态='发行中'"; if (db.SetPublish(0, 1, "", wheresql1, valuesql1, out id) && id == 1) { string msg = NCMessage.GetInstance(db.Language).GetMessageById("CM0081I", db.Language); MessageBox.Show(msg); } else { string msg = NCMessage.GetInstance(db.Language).GetMessageById("CM0082I", db.Language); MessageBox.Show(msg); } } else { string msg = NCMessage.GetInstance(db.Language).GetMessageById("CM0069I", db.Language); MessageBox.Show(msg); } }
/// <summary> /// 期刊发行 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnPublish_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count > 0) { string strState = txtState.Text; if (strState.Trim() != "新建") { string msg = String.Format(NCMessage.GetInstance(db.Language).GetMessageById("CM0083I", db.Language), strState); MessageBox.Show(msg); return; } string strPublishId = dataGridView1.SelectedRows[0].Cells[0].Value.ToString(); string strMagId = dataGridView1.SelectedRows[0].Cells[1].Value.ToString(); string strSPublishId = dataGridView1.SelectedRows[0].Cells[14].Value.ToString(); ///客户订阅 DataSet ds = new DataSet(); if (db.GetCustomer(0, 0, "id", "subscripted='Y'", "", ref ds)) { int id = 0; foreach (DataRow row in ds.Tables[0].Rows) { String customerid = row["id"].ToString(); String fieldlist = "客户编号,期刊编号,发行编号,送信状态,UserID"; String valuelist = customerid + "," + strMagId + "," + strPublishId + ",'未送信','" + db.UserID + "'"; db.SetSend(0, 0, fieldlist, "", valuelist, out id); } ///发行同步 ds = new DataSet(); if (db.GetSPublish(0, 0, "S发行编号", "发行编号=" + strPublishId + " and 期刊编号=" + strMagId + " and S期刊编号='" + SMagId + "'", "", ref ds) && ds.Tables[0].Rows.Count > 0) { String wheresql = "S发行编号='" + ds.Tables[0].Rows[0][0].ToString() + "'"; String valuesql = "发行期号='" + txtPublish.Text + "',期刊状态='" + "新建" + "',文件链接='" + txtFileLink.Text + "',本地文件='" + txtFileLocal.Text + "',FTP文件='" + txtFileFTP.Text + "',图片链接='" + txtPicLink.Text + "',本地图片='" + txtPicLocal.Text + "',FTP图片='" + txtPicFTP.Text + "',文本内容='" + txtText.Text + "',邮件内容='" + txtMail.Text + "'"; db.SetSPublish(0, 1, "", wheresql, valuesql, out id); } else { String fieldlist = "S发行编号,S期刊编号,期刊编号,发行编号,发行期号,发行日期,文件链接,本地文件,FTP文件,图片链接,本地图片,FTP图片,文本内容,邮件内容,期刊状态,UserID"; String valuelist = "'" + strSPublishId + "','" + SMagId + "'," + MagId + "," + strPublishId + ",'" + txtPublish.Text + "','" + System.DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss") + "','" + txtFileLink.Text + "','" + txtFileLocal.Text + "','" + txtFileFTP.Text + "','" + txtPicLink.Text + "','" + txtPicLocal.Text + "','" + txtPicFTP.Text + "','" + txtText.Text + "','" + txtMail.Text + "','新建','" + db.UserID + "'"; db.SetSPublish(0, 0, fieldlist, "", valuelist, out id); } //媒体发布 ds = new DataSet(); if (db.GetMedia(0, 0, "*", "published='Y'", "", ref ds)) { foreach (DataRow row in ds.Tables[0].Rows) { String mediaId = row["id"].ToString(); String mediaType = row["MediaType"].ToString(); String fieldlist = "媒体编号,期刊编号,发行编号,发行状态,媒体名称,UserID"; String valuelist = mediaId + "," + strMagId + "," + strPublishId + ",'未发行','" + mediaType + "','" + db.UserID + "'"; db.SetMediaPublish(0, 0, fieldlist, "", valuelist, out id); } } ///发行状态更新 String wheresql1 = "发行编号=" + txtId.Text; String valuesql1 = "期刊状态='发行中'"; if (db.SetPublish(0, 1, "", wheresql1, valuesql1, out id) && id == 1) { string msg = NCMessage.GetInstance(db.Language).GetMessageById("CM0081I", db.Language); MessageBox.Show(msg); init(); } else { string msg = NCMessage.GetInstance(db.Language).GetMessageById("CM0082I", db.Language); MessageBox.Show(msg); } } else { string msg = NCMessage.GetInstance(db.Language).GetMessageById("CM0074I", db.Language); MessageBox.Show(msg); } } else { string msg = NCMessage.GetInstance(db.Language).GetMessageById("CM0069I", db.Language); MessageBox.Show(msg); } }