/// <summary>
/// 读取id对应的附件列表
/// </summary>
/// <param name="id"></param>
/// <param name="conn"></param>
/// <returns></returns>
private static ProductAttachmentList ReadProductAttachmentList(int id, SQLiteConnection conn)
{
ProductAttachmentList attList = new ProductAttachmentList();
using (SQLiteCommand cmd = new SQLiteCommand(conn))
{
cmd.CommandText = "select * from ProductAttachment where ProductID=@ProductID;";
cmd.Parameters.Add(new SQLiteParameter("@ProductID", id));
using (SQLiteDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
// 获取产品基本信息
int productID = int.Parse(dr["ProductID"].ToString());
AttachmentType type = (AttachmentType)Enum.Parse(typeof(AttachmentType), dr["AttachmentType"].ToString());
string path = dr["AttachmentPath"].ToString();
int? ftpID = null;
if (Convert.IsDBNull(dr["FtpID"]))
{
ftpID = null;
}
else
{
ftpID = int.Parse(dr["FtpID"].ToString());
}
ProductAttachment att = new ProductAttachment(productID, type, path, ftpID);
attList.Add(att);
} //eof while
} //eof dr
} //eof cmd
return(attList);
}
/// <summary>
/// 附件删除（内存）
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void menuAttachmentDel_Click(object sender, EventArgs e)
{
if (lvAttachment.SelectedItems.Count > 0)
{
ProductAttachment att = (ProductAttachment)lvAttachment.SelectedItems[0].Tag;
Product.ProductAttachmentList.Remove(att); // 删除对象
ResetAttachmentList(); // 刷新界面
}
}
/// <summary>
/// 附件增加（内存）
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void menuAttachmentAdd_Click(object sender, EventArgs e)
{
ProductAttachment tmpAtt = new ProductAttachment(Product.Id, AttachmentType.磁盘路径, string.Empty, null);
using (ProductAttachmentEditDialog dlg = new ProductAttachmentEditDialog(Product.ProductAttachmentList, tmpAtt))
{
if (dlg.ShowDialog() == DialogResult.OK)
{
// 增加对象
Product.ProductAttachmentList.Add(tmpAtt);
// 刷新界面
ResetAttachmentList();
}
}
}
/// <summary>
/// 附件修改（内存）
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void menuAttachmentEdit_Click(object sender, EventArgs e)
{
if (lvAttachment.SelectedItems.Count > 0)
{
ProductAttachment att = (ProductAttachment)lvAttachment.SelectedItems[0].Tag;
using (ProductAttachmentEditDialog dlg = new ProductAttachmentEditDialog(Product.ProductAttachmentList, att))
{
if (dlg.ShowDialog() == DialogResult.OK)
{
// 刷新界面
ResetAttachmentList();
}
}
}
}
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();
}
