public ProductAttachmentEditDialog(ProductAttachmentList attList, ProductAttachment att)
{
InitializeComponent();
_attList = attList;
_att = att;
// 加载ftp列表
_ftpList = MailFtpStorage.ReadMailFtpList();
cbFtp.Items.Clear();
foreach (MailFtp ftp in _ftpList)
{
cbFtp.Items.Add(new ComboBoxFtpItem(ftp.FtpDesc, ftp.Id));
}
ResetDialog();
}
/// <summary>
/// 读取FTP列表
/// </summary>
/// <returns></returns>
public static MailFtpList ReadMailFtpList()
{
MailFtpList mailFtpList = new MailFtpList();
try
{
using (SQLiteConnection cn = new SQLiteConnection(ConfigurationManager.AppSettings["conn"]))
{
cn.Open();
string query = "select * from MailFtp";
using (SQLiteCommand cmd = new SQLiteCommand(query, cn))
{
using (SQLiteDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
// 获取产品基本信息
int id = int.Parse(dr["ID"].ToString());
string ftpDesc = dr["FtpDesc"].ToString();
string ftpServer = dr["FtpServer"].ToString();
string userName = dr["UserName"].ToString();
string password = dr["Password"].ToString();
string defaultPath = dr["DefaultPath"].ToString();
MailFtp mailFtp = new MailFtp(id, ftpDesc, ftpServer, userName, password, defaultPath);
mailFtpList.Add(mailFtp);
} //eof while
} //eof dr
} //eof cmd
} //eof conn
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(mailFtpList);
}
public void ReloadFtpList()
{
_mailFtpList = MailFtpStorage.ReadMailFtpList(); // 读取FTP信息
}
