public ActionResult SaveForm(string keyValue, string strEntity, string detailList) { if (!string.IsNullOrEmpty(keyValue)) { var entityTemp = scrapManagerIBLL.GetMes_ScrapHeadEntity(keyValue); if (entityTemp.S_Status == ErpEnums.ScrapStatusEnum.Audit) { return(Fail("该单据已审核,不能编辑!")); } } Mes_ScrapHeadEntity entity = strEntity.ToObject <Mes_ScrapHeadEntity>(); var detail = detailList.ToObject <List <Mes_ScrapDetailEntity> >(); if (detail.Any(item => item.S_Qty <= 0)) { return(Fail("数量只能是大于0的实数")); } foreach (var goods in detail) { var stock_qty = invSeachIbll.GetEntityBy(goods.S_GoodsCode, entity.S_StockCode, goods.S_Batch).I_Qty; if (goods.S_Qty > stock_qty) { return(Fail("【" + goods.S_GoodsName + "】" + "库存不足")); } } scrapManagerIBLL.SaveEntity(keyValue, entity, detail); return(Success("保存成功!")); }
private void btn_Upload_Click(object sender, EventArgs e) { if (MessageBox.Show("是否提交", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == System.Windows.Forms.DialogResult.Yes) { try { Mes_ScrapHeadEntity ScrapHeadEntity = new Mes_ScrapHeadEntity(); Mes_ScrapHeadBLL ScrapHeadBLL = new Mes_ScrapHeadBLL(); Mes_ScrapDetailEntity ScrapDetailEntity = new Mes_ScrapDetailEntity(); Mes_ScrapDetailBLL ScrapDetailBLL = new Mes_ScrapDetailBLL(); MesMaterInHeadBLL MaterInHeadBLL = new MesMaterInHeadBLL(); string strScrapNo = MaterInHeadBLL.GetDH("报废单"); ScrapHeadEntity.S_ScrapNo = strScrapNo; ScrapHeadEntity.S_StockCode = cmbStock.Text; ScrapHeadEntity.S_StockName = cmbStockName.Text; ScrapHeadEntity.S_CreateBy = Globels.strUser; ScrapHeadEntity.S_CreateDate = DateTime.Now; ScrapHeadEntity.S_OrderDate = DateTime.Now; ScrapHeadEntity.S_Remark = ""; ScrapHeadEntity.S_Status = 1; ScrapHeadBLL.SaveEntity("", ScrapHeadEntity); int nCount = listView1.Items.Count; for (int i = 0; i < nCount; i++) { ScrapDetailEntity.S_ScrapNo = strScrapNo; ScrapDetailEntity.S_Batch = listView1.Items[i].SubItems[4].Text; ScrapDetailEntity.S_GoodsCode = listView1.Items[i].SubItems[2].Text; ScrapDetailEntity.S_GoodsName = listView1.Items[i].SubItems[3].Text; ScrapDetailEntity.S_Price = Convert.ToDecimal(listView1.Items[i].SubItems[7].Text); ScrapDetailEntity.S_Unit = listView1.Items[i].SubItems[6].Text; ScrapDetailEntity.S_Qty = Convert.ToDecimal(listView1.Items[i].SubItems[5].Text); ScrapDetailEntity.S_Remark = ""; ScrapDetailBLL.SaveEntity("", ScrapDetailEntity); } MessageBox.Show("报废提交成功"); listView1.Items.Clear(); } catch (Exception ex) { //MessageBox.Show(ex.ToString()); lblTS.Text = "系统提示:" + ex.ToString(); } } }
/// <summary> /// 保存实体数据 /// </summary> /// <param name="keyValue">主键</param> /// <param name="entity">实体</param> /// <returns>返回值大于0:操作成功</returns> public int SaveEntity(string keyValue, Mes_ScrapHeadEntity entity) { try { var strSql = new StringBuilder(); var paramList = new List <SqlParameter>(); if (string.IsNullOrEmpty(keyValue)) { strSql.Append("INSERT INTO Mes_ScrapHead("); strSql.Append("ID,"); strSql.Append("S_ScrapNo,"); strSql.Append("S_StockCode,"); strSql.Append("S_StockName,"); strSql.Append("S_OrderDate,"); strSql.Append("S_Status,"); strSql.Append("S_CreateBy,"); strSql.Append("S_CreateDate,"); strSql.Append("S_UpdateBy,"); strSql.Append("S_UpdateDate,"); strSql.Append("S_DeleteBy,"); strSql.Append("S_DeleteDate,"); strSql.Append("S_UploadBy,"); strSql.Append("S_UploadDate,"); strSql.Append("S_Remark"); strSql.Append(")"); strSql.Append(" VALUES ("); strSql.Append("@ID,"); strSql.Append("@S_ScrapNo,"); strSql.Append("@S_StockCode,"); strSql.Append("@S_StockName,"); strSql.Append("@S_OrderDate,"); strSql.Append("@S_Status,"); strSql.Append("@S_CreateBy,"); strSql.Append("@S_CreateDate,"); strSql.Append("@S_UpdateBy,"); strSql.Append("@S_UpdateDate,"); strSql.Append("@S_DeleteBy,"); strSql.Append("@S_DeleteDate,"); strSql.Append("@S_UploadBy,"); strSql.Append("@S_UploadDate,"); strSql.Append("@S_Remark"); strSql.Append(")"); paramList.Add(new SqlParameter("@ID", Guid.NewGuid().ToString())); } else { } paramList.Add(new SqlParameter("@S_ScrapNo", entity.S_ScrapNo)); paramList.Add(new SqlParameter("@S_StockCode", entity.S_StockCode)); paramList.Add(new SqlParameter("@S_StockName", entity.S_StockName)); paramList.Add(new SqlParameter("@S_OrderDate", entity.S_OrderDate)); paramList.Add(new SqlParameter("@S_Status", entity.S_Status)); paramList.Add(new SqlParameter("@S_CreateBy", entity.S_CreateBy)); paramList.Add(new SqlParameter("@S_CreateDate", entity.S_CreateDate)); paramList.Add(new SqlParameter("@S_UpdateBy", entity.S_UploadBy)); paramList.Add(new SqlParameter("@S_UpdateDate", entity.S_UploadBy)); paramList.Add(new SqlParameter("@S_DeleteBy", entity.S_UploadBy)); paramList.Add(new SqlParameter("@S_DeleteDate", entity.S_UploadBy)); paramList.Add(new SqlParameter("@S_UploadBy", entity.S_UploadBy)); paramList.Add(new SqlParameter("@S_UploadDate", entity.S_UploadBy)); paramList.Add(new SqlParameter("@S_Remark", entity.S_UploadBy)); var result = db.ExecuteNonQuery(strSql.ToString(), paramList.ToArray()); return(result); } catch (Exception) { throw; } }