/// <summary>
/// 保存
/// </summary>
private void addStorage()
{
try
{
//MesProductOrderHeadBLL MesProductOrderHeadBLL = new MesProductOrderHeadBLL();
//var rows = MesProductOrderHeadBLL.GetList(txtOrderNo.Text.Trim());
//if (rows == null || rows.Count < 1)
//{
// untCommon.InfoMsg("输入的生产订单号错误，请重新输入！");
// txtOrderNo.Focus();
// txtOrderNo.SelectAll();
// return;
//}
string[] strStock = comStock.Text.ToString().Split('$');
string[] strProduct = comProductNo.Text.ToString().Split('$');
string[] strSupply = cmbSupply.Text.ToString().Split('$');
MesMaterInHeadBLL MesMaterInHeadBLL = new MesMaterInHeadBLL();
if (checkInput())
{
MesMaterInHeadEntity MesMaterInHead = new MesMaterInHeadEntity();
MesMaterInHead.M_MaterInNo = txtMaterInNo.Text;
MesMaterInHead.M_OrderKind = 0;
MesMaterInHead.M_StockCode = strStock[0];
//MesMaterInHead.M_Kind = "0";
MesMaterInHead.M_StockName = strStock[1];
MesMaterInHead.M_SupplyCode = strSupply[0];
MesMaterInHead.M_SupplyName = strSupply[1];
MesMaterInHead.M_OrderNo = strProduct[0];
MesMaterInHead.M_OrderDate = DateTime.Parse(strProduct[1].ToString());
MesMaterInHead.M_Status = 1;
MesMaterInHead.M_CreateBy = txtCreateBy.Text;
MesMaterInHead.M_CreateDate = DateTime.Now;
MesMaterInHead.M_UpdateDate = null;
MesMaterInHead.M_DeleteDate = null;
MesMaterInHead.M_UploadDate = null;
if (MesMaterInHeadBLL.SaveEntity("", MesMaterInHead) > 0)
{
untCommon.InfoMsg("添加成功！");
string strTime = DateTime.Now.ToString("yyyy-MM-dd ");
string strStartTime = strTime + "00:00:00";
string strEndTime = strTime + "23:59:59";
string strCondit = " and M_CreateDate > '" + strStartTime + "' and M_CreateDate < '" + strEndTime + "'";
frmStorage.loadData(strCondit);
Close();
//frmStorage.Refresh();
}
else
{
untCommon.InfoMsg("添加失败！");
}
}
}
catch (Exception ex)
{
untCommon.ErrorMsg("设备管理添加数据异常：" + ex.Message);
}
}
/// <summary>
/// 保存实体数据
/// </summary>
/// <param name="keyValue">主键</param>
/// <param name="entity">实体</param>
/// <returns>返回值大于0:操作成功</returns>
public int SaveEntity(string keyValue, MesMaterInHeadEntity entity)
{
try
{
var strSql = new StringBuilder();
var paramList = new List <SqlParameter>();
if (string.IsNullOrEmpty(keyValue))
{
strSql.Append("INSERT INTO Mes_MaterInHead(");
strSql.Append("ID,");
strSql.Append("M_OrderKind,");
strSql.Append("M_MaterInNo,");
strSql.Append("M_StockCode,");
strSql.Append("M_StockName,");
strSql.Append("M_SupplyCode,");
strSql.Append("M_SupplyName,");
strSql.Append("M_OrderNo,");
strSql.Append("M_OrderDate,");
strSql.Append("M_Status,");
strSql.Append("M_CreateBy,");
strSql.Append("M_CreateDate,");
strSql.Append("M_UpdateBy,");
strSql.Append("M_UpdateDate,");
strSql.Append("M_Remark,");
strSql.Append("M_DeleteBy,");
strSql.Append("M_DeleteDate,");
strSql.Append("M_UploadBy,");
strSql.Append("M_UploadDate");
strSql.Append(")");
strSql.Append("VALUES(");
strSql.Append("@ID,");
strSql.Append("@M_OrderKind,");
strSql.Append("@M_MaterInNo,");
strSql.Append("@M_StockCode,");
strSql.Append("@M_StockName,");
strSql.Append("@M_SupplyCode,");
strSql.Append("@M_SupplyName,");
strSql.Append("@M_OrderNo,");
strSql.Append("@M_OrderDate,");
strSql.Append("@M_Status,");
strSql.Append("@M_CreateBy,");
strSql.Append("@M_CreateDate,");
strSql.Append("@M_UpdateBy,");
strSql.Append("@M_UpdateDate,");
strSql.Append("@M_Remark,");
strSql.Append("@M_DeleteBy,");
strSql.Append("@M_DeleteDate,");
strSql.Append("@M_UploadBy,");
strSql.Append("@M_UploadDate");
strSql.Append(")");
paramList.Add(new SqlParameter("@ID", Guid.NewGuid().ToString()));
}
else
{
strSql.Append("UPDATE Mes_MaterInHead SET ");
strSql.Append("M_MaterInNo=@M_OrderKind,");
strSql.Append("M_MaterInNo=@M_MaterInNo,");
strSql.Append("M_StockCode=@M_StockCode,");
strSql.Append("M_StockName=@M_StockName,");
strSql.Append("M_OrderNo=@M_OrderNo,");
strSql.Append("M_OrderDate=@M_OrderDate,");
strSql.Append("M_Status=@M_Status,");
strSql.Append("M_CreateBy=@M_CreateBy,");
strSql.Append("M_CreateDate=@M_CreateDate,");
strSql.Append("M_UpdateBy=@M_UpdateBy,");
strSql.Append("M_UpdateDate=@M_UpdateDate,");
strSql.Append("M_Remark=@M_Remark,");
strSql.Append("M_DeleteBy=@M_DeleteBy,");
strSql.Append("M_DeleteDate=@M_DeleteDate,");
strSql.Append("M_UploadBy=@M_UploadBy,");
strSql.Append("M_UploadDate=@M_UploadDate ");
strSql.Append(" WHERE ID=@ID");
paramList.Add(new SqlParameter("@ID", keyValue));
}
paramList.Add(new SqlParameter("@M_OrderKind", entity.M_OrderKind));
paramList.Add(new SqlParameter("@M_MaterInNo", entity.M_MaterInNo));
paramList.Add(new SqlParameter("@M_StockCode", entity.M_StockCode));
paramList.Add(new SqlParameter("@M_StockName", entity.M_StockName));
paramList.Add(new SqlParameter("@M_SupplyCode", entity.M_SupplyCode));
paramList.Add(new SqlParameter("@M_SupplyName", entity.M_SupplyName));
paramList.Add(new SqlParameter("@M_OrderNo", entity.M_OrderNo));
paramList.Add(new SqlParameter("@M_OrderDate", entity.M_OrderDate));
paramList.Add(new SqlParameter("@M_Status", entity.M_Status));
paramList.Add(new SqlParameter("@M_CreateBy", entity.M_CreateBy));
paramList.Add(new SqlParameter("@M_CreateDate", entity.M_CreateDate));
paramList.Add(new SqlParameter("@M_UpdateBy", entity.M_UpdateBy));
paramList.Add(new SqlParameter("@M_UpdateDate", entity.M_UpdateDate));
paramList.Add(new SqlParameter("@M_Remark", entity.M_Remark));
paramList.Add(new SqlParameter("@M_DeleteBy", entity.M_DeleteBy));
paramList.Add(new SqlParameter("@M_DeleteDate", entity.M_DeleteDate));
paramList.Add(new SqlParameter("@M_UploadBy", entity.M_UploadBy));
paramList.Add(new SqlParameter("@M_UploadDate", entity.M_UploadDate));
var result = db.ExecuteNonQuery(strSql.ToString(), paramList.ToArray());
return(result);
}
catch (Exception)
{
throw;
}
}
