mschill
378653c536
The purpose of this upgrade is to improve the user experience when using the Admin tool to Update ROs. Currently for larger RO dbs (like Barakah) we can run up against memory constraints that do not allow all the ROs to be updated at one time. This is based upon some initial resource where some places were identified where we could improve memory usage. Some of these should benefit PROMS as a whole while others will be specific to the RO Update option in Admin Tools.
633 lines
26 KiB
C#
633 lines
26 KiB
C#
// ========================================================================
|
|
// Copyright 2007 - Volian Enterprises, Inc. All rights reserved.
|
|
// Volian Enterprises - Proprietary Information - DO NOT COPY OR DISTRIBUTE
|
|
// ------------------------------------------------------------------------
|
|
// $Workfile: $ $Revision: $
|
|
// $Author: $ $Date: $
|
|
//
|
|
// $History: $
|
|
// ========================================================================
|
|
|
|
using System;
|
|
using System.Data;
|
|
using System.Data.SqlClient;
|
|
using Csla;
|
|
using Csla.Data;
|
|
using System.Configuration;
|
|
using System.IO;
|
|
using System.ComponentModel;
|
|
using System.Collections.Generic;
|
|
namespace VEPROMS.CSLA.Library
|
|
{
|
|
public delegate void DocVersionInfoEvent(object sender);
|
|
/// <summary>
|
|
/// DocVersionInfo Generated by MyGeneration using the CSLA Object Mapping template
|
|
/// </summary>
|
|
[Serializable()]
|
|
[TypeConverter(typeof(DocVersionInfoConverter))]
|
|
public partial class DocVersionInfo : ReadOnlyBase<DocVersionInfo>, IDisposable
|
|
{
|
|
public event DocVersionInfoEvent Changed;
|
|
private void OnChange()
|
|
{
|
|
if (Changed != null) Changed(this);
|
|
}
|
|
#region Log4Net
|
|
private static readonly log4net.ILog _MyLog = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
|
|
#endregion
|
|
#region Collection
|
|
private static List<DocVersionInfo> _CacheList = new List<DocVersionInfo>();
|
|
protected static void AddToCache(DocVersionInfo docVersionInfo)
|
|
{
|
|
if (!_CacheList.Contains(docVersionInfo)) _CacheList.Add(docVersionInfo); // In AddToCache
|
|
}
|
|
protected static void RemoveFromCache(DocVersionInfo docVersionInfo)
|
|
{
|
|
while (_CacheList.Contains(docVersionInfo)) _CacheList.Remove(docVersionInfo); // In RemoveFromCache
|
|
}
|
|
private static Dictionary<string, List<DocVersionInfo>> _CacheByPrimaryKey = new Dictionary<string, List<DocVersionInfo>>();
|
|
private static void ConvertListToDictionary()
|
|
{
|
|
List<DocVersionInfo> remove = new List<DocVersionInfo>();
|
|
foreach (DocVersionInfo tmp in _CacheList)
|
|
{
|
|
if (!_CacheByPrimaryKey.ContainsKey(tmp.VersionID.ToString()))
|
|
{
|
|
_CacheByPrimaryKey[tmp.VersionID.ToString()] = new List<DocVersionInfo>(); // Add new list for PrimaryKey
|
|
}
|
|
_CacheByPrimaryKey[tmp.VersionID.ToString()].Add(tmp); // Add to Primary Key list
|
|
remove.Add(tmp);
|
|
}
|
|
foreach (DocVersionInfo tmp in remove)
|
|
RemoveFromCache(tmp);
|
|
}
|
|
internal static void AddList(DocVersionInfoList lst)
|
|
{
|
|
foreach (DocVersionInfo item in lst) AddToCache(item);
|
|
}
|
|
protected static DocVersionInfo GetCachedByPrimaryKey(int versionID)
|
|
{
|
|
ConvertListToDictionary();
|
|
string key = versionID.ToString();
|
|
if (_CacheByPrimaryKey.ContainsKey(key)) return _CacheByPrimaryKey[key][0];
|
|
return null;
|
|
}
|
|
#endregion
|
|
#region Business Methods
|
|
private string _ErrorMessage = string.Empty;
|
|
public string ErrorMessage
|
|
{
|
|
get { return _ErrorMessage; }
|
|
}
|
|
protected DocVersion _Editable;
|
|
private IVEHasBrokenRules HasBrokenRules
|
|
{
|
|
get
|
|
{
|
|
IVEHasBrokenRules hasBrokenRules = null;
|
|
if (_Editable != null)
|
|
hasBrokenRules = _Editable.HasBrokenRules;
|
|
return hasBrokenRules;
|
|
}
|
|
}
|
|
private int _VersionID;
|
|
[System.ComponentModel.DataObjectField(true, true)]
|
|
public int VersionID
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _VersionID;
|
|
}
|
|
}
|
|
private int _FolderID;
|
|
public int FolderID
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
if (_MyFolder != null) _FolderID = _MyFolder.FolderID;
|
|
return _FolderID;
|
|
}
|
|
}
|
|
private FolderInfo _MyFolder;
|
|
public FolderInfo MyFolder
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
if (_MyFolder == null && _FolderID != 0) _MyFolder = FolderInfo.Get(_FolderID);
|
|
return _MyFolder;
|
|
}
|
|
}
|
|
private int _VersionType;
|
|
/// <summary>
|
|
/// 0 Working Draft, 1 Temporary, 128 Revision, 129 Approved (Greater than 127 - non editable)
|
|
/// </summary>
|
|
public int VersionType
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _VersionType;
|
|
}
|
|
}
|
|
private string _Name = string.Empty;
|
|
public string Name
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _Name;
|
|
}
|
|
}
|
|
private string _Title = string.Empty;
|
|
public string Title
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _Title;
|
|
}
|
|
}
|
|
private int? _ItemID;
|
|
public int? ItemID
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
if (_MyItem != null) _ItemID = _MyItem.ItemID;
|
|
return _ItemID;
|
|
}
|
|
}
|
|
private ItemInfo _MyItem;
|
|
public ItemInfo MyItem
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
if (_MyItem == null && _ItemID != null) _MyItem = ItemInfo.Get((int)_ItemID);
|
|
return _MyItem;
|
|
}
|
|
}
|
|
private int? _FormatID;
|
|
public int? FormatID
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
if (_MyFormat != null) _FormatID = _MyFormat.FormatID;
|
|
return _FormatID;
|
|
}
|
|
}
|
|
private FormatInfo _MyFormat;
|
|
public FormatInfo MyFormat
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
if (_MyFormat == null && _FormatID != null) _MyFormat = FormatInfo.Get((int)_FormatID);
|
|
return _MyFormat;
|
|
}
|
|
}
|
|
private string _Config = string.Empty;
|
|
public string Config
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _Config;
|
|
}
|
|
}
|
|
private DateTime _DTS = new DateTime();
|
|
public DateTime DTS
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _DTS;
|
|
}
|
|
}
|
|
private string _UserID = string.Empty;
|
|
public string UserID
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _UserID;
|
|
}
|
|
}
|
|
private int _DocVersionDocVersionROFstCount = 0;
|
|
/// <summary>
|
|
/// Count of DocVersionDocVersionROFsts for this DocVersion
|
|
/// </summary>
|
|
public int DocVersionDocVersionROFstCount
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
return _DocVersionDocVersionROFstCount;
|
|
}
|
|
}
|
|
private DocVersionROFstInfoList _DocVersionDocVersionROFsts = null;
|
|
[TypeConverter(typeof(DocVersionROFstInfoListConverter))]
|
|
public DocVersionROFstInfoList DocVersionDocVersionROFsts
|
|
{
|
|
[System.Runtime.CompilerServices.MethodImpl(System.Runtime.CompilerServices.MethodImplOptions.NoInlining)]
|
|
get
|
|
{
|
|
if (_DocVersionDocVersionROFstCount < 0 || (_DocVersionDocVersionROFstCount > 0 && _DocVersionDocVersionROFsts == null))
|
|
_DocVersionDocVersionROFsts = DocVersionROFstInfoList.GetByVersionID(_VersionID);
|
|
if (_DocVersionDocVersionROFstCount < 0)
|
|
_DocVersionDocVersionROFstCount = _DocVersionDocVersionROFsts.Count;
|
|
return _DocVersionDocVersionROFsts;
|
|
}
|
|
}
|
|
public void RefreshDocVersionDocVersionROFsts()
|
|
{
|
|
ConvertListToDictionary();
|
|
if (_CacheByPrimaryKey.ContainsKey(_VersionID.ToString()))
|
|
foreach (DocVersionInfo tmp in _CacheByPrimaryKey[_VersionID.ToString()])
|
|
tmp._DocVersionDocVersionROFstCount = -1; // This will cause the data to be requeried
|
|
}
|
|
// TODO: Replace base DocVersionInfo.ToString function as necessary
|
|
/// <summary>
|
|
/// Overrides Base ToString
|
|
/// </summary>
|
|
/// <returns>A string representation of current DocVersionInfo</returns>
|
|
//public override string ToString()
|
|
//{
|
|
// return base.ToString();
|
|
//}
|
|
// TODO: Check DocVersionInfo.GetIdValue to assure that the ID returned is unique
|
|
/// <summary>
|
|
/// Overrides Base GetIdValue - Used internally by CSLA to determine equality
|
|
/// </summary>
|
|
/// <returns>A Unique ID for the current DocVersionInfo</returns>
|
|
protected override object GetIdValue()
|
|
{
|
|
return _VersionID;
|
|
}
|
|
#endregion
|
|
#region Factory Methods
|
|
private static int _DocVersionInfoUnique = 0;
|
|
private static int DocVersionInfoUnique
|
|
{ get { return ++_DocVersionInfoUnique; } }
|
|
private int _MyDocVersionInfoUnique = DocVersionInfoUnique;
|
|
public int MyDocVersionInfoUnique
|
|
{ get { return _MyDocVersionInfoUnique; } }
|
|
protected DocVersionInfo()
|
|
{/* require use of factory methods */
|
|
AddToCache(this);
|
|
}
|
|
public void Dispose()
|
|
{
|
|
RemoveFromCache(this);
|
|
if (!_CacheByPrimaryKey.ContainsKey(VersionID.ToString())) return;
|
|
List<DocVersionInfo> listDocVersionInfo = _CacheByPrimaryKey[VersionID.ToString()]; // Get the list of items
|
|
while (listDocVersionInfo.Contains(this)) listDocVersionInfo.Remove(this); // Remove the item from the list
|
|
if (listDocVersionInfo.Count == 0) // If there are no items left in the list
|
|
_CacheByPrimaryKey.Remove(VersionID.ToString()); // remove the list
|
|
}
|
|
public virtual DocVersion Get()
|
|
{
|
|
return _Editable = DocVersion.Get(_VersionID);
|
|
}
|
|
public static void Refresh(DocVersion tmp)
|
|
{
|
|
string key = tmp.VersionID.ToString();
|
|
ConvertListToDictionary();
|
|
if (_CacheByPrimaryKey.ContainsKey(key))
|
|
foreach (DocVersionInfo tmpInfo in _CacheByPrimaryKey[key])
|
|
tmpInfo.RefreshFields(tmp);
|
|
}
|
|
protected virtual void RefreshFields(DocVersion tmp)
|
|
{
|
|
if (_FolderID != tmp.FolderID)
|
|
{
|
|
if (MyFolder != null) MyFolder.RefreshFolderDocVersions(); // Update List for old value
|
|
_FolderID = tmp.FolderID; // Update the value
|
|
}
|
|
_MyFolder = null; // Reset list so that the next line gets a new list
|
|
if (MyFolder != null) MyFolder.RefreshFolderDocVersions(); // Update List for new value
|
|
_VersionType = tmp.VersionType;
|
|
_Name = tmp.Name;
|
|
_Title = tmp.Title;
|
|
if (_ItemID != tmp.ItemID)
|
|
{
|
|
if (MyItem != null) MyItem.RefreshItemDocVersions(); // Update List for old value
|
|
_ItemID = tmp.ItemID; // Update the value
|
|
}
|
|
_MyItem = null; // Reset list so that the next line gets a new list
|
|
if (MyItem != null) MyItem.RefreshItemDocVersions(); // Update List for new value
|
|
if (_FormatID != tmp.FormatID)
|
|
{
|
|
if (MyFormat != null) MyFormat.RefreshFormatDocVersions(); // Update List for old value
|
|
_FormatID = tmp.FormatID; // Update the value
|
|
}
|
|
_MyFormat = null; // Reset list so that the next line gets a new list
|
|
if (MyFormat != null) MyFormat.RefreshFormatDocVersions(); // Update List for new value
|
|
_Config = tmp.Config;
|
|
_DTS = tmp.DTS;
|
|
_UserID = tmp.UserID;
|
|
_DocVersionInfoExtension.Refresh(this);
|
|
if (_MyFolder != null)
|
|
{
|
|
_MyFolder.Dispose();// Dispose related value
|
|
_MyFolder = null;// Reset related value
|
|
}
|
|
if (_MyItem != null)
|
|
{
|
|
_MyItem.Dispose();// Dispose related value
|
|
_MyItem = null;// Reset related value
|
|
}
|
|
if (_MyFormat != null)
|
|
{
|
|
_MyFormat.Dispose();// Dispose related value
|
|
_MyFormat = null;// Reset related value
|
|
}
|
|
OnChange();// raise an event
|
|
}
|
|
public static void Refresh(FolderDocVersion tmp)
|
|
{
|
|
string key = tmp.VersionID.ToString();
|
|
ConvertListToDictionary();
|
|
if (_CacheByPrimaryKey.ContainsKey(key))
|
|
foreach (DocVersionInfo tmpInfo in _CacheByPrimaryKey[key])
|
|
tmpInfo.RefreshFields(tmp);
|
|
}
|
|
protected virtual void RefreshFields(FolderDocVersion tmp)
|
|
{
|
|
_VersionType = tmp.VersionType;
|
|
_Name = tmp.Name;
|
|
_Title = tmp.Title;
|
|
if (_ItemID != tmp.ItemID)
|
|
{
|
|
if (MyItem != null) MyItem.RefreshItemDocVersions(); // Update List for old value
|
|
_ItemID = tmp.ItemID; // Update the value
|
|
}
|
|
_MyItem = null; // Reset list so that the next line gets a new list
|
|
if (MyItem != null) MyItem.RefreshItemDocVersions(); // Update List for new value
|
|
if (_FormatID != tmp.FormatID)
|
|
{
|
|
if (MyFormat != null) MyFormat.RefreshFormatDocVersions(); // Update List for old value
|
|
_FormatID = tmp.FormatID; // Update the value
|
|
}
|
|
_MyFormat = null; // Reset list so that the next line gets a new list
|
|
if (MyFormat != null) MyFormat.RefreshFormatDocVersions(); // Update List for new value
|
|
_Config = tmp.Config;
|
|
_DTS = tmp.DTS;
|
|
_UserID = tmp.UserID;
|
|
_DocVersionInfoExtension.Refresh(this);
|
|
if (_MyFolder != null)
|
|
{
|
|
_MyFolder.Dispose();// Dispose related value
|
|
_MyFolder = null;// Reset related value
|
|
}
|
|
if (_MyItem != null)
|
|
{
|
|
_MyItem.Dispose();// Dispose related value
|
|
_MyItem = null;// Reset related value
|
|
}
|
|
if (_MyFormat != null)
|
|
{
|
|
_MyFormat.Dispose();// Dispose related value
|
|
_MyFormat = null;// Reset related value
|
|
}
|
|
OnChange();// raise an event
|
|
}
|
|
public static void Refresh(FormatDocVersion tmp)
|
|
{
|
|
string key = tmp.VersionID.ToString();
|
|
ConvertListToDictionary();
|
|
if (_CacheByPrimaryKey.ContainsKey(key))
|
|
foreach (DocVersionInfo tmpInfo in _CacheByPrimaryKey[key])
|
|
tmpInfo.RefreshFields(tmp);
|
|
}
|
|
protected virtual void RefreshFields(FormatDocVersion tmp)
|
|
{
|
|
if (_FolderID != tmp.FolderID)
|
|
{
|
|
if (MyFolder != null) MyFolder.RefreshFolderDocVersions(); // Update List for old value
|
|
_FolderID = tmp.FolderID; // Update the value
|
|
}
|
|
_MyFolder = null; // Reset list so that the next line gets a new list
|
|
if (MyFolder != null) MyFolder.RefreshFolderDocVersions(); // Update List for new value
|
|
_VersionType = tmp.VersionType;
|
|
_Name = tmp.Name;
|
|
_Title = tmp.Title;
|
|
if (_ItemID != tmp.ItemID)
|
|
{
|
|
if (MyItem != null) MyItem.RefreshItemDocVersions(); // Update List for old value
|
|
_ItemID = tmp.ItemID; // Update the value
|
|
}
|
|
_MyItem = null; // Reset list so that the next line gets a new list
|
|
if (MyItem != null) MyItem.RefreshItemDocVersions(); // Update List for new value
|
|
_Config = tmp.Config;
|
|
_DTS = tmp.DTS;
|
|
_UserID = tmp.UserID;
|
|
_DocVersionInfoExtension.Refresh(this);
|
|
if (_MyFolder != null)
|
|
{
|
|
_MyFolder.Dispose();// Dispose related value
|
|
_MyFolder = null;// Reset related value
|
|
}
|
|
if (_MyItem != null)
|
|
{
|
|
_MyItem.Dispose();// Dispose related value
|
|
_MyItem = null;// Reset related value
|
|
}
|
|
if (_MyFormat != null)
|
|
{
|
|
_MyFormat.Dispose();// Dispose related value
|
|
_MyFormat = null;// Reset related value
|
|
}
|
|
OnChange();// raise an event
|
|
}
|
|
public static void Refresh(ItemDocVersion tmp)
|
|
{
|
|
string key = tmp.VersionID.ToString();
|
|
ConvertListToDictionary();
|
|
if (_CacheByPrimaryKey.ContainsKey(key))
|
|
foreach (DocVersionInfo tmpInfo in _CacheByPrimaryKey[key])
|
|
tmpInfo.RefreshFields(tmp);
|
|
}
|
|
protected virtual void RefreshFields(ItemDocVersion tmp)
|
|
{
|
|
if (_FolderID != tmp.FolderID)
|
|
{
|
|
if (MyFolder != null) MyFolder.RefreshFolderDocVersions(); // Update List for old value
|
|
_FolderID = tmp.FolderID; // Update the value
|
|
}
|
|
_MyFolder = null; // Reset list so that the next line gets a new list
|
|
if (MyFolder != null) MyFolder.RefreshFolderDocVersions(); // Update List for new value
|
|
_VersionType = tmp.VersionType;
|
|
_Name = tmp.Name;
|
|
_Title = tmp.Title;
|
|
if (_FormatID != tmp.FormatID)
|
|
{
|
|
if (MyFormat != null) MyFormat.RefreshFormatDocVersions(); // Update List for old value
|
|
_FormatID = tmp.FormatID; // Update the value
|
|
}
|
|
_MyFormat = null; // Reset list so that the next line gets a new list
|
|
if (MyFormat != null) MyFormat.RefreshFormatDocVersions(); // Update List for new value
|
|
_Config = tmp.Config;
|
|
_DTS = tmp.DTS;
|
|
_UserID = tmp.UserID;
|
|
_DocVersionInfoExtension.Refresh(this);
|
|
if (_MyFolder != null)
|
|
{
|
|
_MyFolder.Dispose();// Dispose related value
|
|
_MyFolder = null;// Reset related value
|
|
}
|
|
if (_MyItem != null)
|
|
{
|
|
_MyItem.Dispose();// Dispose related value
|
|
_MyItem = null;// Reset related value
|
|
}
|
|
if (_MyFormat != null)
|
|
{
|
|
_MyFormat.Dispose();// Dispose related value
|
|
_MyFormat = null;// Reset related value
|
|
}
|
|
OnChange();// raise an event
|
|
}
|
|
public static DocVersionInfo Get(int versionID)
|
|
{
|
|
//if (!CanGetObject())
|
|
// throw new System.Security.SecurityException("User not authorized to view a DocVersion");
|
|
try
|
|
{
|
|
DocVersionInfo tmp = GetCachedByPrimaryKey(versionID);
|
|
if (tmp == null)
|
|
{
|
|
tmp = DataPortal.Fetch<DocVersionInfo>(new PKCriteria(versionID));
|
|
AddToCache(tmp);
|
|
}
|
|
if (tmp.ErrorMessage == "No Record Found")
|
|
{
|
|
tmp.Dispose(); // Clean-up DocVersionInfo
|
|
tmp = null;
|
|
}
|
|
return tmp;
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
throw new DbCslaException("Error on DocVersionInfo.Get", ex);
|
|
}
|
|
}
|
|
#endregion
|
|
#region Data Access Portal
|
|
internal DocVersionInfo(SafeDataReader dr)
|
|
{
|
|
if (_MyLog.IsDebugEnabled) _MyLog.DebugFormat("[{0}] DocVersionInfo.Constructor", GetHashCode());
|
|
try
|
|
{
|
|
ReadData(dr);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
if (_MyLog.IsErrorEnabled) _MyLog.Error("DocVersionInfo.Constructor", ex);
|
|
throw new DbCslaException("DocVersionInfo.Constructor", ex);
|
|
}
|
|
}
|
|
[Serializable()]
|
|
protected class PKCriteria
|
|
{
|
|
private int _VersionID;
|
|
public int VersionID
|
|
{ get { return _VersionID; } }
|
|
public PKCriteria(int versionID)
|
|
{
|
|
_VersionID = versionID;
|
|
}
|
|
}
|
|
private void ReadData(SafeDataReader dr)
|
|
{
|
|
if (_MyLog.IsDebugEnabled) _MyLog.DebugFormat("[{0}] DocVersionInfo.ReadData", GetHashCode());
|
|
try
|
|
{
|
|
_VersionID = dr.GetInt32("VersionID");
|
|
_FolderID = dr.GetInt32("FolderID");
|
|
_VersionType = dr.GetInt32("VersionType");
|
|
_Name = dr.GetString("Name");
|
|
_Title = dr.GetString("Title");
|
|
_ItemID = (int?)dr.GetValue("ItemID");
|
|
_FormatID = (int?)dr.GetValue("FormatID");
|
|
_Config = dr.GetString("Config");
|
|
_DTS = dr.GetDateTime("DTS");
|
|
_UserID = dr.GetString("UserID");
|
|
_DocVersionDocVersionROFstCount = dr.GetInt32("DocVersionROFstCount");
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
if (_MyLog.IsErrorEnabled) _MyLog.Error("DocVersionInfo.ReadData", ex);
|
|
_ErrorMessage = ex.Message;
|
|
throw new DbCslaException("DocVersionInfo.ReadData", ex);
|
|
}
|
|
}
|
|
private void DataPortal_Fetch(PKCriteria criteria)
|
|
{
|
|
if (_MyLog.IsDebugEnabled) _MyLog.DebugFormat("[{0}] DocVersionInfo.DataPortal_Fetch", GetHashCode());
|
|
try
|
|
{
|
|
using (SqlConnection cn = Database.VEPROMS_SqlConnection)
|
|
{
|
|
ApplicationContext.LocalContext["cn"] = cn;
|
|
using (SqlCommand cm = cn.CreateCommand())
|
|
{
|
|
cm.CommandType = CommandType.StoredProcedure;
|
|
cm.CommandText = "getDocVersion";
|
|
cm.Parameters.AddWithValue("@VersionID", criteria.VersionID);
|
|
using (SafeDataReader dr = new SafeDataReader(cm.ExecuteReader()))
|
|
{
|
|
if (!dr.Read())
|
|
{
|
|
_ErrorMessage = "No Record Found";
|
|
return;
|
|
}
|
|
ReadData(dr);
|
|
}
|
|
}
|
|
// removing of item only needed for local data portal
|
|
if (ApplicationContext.ExecutionLocation == ApplicationContext.ExecutionLocations.Client)
|
|
ApplicationContext.LocalContext.Remove("cn");
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
if (_MyLog.IsErrorEnabled) _MyLog.Error("DocVersionInfo.DataPortal_Fetch", ex);
|
|
_ErrorMessage = ex.Message;
|
|
throw new DbCslaException("DocVersionInfo.DataPortal_Fetch", ex);
|
|
}
|
|
}
|
|
#endregion
|
|
// Standard Refresh
|
|
#region extension
|
|
DocVersionInfoExtension _DocVersionInfoExtension = new DocVersionInfoExtension();
|
|
[Serializable()]
|
|
partial class DocVersionInfoExtension : extensionBase { }
|
|
[Serializable()]
|
|
class extensionBase
|
|
{
|
|
// Default Refresh
|
|
public virtual void Refresh(DocVersionInfo tmp) { }
|
|
}
|
|
#endregion
|
|
} // Class
|
|
#region Converter
|
|
internal class DocVersionInfoConverter : ExpandableObjectConverter
|
|
{
|
|
public override object ConvertTo(ITypeDescriptorContext context, System.Globalization.CultureInfo culture, object value, Type destType)
|
|
{
|
|
if (destType == typeof(string) && value is DocVersionInfo)
|
|
{
|
|
// Return the ToString value
|
|
return ((DocVersionInfo)value).ToString();
|
|
}
|
|
return base.ConvertTo(context, culture, value, destType);
|
|
}
|
|
}
|
|
#endregion
|
|
} // Namespace
|