/// <summary> /// 保存实体数据 /// </summary> /// <param name="keyValue">主键</param> /// <param name="entity">实体</param> /// <returns>返回值大于0:操作成功</returns> public int SaveEntity(string keyValue, Mes_ScrapDetailEntity entity) { try { var strSql = new StringBuilder(); var paramList = new List <SqlParameter>(); if (string.IsNullOrEmpty(keyValue)) { strSql.Append("INSERT INTO Mes_ScrapDetail("); strSql.Append("ID,"); strSql.Append("S_ScrapNo,"); strSql.Append("S_GoodsCode,"); strSql.Append("S_GoodsName,"); strSql.Append("S_Unit,"); strSql.Append("S_Qty,"); strSql.Append("S_Batch,"); strSql.Append("S_Remark,"); strSql.Append("S_Price"); strSql.Append(")"); strSql.Append(" VALUES ("); strSql.Append("@ID,"); strSql.Append("@S_ScrapNo,"); strSql.Append("@S_GoodsCode,"); strSql.Append("@S_GoodsName,"); strSql.Append("@S_Unit,"); strSql.Append("@S_Qty,"); strSql.Append("@S_Batch,"); strSql.Append("@S_Remark,"); strSql.Append("@S_Price"); 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_GoodsCode", entity.S_GoodsCode)); paramList.Add(new SqlParameter("@S_GoodsName", entity.S_GoodsName)); paramList.Add(new SqlParameter("@S_Unit", entity.S_Unit)); paramList.Add(new SqlParameter("@S_Qty", entity.S_Qty)); paramList.Add(new SqlParameter("@S_Batch", entity.S_Batch)); paramList.Add(new SqlParameter("@S_Remark", entity.S_Remark)); paramList.Add(new SqlParameter("@S_Price", entity.S_Price)); var result = db.ExecuteNonQuery(strSql.ToString(), paramList.ToArray()); return(result); } catch (Exception) { throw; } }
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(); } } }