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