//保存 private void tsbSave_Click(object sender, EventArgs e) { gridView1.UpdateCurrentRow(); if (dateTimePicker1.Text == "") { this.ShowAlertMessage("请选择日期!"); return; } if (cboDepotOut.Text == "") { this.ShowAlertMessage("必须选择调出仓库!"); return; } if (cboDepotIn.Text == "") { this.ShowAlertMessage("必须选择调入仓库!"); return; } if (cboDepotOut.Text == cboDepotIn.Text) { this.ShowAlertMessage("调出仓库与调入仓库的值不允许相同!"); return; } if (cboHandlePerson.Text == "") { this.ShowAlertMessage("必须选择经手人!"); return; } if (gridView1.RowCount <= 0) { this.ShowAlertMessage("必须增加货品明细数据!"); return; } RemoveBill RemoveBill = new RemoveBill(); RemoveBill.RemoveBillGuid = txtGuid.Text; RemoveBill.BillDate = DateTime.Parse(dateTimePicker1.Text); RemoveBill.BillID = txtBillID.Text; RemoveBill.DepotOut = cboDepotOut.Text; RemoveBill.DepotIn = cboDepotIn.Text; if (txtCreateDate.Text.Trim() == "") { RemoveBill.CreateDate = DateTime.Now; } else { RemoveBill.CreateDate = DateTime.Parse(txtCreateDate.Text); } RemoveBill.CreatePerson = SysParams.UserName; RemoveBill.CheckDate = DateTime.Parse("1900-01-01"); RemoveBill.CheckPerson = ""; RemoveBill.Remark = txtRemark.Text; RemoveBill.BillAutoID = txtAutoBillID.Text; RemoveBill.HandlePerson = cboHandlePerson.Text; List <RemoveBillDetail> list = new List <RemoveBillDetail>(); RemoveBillDetail RemoveBillDetail = new RemoveBillDetail(); for (int i = 0; i < gridView1.RowCount; i++) { DataRowView dr = (DataRowView)(gridView1.GetRow(i)); RemoveBillDetail = new RemoveBillDetail(); RemoveBillDetail.RemoveBillDetailGuid = Guid.NewGuid().ToString(); RemoveBillDetail.RemoveBillGuid = RemoveBill.RemoveBillGuid; RemoveBillDetail.MaterialGuid = dr[0].ToString(); //gridView1.GetRowCellValue(i, gridMaterialGuid).ToString(); RemoveBillDetail.MaterialID = dr[1].ToString(); //gridView1.GetRowCellValue(i, gridMaterialGuid).ToString(); RemoveBillDetail.MaterialName = dr[2].ToString(); //gridView1.GetRowCellValue(i, gridMaterialName).ToString(); RemoveBillDetail.BarNo = dr[3].ToString(); //gridView1.GetRowCellValue(i, gridMaterialName).ToString(); RemoveBillDetail.Spec = dr[4].ToString(); // gridView1.GetRowCellValue(i, gridSpec).ToString(); RemoveBillDetail.Unit = dr[5].ToString(); //gridView1.GetRowCellValue(i, gridUnit).ToString(); if (dr[6].ToString().Trim() != "") { RemoveBillDetail.Qty = decimal.Parse(dr[6].ToString());//int.Parse(gridView1.GetRowCellValue(i, gridQty).ToString()); } else { RemoveBillDetail.Qty = 0; } if (dr[7].ToString().Trim() != "") { RemoveBillDetail.Price = decimal.Parse(dr[7].ToString()); //decimal.Parse(gridView1.GetRowCellValue(i, gridPrice).ToString()); } else { RemoveBillDetail.Price = 0; } if (dr[8].ToString().Trim() != "") { RemoveBillDetail.Total = decimal.Parse(dr[8].ToString()); //decimal.Parse(gridView1.GetRowCellValue(i, gridTotal ).ToString()); } else { RemoveBillDetail.Total = 0; } RemoveBillDetail.Remark = dr[9].ToString();//gridView1.GetRowCellValue(i, gridRemark).ToString(); list.Add(RemoveBillDetail); } //保存 rbm.SaveRemoveBill(RemoveBill, list); //刷新 if (SendFlag == 0) { frmRemoveBill.frmremovebill.LoadBill(); } tsbCheckPass.Enabled = true; //得到明细表数据 DataTable dtl = rbm.GetRemoveBillData(txtGuid.Text); DataTable dtlDetail = rbm.GetRemoveBillDetailData(txtGuid.Text); this.gridControl1.DataSource = dtlDetail; //存放dataset供打印用数据集 ds.Tables.Add(dtl.Copy()); ds.Tables[0].TableName = "dtlRemoveBill"; ds.Tables.Add(dtlDetail.Copy()); ds.Tables[1].TableName = "dtlRemoveBillDetail"; this.ShowMessage("保存成功"); }
/// <summary> /// 保存 /// </summary> /// <param name="SaveType">1-保存 2-保存并审核</param> /// <returns></returns> private bool SaveData(int SaveType) { txtRemark.Focus(); gridView1.UpdateCurrentRow(); if (txtDepotOut.Text == "") { this.ShowAlertMessage("必须输入调出仓库!"); return(false); } if (txtDepotIn.Text == "") { this.ShowAlertMessage("必须输入调入仓库!"); return(false); } if (dtpRemoveBillDate.Text == "") { this.ShowAlertMessage("必须输入开单日期!"); return(false); } if (gridView1.RowCount <= 0) { this.ShowAlertMessage("必须增加明细数据!"); return(false); } //if (bm.IsExistBillID(txtBillID.Text) == true && this.Tag.ToString() == "add") //{ // this.ShowAlertMessage("订单号已经存在,请重新输入!"); // return; //} //------------------------------------- //是否开启数量超出库存预警 if (MaterialManage.OverNumStorage(txtDepotOut.Tag.ToString()) == true) { List <YJMaterialStorage> lst = IsOverStorageNum(); if (lst.Count > 0) { frmShowYJMaterial frmShowYJMaterial = new frmShowYJMaterial(); frmShowYJMaterial.ShowFillData(lst); return(false); } } //--------------------------------------- RemoveBill RemoveBill = new RemoveBill(); RemoveBill.RemoveBillGuid = txtRemoveBillGuid.Text; RemoveBill.RemoveBillID = txtRemoveBillID.Text; RemoveBill.RemoveBillDate = DateTime.Parse(dtpRemoveBillDate.Text); if (txtDepotOut.Tag != null) { RemoveBill.DepotOut = txtDepotOut.Tag.ToString(); } if (txtDepotIn.Tag != null) { RemoveBill.DepotIn = txtDepotIn.Tag.ToString(); } if (txtHandlePerson.Tag != null) { RemoveBill.HandlePerson = txtHandlePerson.Tag.ToString(); } RemoveBill.Remark = txtRemark.Text; RemoveBill.CreateGuid = txtCreateGuid.Tag.ToString(); RemoveBill.CreateDate = DateTime.Now; RemoveBill.CheckGuid = ""; RemoveBill.CheckDate = DateTime.Parse("1900-01-01"); RemoveBill.CheckGuid2 = ""; RemoveBill.CheckDate2 = DateTime.Parse("1900-01-01"); List <RemoveBillDetail> list = new List <RemoveBillDetail>(); RemoveBillDetail RemoveBillDetail = new RemoveBillDetail(); for (int i = 0; i < gridView1.RowCount; i++) { DataRowView dr = (DataRowView)(gridView1.GetRow(i)); RemoveBillDetail = new RemoveBillDetail(); RemoveBillDetail.RemoveBillGuid = txtRemoveBillGuid.Text; RemoveBillDetail.MaterialGuID = dr["MaterialGuID"].ToString(); if (dr["MaterialSum"].ToString().Trim() != "") { RemoveBillDetail.MaterialSum = decimal.Parse(dr["MaterialSum"].ToString()); } else { RemoveBillDetail.MaterialSum = 0; } list.Add(RemoveBillDetail); } //保存 RemoveBillManage.SaveBill(RemoveBill, list); tsbCheck.Enabled = true; tsbUnCheck.Enabled = false; SetRight(); //写日志 SysLog.AddOperateLog(SysParams.UserName, "调拨单保存", "保存", SysParams.UserName + "用户保存调拨单,唯一号:" + txtRemoveBillGuid.Text + ",调拨单号:" + txtRemoveBillID.Text); //用于打印 DataTable dtl3 = base.GetDataTable((DataView)gridView1.DataSource); ds.Tables.Clear(); ds.Tables.Add(dtl3.Copy()); ds.Tables[0].TableName = "RemoveBillDetail"; this.Tag = "edit"; if (SaveType == 1) { this.ShowMessage("保存成功"); } frmRemoveBill.frmremovebill.LoadData(); return(true); }