private void IsExistsCode(ISession session, SellOrderDetail sellOrderDetail) { ICriteria criteria = session.CreateCriteria(typeof(SellOrderDetail)); ICriterion criterion = null; if (sellOrderDetail.Id != Guid.Empty) { criterion = Restrictions.Not(Restrictions.IdEq(sellOrderDetail.Id)); criteria.Add(criterion); } criterion = Restrictions.Eq("SellOrderID", sellOrderDetail.SellOrder); criteria.Add(criterion); //统计 criteria.SetProjection( Projections.ProjectionList() .Add(Projections.Count("Id")) ); int count = (int)criteria.UniqueResult(); if (count > 0) { throw new EasyJob.Tools.Exceptions.SellOrderIsExistsException();//销售明细单号已经存在 } }
public ActionResult Update(SellOrderDetail sellOrderDetail) { return(Json(sellOrderDetailOper.Update(sellOrderDetail, delegate(object sender, ISession session) { //判断是否存在销售明细单号 IsExistsCode(session, sellOrderDetail); } ))); }
/// <summary> /// 保存数据 /// </summary> /// <param name="SaveType">1-保存 2-审核并保存</param> /// <returns></returns> private bool SaveData(int SaveType) { txtRemark.Focus(); gridView1.UpdateCurrentRow(); if (txtClient.Text == "") { this.ShowAlertMessage("必须输入客户!"); return(false); } if (dtpSellOrderDate.Text == "") { this.ShowAlertMessage("必须输入开单日期!"); return(false); } if (gridView1.RowCount <= 0) { this.ShowAlertMessage("必须增加明细数据!"); return(false); } // ClientOrderManage ClientOrderManage = new ClientOrderManage(); //检查当前输入的客户订单号是否存在,如果不存在则需要提示,不能保存 //for (int i = 0; i < gridView1.RowCount; i++) //{ // DataRowView dr = (DataRowView)(gridView1.GetRow(i)); // string strValue=ClientOrderManage.GetClientOrderGuid(dr["ClientOrderID"].ToString(), dr["MaterialGuID"].ToString()); // if (strValue.Trim() == "0") // { // this.ShowAlertMessage("没有找到这个客户订单号[" + dr["ClientOrderID"].ToString() + "],请确认是否存在"); // return; // } // else if (strValue.Trim() == "1") // { // this.ShowAlertMessage("客户订单号[" + dr["ClientOrderID"].ToString() + "]下没有找到这个料件[" + dr["MaterialID"].ToString() + "],请确认是否存在"); // return; // } // else // { // //更新ClientOrderGuID // } //} //------------------------------------- //是否开启数量超出库存预警 if (MaterialManage.OverNumStorage(txtOutStorage.Tag.ToString()) == true) { List <YJMaterialStorage> lst = IsOverStorageNum(); if (lst.Count > 0) { frmShowYJMaterial frmShowYJMaterial = new frmShowYJMaterial(); frmShowYJMaterial.ShowFillData(lst); return(false); } } //--------------------------------------- //if (bm.IsExistBillID(txtBillID.Text) == true && this.Tag.ToString() == "add") //{ // this.ShowAlertMessage("订单号已经存在,请重新输入!"); // return; //} SellOrder SellOrder = new SellOrder(); SellOrder.SellOrderGuid = txtSellOrderGuid.Text; SellOrder.SellOrderID = txtSellOrderID.Text; SellOrder.SellOrderDate = DateTime.Parse(dtpSellOrderDate.Text); if (txtClient.Tag != null) { SellOrder.Client = txtClient.Tag.ToString(); } if (txtQualityPerson.Tag != null) { SellOrder.QualityPerson = txtQualityPerson.Tag.ToString(); } if (txtStoragePerson.Tag != null) { SellOrder.StoragePerson = txtStoragePerson.Tag.ToString(); } if (txtClient.Tag != null) { SellOrder.Client = txtClient.Tag.ToString(); } if (txtOutStorage.Tag != null) { SellOrder.OutStorage = txtOutStorage.Tag.ToString(); } SellOrder.Shipping = txtShipping.Text.Replace("'", "''"); SellOrder.Remark = txtRemark.Text; SellOrder.CreateGuid = txtCreateGuid.Tag.ToString(); SellOrder.CreateDate = DateTime.Now; SellOrder.CheckGuid = ""; SellOrder.CheckDate = DateTime.Parse("1900-01-01"); List <SellOrderDetail> list = new List <SellOrderDetail>(); SellOrderDetail SellOrderDetail = new SellOrderDetail(); for (int i = 0; i < gridView1.RowCount; i++) { DataRowView dr = (DataRowView)(gridView1.GetRow(i)); SellOrderDetail = new SellOrderDetail(); SellOrderDetail.SellOrderGuid = txtSellOrderGuid.Text; SellOrderDetail.ClientOrderGuid = dr["ClientOrderGuid"].ToString(); SellOrderDetail.ClientOrderID = dr["ClientOrderID"].ToString(); SellOrderDetail.ClientOrderDetailGuid = dr["ClientOrderDetailGuid"].ToString(); SellOrderDetail.MaterialGuID = dr["MaterialGuID"].ToString(); if (dr["MaterialSum"].ToString().Trim() != "") { SellOrderDetail.MaterialSum = decimal.Parse(dr["MaterialSum"].ToString()); } else { SellOrderDetail.MaterialSum = 0; } if (dr["Price"].ToString().Trim() != "") { SellOrderDetail.Price = decimal.Parse(dr["Price"].ToString()); } else { SellOrderDetail.Price = 0; } if (dr["MaterialMoney"].ToString().Trim() != "") { SellOrderDetail.MaterialMoney = decimal.Parse(dr["MaterialMoney"].ToString()); } else { SellOrderDetail.MaterialMoney = 0; } if (dr["BoxSum"].ToString().Trim() != "") { SellOrderDetail.BoxSum = decimal.Parse(dr["BoxSum"].ToString()); } else { SellOrderDetail.BoxSum = 0; } SellOrderDetail.Remark = dr["Remark"].ToString(); SellOrderDetail.SortID = i; list.Add(SellOrderDetail); } //保存 SellOrderManage.SaveBill(SellOrder, list); tsbCheck.Enabled = true; tsbUnCheck.Enabled = false; SetRight(); //用于打印 DataTable dtl3 = base.GetDataTable((DataView)gridView1.DataSource); ds.Tables.Clear(); ds.Tables.Add(dtl3.Copy()); ds.Tables[0].TableName = "SellOrderDetail"; this.Tag = "edit"; if (SaveType == 1) { this.ShowMessage("保存成功"); } frmSellOrder.frmsellorder.LoadData(); return(true); }
public ActionResult Del(SellOrderDetail sellOrderDetail) { return(Json(sellOrderDetailOper.Del(sellOrderDetail))); }