/// <summary> /// 期刊备份,期刊发行数据复制到期刊发行历史记录中 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnBackup_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count > 0) { int id = 0; String wheresql = "发行编号=" + txtId.Text; DataSet ds_Send = new DataSet(); if (db.GetSend(0, 0, "*", wheresql, "", ref ds_Send) && ds_Send.Tables[0].Rows.Count > 0) { ///送信备份 foreach (DataRow row in ds_Send.Tables[0].Rows) { String sendid = row["送信编号"].ToString(); string strPublishId = row["发行编号"].ToString();; string strMagId = row["期刊编号"].ToString();; String customerid = row["客户编号"].ToString(); string strStatus = row["送信状态"].ToString();; string strServer = row["服务器名称"].ToString();; string strMsgId = row["信息编号"].ToString();; string strUserId = row["UserID"].ToString();; String fieldlist = "送信编号,发行编号,期刊编号,客户编号,送信状态,服务器名称,信息编号,UserID"; String valuelist = sendid + "," + strPublishId + "," + strMagId + "," + customerid + ",'" + strStatus + "','" + strServer + "','" + strMsgId + "','" + strUserId + "'"; db.SetHistory(0, 0, fieldlist, "", valuelist, out id); db.SetSend(0, 2, "", "送信编号=" + sendid, "", out id); } ///FTP上传备份 DataSet ds_FTP = new DataSet(); if (db.GetFTPUpload(0, 0, "*", wheresql, "", ref ds_FTP) && ds_FTP.Tables[0].Rows.Count > 0) { ///FTP上传备份 foreach (DataRow row in ds_FTP.Tables[0].Rows) { String uploadid = row["上传编号"].ToString(); string strPublishId = row["发行编号"].ToString();; string strMagId = row["期刊编号"].ToString();; String ftpid = row["FTP编号"].ToString(); string strStatus = row["上传状态"].ToString();; string strName = row["上传名称"].ToString();; string strUserId = row["UserID"].ToString();; String fieldlist = "上传编号,发行编号,期刊编号,FTP编号,上传状态,上传名称,UserID"; String valuelist = uploadid + "," + strPublishId + "," + strMagId + "," + ftpid + ",'" + strStatus + "','" + strName + "','" + strUserId + "'"; db.SetFTPHistory(0, 0, fieldlist, "", valuelist, out id); db.SetFTPUpload(0, 2, "", "上传编号=" + uploadid, "", out id); } } ///媒体发布备份 DataSet ds_Media = new DataSet(); if (db.GetMediaPublish(0, 0, "*", wheresql, "", ref ds_Media) && ds_Media.Tables[0].Rows.Count > 0) { ///媒体发布备份 foreach (DataRow row in ds_Media.Tables[0].Rows) { String mediapublishid = row["发布编号"].ToString(); string strPublishId = row["发行编号"].ToString();; string strMagId = row["期刊编号"].ToString();; String mediaid = row["媒体编号"].ToString(); string strStatus = row["发行状态"].ToString();; string strName = row["媒体名称"].ToString();; string strMsgId = row["信息编号"].ToString();; string strUserId = row["UserID"].ToString();; String fieldlist = "发布编号,发行编号,期刊编号,媒体编号,发行状态,媒体名称,信息编号,UserID"; String valuelist = mediapublishid + "," + strPublishId + "," + strMagId + "," + mediaid + ",'" + strStatus + "','" + strName + "','" + strMsgId + "','" + strUserId + "'"; db.SetMediaHistory(0, 0, fieldlist, "", valuelist, out id); db.SetMediaPublish(0, 2, "", "上传编号=" + mediapublishid, "", out id); } } ///期刊状态更新 String valuesql = "期刊状态='发行完'"; if (db.SetPublish(0, 1, "", wheresql, valuesql, out id) && id == 1) { string msg = NCMessage.GetInstance(db.Language).GetMessageById("CM0075I", db.Language); MessageBox.Show(msg); init(); } else { string msg = NCMessage.GetInstance(db.Language).GetMessageById("CM0076I", db.Language); MessageBox.Show(msg); } } else { string msg = NCMessage.GetInstance(db.Language).GetMessageById("CM0077I", db.Language); MessageBox.Show(msg); } } else { string msg = NCMessage.GetInstance(db.Language).GetMessageById("CM0069I", db.Language); MessageBox.Show(msg); } }