public DataTable GetProductionOrderStatus(string Code, string No, string STT) { DataTable dt = new DataTable(); ProductionOrderStatus POStatus = new ProductionOrderStatus(); try { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append(" select * from MOCTA where 1=1 "); stringBuilder.Append(" and TA026 ='" + Code + "' "); stringBuilder.Append(" and TA027 = '" + No + "' "); stringBuilder.Append(" and TA028 = '" + STT + "' "); stringBuilder.Append(" and TA013 = '" + "Y" + "' "); SqlTLVN2 sqlTLVN2 = new SqlTLVN2(); sqlTLVN2.sqlDataAdapterFillDatatable(stringBuilder.ToString(), ref dt); if (dt.Rows.Count > 0) { } } catch (Exception ex) { SystemLog.Output(SystemLog.MSG_TYPE.Err, "GetProductionOrderStatus(string clientOrder)", ex.Message); } return(dt); }
internal static void ChangeStatus(ProductionOrder productionOrder, ProductionOrderStatus status) { try { using (var connection = SqlServer.OpenConnection()) { var strSql = "UPDATE ProductionOrders SET Status=@Status WHERE Id = @Id"; using (var command = new SqlCommand(strSql, connection)) { command.Parameters.AddWithValue("@Id", productionOrder.Id); command.Parameters.AddWithValue("@Status", status); command.ExecuteNonQuery(); // Para el INSERT, DELETE Y UPDATE se utiliza el ExecuteNonQuery porque no devuelve nada } } } catch (Exception ex) { throw ex; } }
public static StatusOption GetStatusOption(ProductionOrderStatus status, DataAccessDataContext context) { return StatusService.GetStatuses(context)[StatusType.ProductionOrderStatus].Where(s => s.SystemName == status.ToString()).SingleOrDefault(); }
public int GetProductionOrderStatusID(ProductionOrderStatus oProductionOrderStatus) { var iProductionOrderStatusID = 0; var sCacheItemKey = "ProductionOrderStatus-" + oProductionOrderStatus.ToString(); if (HttpContext.Current.Cache[sCacheItemKey] == null) { iProductionOrderStatusID = GetProductionOrderStatusFromDB(oProductionOrderStatus).IAProductionOrderStatusID; HttpContext.Current.Cache.Add(sCacheItemKey, iProductionOrderStatusID, null, DateTime.Now.AddSeconds(3600), TimeSpan.Zero, CacheItemPriority.Normal, null); } else { iProductionOrderStatusID = (int) HttpContext.Current.Cache[sCacheItemKey]; } return iProductionOrderStatusID; }
/// <summary> /// Retreives the apporpirate ProductionOrderStatus object from the DB based on the enum value passed in /// </summary> /// <param name="oProductionOrderStatus"></param> /// <returns></returns> private IAProductionOrderStatus GetProductionOrderStatusFromDB(ProductionOrderStatus oProductionOrderStatus) { IAProductionOrderStatus oIAProductionOrderStatus = null; switch (oProductionOrderStatus) { case ProductionOrderStatus.Incomplete: oIAProductionOrderStatus = DataAccess.IAProductionOrderStatus.SingleOrDefault(row => row.Name == "Incomplete"); break; case ProductionOrderStatus.Complete: oIAProductionOrderStatus = DataAccess.IAProductionOrderStatus.SingleOrDefault(row => row.Name == "Complete"); break; default: throw new ApplicationException(string.Format("Production Order status is undefined or doesn't exist: {0}", oProductionOrderStatus.ToString())); } return oIAProductionOrderStatus; }