private void InitDict()
{
try
{
CustomerDAC dacCustomer = new CustomerDAC();
customer.Items.Clear();
List <CustomerEntity> lstCustomer = dacCustomer.SelectAll();
foreach (CustomerEntity entity in lstCustomer)
{
customer.Items.Add(entity.customer);
}
SysDictDAC dacSys = new SysDictDAC();
model.Items.Clear();
List <SysDictEntity> lstDict = dacSys.SelectList("model");
foreach (SysDictEntity entity in lstDict)
{
model.Items.Add(entity.dictvalue);
}
goodname.Items.Clear();
lstDict = dacSys.SelectList("goodname");
foreach (SysDictEntity entity in lstDict)
{
goodname.Items.Add(entity.dictvalue);
}
}
catch (Exception ex)
{
MessageBox.Show("提取字典出错，请检查网络是否异常！\r\n原因如下:" + ex.Message);
}
}
private void InitCombo()
{
dtpStart.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 0, 0, 0);
dtpEnd.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 23, 59, 59);
try
{
CustomerDAC dacCustomer = new CustomerDAC();
customer.Items.Clear();
List <CustomerEntity> lstCustomer = dacCustomer.SelectAll();
foreach (CustomerEntity entity in lstCustomer)
{
customer.Items.Add(entity.customer);
}
SysDictDAC dacSys = new SysDictDAC();
specifications.Items.Clear();
List <SysDictEntity> lstDict = dacSys.SelectList("deliveryspec");
foreach (SysDictEntity entity in lstDict)
{
specifications.Items.Add(entity.dictvalue);
}
goodname.Items.Clear();
lstDict = dacSys.SelectList("goodname");
foreach (SysDictEntity entity in lstDict)
{
goodname.Items.Add(entity.dictvalue);
}
}
catch (Exception ex)
{
MessageBox.Show("读取数据库出错，请检查网络;\r\n原因:" + ex.Message);
}
}