private void DeleteData()
{
//删除临时数据
Mes_InWorkShopTempBLL InWorkShopTempBLL = new Mes_InWorkShopTempBLL();
InWorkShopTempBLL.DeleteData("where I_StockCode = '" + cmbStock.Text + "' and I_WorkShop = '" + cmbWorkShop.Text + "' and I_OrderNo = '" + comOrderNo.Text + "'");
}
private void UpdataNew()
{
Mes_InWorkShopTempBLL InWorkShopTempBLL = new Mes_InWorkShopTempBLL();
var rows = InWorkShopTempBLL.GetList_InWorkShopTemp("where I_StockCode = '" + cmbStock.Text + "' and I_WorkShop = '" + cmbWorkShop.Text + "' and I_OrderNo = '" + comOrderNo.Text + "' order by I_CreateDate Desc");
dataGridView1.DataSource = rows;
}
private void Save()
{
if (txtCode.Text == "" || txtPc.Text == "" || txtQty.Text == "" || txtBarcode.Text == "")
{
MessageBox.Show("请扫描二维码");
txtBarcode.Focus();
return;
}
//if (MessageBox.Show("是否保存", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == System.Windows.Forms.DialogResult.Yes)
//{
try
{
Mes_InWorkShopTempEntity InWorkShopTempEntity = new Mes_InWorkShopTempEntity();
InWorkShopTempEntity.I_StockCode = cmbStock.Text;
InWorkShopTempEntity.I_StockName = cmbStockName.Text;
InWorkShopTempEntity.I_WorkShop = cmbWorkShop.Text;
InWorkShopTempEntity.I_WorkShopName = cmbWorkshopName.Text;
InWorkShopTempEntity.I_OrderNo = comOrderNo.Text;
InWorkShopTempEntity.I_Status = 1;
InWorkShopTempEntity.I_CreateBy = Globels.strUser;
InWorkShopTempEntity.I_CreateDate = DateTime.Now;
InWorkShopTempEntity.I_GoodsCode = txtCode.Text;
InWorkShopTempEntity.I_GoodsName = txtName.Text;
InWorkShopTempEntity.I_Unit = strUnit;
InWorkShopTempEntity.I_Qty = Convert.ToDecimal(txtQty.Text);
InWorkShopTempEntity.I_Batch = txtPc.Text;
InWorkShopTempEntity.I_Remark = "";
InWorkShopTempEntity.I_Barcode = txtBarcode.Text;
InWorkShopTempEntity.I_Price = Convert.ToDecimal(txtPrice.Text);
InWorkShopTempEntity.I_Record = cmbRecord.Text;
Mes_InWorkShopTempBLL InWorkShopTempBLL = new Mes_InWorkShopTempBLL();
if (InWorkShopTempBLL.SaveEntity("", InWorkShopTempEntity) > 0)
{
//untCommon.InfoMsg("添加成功！");
UpdataNew();
cls();
UpdateBarcode(m_strBarcode);
txtBarcode.SelectAll();
txtBarcode.Focus();
//frmParent.loadData();
}
else
{
untCommon.InfoMsg("添加失败！");
}
}
catch (Exception ex)
{
cls();
txtBarcode.SelectAll();
txtBarcode.Focus();
}
//}
}
private void Delete()
{
try
{
string strID = dataGridView1.Rows[dataGridView1.SelectedCells[0].RowIndex].Cells["ID"].Value.ToString();
string strBarcode = dataGridView1.Rows[dataGridView1.SelectedCells[0].RowIndex].Cells["条码"].Value.ToString();
Mes_InWorkShopTempBLL InWorkShopTempBLL = new Mes_InWorkShopTempBLL();
string strSql = " where ID = '" + strID + "'";
InWorkShopTempBLL.DeleteData(strSql);
string[] str = strBarcode.Split(',');
UpdateBarcode2(str[4]);
}
catch (Exception ex)
{
//MessageBox.Show("请选中某一行进行退仓库");
lblTS.Text = "系统提示：请选中某一行进行退仓库";
}
}
private void btnUpload_Click(object sender, EventArgs e)
{
try
{
if (MessageBox.Show("是否要提交", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == System.Windows.Forms.DialogResult.Yes)
{
Mes_InWorkShopTempBLL InWorkShopTempBLL = new Mes_InWorkShopTempBLL();
var rows = InWorkShopTempBLL.GetList_InWorkShopTemp("where I_StockCode = '" + cmbStock.Text + "' and I_WorkShop = '" + cmbWorkShop.Text + "' and I_OrderNo = '" + comOrderNo.Text + "'");
if (rows == null || rows.Count < 1)
{
//untCommon.InfoMsg("没有任何数据！");
lblTS.Text = "系统提示：没有任何数据！";
return;
}
Mes_InWorkShopHeadBLL InWorkShopHeadBLL = new Mes_InWorkShopHeadBLL();
Mes_InWorkShopDetailBLL InWorkShopDetailBLL = new Mes_InWorkShopDetailBLL();
Mes_InWorkShopHeadEntity InWorkShopHeadEntity = new Mes_InWorkShopHeadEntity();
Mes_InWorkShopDetailEntity InWorkShopDetailEntity = new Mes_InWorkShopDetailEntity();
string strIn_No = "";
MesMaterInHeadBLL MaterInHeadBLL = new MesMaterInHeadBLL();
strIn_No = MaterInHeadBLL.GetDH("车间入库到线边仓单");
InWorkShopHeadEntity.I_InNo = strIn_No;
InWorkShopHeadEntity.I_OrderNo = comOrderNo.Text;
InWorkShopHeadEntity.I_StockCode = cmbStock.Text;
InWorkShopHeadEntity.I_StockName = cmbStockName.Text;
InWorkShopHeadEntity.I_CreateBy = "";
InWorkShopHeadEntity.I_CreateDate = DateTime.Now;
InWorkShopHeadEntity.I_OrderDate = txtOrderDate.Text;
InWorkShopHeadEntity.I_Remark = "";
InWorkShopHeadEntity.I_Status = 1;
InWorkShopHeadEntity.I_WorkShop = cmbWorkShop.Text;
int nRow = InWorkShopHeadBLL.SaveEntity("", InWorkShopHeadEntity);
for (int i = 0; i < rows.Count; i++)
{
InWorkShopDetailEntity.I_GoodsCode = rows[i].I_GoodsCode;
InWorkShopDetailEntity.I_GoodsName = rows[i].I_GoodsName;
InWorkShopDetailEntity.I_InNo = strIn_No;
InWorkShopDetailEntity.I_Price = rows[i].I_Price;
InWorkShopDetailEntity.I_Qty = rows[i].I_Qty;
InWorkShopDetailEntity.I_Remark = rows[i].I_Remark;
InWorkShopDetailEntity.I_Unit = rows[i].I_Unit;
InWorkShopDetailEntity.I_Batch = rows[i].I_Batch;
nRow = InWorkShopDetailBLL.SaveEntity("", InWorkShopDetailEntity);
}
//更改临时数据状态
Upload(strIn_No);
MessageBox.Show("保存成功");
lblTS.Text = "";
DeleteData();
UpdataNew();
}
else
{
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
