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