public HttpResponseMessage ClearLot(int pk)
{
try
{
QM_Batch_Error entity = qM_Batch_ErrorBO.GetEntity(pk);
entity.IsCleared = true;
qM_Batch_ErrorBO.UpdateSome(entity);
return(Request.CreateResponse(HttpStatusCode.OK, "解锁成功"));
}
catch (Exception ex) {
return(Request.CreateResponse(HttpStatusCode.InternalServerError, "解锁失败：" + ex.Message));
}
}
public string ajqxUpQM_Batch_Error(QM_Batch_Error_Param def)
{
try
{
QM_Batch_Error defList = new QM_Batch_Error();
LES_REQUEST_RECEIVE updateReceiveTime = new LES_REQUEST_RECEIVE();
string orderID = "";
string materialID = "";
string lotID = "";
if (def.IsMoisture == "1" || def.IsMoisture == "是")
{
defList.RowDelete = true;
defList.PK = def.PK;
IQM_Batch_ErrorBOibo.UpdateSome(defList);
materialID = defList.MaterialID;
orderID = defList.OrderID;
lotID = defList.lotID;
string sqlGetReceivePK = @"SELECT ReceivePK FROM dbo.LES_REQUEST_RECEIVE WHERE OrderID='{0}' AND MaterialID='{1}' AND LotID='{2}' and Status=3";
sqlGetReceivePK = string.Format(sqlGetReceivePK, orderID, materialID, lotID);
DataTable dtReceivePk = co_BSC_BO.GetDataTableBySql(sqlGetReceivePK);
if (dtReceivePk == null || dtReceivePk.Rows.Count == 0)
{
}
else
{
for (int i = 0; i < dtReceivePk.Rows.Count; i++)
{
updateReceiveTime.ReceivePK = Convert.ToInt32(dtReceivePk.Rows[i][0]);
updateReceiveTime.ReceiveTime = DateTime.Now;
ILES_Request_ReceiveBO.UpdateSome(updateReceiveTime);
//string updateLesReceiveTime = @"UPDATE dbo.LES_REQUEST_RECEIVE SET ReceiveTime=GETDATE() WHERE ReceivePK='" + dtReceivePk.Rows[i][0] + "'";
//updateLesReceiveTime = string.Format(updateLesReceiveTime);
//co_BSC_BO.ExecuteNonQueryBySql(updateLesReceiveTime);
}
}
}
else
{
return("当前产品不需要释放。");
}
return("OK");
}
catch (Exception ex) {
return("系统内部出现异常：" + ex.Message);
}
}
