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("保存失败!"); } } }