/// <summary>
/// 初始化
/// </summary>
private void init()
{
DataSet ds_ftp = new DataSet();
if (db.GetFTPUploadVW(0, 0, "*", "", "", ref ds_ftp))
{
dataGridView3.DataSource = ds_ftp.Tables[0];
lblFileUploadN.Text = Convert.ToString(ds_ftp.Tables[0].Rows.Count);
}
}
/**
*ＦＴＰアップロードタスク
*アップロードしないタスクを実行する
*/
private static void FtpUpload()
{
DataSet ds = new DataSet();
String strWhere = "上传状态='未上传'";
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, "未上传");
}
}
}
}
/// <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);
}
}
