/// <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(); }