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