/// <summary> /// 读取id对应的收件人列表 /// </summary> /// <param name="id"></param> /// <param name="conn"></param> /// <returns></returns> private static ProductReceiverList ReadProductReceiver(int id, SQLiteConnection conn) { ProductReceiverList receiverList = new ProductReceiverList(); string query = string.Format("select * from ProductReceiver where ProductID='{0}';", id); using (SQLiteCommand cmd = new SQLiteCommand(query, conn)) { using (SQLiteDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { // 获取产品基本信息 int productID = int.Parse(dr["ProductID"].ToString()); string emailAddress = dr["EmailAddress"].ToString(); ReceiverType receiverType = (ReceiverType)Enum.Parse(typeof(ReceiverType), dr["ReceiverType"].ToString()); ProductReceiver receiver = new ProductReceiver(productID, emailAddress, receiverType); receiverList.Add(receiver); } //eof while } //eof dr } //eof cmd return(receiverList); }
public ProductReceiverEditDialog(ProductReceiverList receiverList, ProductReceiver receiver) { InitializeComponent(); _receiverList = receiverList; _receiver = receiver; ResetDialog(); }
//构造函数 public Product(int id, string productName, string mailTitle, string mailContent, bool disable, ProductAttachmentList attachmentList, ProductReceiverList receiverList, bool isCredit, bool isDelay, int?delaySeconds) { _id = id; _productName = productName; _mailTitle = mailTitle; _mailContent = mailContent; _disable = disable; _attachmentList = attachmentList; _receiverList = receiverList; _isCredit = isCredit; _isDelay = isDelay; _delaySeconds = delaySeconds; }
/// <summary> /// 读取一个产品 /// </summary> /// <param name="id"></param> /// <returns></returns> public static Product ReadProduct(int id) { Product product = null; try { using (SQLiteConnection cn = new SQLiteConnection(ConfigurationManager.AppSettings["conn"])) { cn.Open(); using (SQLiteCommand cmd = new SQLiteCommand(cn)) { cmd.CommandText = "select * from Product where ID=@ID"; cmd.Parameters.Add(new SQLiteParameter("@ID", id)); using (SQLiteDataReader dr = cmd.ExecuteReader()) { if (dr.HasRows) { dr.Read(); string productName = dr["ProductName"].ToString(); string mailTitle = dr["MailTitle"].ToString(); string mailContent = dr["MailContent"].ToString(); bool disable = bool.Parse(dr["Disable"].ToString()); bool isCredit = bool.Parse(dr["IsCredit"].ToString()); bool isDelay = bool.Parse(dr["IsDelay"].ToString()); // 2019-03-20发送前延迟是否单独设置 int? delaySeconds = null; // 2019-03-20发送前延迟秒数 if (Convert.IsDBNull(dr["DelaySeconds"])) { delaySeconds = null; } else { delaySeconds = int.Parse(dr["DelaySeconds"].ToString()); } // 获取附件列表 ProductAttachmentList attList = ReadProductAttachmentList(id, cn); // 获取收件人列表 ProductReceiverList receiverList = ReadProductReceiver(id, cn); product = new Product( id: id, productName: productName, mailTitle: mailTitle, mailContent: mailContent, disable: disable, attachmentList: attList, receiverList: receiverList, isCredit: isCredit, isDelay: isDelay, delaySeconds: delaySeconds); } else { throw new Exception(string.Format(@"记录ID[{0}]不存在!", id)); } } //eof dr } //eof cmd } //eof conn } catch (Exception ex) { throw new Exception(ex.Message); } return(product); }
/// <summary> /// 读取产品列表 /// </summary> /// <returns></returns> public static ProductList ReadProductlist() { ProductList productList = new ProductList(); try { using (SQLiteConnection cn = new SQLiteConnection(ConfigurationManager.AppSettings["conn"])) { cn.Open(); string query = "select * from Product"; using (SQLiteCommand cmd = new SQLiteCommand(query, cn)) { using (SQLiteDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { // 获取产品基本信息 int id = int.Parse(dr["ID"].ToString()); string productName = dr["ProductName"].ToString(); string mailTitle = dr["MailTitle"].ToString(); string mailContent = dr["MailContent"].ToString(); bool disable = bool.Parse(dr["Disable"].ToString()); bool isCredit = bool.Parse(dr["IsCredit"].ToString()); // 2018-12-20是否信用 bool isDelay = bool.Parse(dr["IsDelay"].ToString()); // 2019-03-20发送前延迟是否单独设置 int? delaySeconds = null; // 2019-03-20发送前延迟秒数 if (Convert.IsDBNull(dr["DelaySeconds"])) { delaySeconds = null; } else { delaySeconds = int.Parse(dr["DelaySeconds"].ToString()); } // 获取附件列表 ProductAttachmentList attList = ReadProductAttachmentList(id, cn); // 获取收件人列表 ProductReceiverList receiverList = ReadProductReceiver(id, cn); Product product = new Product( id: id, productName: productName, mailTitle: mailTitle, mailContent: mailContent, disable: disable, attachmentList: attList, receiverList: receiverList, isCredit: isCredit, isDelay: isDelay, delaySeconds: delaySeconds); productList.Add(product); } //eof while } //eof dr } //eof cmd } //eof conn } catch (Exception ex) { throw new Exception(ex.Message); } return(productList); }