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)));
}
