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 btnSave_Click(object sender, EventArgs e) { bool saveInsert; string sRet = CheckForm(out saveInsert); if (sRet.Length > 0) { MessageBox.Show(sRet); return; } DeliveryNote EditNote = new DeliveryNote(); if (EditMode == 2) { EditNote.noteid = int.Parse(noteid.Text); EditNote.deliverid = int.Parse(deliverid.Text); if (objNote == null) { EditNote.sdate = DateTime.Now; } else { EditNote.sdate = objNote.sdate; } } else { EditNote.sdate = DateTime.Now; } EditNote.customer = customer.Text.Trim(); EditNote.model = model.Text.Trim(); EditNote.deliverdate = deliverdate.Value; EditNote.goodname = goodname.Text.Trim(); EditNote.batch = batch.Text; EditNote.description = description.Text; EditNote.description1 = description1.Text; EditNote.loginid = Global.LoginUser.loginid; SysDictDAC dac = new SysDictDAC(); SysDictEntity dictEntity = dac.Select("model", EditNote.model); if (dictEntity == null) { dictEntity = new SysDictEntity(); dictEntity.dictype = "model"; dictEntity.dictvalue = EditNote.model; dac.Add(dictEntity); } dictEntity = null; dictEntity = dac.Select("goodname", EditNote.goodname); if (dictEntity == null) { dictEntity = new SysDictEntity(); dictEntity.dictype = "goodname"; dictEntity.dictvalue = EditNote.goodname; dac.Add(dictEntity); } dictEntity = null; GridPanel panel = superGrid.PrimaryGrid; if (panel.Rows.Count > 0) { List <DeliveryItem> DeliveryItems = new List <DeliveryItem>(); for (int i = 0; i < panel.Rows.Count; i++) { DeliveryItem item = new DeliveryItem(); GridRow curRow = panel.Rows[i] as GridRow; bool bSave = false; if (!curRow.IsInsertRow) { bSave = true; } else { bSave = saveInsert; } if (bSave) { item.noteid = EditNote.noteid; item.jiannum = ControlHelper.Object2String(curRow["jiannum"].Value); string spec = ControlHelper.Object2String(curRow["specifications"].Value); dictEntity = dac.Select("deliveryspec", spec); if (dictEntity == null) { dictEntity = new SysDictEntity(); dictEntity.dictype = "deliveryspec"; dictEntity.dictvalue = spec; dac.Add(dictEntity); } dictEntity = null; item.specifications = spec; item.lenght = ControlHelper.Object2Int(curRow["lenght"].Value); item.discnum = ControlHelper.Object2Int(curRow["discnum"].Value); item.weight = ControlHelper.Object2Double(curRow["weight"].Value); item.price = ControlHelper.Object2Double(curRow["price"].Value.ToString()); item.totalprice = ControlHelper.Object2Double(curRow["totalprice"].Value); item.contractno = ControlHelper.Object2String(curRow["contractno"].Value); item.netweight = ControlHelper.Object2Double(curRow["netweight"].Value); item.coreweight = ControlHelper.Object2Double(curRow["coreweight"].Value.ToString()); DeliveryItems.Add(item); } } EditNote.items = DeliveryItems; } DeliveryDAC dacDelivery = new DeliveryDAC(); if (EditMode == 0 || EditMode == 1) { bool bRet = false; try { bRet = dacDelivery.Add(EditNote); } catch (Exception ex) { MessageBox.Show("操作数据库出错,请检查网络;\r\n原因:" + ex.Message); return; } if (bRet) { if (MessageBox.Show("保存成功,是否继续新建送货单?", "提示", MessageBoxButtons.YesNo) == DialogResult.No) { this.DialogResult = DialogResult.OK; this.Close(); } else { EditMode = 1; InitVar(); } } else { MessageBox.Show("保存失败"); } } else { try { dacDelivery.Update(EditNote); } catch (Exception ex) { MessageBox.Show("操作数据库出错,请检查网络;\r\n原因:" + ex.Message); return; } MessageBox.Show("保存成功"); this.DialogResult = DialogResult.OK; this.Close(); } }
private void btnOk_Click(object sender, EventArgs e) { if (!ControlHelper.isNumeric(length.Text)) { MessageBox.Show("规格必须为数字!"); length.Focus(); return; } if (batch.Text.Trim().Length == 0) { MessageBox.Show("必须输入批号"); batch.Focus(); return; } try { SysDictDAC dacSys = new SysDictDAC(); SysDictEntity objEntity = dacSys.Select("qtspec", specifications.Text.Trim()); if (objEntity == null) { SysDictEntity newSysEntity = new SysDictEntity(); newSysEntity.dictype = "qtspec"; newSysEntity.dictvalue = specifications.Text.Trim(); dacSys.Add(newSysEntity); } objEntity = dacSys.Select("qtcategory", category.Text.Trim()); if (objEntity == null) { SysDictEntity newSysEntity = new SysDictEntity(); newSysEntity.dictype = "qtcategory"; newSysEntity.dictvalue = category.Text.Trim(); dacSys.Add(newSysEntity); } objEntity = dacSys.Select("target", target.Text.Trim()); if (objEntity == null) { SysDictEntity newSysEntity = new SysDictEntity(); newSysEntity.dictype = "target"; newSysEntity.dictvalue = target.Text.Trim(); dacSys.Add(newSysEntity); } } catch (Exception ex) { MessageBox.Show("保存字典出错,请检查网络是否异常!\r\n原因如下:" + ex.Message); } QualityTrackingDAC dac = new QualityTrackingDAC(); if (EditMode == 0 || EditMode == 1) { QualityTrackingEntity entity = new QualityTrackingEntity(); entity.qtdate = qtdate.Value; entity.category = category.Text; entity.batch = batch.Text; entity.specifications = specifications.Text; if (length.Text.Trim().Length == 0) { entity.length = 0; } else { entity.length = int.Parse(length.Text); } entity.volume = volume.Text; entity.stripping1 = stripping1.Text; entity.stripping2 = stripping2.Text; entity.sample11 = sample11.Text; entity.sample12 = sample12.Text; entity.sample13 = sample13.Text; entity.sample21 = sample21.Text; entity.sample22 = sample22.Text; entity.sample23 = sample23.Text; entity.baseheight = baseheight.Text; entity.measuredheight = measuredheight.Text; entity.compositeheight = compositeheight.Text; entity.cutheight = cutheight.Text; entity.bubblewater1 = bubblewater1.Text; entity.bubblewater2 = bubblewater2.Text; entity.bubbleoil = bubbleoil.Text; entity.descrtiption = descrtiption.Text; entity.loginid = Global.LoginUser.loginid; entity.target = target.Text; entity.elongation = elongation.Text.Trim(); entity.elongation1 = elongation1.Text.Trim(); entity.type = type.Text; entity.decision = decision.Text; int id = 0; try { id = dac.Insert(entity); } catch (Exception ex) { MessageBox.Show("新增出错,请检查网络是否异常!\r\n原因如下:" + ex.Message); } if (id > 0) { if (MessageBox.Show("保存成功,是否继续添加?", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { batch.Text = ""; qtdate.Focus(); } else { this.DialogResult = DialogResult.OK; this.Close(); } } else { MessageBox.Show("保存失败!"); } } else { if (objTracking == null) { MessageBox.Show("系统错误"); return; } objTracking.qtdate = qtdate.Value; objTracking.category = category.Text; objTracking.batch = batch.Text; objTracking.specifications = specifications.Text; if (length.Text.Trim().Length == 0) { objTracking.length = 0; } else { objTracking.length = int.Parse(length.Text); } objTracking.volume = volume.Text; objTracking.stripping1 = stripping1.Text; objTracking.stripping2 = stripping2.Text; objTracking.sample11 = sample11.Text; objTracking.sample12 = sample12.Text; objTracking.sample13 = sample13.Text; objTracking.sample21 = sample21.Text; objTracking.sample22 = sample22.Text; objTracking.sample23 = sample23.Text; objTracking.baseheight = baseheight.Text; objTracking.measuredheight = measuredheight.Text; objTracking.compositeheight = compositeheight.Text; objTracking.cutheight = cutheight.Text; objTracking.bubblewater1 = bubblewater1.Text; objTracking.bubblewater2 = bubblewater2.Text; objTracking.bubbleoil = bubbleoil.Text; objTracking.descrtiption = descrtiption.Text; objTracking.loginid = Global.LoginUser.loginid; objTracking.target = target.Text; objTracking.elongation = elongation.Text; objTracking.elongation1 = elongation1.Text; objTracking.type = type.Text; objTracking.decision = decision.Text; int id = 0; try { id = dac.Update(objTracking); } catch (Exception ex) { MessageBox.Show("保存出错,请检查网络是否异常!\r\n原因如下:" + ex.Message); } if (id > 0) { MessageBox.Show("保存成功"); this.DialogResult = DialogResult.OK; this.Close(); } else { MessageBox.Show("保存失败!"); } } }
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; } } }