public ActionResult SaveForm(string keyValue, string strEntity, string strmes_InWorkShopDetailList)
{
if (!string.IsNullOrEmpty(keyValue))
{
var entityTemp = inWorkShopManagerIBLL.GetMes_InWorkShopHeadEntity(keyValue);
if (entityTemp.I_Status == ErpEnums.InStatusEnum.Audit)
{
return(Fail("该单据已审核,不能编辑！"));
}
}
Mes_InWorkShopHeadEntity entity = strEntity.ToObject <Mes_InWorkShopHeadEntity>();
var mes_InWorkShopDetailList = strmes_InWorkShopDetailList.ToObject <List <Mes_InWorkShopDetailEntity> >();
if (string.IsNullOrEmpty(strmes_InWorkShopDetailList))
{
return(Fail("明细列表不能为空"));
}
if (mes_InWorkShopDetailList.Any(c => c.I_Qty <= 0))
{
return(Fail("数量只能是大于0的实数"));
}
inWorkShopManagerIBLL.SaveEntity(keyValue, entity, mes_InWorkShopDetailList);
return(Success("保存成功！"));
}
private void btnUpload_Click(object sender, EventArgs e)
{
try
{
if (MessageBox.Show("是否要提交", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == System.Windows.Forms.DialogResult.Yes)
{
Mes_InWorkShopTempBLL InWorkShopTempBLL = new Mes_InWorkShopTempBLL();
var rows = InWorkShopTempBLL.GetList_InWorkShopTemp("where I_StockCode = '" + cmbStock.Text + "' and I_WorkShop = '" + cmbWorkShop.Text + "' and I_OrderNo = '" + comOrderNo.Text + "'");
if (rows == null || rows.Count < 1)
{
//untCommon.InfoMsg("没有任何数据！");
lblTS.Text = "系统提示：没有任何数据！";
return;
}
Mes_InWorkShopHeadBLL InWorkShopHeadBLL = new Mes_InWorkShopHeadBLL();
Mes_InWorkShopDetailBLL InWorkShopDetailBLL = new Mes_InWorkShopDetailBLL();
Mes_InWorkShopHeadEntity InWorkShopHeadEntity = new Mes_InWorkShopHeadEntity();
Mes_InWorkShopDetailEntity InWorkShopDetailEntity = new Mes_InWorkShopDetailEntity();
string strIn_No = "";
MesMaterInHeadBLL MaterInHeadBLL = new MesMaterInHeadBLL();
strIn_No = MaterInHeadBLL.GetDH("车间入库到线边仓单");
InWorkShopHeadEntity.I_InNo = strIn_No;
InWorkShopHeadEntity.I_OrderNo = comOrderNo.Text;
InWorkShopHeadEntity.I_StockCode = cmbStock.Text;
InWorkShopHeadEntity.I_StockName = cmbStockName.Text;
InWorkShopHeadEntity.I_CreateBy = "";
InWorkShopHeadEntity.I_CreateDate = DateTime.Now;
InWorkShopHeadEntity.I_OrderDate = txtOrderDate.Text;
InWorkShopHeadEntity.I_Remark = "";
InWorkShopHeadEntity.I_Status = 1;
InWorkShopHeadEntity.I_WorkShop = cmbWorkShop.Text;
int nRow = InWorkShopHeadBLL.SaveEntity("", InWorkShopHeadEntity);
for (int i = 0; i < rows.Count; i++)
{
InWorkShopDetailEntity.I_GoodsCode = rows[i].I_GoodsCode;
InWorkShopDetailEntity.I_GoodsName = rows[i].I_GoodsName;
InWorkShopDetailEntity.I_InNo = strIn_No;
InWorkShopDetailEntity.I_Price = rows[i].I_Price;
InWorkShopDetailEntity.I_Qty = rows[i].I_Qty;
InWorkShopDetailEntity.I_Remark = rows[i].I_Remark;
InWorkShopDetailEntity.I_Unit = rows[i].I_Unit;
InWorkShopDetailEntity.I_Batch = rows[i].I_Batch;
nRow = InWorkShopDetailBLL.SaveEntity("", InWorkShopDetailEntity);
}
//更改临时数据状态
Upload(strIn_No);
MessageBox.Show("保存成功");
lblTS.Text = "";
DeleteData();
UpdataNew();
}
else
{
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
/// <summary>
/// 保存实体数据
/// </summary>
/// <param name="keyValue">主键</param>
/// <param name="entity">实体</param>
/// <returns>返回值大于0:操作成功</returns>
public int SaveEntity(string keyValue, Mes_InWorkShopHeadEntity entity)
{
try
{
var strSql = new StringBuilder();
var paramList = new List <SqlParameter>();
if (string.IsNullOrEmpty(keyValue))
{
strSql.Append("INSERT INTO Mes_InWorkShopHead(");
strSql.Append("ID,");
strSql.Append("I_InNo,");
strSql.Append("I_StockCode,");
strSql.Append("I_StockName,");
strSql.Append("I_WorkShop,");
strSql.Append("I_OrderNo,");
strSql.Append("I_OrderDate,");
strSql.Append("I_Status,");
strSql.Append("I_CreateBy,");
strSql.Append("I_CreateDate,");
strSql.Append("I_Remark");
strSql.Append(")");
strSql.Append(" VALUES (");
strSql.Append("@ID,");
strSql.Append("@I_InNo,");
strSql.Append("@I_StockCode,");
strSql.Append("@I_StockName,");
strSql.Append("@I_WorkShop,");
strSql.Append("@I_OrderNo,");
strSql.Append("@I_OrderDate,");
strSql.Append("@I_Status,");
strSql.Append("@I_CreateBy,");
strSql.Append("@I_CreateDate,");
strSql.Append("@I_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("@I_InNo", entity.I_InNo));
paramList.Add(new SqlParameter("@I_StockCode", entity.I_StockCode));
paramList.Add(new SqlParameter("@I_StockName", entity.I_StockName));
paramList.Add(new SqlParameter("@I_WorkShop", entity.I_WorkShop));
paramList.Add(new SqlParameter("@I_OrderNo", entity.I_OrderNo));
paramList.Add(new SqlParameter("@I_OrderDate", entity.I_OrderDate));
paramList.Add(new SqlParameter("@I_Status", entity.I_Status));
paramList.Add(new SqlParameter("@I_CreateBy", entity.I_CreateBy));
paramList.Add(new SqlParameter("@I_CreateDate", entity.I_CreateDate));
paramList.Add(new SqlParameter("@I_Remark", entity.I_Remark));
var result = db.ExecuteNonQuery(strSql.ToString(), paramList.ToArray());
return(result);
}
catch (Exception)
{
throw;
}
}
