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;
}
}
