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