public ActionResult SaveForm(string keyValue, string strEntity, string strmes_OutWorkShopDetailList) { if (!string.IsNullOrEmpty(keyValue)) { var entityTemp = outWorkShopManagerIBLL.GetMes_OutWorkShopHeadEntity(keyValue); if (entityTemp.O_Status == ErpEnums.ProOutStatusEnum.Audit) { return(Fail("单据已审核,不能修改!")); } } Mes_OutWorkShopHeadEntity entity = strEntity.ToObject <Mes_OutWorkShopHeadEntity>(); var mes_OutWorkShopDetailList = strmes_OutWorkShopDetailList.ToObject <List <Mes_OutWorkShopDetailEntity> >(); if (mes_OutWorkShopDetailList.Any(c => c.O_Qty <= 0)) { return(Fail("数量只能是大于0的实数")); } foreach (var goods in mes_OutWorkShopDetailList) { var stock_qty = invSeachIbll.GetEntityBy(goods.O_GoodsCode, entity.O_StockCode, goods.O_Batch).I_Qty; if (goods.O_Qty > stock_qty) { return(Fail("【" + goods.O_GoodsName + "】" + "库存不足")); } } outWorkShopManagerIBLL.SaveEntity(keyValue, entity, mes_OutWorkShopDetailList); return(Success("保存成功!")); }
private void btnBack_Click(object sender, EventArgs e) { try { //string strOrderNo = dataGridView1.Rows[dataGridView1.SelectedCells[0].RowIndex].Cells["生产订单号"].Value.ToString(); string strWorkShop = dataGridView1.Rows[dataGridView1.SelectedCells[0].RowIndex].Cells["车间"].Value.ToString(); string strGoodsCode = dataGridView1.Rows[dataGridView1.SelectedCells[0].RowIndex].Cells["物料"].Value.ToString(); string strBatch = dataGridView1.Rows[dataGridView1.SelectedCells[0].RowIndex].Cells["批次"].Value.ToString(); string strQty = dataGridView1.Rows[dataGridView1.SelectedCells[0].RowIndex].Cells["数量"].Value.ToString(); string strPrice = dataGridView1.Rows[dataGridView1.SelectedCells[0].RowIndex].Cells["价格"].Value.ToString(); string strGoodsName = dataGridView1.Rows[dataGridView1.SelectedCells[0].RowIndex].Cells["物料名称"].Value.ToString(); string strUnit = dataGridView1.Rows[dataGridView1.SelectedCells[0].RowIndex].Cells["单位"].Value.ToString(); string strId = dataGridView1.Rows[dataGridView1.SelectedCells[0].RowIndex].Cells["Id"].Value.ToString(); string strStockCode = dataGridView1.Rows[dataGridView1.SelectedCells[0].RowIndex].Cells["仓库编码"].Value.ToString(); string strStockName = dataGridView1.Rows[dataGridView1.SelectedCells[0].RowIndex].Cells["仓库名称"].Value.ToString(); //string strDate = dataGridView1.Rows[dataGridView1.SelectedCells[0].RowIndex].Cells["W_Price"].Value.ToString(); if (MessageBox.Show("物料是否要退回仓库?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == System.Windows.Forms.DialogResult.Yes) { Mes_OutWorkShopHeadBLL OutWorkShopHeadBLL = new Mes_OutWorkShopHeadBLL(); try { this.Enabled = false; Cursor.Current = Cursors.WaitCursor; Mes_OutWorkShopDetailBLL OutWorkShopDetailBLL = new Mes_OutWorkShopDetailBLL(); Mes_OutWorkShopHeadEntity OutWorkShopHeadEntity = new Mes_OutWorkShopHeadEntity(); Mes_OutWorkShopDetailEntity OutWorkShopDetailEntity = new Mes_OutWorkShopDetailEntity(); string strIn_No = ""; MesMaterInHeadBLL MaterInHeadBLL = new MesMaterInHeadBLL(); strIn_No = MaterInHeadBLL.GetDH("线边仓出库到车间单"); //var rowsHead = OutWorkShopHeadBLL.GetList_OutWorkShopHead("where 1 = 1 order by O_OutNo DESC"); //if (rowsHead == null || rowsHead.Count < 1) //{ // strIn_No = "OW" + DateTime.Now.ToString("yyyyMMdd") + "000001"; //} //else //{ // string strDate = rowsHead[0].O_OutNo.Substring(2, 8); // if (strDate == DateTime.Now.ToString("yyyyMMdd")) // { // string strList = rowsHead[0].O_OutNo.Substring(10, 4); // int nList = Convert.ToInt32(strList) + 1; // strIn_No = "OW" + DateTime.Now.ToString("yyyyMMdd") + nList.ToString().PadLeft(4, '0'); // } // else // { // strIn_No = "OW" + DateTime.Now.ToString("yyyyMMdd") + "000001"; // } //} OutWorkShopHeadEntity.O_OutNo = strIn_No; OutWorkShopHeadEntity.O_OrderNo = ""; OutWorkShopHeadEntity.O_StockCode = strStockCode; OutWorkShopHeadEntity.O_StockName = strStockName; OutWorkShopHeadEntity.O_CreateBy = Globels.strUser; OutWorkShopHeadEntity.O_CreateDate = DateTime.Now; OutWorkShopHeadEntity.O_OrderDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); OutWorkShopHeadEntity.O_Remark = ""; OutWorkShopHeadEntity.O_Status = 1; OutWorkShopHeadEntity.O_WorkShop = txtWorkShop.Text; OutWorkShopHeadEntity.O_Kind = 2; int nRow = OutWorkShopHeadBLL.SaveEntity("", OutWorkShopHeadEntity); //for (int i = 0; i < rows.Count; i++) //{ OutWorkShopDetailEntity.O_GoodsCode = strGoodsCode; OutWorkShopDetailEntity.O_GoodsName = strGoodsName; OutWorkShopDetailEntity.O_OutNo = strIn_No; OutWorkShopDetailEntity.O_Price = Convert.ToDecimal(strPrice); OutWorkShopDetailEntity.O_Qty = Convert.ToDecimal(strQty); OutWorkShopDetailEntity.O_Remark = ""; OutWorkShopDetailEntity.O_Unit = strUnit; OutWorkShopDetailEntity.O_Batch = strBatch; nRow = OutWorkShopDetailBLL.SaveEntity("", OutWorkShopDetailEntity); //} MessageBox.Show("保存成功"); Upload(strIn_No); string Barcode = strGoodsCode + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); //GetImg("物料" + strGoodsCode + "批次" + strBatch + "单号" + Globels.strOrderNo, strGoodsName, strQty, strGoodsCode, strBatch, Barcode); //SaveBarcode(Barcode, strGoodsCode, strGoodsName, OutWorkShopDetailEntity.O_Qty, OutWorkShopHeadEntity.O_WorkShop); DeleteData(strId); UpdateGoods(); this.Enabled = true; Cursor.Current = Cursors.Default; } catch (Exception ex) { this.Enabled = true; Cursor.Current = Cursors.Default; } } } catch (Exception ex) { //MessageBox.Show("请选中某一行进行退仓库"); lblTS.Text = "系统提示:请选中某一行进行退仓库"; } }
/// <summary> /// 保存实体数据 /// </summary> /// <param name="keyValue">主键</param> /// <param name="entity">实体</param> /// <returns>返回值大于0:操作成功</returns> public int SaveEntity(string keyValue, Mes_OutWorkShopHeadEntity entity) { try { var strSql = new StringBuilder(); var paramList = new List <SqlParameter>(); if (string.IsNullOrEmpty(keyValue)) { strSql.Append("INSERT INTO Mes_OutWorkShopHead("); strSql.Append("ID,"); strSql.Append("O_OutNo,"); strSql.Append("O_StockCode,"); strSql.Append("O_StockName,"); strSql.Append("O_WorkShop,"); strSql.Append("O_OrderNo,"); strSql.Append("O_OrderDate,"); strSql.Append("O_Status,"); strSql.Append("O_CreateBy,"); strSql.Append("O_Kind,"); strSql.Append("O_CreateDate,"); strSql.Append("O_Remark"); strSql.Append(")"); strSql.Append(" VALUES ("); strSql.Append("@ID,"); strSql.Append("@O_OutNo,"); strSql.Append("@O_StockCode,"); strSql.Append("@O_StockName,"); strSql.Append("@O_WorkShop,"); strSql.Append("@O_OrderNo,"); strSql.Append("@O_OrderDate,"); strSql.Append("@O_Status,"); strSql.Append("@O_CreateBy,"); strSql.Append("@O_Kind,"); strSql.Append("@O_CreateDate,"); strSql.Append("@O_Remark"); strSql.Append(")"); paramList.Add(new SqlParameter("@ID", Guid.NewGuid().ToString())); } else { //strSql.Append("UPDATE Mes_InWorkShopHead SET "); //strSql.Append("B_BasketCode=@B_BasketCode,"); //strSql.Append("B_BasketName=@B_BasketName,"); //strSql.Append("M_Weight=@M_Weight "); //strSql.Append(" WHERE ID=@ID"); //paramList.Add(new SqlParameter("@ID", keyValue)); } paramList.Add(new SqlParameter("@O_OutNo", entity.O_OutNo)); paramList.Add(new SqlParameter("@O_StockCode", entity.O_StockCode)); paramList.Add(new SqlParameter("@O_StockName", entity.O_StockName)); paramList.Add(new SqlParameter("@O_WorkShop", entity.O_WorkShop)); paramList.Add(new SqlParameter("@O_OrderNo", entity.O_OrderNo)); paramList.Add(new SqlParameter("@O_OrderDate", entity.O_OrderDate)); paramList.Add(new SqlParameter("@O_Status", entity.O_Status)); paramList.Add(new SqlParameter("@O_CreateBy", entity.O_CreateBy)); paramList.Add(new SqlParameter("@O_Kind", entity.O_Kind)); paramList.Add(new SqlParameter("@O_CreateDate", entity.O_CreateDate)); paramList.Add(new SqlParameter("@O_Remark", entity.O_Remark)); var result = db.ExecuteNonQuery(strSql.ToString(), paramList.ToArray()); return(result); } catch (Exception) { throw; } }
private void btn_upload_Click(object sender, EventArgs e) { try { if (MessageBox.Show("是否要完工?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes) { Mes_OutWorkShopTempBLL OutWorkShopTempBLL = new Mes_OutWorkShopTempBLL(); var rows = OutWorkShopTempBLL.GetList_OutWorkShopTemp("where O_StockCode = '" + cmbStock.Text + "' and O_WorkShop = '" + cmbWorkShop.Text + "' and O_OrderNo = '" + comOrderNo.Text + "'"); if (rows == null || rows.Count < 1) { //untCommon.InfoMsg("没有任何数据!"); lblTS.Text = "没有任何数据!"; return; } Mes_OutWorkShopHeadBLL OutWorkShopHeadBLL = new Mes_OutWorkShopHeadBLL(); Mes_OutWorkShopDetailBLL OutWorkShopDetailBLL = new Mes_OutWorkShopDetailBLL(); Mes_OutWorkShopHeadEntity OutWorkShopHeadEntity = new Mes_OutWorkShopHeadEntity(); Mes_OutWorkShopDetailEntity OutWorkShopDetailEntity = new Mes_OutWorkShopDetailEntity(); string strIn_No = ""; MesMaterInHeadBLL MaterInHeadBLL = new MesMaterInHeadBLL(); strIn_No = MaterInHeadBLL.GetDH("线边仓出库到车间单"); /*var rowsHead = OutWorkShopHeadBLL.GetList_OutWorkShopHead("where 1 = 1 order by O_OutNo DESC"); * if (rowsHead == null || rowsHead.Count < 1) * { * strIn_No = "OW" + DateTime.Now.ToString("yyyyMMdd") + "000001"; * } * else * { * string strDate = rowsHead[0].O_OutNo.Substring(2, 8); * if (strDate == DateTime.Now.ToString("yyyyMMdd")) * { * string strList = rowsHead[0].O_OutNo.Substring(10, 6); * int nList = Convert.ToInt32(strList) + 1; * strIn_No = "OW" + DateTime.Now.ToString("yyyyMMdd") + nList.ToString().PadLeft(6, '0'); * } * else * { * strIn_No = "OW" + DateTime.Now.ToString("yyyyMMdd") + "000001"; * } * * }*/ OutWorkShopHeadEntity.O_OutNo = strIn_No; OutWorkShopHeadEntity.O_OrderNo = comOrderNo.Text; OutWorkShopHeadEntity.O_StockCode = cmbStock.Text; OutWorkShopHeadEntity.O_StockName = cmbStockName.Text; OutWorkShopHeadEntity.O_CreateBy = Globels.strUser; OutWorkShopHeadEntity.O_CreateDate = DateTime.Now; OutWorkShopHeadEntity.O_OrderDate = txtOrderDate.Text; OutWorkShopHeadEntity.O_Remark = ""; OutWorkShopHeadEntity.O_Status = 1; OutWorkShopHeadEntity.O_WorkShop = cmbWorkShop.Text; OutWorkShopHeadEntity.O_Kind = 1; int nRow = OutWorkShopHeadBLL.SaveEntity("", OutWorkShopHeadEntity); for (int i = 0; i < rows.Count; i++) { OutWorkShopDetailEntity.O_GoodsCode = rows[i].O_GoodsCode; OutWorkShopDetailEntity.O_GoodsName = rows[i].O_GoodsName; OutWorkShopDetailEntity.O_OutNo = strIn_No; OutWorkShopDetailEntity.O_Price = rows[i].O_Price; OutWorkShopDetailEntity.O_Qty = rows[i].O_Qty; OutWorkShopDetailEntity.O_Remark = rows[i].O_Remark; OutWorkShopDetailEntity.O_Unit = rows[i].O_Unit; OutWorkShopDetailEntity.O_Batch = rows[i].O_Batch; nRow = OutWorkShopDetailBLL.SaveEntity("", OutWorkShopDetailEntity); } Upload(strIn_No); MessageBox.Show("保存成功"); lblTS.Text = ""; DeleteData(); Update(); } } catch (Exception ex) { //MessageBox.Show(ex.ToString()); lblTS.Text = ex.ToString(); } }