/// <summary>
/// 更新出库
/// </summary>
/// <param name="wms_PutOut_Model"></param>
/// <param name="condition"></param>
/// <returns></returns>
public static int Update_PutOutHis(WMS_PutOutHis_Model wms_PutOutHis_Model, string condition)
{
using (var con = GetOpenConnection())
{
return(con.Execute(WMS_PutOutHis_Dal.Update_PutOutHis(wms_PutOutHis_Model, condition)));
}
}
/// <summary>
/// 插入出库
/// </summary>
/// <param name="wms_PutOut_Model"></param>
/// <returns></returns>
public static int Insert_PutOutHis(WMS_PutOutHis_Model wms_PutOutHis_Model)
{
using (var con = GetOpenConnection())
{
return(con.Execute(WMS_PutOutHis_Dal.Insert_PutOutHis(wms_PutOutHis_Model)));
}
}
/// <summary>
/// 插入出库
/// </summary>
/// <param name="wms_PutOut_Model"></param>
/// <returns></returns>
public static string Insert_PutOutHis(WMS_PutOutHis_Model wms_PutOutHis_Model)
{
string _insertSql = "INSERT INTO [WMS].[dbo].[WMS_PutOutHis]"
+ "([ShelfNo],[PutOutNo],[SN],[OrderNo],[PutOutType]"
+ ",[Status],[PutOutTime])VALUES('" + wms_PutOutHis_Model.ShelfNo
+ "','" + wms_PutOutHis_Model.PutOutNo + "','"
+ wms_PutOutHis_Model.SN + "','" + wms_PutOutHis_Model.OrderNo
+ "','" + wms_PutOutHis_Model.PutOutType
+ "','" + wms_PutOutHis_Model.Status + "','"
+ wms_PutOutHis_Model.PutOutTime + "')";
return(_insertSql);
}
/// <summary>
/// 更新出库
/// </summary>
/// <param name="wms_PutOut_Model"></param>
/// <param name="condition"></param>
/// <returns></returns>
public static string Update_PutOutHis(WMS_PutOutHis_Model wms_PutOutHis_Model, string condition)
{
string _updateSql = "UPDATE [WMS].[dbo].[WMS_PutOutHis] "
+ "SET[ShelfNo] = '" + wms_PutOutHis_Model.ShelfNo
+ "',[PutOutNo] = '" + wms_PutOutHis_Model.PutOutNo
+ "',[SN] = '" + wms_PutOutHis_Model.SN
+ "',[OrderNo] = '" + wms_PutOutHis_Model.OrderNo
+ "',[PutOutType] = '" + wms_PutOutHis_Model.PutOutType
+ "',[Status] = '" + wms_PutOutHis_Model.Status
+ "',[PutOutTime] = '" + wms_PutOutHis_Model.PutOutTime
+ "' WHERE " + condition;
return(_updateSql);
}