public List <C_Ftp> GetEntities(EnmFtp type)
{
SqlParameter[] parms = { new SqlParameter("@Type", SqlDbType.Int) };
parms[0].Value = (int)type;
var entities = new List <C_Ftp>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_C_FTP_Repository_GetFTPInType, parms)) {
while (rdr.Read())
{
var entity = new C_Ftp();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.Type = SqlTypeConverter.DBNullFtpHandler(rdr["Type"]);
entity.IP = SqlTypeConverter.DBNullStringHandler(rdr["IP"]);
entity.Port = SqlTypeConverter.DBNullInt32Handler(rdr["Port"]);
entity.User = SqlTypeConverter.DBNullStringHandler(rdr["User"]);
entity.Password = SqlTypeConverter.DBNullStringHandler(rdr["Password"]);
entity.Directory = SqlTypeConverter.DBNullStringHandler(rdr["Directory"]);
entity.Remark = SqlTypeConverter.DBNullStringHandler(rdr["Remark"]);
entities.Add(entity);
}
}
return(entities);
}
private List <FileModel> GetFtpFiles(C_Ftp ftp)
{
var files = new List <FileModel>();
using (FtpClient conn = new FtpClient()) {
conn.Host = ftp.IP;
conn.Port = ftp.Port;
conn.Credentials = new NetworkCredential(ftp.User, ftp.Password);
conn.SetWorkingDirectory(ftp.Directory);
var index = 0;
foreach (var item in conn.GetListing(conn.GetWorkingDirectory(), FtpListOption.Modify | FtpListOption.Size))
{
if (item.Type == FtpFileSystemObjectType.File)
{
files.Add(new FileModel {
index = ++index,
name = item.Name,
size = string.Format("{0:N0} KB", item.Size / 1024),
type = CommonHelper.GetFileType(item.Name),
date = CommonHelper.DateTimeConverter(item.Modified)
});
}
}
}
return(files);
}
private string GetFtpKey(C_Ftp ftp)
{
if (ftp == null)
{
throw new ArgumentNullException("ftp");
}
return(string.Format("ftp://{0}:{1}/{2}", ftp.IP, ftp.Port, ftp.Directory));
}
public JsonResult Login(string ip, int port, string user, string password, string directory)
{
try {
if (string.IsNullOrWhiteSpace(ip))
{
throw new ArgumentNullException("ip");
}
if (string.IsNullOrWhiteSpace(user))
{
throw new ArgumentNullException("user");
}
if (string.IsNullOrWhiteSpace(password))
{
throw new ArgumentNullException("password");
}
if (string.IsNullOrWhiteSpace(directory))
{
throw new ArgumentNullException("directory");
}
using (FtpClient conn = new FtpClient()) {
conn.Host = ip;
conn.Port = port;
conn.Credentials = new NetworkCredential(user, password);
conn.SetWorkingDirectory(directory);
conn.Connect();
}
var ftp = new C_Ftp {
Name = "手动认证", IP = ip, Port = port, User = user, Password = password, Directory = directory
};
var key = this.GetFtpKey(ftp);
_cacheManager.Set(string.Format(GlobalCacheKeys.Ftp_Info_Cfg, key), ftp, TimeSpan.FromDays(1));
return(Json(new AjaxResultModel {
success = true, code = 200, message = key
}));
} catch (Exception exc) {
return(Json(new AjaxResultModel {
success = false, code = 400, message = exc.Message
}));
}
}
public ActionResult FsuLog(string fsu)
{
var ext = _fsuService.GetExtFsu(fsu);
if (ext != null)
{
var ftp = new C_Ftp {
IP = ext.IP,
Port = 21,
User = ext.FtpUid,
Password = ext.FtpPwd,
Directory = "logs"
};
var key = this.GetFtpKey(ftp);
_cacheManager.Set(string.Format(GlobalCacheKeys.Ftp_Info_Cfg, key), ftp, TimeSpan.FromHours(1));
ViewBag.FTPKey = key;
}
return(View("Index"));
}
public List <C_Ftp> GetEntities()
{
var entities = new List <C_Ftp>();
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Rs.Sql_C_FTP_Repository_GetFTPs, null)) {
while (rdr.Read())
{
var entity = new C_Ftp();
entity.Id = SqlTypeConverter.DBNullStringHandler(rdr["Id"]);
entity.Name = SqlTypeConverter.DBNullStringHandler(rdr["Name"]);
entity.Type = SqlTypeConverter.DBNullFtpHandler(rdr["Type"]);
entity.IP = SqlTypeConverter.DBNullStringHandler(rdr["IP"]);
entity.Port = SqlTypeConverter.DBNullInt32Handler(rdr["Port"]);
entity.User = SqlTypeConverter.DBNullStringHandler(rdr["User"]);
entity.Password = SqlTypeConverter.DBNullStringHandler(rdr["Password"]);
entity.Directory = SqlTypeConverter.DBNullStringHandler(rdr["Directory"]);
entity.Remark = SqlTypeConverter.DBNullStringHandler(rdr["Remark"]);
entities.Add(entity);
}
}
return(entities);
}
