/// <summary> /// 初期化 /// </summary> private void init() { DataSet ds = new DataSet(); if (db.GetPublish(0, 0, "发行编号,期刊编号,发行期号,发行日期,期刊状态,文件链接,本地文件,FTP文件,图片链接,本地图片,FTP图片,文本内容,邮件内容,S期刊编号,S发行编号", "期刊编号=" + MagId, "", ref ds)) { dataGridView1.DataSource = ds.Tables[0]; } }
/// <summary> /// 初期化 /// </summary> private void init() { string MagId = PageData["MagId"].ToString(); DataSet ds = new DataSet(); if (db.GetPublish(0, 0, "发行编号,发行期号", "期刊编号=" + MagId, "", ref ds)) { cmbMagzineNo.DataSource = ds.Tables[0]; cmbMagzineNo.DisplayMember = "发行期号"; ButtonStateNext |= WizardButtonState.Enabled; } }
/// <summary> /// 期刊存在检查 /// </summary> /// <returns></returns> private Boolean checkMagNo() { string MagId = PageData["MagId"].ToString(); DataSet ds = new DataSet(); if (db.GetPublish(0, 0, "count(*)", "期刊编号=" + MagId + " AND 发行期号='" + txtMagzineNo.Text + "'", "", ref ds)) { int count = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString()); if (count > 0) { return(false); } } return(true); }
/// <summary> /// 删除期刊和相关的发行数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnDelete_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count > 0) { int id = 0; String wheresql = "期刊编号=" + txtId.Text; DataSet ds = new DataSet(); if (db.GetPublish(0, 0, "*", wheresql, "", ref ds)) { foreach (DataRow dr in ds.Tables[0].Rows) { String PublishId = dr[0].ToString(); deletePublish(PublishId); } } wheresql = "编号=" + txtId.Text; if (db.SetMag(0, 2, "", wheresql, "", out id) && id == 2) { wheresql = "S期刊编号=" + lblSID.Text; if (db.SetSMag(0, 2, "", wheresql, "", out id) && id == 2) { string msg = NCMessage.GetInstance(db.Language).GetMessageById("CM0034I", db.Language); MessageBox.Show(msg); string isLocal = ""; if (chbIslocal.Checked) { isLocal = "Y"; } init(cmbBig4s.Text, cmbMiddle4s.Text, cmbSmall4s.Text, isLocal); } else { string msg = NCMessage.GetInstance(db.Language).GetMessageById("CM0035I", db.Language); MessageBox.Show(msg); } } else { string msg = NCMessage.GetInstance(db.Language).GetMessageById("CM0035I", db.Language); MessageBox.Show(msg); } } else { string msg = NCMessage.GetInstance(db.Language).GetMessageById("CM0029I", db.Language); MessageBox.Show(msg); } }
/// <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); } }