private bool ApplyFtp() { string ss = "select mkey,mvalue from dbo.ConSystem where mParentID=(select mid from dbo.ConSystem where mKey='FTP')"; SqlConnection sc = MSSQLDB.CreateDBConnet(); try { sc.Open(); SqlCommand scmd = new SqlCommand(ss, sc); SqlDataAdapter sda = new SqlDataAdapter(scmd); DataTable dt = new DataTable(); sda.Fill(dt); if (dt.Rows.Count == 4) { string ftpAddress="", ftpPort="", ftpUser="", ftppassword=""; foreach (DataRow dr in dt.Rows) { if (dr[0].ToString() == "Address") { ftpAddress = dr[1].ToString(); continue; } if (dr[0].ToString() == "Port") { ftpPort = dr[1].ToString(); continue; } if (dr[0].ToString() == "User") { ftpUser = dr[1].ToString(); continue; } if (dr[0].ToString() == "password") { ftppassword = dr[1].ToString(); continue; } } if (ftpAddress.Length <= 0 || ftpPort.Length <= 0 || ftpUser.Length <= 0 || ftppassword.Length <= 0) { } else {//注意默认路径下,有xps和doc两个文件夹,分别对应原始和现在需要的文件,下载必须使用xps,否则客户端无法解读。 fw = new FtpWeb(ftpAddress, ftpPort, @"xps", ftpUser, ftppassword); sc.Close(); return true; } } sfailedopen = "FTP设置错误!"; sc.Close(); return false; } catch {} sfailedopen = MSSQLDB.error; return false; }
//public Agendo(string sid, string sname,FtpWeb fw,MemoryStream ms) //{ // Init(sid, sname, fw); // xpscontent = CreateXpsDocument(ms); //} //public Agendo(string sid, string sname, FtpWeb fw, string sContent) //{ // Init(sid, sname, fw); // xpscontent = CreateXpsDocument(sContent); //} public Agendo(string sid, string sname, FtpWeb fw, IDocumentPaginatorSource ids, DateTime dtstart, DateTime dtend) { Init(sid, sname, fw); xpscontent = ids; initDatetime(dtstart, dtend); }
public Agendo(string sid,string sname,FtpWeb fw) { Init(sid,sname,fw); }
public Agendo(string sid,string sname,FtpWeb fw, IDocumentPaginatorSource Content) { Init(sid, sname, fw); xpscontent = Content; }
private void Init(string sid, string sname, FtpWeb fw) { mId = sid; gfw = fw; name = sname; }