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