//T ConvertTableT( DataTable table)
//{
// return new T(table);
//}
/// <summary>
/// 根据id读取指定行。该方法不受其它参数限定
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public virtual T GetRowById(int id)
{
T dt = new T();
if (string.IsNullOrEmpty(dt.IdentifyField))
{
throw new Exception("表[" + dt.TableName + "] 无主键数");
}
string sql = string.Format("select * from {0} where {1}={2}",
((IDBSQLHelper)this).safeTableName, dBase.FieldEncode(dt.IdentifyField), id);
LastSqlExecute = sql;
var cmd = dBase.Command();
cmd.CommandText = sql;
System.Data.IDataReader reader = null;
try
{
reader = dBase.ExecuteReader(cmd);
return(Reader2Item(reader));
}
finally
{
cmd.Cancel();//可快速关闭reader
if (reader != null)
{
reader.Dispose();
}
cmd.Dispose();
}
}
/// <summary>
/// Returns the value of the specified variable name
/// </summary>
/// <param name="varName">Variable name</param>
/// <returns>variable value</returns>
public string GetVarValue(string varName)
{
string Function_Name = "GetVarValue";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
string varValue = "null";
string localSQL = "SELECT VAR_VALUE FROM CONFIG_VARS WHERE VAR_NAME = '" + varName + "'";
System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL);
if (drReader != null)
{
try
{
while (drReader.Read())
{
if (!drReader.IsDBNull(0))
{
varValue = drReader.GetString(0).ToString();
}
}
}
catch (System.Exception ex)
{
LogHelper.Error(CLASS_NAME, Function_Name, ex.ToString());
}
drReader.Close();
drReader.Dispose();
}
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited");
return(varValue);
}
public void Dispose()
{
if (m_reader != null)
{
m_reader.Dispose();
m_reader = null;
}
if (m_command != null)
{
m_command.Dispose();
m_command = null;
}
if (m_tmptable != null)
{
try
{
using (var c = m_connection.CreateCommand())
{
c.CommandText = string.Format(@"DROP TABLE IF EXISTS ""{0}""", m_tmptable);
c.ExecuteNonQuery();
}
}
catch { }
finally { m_tmptable = null; }
}
}
public static SoftFluent.Samples.Thinktecture.IdentityServer.Login LoadById(System.Guid id)
{
if ((id.Equals(CodeFluentPersistence.DefaultGuidValue) == true))
{
return(null);
}
SoftFluent.Samples.Thinktecture.IdentityServer.Login login = new SoftFluent.Samples.Thinktecture.IdentityServer.Login();
CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.Samples.Thinktecture.IdentityServer.Constants.SoftFluent_Samples_Thinktecture_IdentityServerStoreName).Persistence;
persistence.CreateStoredProcedureCommand(null, "Login", "LoadById");
persistence.AddParameter("@Id", id, CodeFluentPersistence.DefaultGuidValue);
System.Data.IDataReader reader = null;
try
{
reader = persistence.ExecuteReader();
if ((reader.Read() == true))
{
login.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
login.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
return(login);
}
}
finally
{
if ((reader != null))
{
reader.Dispose();
}
persistence.CompleteCommand();
}
return(null);
}
public static SoftFluent.Json.NET.Publication LoadById(int id)
{
if ((id == -1))
{
return(null);
}
SoftFluent.Json.NET.Publication publication = new SoftFluent.Json.NET.Publication();
CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.Json.NET.Constants.SoftFluent_Json_NETStoreName).Persistence;
persistence.CreateStoredProcedureCommand(null, "Publication", "LoadById");
persistence.AddParameter("@Id", id, ((int)(-1)));
System.Data.IDataReader reader = null;
try
{
reader = persistence.ExecuteReader();
if ((reader.Read() == true))
{
publication.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
publication.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
return(publication);
}
}
finally
{
if ((reader != null))
{
reader.Dispose();
}
persistence.CompleteCommand();
}
return(null);
}
public static ModelCodeFluent.Identity.RoleClaim LoadById(System.Guid id)
{
if ((id.Equals(CodeFluentPersistence.DefaultGuidValue) == true))
{
return(null);
}
ModelCodeFluent.Identity.RoleClaim roleClaim = new ModelCodeFluent.Identity.RoleClaim();
CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(ModelCodeFluent.Constants.ModelCodeFluentStoreName).Persistence;
persistence.CreateStoredProcedureCommand(null, "RoleClaim", "LoadById");
persistence.AddParameter("@Id", id, CodeFluentPersistence.DefaultGuidValue);
System.Data.IDataReader reader = null;
try
{
reader = persistence.ExecuteReader();
if ((reader.Read() == true))
{
roleClaim.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
roleClaim.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
return(roleClaim);
}
}
finally
{
if ((reader != null))
{
reader.Dispose();
}
persistence.CompleteCommand();
}
return(null);
}
public string GetLocationNameFromKey(double locationKey)
{
string Function_Name = "GetLocationNameFromKey";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
string locationName = "";
string localSQL = "SELECT NAME FROM LOCATION WHERE PKEY = " + locationKey.ToString();
System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL);
try
{
if (drReader != null && drReader.Read())
{
if (!drReader.IsDBNull(drReader.GetOrdinal("NAME")))
{
locationName = DAOHelper.convert8859P1ToGB2312(drReader["NAME"].ToString());
}
}
}
catch (System.Exception ex)
{
LogHelper.Error(CLASS_NAME, Function_Name, ex.ToString());
}
if (drReader != null)
{
drReader.Close();
drReader.Dispose();
//SimpleDatabase.GetInstance().CloseCurrentSession();
}
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited");
return(locationName);
}
public static SoftFluent.Samples.AspNetIdentity2.Role Load(System.Guid id)
{
if ((id.Equals(CodeFluentPersistence.DefaultGuidValue) == true))
{
return(null);
}
SoftFluent.Samples.AspNetIdentity2.Role role = new SoftFluent.Samples.AspNetIdentity2.Role();
CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.Samples.AspNetIdentity2.Constants.SoftFluent_Samples_AspNetIdentity2StoreName).Persistence;
persistence.CreateStoredProcedureCommand(null, "Role", "Load");
persistence.AddParameter("@Id", id, CodeFluentPersistence.DefaultGuidValue);
System.Data.IDataReader reader = null;
try
{
reader = persistence.ExecuteReader();
if ((reader.Read() == true))
{
role.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
role.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
return(role);
}
}
finally
{
if ((reader != null))
{
reader.Dispose();
}
persistence.CompleteCommand();
}
return(null);
}
/// <summary>
/// Returns the total sample group records count in table
/// </summary>
/// <returns>No of Sample group configured</returns>
public int GetRowCount()
{
string Function_Name = "GetRowCount";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
string localSQL;
int nRowCount = 0;
localSQL = "SELECT COUNT(SAMPLE_GRP_NAME) AS MAXROWS FROM OPC_DT_SAMPLE_GRP";
System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL);
try
{
if (drReader != null && drReader.Read())
{
if (!drReader.IsDBNull(0))
{
LogHelper.Debug(CLASS_NAME, Function_Name, "Function_Exited");
nRowCount = Convert.ToInt32(drReader["MAXROWS"]);
}
}
}
catch (System.Exception ex)
{
LogHelper.Error(CLASS_NAME, Function_Name, ex.ToString());
}
if (drReader != null)
{
drReader.Close();
drReader.Dispose();
}
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited");
return(nRowCount);
}
public static ContactManager.ContactSource LoadById(int id)
{
if ((id == -1))
{
return(null);
}
ContactManager.ContactSource contactSource = new ContactManager.ContactSource();
CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(ContactManager.Constants.ContactManagerStoreName).Persistence;
persistence.CreateStoredProcedureCommand(null, "ContactSource", "LoadById");
persistence.AddParameter("@Id", id, ((int)(-1)));
System.Data.IDataReader reader = null;
try
{
reader = persistence.ExecuteReader();
if ((reader.Read() == true))
{
contactSource.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
contactSource.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
return(contactSource);
}
}
finally
{
if ((reader != null))
{
reader.Dispose();
}
persistence.CompleteCommand();
}
return(null);
}
public static SoftFluent.Samples.GED.Directory LoadById(System.Guid id)
{
if ((id.Equals(CodeFluentPersistence.DefaultGuidValue) == true))
{
return(null);
}
SoftFluent.Samples.GED.Directory directory = new SoftFluent.Samples.GED.Directory();
CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.Samples.GED.Constants.SoftFluent_Samples_GEDStoreName).Persistence;
persistence.CreateStoredProcedureCommand(null, "Directory", "LoadById");
persistence.AddRawParameter("@Id", id);
System.Data.IDataReader reader = null;
try
{
reader = persistence.ExecuteReader();
if ((reader.Read() == true))
{
directory.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
directory.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
return(directory);
}
}
finally
{
if ((reader != null))
{
reader.Dispose();
}
persistence.CompleteCommand();
}
return(null);
}
public bool GetOPCDataPointByName(string dataPoint)
{
string Function_Name = "GetOPCDataPointByName";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
string localSQL = "SELECT PKEY FROM DATALOG_DP_TREND WHERE DP_NAME = '" + dataPoint + "'";
System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL);
bool bFound = false;
try
{
if (drReader != null && drReader.Read())
{
if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_PKEY)))
{
bFound = true;
}
}
}
catch (System.Exception ex)
{
LogHelper.Error(CLASS_NAME, Function_Name, ex.ToString());
}
if (drReader != null)
{
drReader.Close();
drReader.Dispose();
}
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited");
return(bFound);
}
public static SoftFluent.Json.NET.Support LoadByName(string name)
{
if ((name == default(string)))
{
return(null);
}
SoftFluent.Json.NET.Support support = new SoftFluent.Json.NET.Support();
CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.Json.NET.Constants.SoftFluent_Json_NETStoreName).Persistence;
persistence.CreateStoredProcedureCommand(null, "Support", "LoadByName");
persistence.AddParameter("@Name", name, default(string));
System.Data.IDataReader reader = null;
try
{
reader = persistence.ExecuteReader();
if ((reader.Read() == true))
{
support.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
support.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
return(support);
}
}
finally
{
if ((reader != null))
{
reader.Dispose();
}
persistence.CompleteCommand();
}
return(null);
}
public static ModelCodeFluent.Vehicle LoadByVehicleId(System.Guid vehicleId)
{
if ((vehicleId.Equals(CodeFluentPersistence.DefaultGuidValue) == true))
{
return(null);
}
ModelCodeFluent.Vehicle vehicle = new ModelCodeFluent.Vehicle();
CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(ModelCodeFluent.Constants.ModelCodeFluentStoreName).Persistence;
persistence.CreateStoredProcedureCommand(null, "Vehicle", "LoadByVehicleId");
persistence.AddParameter("@VehicleId", vehicleId, CodeFluentPersistence.DefaultGuidValue);
System.Data.IDataReader reader = null;
try
{
reader = persistence.ExecuteReader();
if ((reader.Read() == true))
{
vehicle.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
vehicle.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
return(vehicle);
}
}
finally
{
if ((reader != null))
{
reader.Dispose();
}
persistence.CompleteCommand();
}
return(null);
}
public static SoftFluent.SqlServerInMemory.Customer LoadById(System.Guid id)
{
if ((id.Equals(CodeFluentPersistence.DefaultGuidValue) == true))
{
return(null);
}
SoftFluent.SqlServerInMemory.Customer customer = new SoftFluent.SqlServerInMemory.Customer();
CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.SqlServerInMemory.Constants.SoftFluent_SqlServerInMemoryStoreName).Persistence;
persistence.CreateStoredProcedureCommand(null, "Customer", "LoadById");
persistence.AddParameter("@Id", id, CodeFluentPersistence.DefaultGuidValue);
System.Data.IDataReader reader = null;
try
{
reader = persistence.ExecuteReader();
if ((reader.Read() == true))
{
customer.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
customer.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
return(customer);
}
}
finally
{
if ((reader != null))
{
reader.Dispose();
}
persistence.CompleteCommand();
}
return(null);
}
public static SoftFluent.Samples.GED.Page LoadOneToProcess()
{
SoftFluent.Samples.GED.Page page = new SoftFluent.Samples.GED.Page();
CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.Samples.GED.Constants.SoftFluent_Samples_GEDStoreName).Persistence;
persistence.CreateStoredProcedureCommand(null, "Page", "LoadOneToProcess");
System.Data.IDataReader reader = null;
try
{
reader = persistence.ExecuteReader();
if ((reader.Read() == true))
{
page.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
page.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
return(page);
}
}
finally
{
if ((reader != null))
{
reader.Dispose();
}
persistence.CompleteCommand();
}
return(null);
}
public static void SaveLocalizedValues(SoftFluent.Samples.RedisCache.Category entity, int lcid, bool isDefault, string name)
{
if ((entity == null))
{
throw new System.ArgumentNullException("entity");
}
if ((entity.Id.Equals(CodeFluentPersistence.DefaultGuidValue) == true))
{
CodeFluent.Runtime.CodeFluentRuntimeException.Throw("invalidEntityKey", "Id", "entity", "SoftFluent.Samples.RedisCache.Category");
}
CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.Samples.RedisCache.Constants.SoftFluent_Samples_RedisCacheStoreName).Persistence;
persistence.CreateStoredProcedureCommand(null, "Category", "SaveLocalizedValues");
persistence.AddParameter("@entityId", entity.Id, CodeFluentPersistence.DefaultGuidValue);
persistence.AddParameter("@Lcid", lcid);
persistence.AddRawParameter("@IsDefault", isDefault);
persistence.AddParameter("@Name", name, default(string));
System.Data.IDataReader reader = null;
try
{
reader = persistence.ExecuteReader();
SoftFluent.Samples.RedisCache.Category.SaveLocalizedValuesUpdateRowVersion(reader, entity, lcid, isDefault, name);
}
finally
{
if ((reader != null))
{
reader.Dispose();
}
persistence.CompleteCommand();
}
}
public static SoftFluent.Samples.AspNetIdentity1.User LoadByProviderKey(string providerKey)
{
if ((providerKey == default(string)))
{
return(null);
}
SoftFluent.Samples.AspNetIdentity1.User user = new SoftFluent.Samples.AspNetIdentity1.User();
CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.Samples.AspNetIdentity1.Constants.SoftFluent_Samples_AspNetIdentity1StoreName).Persistence;
persistence.CreateStoredProcedureCommand(null, "User", "LoadByProviderKey");
persistence.AddParameter("@providerKey", providerKey);
System.Data.IDataReader reader = null;
try
{
reader = persistence.ExecuteReader();
if ((reader.Read() == true))
{
user.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
user.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
return(user);
}
}
finally
{
if ((reader != null))
{
reader.Dispose();
}
persistence.CompleteCommand();
}
return(null);
}
public static ContactManager.User LoadByEmail(string email)
{
if ((email == default(string)))
{
return(null);
}
ContactManager.User user = new ContactManager.User();
CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(ContactManager.Constants.ContactManagerStoreName).Persistence;
persistence.CreateStoredProcedureCommand(null, "User", "LoadByEmail");
persistence.AddParameter("@Email", email, default(string));
System.Data.IDataReader reader = null;
try
{
reader = persistence.ExecuteReader();
if ((reader.Read() == true))
{
user.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
user.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
return(user);
}
}
finally
{
if ((reader != null))
{
reader.Dispose();
}
persistence.CompleteCommand();
}
return(null);
}
public static ContactManager.Address LoadByContact(int contactId)
{
if ((contactId == -1))
{
return(null);
}
ContactManager.Address address = new ContactManager.Address();
CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(ContactManager.Constants.ContactManagerStoreName).Persistence;
persistence.CreateStoredProcedureCommand(null, "Address", "LoadByContact");
persistence.AddParameter("@ContactId", contactId);
System.Data.IDataReader reader = null;
try
{
reader = persistence.ExecuteReader();
if ((reader.Read() == true))
{
address.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
address.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
return(address);
}
}
finally
{
if ((reader != null))
{
reader.Dispose();
}
persistence.CompleteCommand();
}
return(null);
}
public static SoftFluent.Samples.ExtendedSearch.Customer LoadById(int id)
{
if ((id == -1))
{
return(null);
}
SoftFluent.Samples.ExtendedSearch.Customer customer = new SoftFluent.Samples.ExtendedSearch.Customer();
CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.Samples.ExtendedSearch.Constants.SoftFluent_Samples_ExtendedSearchStoreName).Persistence;
persistence.CreateStoredProcedureCommand(null, "Customer", "LoadById");
persistence.AddParameter("@Id", id, ((int)(-1)));
System.Data.IDataReader reader = null;
try
{
reader = persistence.ExecuteReader();
if ((reader.Read() == true))
{
customer.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
customer.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
return(customer);
}
}
finally
{
if ((reader != null))
{
reader.Dispose();
}
persistence.CompleteCommand();
}
return(null);
}
/// <summary>
/// retrieve all the configuration name for real-time charting.
/// </summary>
/// <returns></returns>
public List <string> GetAllDPGrpNames()
{
string Function_Name = "GetAllDPGrpNames";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
List <string> dpGrpNames = new List <string>();
string localSQL = " SELECT DISTINCT CONFIG_NAME FROM TRENDVIEWER_CONFIG order by config_name ";
System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL);
if (drReader != null)
{
try
{
while (drReader.Read())
{
if (!drReader.IsDBNull(0))
{
dpGrpNames.Add(DAOHelper.convert8859P1ToGB2312(drReader["CONFIG_NAME"].ToString()));
}
}
}
catch (System.Exception ex)
{
LogHelper.Error(CLASS_NAME, Function_Name, ex.ToString());
}
drReader.Close();
drReader.Dispose();
//SimpleDatabase.GetInstance().CloseCurrentSession();
}
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited");
return(dpGrpNames);
}
public static DigitalPicnik.List LoadById(System.Guid id)
{
if ((id.Equals(CodeFluentPersistence.DefaultGuidValue) == true))
{
return(null);
}
DigitalPicnik.List list = new DigitalPicnik.List();
CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(DigitalPicnik.Constants.DigitalPicnikStoreName).Persistence;
persistence.CreateStoredProcedureCommand(null, "List", "LoadById");
persistence.AddParameter("@Id", id, CodeFluentPersistence.DefaultGuidValue);
System.Data.IDataReader reader = null;
try
{
reader = persistence.ExecuteReader();
if ((reader.Read() == true))
{
list.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
list.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
return(list);
}
}
finally
{
if ((reader != null))
{
reader.Dispose();
}
persistence.CompleteCommand();
}
return(null);
}
public static SoftFluent.Samples.Thinktecture.IdentityServer.Role LoadByName(string name)
{
if ((name == default(string)))
{
return(null);
}
SoftFluent.Samples.Thinktecture.IdentityServer.Role role = new SoftFluent.Samples.Thinktecture.IdentityServer.Role();
CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.Samples.Thinktecture.IdentityServer.Constants.SoftFluent_Samples_Thinktecture_IdentityServerStoreName).Persistence;
persistence.CreateStoredProcedureCommand(null, "Role", "LoadByName");
persistence.AddParameter("@Name", name, default(string));
System.Data.IDataReader reader = null;
try
{
reader = persistence.ExecuteReader();
if ((reader.Read() == true))
{
role.ReadRecord(reader, CodeFluent.Runtime.CodeFluentReloadOptions.Default);
role.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
return(role);
}
}
finally
{
if ((reader != null))
{
reader.Dispose();
}
persistence.CompleteCommand();
}
return(null);
}
/// <summary>
/// Returns Sample Group details of the specified Sample group Key.
/// </summary>
/// <param name="opcGrpID">Sample group key</param>
/// <returns>Sample Group entity</returns>
public EtyOPCSampleGroup GetOPCGrpByID(string opcGrpID)
{
string Function_Name = "GetOPCGrpByID";
LogHelper.Trace(CLASS_NAME, Function_Name, string.Format("Function_Entered with params - {0}", opcGrpID));
EtyOPCSampleGroup etyOPCSampleGrp = new EtyOPCSampleGroup();
string localSQL = " SELECT SAMPLE_GRP_NAME,SAMPLE_GRP_DESC,SAMPLE_INTERVAL,INTERVAL_TYPE,START_TIME,DELTA_VALUE,DISABLE "
+ " FROM OPC_DT_SAMPLE_GRP WHERE SAMPLE_GRP_ID = " + opcGrpID;
System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL);
try
{
while (drReader != null && drReader.Read())
{
if (!drReader.IsDBNull(drReader.GetOrdinal("SAMPLE_GRP_NAME")))
{
etyOPCSampleGrp.SampleGrpName = DAOHelper.convert8859P1ToGB2312(drReader["SAMPLE_GRP_NAME"].ToString());
}
if (!drReader.IsDBNull(drReader.GetOrdinal("SAMPLE_GRP_DESC")))
{
etyOPCSampleGrp.SampleGrpDescription = DAOHelper.convert8859P1ToGB2312(drReader["SAMPLE_GRP_DESC"].ToString());
}
if (!drReader.IsDBNull(drReader.GetOrdinal("SAMPLE_INTERVAL")))
{
etyOPCSampleGrp.Interval = Convert.ToInt32(drReader["SAMPLE_INTERVAL"]);
}
if (!drReader.IsDBNull(drReader.GetOrdinal("INTERVAL_TYPE")))
{
etyOPCSampleGrp.IntervalType = drReader["INTERVAL_TYPE"].ToString();
}
if (!drReader.IsDBNull(drReader.GetOrdinal("START_TIME")))
{
etyOPCSampleGrp.StartTime = drReader["START_TIME"].ToString();
}
if (!drReader.IsDBNull(drReader.GetOrdinal("DELTA_VALUE")))
{
etyOPCSampleGrp.DeltaValue = Convert.ToDouble(drReader["DELTA_VALUE"]);
}
if (!drReader.IsDBNull(drReader.GetOrdinal("DISABLE")))
{
etyOPCSampleGrp.Disabled = DAOHelper.ChangeStrToBool(drReader["DISABLE"].ToString());
}
}
}
catch (System.Exception ex)
{
LogHelper.Error(CLASS_NAME, Function_Name, ex.ToString());
}
if (drReader != null)
{
drReader.Close();
drReader.Dispose();
}
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited");
return(etyOPCSampleGrp);
}
// CacheManager0
private static SoftFluent.Samples.RedisCache.CategoryCollection CachePageLoadAll(bool useCache, int pageIndex, int pageSize, CodeFluent.Runtime.PageOptions pageOptions)
{
if ((pageIndex < 0))
{
pageIndex = 0;
}
if ((pageSize < 0))
{
if ((pageOptions != null))
{
pageSize = pageOptions.DefaultPageSize;
}
else
{
pageSize = int.MaxValue;
}
}
SoftFluent.Samples.RedisCache.CategoryCollection ret = null;
string cacheKey = null;
if ((useCache == true))
{
cacheKey = CodeFluent.Runtime.Caching.SimpleCacheManager.BuildCacheKey("69d80ec93c1e64a950b65ea0729f45bc", pageIndex, pageSize, pageOptions);
ret = SoftFluent.Samples.RedisCache.Caching.CacheManager0.Manager.Get("SoftFluent.Samples.RedisCache.Category", cacheKey) as SoftFluent.Samples.RedisCache.CategoryCollection;
if ((ret != null))
{
return(ret);
}
}
ret = new SoftFluent.Samples.RedisCache.CategoryCollection();
System.Data.IDataReader reader = null;
try
{
reader = SoftFluent.Samples.RedisCache.CategoryCollection.PageDataLoadAll(pageOptions);
if ((reader == null))
{
if ((useCache == true))
{
SoftFluent.Samples.RedisCache.Caching.CacheManager0.Manager.Add("SoftFluent.Samples.RedisCache.Category", cacheKey, ret, null);
}
return(ret);
}
ret.LoadAll(pageIndex, pageSize, pageOptions, reader);
}
finally
{
if ((reader != null))
{
reader.Dispose();
}
CodeFluent.Runtime.CodeFluentPersistence.CompleteCommand(SoftFluent.Samples.RedisCache.Constants.SoftFluent_Samples_RedisCacheStoreName);
}
if ((useCache == true))
{
SoftFluent.Samples.RedisCache.Caching.CacheManager0.Manager.Add("SoftFluent.Samples.RedisCache.Category", cacheKey, ret, null);
}
return(ret);
}
/// <summary>
/// Returns the DataPoints based specified datapoint name substring.
/// </summary>
/// <param name="opcServerName">Datapoint server name</param>
/// <param name="DataPointNameSubstr"> Datapoint name substring to be queried</param>
/// <returns>Datapoints</returns>
public List <EtyDataLogDPTrend> GetDataPointByName(string opcServerName, string DataPointNameSubstr)
{
const string Function_Name = "GetDataPointByName";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
List <EtyDataLogDPTrend> etyDPTrendList = new List <EtyDataLogDPTrend>();
string localSQL = "SELECT et.PKEY AS ENTITY_KEY,CONCAT(et.NAME,'.Value')as DP_NAME ,DP.DP_GRP_ID AS DP_GRP_ID FROM ENTITY et LEFT JOIN DATALOG_DP_TREND DP" +
" ON et.PKEY = DP.ENTITY_KEY WHERE TYPEKEY = (SELECT PKEY FROM ENTITYTYPE WHERE NAME = 'DataPoint')" +
" AND UPPER(et.NAME) LIKE '%" + DAOHelper.convertEscapeStringAndGB2312To8859P1(DataPointNameSubstr) + "%'";
string LocationClauseStr = DAOHelper.CheckLocationAndAddSQL(COLUMN_ENTITY_LOCATIONKEY);
if (LocationClauseStr.Length != 0)
{
localSQL += " AND" + LocationClauseStr;
}
localSQL += " ORDER BY DP_NAME ";
System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL);
if (drReader != null)
{
try
{
while (drReader.Read())
{
EtyDataLogDPTrend etyDPTrend = new EtyDataLogDPTrend();
if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_ENTITY_KEY)))
{
etyDPTrend.EntityKey = Convert.ToDouble(drReader[COLUMN_ENTITY_KEY]);
}
if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_NAME)))
{
etyDPTrend.OPCDataPointName = DAOHelper.convert8859P1ToGB2312(drReader[COLUMN_NAME].ToString());
}
if (!drReader.IsDBNull(drReader.GetOrdinal(COLUMN_SAMPLE_GRP_ID)))
{
etyDPTrend.OPCSampleGrpId = Convert.ToDouble(drReader[COLUMN_SAMPLE_GRP_ID]);
}
etyDPTrendList.Add(etyDPTrend);
}
}
catch (System.Exception ex)
{
LogHelper.Error(CLASS_NAME, Function_Name, ex.ToString());
}
drReader.Close();
drReader.Dispose();
//SimpleDatabase.GetInstance().CloseCurrentSession();
}
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited");
return(etyDPTrendList);
}
protected virtual bool BaseSave(bool force)
{
if ((this.EntityState == CodeFluent.Runtime.CodeFluentEntityState.ToBeDeleted))
{
this.Delete();
return(false);
}
CodeFluent.Runtime.CodeFluentEntityActionEventArgs evt = new CodeFluent.Runtime.CodeFluentEntityActionEventArgs(this, CodeFluent.Runtime.CodeFluentEntityAction.Saving, true);
this.OnEntityAction(evt);
if ((evt.Cancel == true))
{
return(false);
}
CodeFluentPersistence.ThrowIfDeleted(this);
this.Validate();
if (((force == false) &&
(this.EntityState == CodeFluent.Runtime.CodeFluentEntityState.Unchanged)))
{
return(false);
}
CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.Json.NET.Constants.SoftFluent_Json_NETStoreName).Persistence;
persistence.CreateStoredProcedureCommand(null, "Customer", "Save");
persistence.AddParameter("@Customer_Id", this.Id, ((int)(-1)));
persistence.AddParameter("@Customer_Name", this.Name, default(string));
persistence.AddParameter("@Customer_Address", this.Address, default(string));
persistence.AddParameter("@Customer_City", this.City, default(string));
persistence.AddParameter("@Customer_ZipCode", this.ZipCode, default(string));
persistence.AddParameter("@Customer_Country", this.Country, default(string));
persistence.AddParameter("@Customer_Phone", this.Phone, default(string));
persistence.AddParameter("@Customer_Fax", this.Fax, default(string));
persistence.AddParameter("@Customer_WebSite", this.WebSite, default(string));
persistence.AddParameterEnumInt32("@Customer_Language", this.Language, SoftFluent.Json.NET.Language.French);
persistence.AddParameterEnumInt32("@Customer_CustomerType", this.CustomerType, SoftFluent.Json.NET.CustomerType.Client);
persistence.AddParameter("@_trackLastWriteUser", persistence.Context.User.Name);
persistence.AddParameter("@_rowVersion", this.RowVersion);
System.Data.IDataReader reader = null;
try
{
reader = persistence.ExecuteReader();
if ((reader.Read() == true))
{
this.ReadRecordOnSave(reader);
}
CodeFluentPersistence.NextResults(reader);
}
finally
{
if ((reader != null))
{
reader.Dispose();
}
persistence.CompleteCommand();
}
this.OnEntityAction(new CodeFluent.Runtime.CodeFluentEntityActionEventArgs(this, CodeFluent.Runtime.CodeFluentEntityAction.Saved, false, false));
this.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
return(true);
}
protected virtual bool BaseSave(bool force)
{
if ((this.EntityState == CodeFluent.Runtime.CodeFluentEntityState.ToBeDeleted))
{
this.Delete();
return(false);
}
CodeFluent.Runtime.CodeFluentEntityActionEventArgs evt = new CodeFluent.Runtime.CodeFluentEntityActionEventArgs(this, CodeFluent.Runtime.CodeFluentEntityAction.Saving, true);
this.OnEntityAction(evt);
if ((evt.Cancel == true))
{
return(false);
}
CodeFluentPersistence.ThrowIfDeleted(this);
this.Validate();
if (((force == false) &&
(this.EntityState == CodeFluent.Runtime.CodeFluentEntityState.Unchanged)))
{
return(false);
}
CodeFluent.Runtime.CodeFluentPersistence persistence = CodeFluentContext.Get(SoftFluent.Json.NET.Constants.SoftFluent_Json_NETStoreName).Persistence;
persistence.CreateStoredProcedureCommand(null, "Campaign", "Save");
persistence.AddParameter("@Campaign_Id", this.Id, ((int)(-1)));
persistence.AddParameter("@Campaign_Name", this.Name, default(string));
persistence.AddParameterEnumInt32("@Campaign_State", this.State, SoftFluent.Json.NET.CampaignStateType.Conceived);
persistence.AddParameter("@Campaign_Customer_Id", this.CustomerId, ((int)(-1)));
persistence.AddParameter("@Campaign_Price", this.Price, CodeFluentPersistence.DefaultDecimalValue);
persistence.AddParameter("@Campaign_PriceAllTaxIncluded", this.PriceAllTaxIncluded, CodeFluentPersistence.DefaultDecimalValue);
persistence.AddParameter("@Campaign_DiscountRate", this.DiscountRate, CodeFluentPersistence.DefaultDecimalValue);
persistence.AddParameter("@Campaign_ConceptionDate", this.ConceptionDate, CodeFluentPersistence.DefaultDateTimeValue);
persistence.AddParameter("@Campaign_AddressedDate", this.AddressedDate, CodeFluentPersistence.DefaultDateTimeValue);
persistence.AddParameter("@Campaign_PropositionDate", this.PropositionDate, CodeFluentPersistence.DefaultDateTimeValue);
persistence.AddParameter("@Campaign_ConfirmationDate", this.ConfirmationDate, CodeFluentPersistence.DefaultDateTimeValue);
persistence.AddParameter("@_trackLastWriteUser", persistence.Context.User.Name);
persistence.AddParameter("@_rowVersion", this.RowVersion);
System.Data.IDataReader reader = null;
try
{
reader = persistence.ExecuteReader();
if ((reader.Read() == true))
{
this.ReadRecordOnSave(reader);
}
CodeFluentPersistence.NextResults(reader);
}
finally
{
if ((reader != null))
{
reader.Dispose();
}
persistence.CompleteCommand();
}
this.OnEntityAction(new CodeFluent.Runtime.CodeFluentEntityActionEventArgs(this, CodeFluent.Runtime.CodeFluentEntityAction.Saved, false, false));
this.EntityState = CodeFluent.Runtime.CodeFluentEntityState.Unchanged;
return(true);
}
/// <summary>
/// Returns all the Root Data Nodes.
/// </summary>
/// <returns>Root Data Nodes</returns>
public List <EtyOPCDataNode> GetAllOPCDataNode(string serverRootName, string opcServerName)
{
const string Function_Name = "GetAllOPCDataNode";
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Entered");
List <EtyOPCDataNode> OPCDataNodeList = new List <EtyOPCDataNode>();
string localSQL = " SELECT KEYID,DT_NODE_NAME,DT_NODE_DESC " +
" FROM OPC_DT_NODE WHERE PKEYID IN (SELECT DISTINCT PKEY FROM ENTITY WHERE NAME = '" + serverRootName + "') AND DISABLE = 'N' AND DATA_PT_SERVER = '" + opcServerName
+ "' ORDER BY DT_NODE_NAME";
//sql for getting from entity table
/*string localSQL = " SELECT PKEY,NAME,DESCRIPTION" +
* " FROM ENTITY WHERE TYPEKEY = (SELECT PKEY FROM ENTITYTYPE WHERE NAME = 'DataNode')"+
* " AND PARENTKEY IN (SELECT DISTINCT PKEY FROM ENTITY WHERE TYPEKEY IN (SELECT PKEY FROM ENTITYTYPE WHERE NAME = 'SCADAROOT'))"+
* " ORDER BY NAME";*/
System.Data.IDataReader drReader = SimpleDatabase.GetInstance().ExecuteQuery(localSQL);
if (drReader != null)
{
try
{
while (drReader.Read())
{
EtyOPCDataNode etyOPCDataNode = new EtyOPCDataNode();
if (!drReader.IsDBNull(drReader.GetOrdinal("KEYID")))
{
etyOPCDataNode.OPCDataNodeId = Convert.ToDouble(drReader["KEYID"]);
}
if (!drReader.IsDBNull(drReader.GetOrdinal("DT_NODE_NAME")))
{
etyOPCDataNode.OPCDataNodeName = DAOHelper.convert8859P1ToGB2312(drReader["DT_NODE_NAME"].ToString());
}
if (!drReader.IsDBNull(drReader.GetOrdinal("DT_NODE_DESC")))
{
etyOPCDataNode.OPCDataNodeDesc = DAOHelper.convert8859P1ToGB2312(drReader["DT_NODE_DESC"].ToString());
}
OPCDataNodeList.Add(etyOPCDataNode);
}
}
catch (System.Exception ex)
{
LogHelper.Error(CLASS_NAME, Function_Name, ex.ToString());
}
drReader.Close();
drReader.Dispose();
}
LogHelper.Trace(CLASS_NAME, Function_Name, "Function_Exited");
return(OPCDataNodeList);
}
