//保存
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);
}
