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); } }
private void Form1_Load(object sender, EventArgs e) { 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); SysDictDAC dacSys = new SysDictDAC(); target.Items.Clear(); try { List <SysDictEntity> lstDict = dacSys.SelectList("target"); foreach (SysDictEntity entity in lstDict) { target.Items.Add(entity.dictvalue); } } catch (Exception ex) { MessageBox.Show("数据库错误,请联系管理员"); } Refresh(); }
private void InitGrid() { GridPanel panel = superGrid.PrimaryGrid; try { SysDictDAC dacSys = new SysDictDAC(); List <SysDictEntity> lstDict = dacSys.SelectList("deliveryspec"); if (lstDict.Count > 0) { string[] specArray = new string[lstDict.Count]; int i = 0; foreach (SysDictEntity entity in lstDict) { specArray[i] = entity.dictvalue; i++; } panel.Columns["specifications"].EditorType = typeof(FragrantComboBox); panel.Columns["specifications"].EditorParams = new object[] { specArray }; } } catch (Exception ex) { MessageBox.Show("提取字典出错,请检查网络是否异常!\r\n原因如下:" + ex.Message); } if (objNote != null & EditMode > 0) { if (EditMode == 2) { noteid.Text = objNote.noteid.ToString(); deliverid.Text = objNote.deliverid.ToString().PadLeft(3, '0'); customer.Enabled = false; } customer.Text = objNote.customer; model.Text = objNote.model; deliverdate.Value = objNote.deliverdate; goodname.Text = objNote.goodname; batch.Text = objNote.batch; description.Text = objNote.description; description1.Text = objNote.description1; if (objNote.items != null) { foreach (DeliveryItem item in objNote.items) { GridRow newRow = new GridRow( item.jiannum, item.specifications, item.lenght, item.discnum, item.weight, Math.Round(item.price, 5), Math.Round(item.totalprice, 5), item.contractno, item.netweight, item.coreweight ); panel.Rows.Add(newRow); } } } }
private void frmQualityTracking_Load(object sender, EventArgs e) { try { SysDictDAC dacSys = new SysDictDAC(); specifications.Items.Clear(); List <SysDictEntity> lstDict = dacSys.SelectList("qtspec"); foreach (SysDictEntity entity in lstDict) { specifications.Items.Add(entity.dictvalue); } category.Items.Clear(); lstDict = dacSys.SelectList("qtcategory"); foreach (SysDictEntity entity in lstDict) { category.Items.Add(entity.dictvalue); } target.Items.Clear(); lstDict = dacSys.SelectList("target"); foreach (SysDictEntity entity in lstDict) { target.Items.Add(entity.dictvalue); } } catch (Exception ex) { MessageBox.Show("提取字典出错,请检查网络是否异常!\r\n原因如下:" + ex.Message); } if (objTracking != null & EditMode > 0) { qtdate.Value = objTracking.qtdate; category.Text = objTracking.category; if (EditMode == 1) { batch.Text = ""; } else { batch.Text = objTracking.batch; } specifications.Text = objTracking.specifications; length.Text = objTracking.length.ToString(); volume.Text = objTracking.volume; stripping1.Text = objTracking.stripping1; stripping2.Text = objTracking.stripping2; sample11.Text = objTracking.sample11; sample12.Text = objTracking.sample12; sample13.Text = objTracking.sample13; sample21.Text = objTracking.sample21; sample22.Text = objTracking.sample22; sample23.Text = objTracking.sample23; baseheight.Text = objTracking.baseheight; measuredheight.Text = objTracking.measuredheight; compositeheight.Text = objTracking.compositeheight; cutheight.Text = objTracking.cutheight; bubblewater1.Text = objTracking.bubblewater1; bubblewater2.Text = objTracking.bubblewater2; bubbleoil.Text = objTracking.bubbleoil; descrtiption.Text = objTracking.descrtiption; target.Text = objTracking.target; elongation.Text = objTracking.elongation; elongation1.Text = objTracking.elongation1; if (objTracking.type != null) { type.Text = objTracking.type; } if (objTracking.decision != null) { decision.Text = objTracking.decision; } } }