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