public static Art[] FindArtByArtName(decimal?mandantid, string artname, GetModeEnum mode, IUnitOfWork uow)
{
if (!mandantid.HasValue || string.IsNullOrEmpty(artname))
{
return(null);
}
var type = typeof(Art);
var filter = string.Format("UPPER({0}) = '{1}' and {2} = {3}",
SourceNameHelper.Instance.GetPropertySourceName(type, Art.ArtNamePropertyName),
string.IsNullOrEmpty(artname) ? artname : artname.ToUpper(),
SourceNameHelper.Instance.GetPropertySourceName(type, Art.MANDANTIDPropertyName), mandantid);
Art[] result;
using (var mgr = IoC.Instance.Resolve <IBaseManager <Art> >())
{
if (uow != null)
{
mgr.SetUnitOfWork(uow);
}
result = mgr.GetFiltered(filter, mode).ToArray();
}
if (result.Length > 1)
{
result = result.Where(p => p.ArtName == artname).ToArray();
}
return(result);
}
public IEnumerable <TE> GetByCurrentPlace(string placeCode, GetModeEnum mode = GetModeEnum.Partial)
{
if (string.IsNullOrEmpty(placeCode))
{
throw new ArgumentNullException("placeCode");
}
var filter = string.Format("{0} = '{1}'", TE.CurrentPlacePropertyName, placeCode);
return(GetFiltered(filter, mode));
}
public IEnumerable <TE> GetPackingTEOnPlace(string placeCode, GetModeEnum mode = GetModeEnum.Partial)
{
if (string.IsNullOrEmpty(placeCode))
{
throw new ArgumentNullException("placeCode");
}
// фильтр, который отберет все ТЕ с данного места у которых тип - упаковка
var filter = string.Format("{0} = '{1}' AND NVL(TEPACKSTATUS,' ') != 'TE_PKG_NONE' ", TE.CurrentPlacePropertyName, placeCode);
return(GetFiltered(filter, mode));
}
T IBaseManager <T> .Get(object key, GetModeEnum mode)
{
if (key == null)
{
throw new ArgumentNullException("key");
}
//HACK: сделано для SysObject'а.
if (typeof(TKey) == typeof(int) && key is decimal)
{
key = key.To(0);
}
return(Get((TKey)key, mode));
}
public ReportFile GetByReportFile(string reportFile, GetModeEnum mode = GetModeEnum.Partial)
{
if (string.IsNullOrEmpty(reportFile))
{
return(null);
}
var reportFiles =
GetFiltered(string.Format("{0} = '{1}'",
SourceNameHelper.Instance.GetPropertySourceName(typeof(ReportFile),
ReportFile.ReportFileFilePropertyName), reportFile), mode).ToArray();
return(reportFiles.Any() ? reportFiles[0] : null);
}
IEnumerable <object> IBaseManager.GetAll(GetModeEnum mode)
{
return(GetAll(mode));
}
object IBaseManager.Get(object key, GetModeEnum mode)
{
return(Get((TKey)key, mode));
}
public override ObjectValid Get(decimal key, GetModeEnum mode = GetModeEnum.Full)
{
// не лезем в БД за единичными записями (получаем сразу все и кэшируем)
return(GetAll(mode).FirstOrDefault(i => i.ObjectValidId == key));
}
/// <summary>
/// Initializes a new instance of the <see cref="GetByIDParameters"/> class.
/// </summary>
/// <param name="getMode">The get mode.</param>
/// <param name="lockMode">The lock mode.</param>
public GetByIDParameters(GetSourceTypeEnum sourceType, GetModeEnum getMode, LockModeEnum lockMode)
{
_GetMode = getMode;
_LockMode = lockMode;
_SourceType = sourceType;
}
public virtual IEnumerable <T> GetAll(GetModeEnum mode = GetModeEnum.Full)
{
return(GetAll(GetAttrEntity(typeof(T), mode)));
}
public virtual T Get(TKey key, GetModeEnum mode)
{
return(Get(key, GetAttrEntity(typeof(T), mode)));
}
IEnumerable <object> IHistoryManager.GetHistory(string filter, GetModeEnum mode)
{
return(GetHistory(filter, mode));
}
public IEnumerable <HistoryWrapper <T> > GetHistory(string filter, GetModeEnum mode)
{
return(GetHistory(filter, GetAttrEntity(typeof(T), mode)));
}
public IEnumerable <Product> GetByTECode(string teCode, bool byNested = false, GetModeEnum mode = GetModeEnum.Partial)
{
if (string.IsNullOrEmpty(teCode))
{
throw new ArgumentNullException("teCode");
}
var filter = !byNested?string.Format("TECODE_R = '{0}'", teCode) : string.Format("TECODE_R in (select wmste.tecode from wmste start with (TECarrierStreakCode = '{0}' or tecode='{0}') connect by prior TECode = TECarrierStreakCode) ", teCode);
return(GetFiltered(filter, mode));
}
protected override string GetAttrEntity(Type type, GetModeEnum mode)
{
//TODO: реализовать "короткий" формат
return(base.GetAttrEntity(type, mode));
}
public override SysObject Get(decimal key, GetModeEnum mode = GetModeEnum.Full)
{
return(GetAll().FirstOrDefault(i => i.ObjectID == key));
}
public override IEnumerable <SysObject> GetFiltered(string filter, GetModeEnum mode = GetModeEnum.Full)
{
Initialize();
return(base.GetFiltered(filter, mode));
}
public override IEnumerable <SysObject> GetAll(GetModeEnum mode = GetModeEnum.Full)
{
Initialize();
return(base.GetAll(mode));
}
IEnumerable <object> IBaseManager.GetFiltered(string filter, GetModeEnum mode)
{
return(GetFiltered(filter, mode));
}
public override IEnumerable <T> GetFiltered(string filter, GetModeEnum mode = GetModeEnum.Full)
{
Check(ReadRightName);
return(base.GetFiltered(filter, mode));
}
public override IEnumerable <T> GetAll(GetModeEnum mode = GetModeEnum.Full)
{
Check(ReadRightName);
return(base.GetAll(mode));
}
protected virtual string GetAttrEntity(Type type, GetModeEnum mode)
{
return(mode == GetModeEnum.Full
? null
: XmlDocumentConverter.GetShortTemplate(typeof(T)).OuterXml);
}
/// <summary>
/// Поиск работы для сущности по коду операции.
/// </summary>
/// <param name="entity">имя сущности</param>
/// <param name="key">код экземпляра сущности</param>
/// <param name="operation">код операции</param>
/// <param name="mode">режим получения объекта</param>
/// <returns>работа</returns>
public static Work GetWorkByEntity(string entity, object key, BillOperationCode operation, GetModeEnum mode = GetModeEnum.Full)
{
var filter =
string.Format(
"workid in (select max(w2e.workid_r) from wmswork2entity w2e inner join wmswork w on w.workid = w2e.workid_r where w2e.work2entityentity = '{0}' and w2e.work2entitykey = '{1}' and w.operationcode_r = '{2}')",
entity, key, operation);
using (var mgr = IoC.Instance.Resolve <IBaseManager <Work> >())
{
var works = mgr.GetFiltered(filter, mode).ToArray();
if (works.Length > 0)
{
return(works[0]);
}
}
return(null);
}
public virtual IEnumerable <T> GetFiltered(string filter, GetModeEnum mode)
{
return(GetFiltered(filter, GetAttrEntity(typeof(T), mode)));
}
/// <summary>
/// Initializes a new instance of the <see cref="GetByIDParameters"/> class.
/// </summary>
/// <param name="sourceType">Type of the source.</param>
/// <param name="getMode">The get mode.</param>
public GetByIDParameters(GetSourceTypeEnum sourceType, GetModeEnum getMode)
: this(sourceType, getMode, LockModeEnum.None)
{
}
public override ObjectLookUp Get(string key, GetModeEnum mode = GetModeEnum.Full)
{
// не лезем в БД за единичными записями (получаем сразу все и кэшируем)
return(GetAll(mode).FirstOrDefault(i => key.Equals(i.GetKey())));
}
public override T Get(TKey key, GetModeEnum mode = GetModeEnum.Full)
{
Check(ReadRightName);
return(base.Get(key, mode));
}
