public static DbNullable<string> FceGetComponentMovementCode(DbNullable<int> movementType)
{
DbCache.FunctionKey key = new DbCache.FunctionKey("FceGetComponentMovementCode");
DbCache.CacheRecord record;
key.Set(movementType);
if (DbCache.Contains(key))
{
record = DbCache.GetRecord(key);
if (!record.IsValid())
{
record.Value = Functions.FceGetComponentMovementCode(movementType);
record.LastUpdate = DateTime.Now;
record.Valid = true;
}
}
else
{
record = new DbCache.CacheRecord();
record.Value = Functions.FceGetComponentMovementCode(movementType);
record.LastUpdate = DateTime.Now;
record.Valid = true;
DbCache.SetRecord(key, record);
}
return (DbNullable<string>)record.Value;
}
public static void Dt_adduserobject_vcs(DbNullable<string> vchProperty)
{
SqlCommand cmdProcedure = Session.CreateCommand();
cmdProcedure.CommandText = "dbo.dt_adduserobject_vcs";
cmdProcedure.CommandType = CommandType.StoredProcedure;
cmdProcedure.Parameters.AddWithValue("@vchProperty", DbConverter.FromStringNull(vchProperty));
cmdProcedure.ExecuteNonQuery();
}
public static void Dropdiagram(DbNullable<string> diagramname, DbNullable<int> owner_id)
{
SqlCommand cmdProcedure = Session.CreateCommand();
cmdProcedure.CommandText = "dbo.sp_dropdiagram";
cmdProcedure.CommandType = CommandType.StoredProcedure;
cmdProcedure.Parameters.AddWithValue("@diagramname", DbConverter.FromStringNull(diagramname));
cmdProcedure.Parameters.AddWithValue("@owner_id", DbConverter.FromIntNull(owner_id));
cmdProcedure.ExecuteNonQuery();
}
public static void Dt_addtosourcecontrol_u(DbNullable<string> vchSourceSafeINI, DbNullable<string> vchProjectName, DbNullable<string> vchComment, DbNullable<string> vchLoginName, DbNullable<string> vchPassword)
{
SqlCommand cmdProcedure = Session.CreateCommand();
cmdProcedure.CommandText = "dbo.dt_addtosourcecontrol_u";
cmdProcedure.CommandType = CommandType.StoredProcedure;
cmdProcedure.Parameters.AddWithValue("@vchSourceSafeINI", DbConverter.FromStringNull(vchSourceSafeINI));
cmdProcedure.Parameters.AddWithValue("@vchProjectName", DbConverter.FromStringNull(vchProjectName));
cmdProcedure.Parameters.AddWithValue("@vchComment", DbConverter.FromStringNull(vchComment));
cmdProcedure.Parameters.AddWithValue("@vchLoginName", DbConverter.FromStringNull(vchLoginName));
cmdProcedure.Parameters.AddWithValue("@vchPassword", DbConverter.FromStringNull(vchPassword));
cmdProcedure.ExecuteNonQuery();
}
public static DbNullable<string> FceGetComponentMovementCode(DbNullable<int> movementType)
{
SqlCommand cmdFunction = Session.CreateCommand();
cmdFunction.CommandText = "SELECT dbo.FceGetComponentMovementCode(@MovementType)";
cmdFunction.Parameters.AddWithValue("@MovementType", DbConverter.FromIntNull(movementType));
object data = cmdFunction.ExecuteScalar();
if (data == null || data == DBNull.Value)
{
return DBNull.Value;
}
else
{
return DbConverter.ToStringNull(data);
}
}
public static DbNullable<decimal> FceGetIFU_value(DbNullable<int> iFU_type)
{
SqlCommand cmdFunction = Session.CreateCommand();
cmdFunction.CommandText = "SELECT dbo.FceGetIFU_value(@IFU_type)";
cmdFunction.Parameters.AddWithValue("@IFU_type", DbConverter.FromIntNull(iFU_type));
object data = cmdFunction.ExecuteScalar();
if (data == null || data == DBNull.Value)
{
return DBNull.Value;
}
else
{
return DbConverter.ToDecimalNull(data);
}
}
public static void Dt_checkinobject(DbNullable<string> chObjectType, DbNullable<string> vchObjectName, DbNullable<string> vchComment, DbNullable<string> vchLoginName, DbNullable<string> vchPassword, DbNullable<int> iVCSFlags, DbNullable<int> iActionFlag, DbNullable<string> txStream1, DbNullable<string> txStream2, DbNullable<string> txStream3)
{
SqlCommand cmdProcedure = Session.CreateCommand();
cmdProcedure.CommandText = "dbo.dt_checkinobject";
cmdProcedure.CommandType = CommandType.StoredProcedure;
cmdProcedure.Parameters.AddWithValue("@chObjectType", DbConverter.FromStringNull(chObjectType));
cmdProcedure.Parameters.AddWithValue("@vchObjectName", DbConverter.FromStringNull(vchObjectName));
cmdProcedure.Parameters.AddWithValue("@vchComment", DbConverter.FromStringNull(vchComment));
cmdProcedure.Parameters.AddWithValue("@vchLoginName", DbConverter.FromStringNull(vchLoginName));
cmdProcedure.Parameters.AddWithValue("@vchPassword", DbConverter.FromStringNull(vchPassword));
cmdProcedure.Parameters.AddWithValue("@iVCSFlags", DbConverter.FromIntNull(iVCSFlags));
cmdProcedure.Parameters.AddWithValue("@iActionFlag", DbConverter.FromIntNull(iActionFlag));
cmdProcedure.Parameters.AddWithValue("@txStream1", DbConverter.FromStringNull(txStream1));
cmdProcedure.Parameters.AddWithValue("@txStream2", DbConverter.FromStringNull(txStream2));
cmdProcedure.Parameters.AddWithValue("@txStream3", DbConverter.FromStringNull(txStream3));
cmdProcedure.ExecuteNonQuery();
}
public static void SPTimesRevisionUpdateMainRevision(DbNullable<int> newID)
{
SqlCommand cmdProcedure = Session.CreateCommand();
cmdProcedure.CommandText = "dbo.SPTimesRevisionUpdateMainRevision";
cmdProcedure.CommandType = CommandType.StoredProcedure;
cmdProcedure.Parameters.AddWithValue("@NewID", DbConverter.FromIntNull(newID));
cmdProcedure.ExecuteNonQuery();
}
public static DbNullable<int> FceWorkDays(DbNullable<DateTime> dateFrom, DbNullable<DateTime> dateTill)
{
SqlCommand cmdFunction = Session.CreateCommand();
cmdFunction.CommandText = "SELECT dbo.FceWorkDays(@DateFrom, @DateTill)";
cmdFunction.Parameters.AddWithValue("@DateFrom", DbConverter.FromDateTimeNull(dateFrom));
cmdFunction.Parameters.AddWithValue("@DateTill", DbConverter.FromDateTimeNull(dateTill));
object data = cmdFunction.ExecuteScalar();
if (data == null || data == DBNull.Value)
{
return DBNull.Value;
}
else
{
return DbConverter.ToIntNull(data);
}
}
public static void SPTimesRevisionNew(DbNullable<int> revisionID, DbNullable<int> componentID)
{
SqlCommand cmdProcedure = Session.CreateCommand();
cmdProcedure.CommandText = "dbo.SPTimesRevisionNew";
cmdProcedure.CommandType = CommandType.StoredProcedure;
cmdProcedure.Parameters.AddWithValue("@RevisionID", DbConverter.FromIntNull(revisionID));
cmdProcedure.Parameters.AddWithValue("@ComponentID", DbConverter.FromIntNull(componentID));
cmdProcedure.ExecuteNonQuery();
}
public static void SPSampleListUpdate(DbNullable<string> cisloSetu)
{
SqlCommand cmdProcedure = Session.CreateCommand();
cmdProcedure.CommandText = "dbo.SPSampleListUpdate";
cmdProcedure.CommandType = CommandType.StoredProcedure;
cmdProcedure.Parameters.AddWithValue("@CisloSetu", DbConverter.FromStringNull(cisloSetu));
cmdProcedure.ExecuteNonQuery();
}
public static void SPTimesRevisionDetailClear(DbNullable<int> iD)
{
SqlCommand cmdProcedure = Session.CreateCommand();
cmdProcedure.CommandText = "dbo.SPTimesRevisionDetailClear";
cmdProcedure.CommandType = CommandType.StoredProcedure;
cmdProcedure.Parameters.AddWithValue("@ID", DbConverter.FromIntNull(iD));
cmdProcedure.ExecuteNonQuery();
}
public static void Dt_getobjwithprop_u(DbNullable<string> property, DbNullable<string> uvalue)
{
SqlCommand cmdProcedure = Session.CreateCommand();
cmdProcedure.CommandText = "dbo.dt_getobjwithprop_u";
cmdProcedure.CommandType = CommandType.StoredProcedure;
cmdProcedure.Parameters.AddWithValue("@property", DbConverter.FromStringNull(property));
cmdProcedure.Parameters.AddWithValue("@uvalue", DbConverter.FromStringNull(uvalue));
cmdProcedure.ExecuteNonQuery();
}
public static void Dt_displayoaerror_u(DbNullable<int> iObject, DbNullable<int> iresult)
{
SqlCommand cmdProcedure = Session.CreateCommand();
cmdProcedure.CommandText = "dbo.dt_displayoaerror_u";
cmdProcedure.CommandType = CommandType.StoredProcedure;
cmdProcedure.Parameters.AddWithValue("@iObject", DbConverter.FromIntNull(iObject));
cmdProcedure.Parameters.AddWithValue("@iresult", DbConverter.FromIntNull(iresult));
cmdProcedure.ExecuteNonQuery();
}
/// <summary>
/// LUA结构支持
/// </summary>
/// <returns></returns>
public override void GetLuaStruct(StringBuilder code)
{
base.GetLuaStruct(code);
int idx;
if (!string.IsNullOrWhiteSpace(PropertyName))
{
code.AppendLine($@"['PropertyName'] = '{PropertyName.ToLuaString()}',");
}
else
{
code.AppendLine($@"['PropertyName'] = nil,");
}
code.AppendLine($@"['IsCaption'] ={(IsCaption.ToString().ToLower())},");
if (!string.IsNullOrWhiteSpace(Alias))
{
code.AppendLine($@"['Alias'] = '{Alias.ToLuaString()}',");
}
else
{
code.AppendLine($@"['Alias'] = nil,");
}
if (!string.IsNullOrWhiteSpace(Group))
{
code.AppendLine($@"['Group'] = '{Group.ToLuaString()}',");
}
else
{
code.AppendLine($@"['Group'] = nil,");
}
code.AppendLine($@"['CreateIndex'] ={(CreateIndex.ToString().ToLower())},");
code.AppendLine($@"['IsPrimaryKey'] ={(IsPrimaryKey.ToString().ToLower())},");
code.AppendLine($@"['IsExtendKey'] ={(IsExtendKey.ToString().ToLower())},");
code.AppendLine($@"['IsIdentity'] ={(IsIdentity.ToString().ToLower())},");
code.AppendLine($@"['IsGlobalKey'] ={(IsGlobalKey.ToString().ToLower())},");
code.AppendLine($@"['UniqueIndex'] ={UniqueIndex},");
code.AppendLine($@"['IsRequired'] ={(IsRequired.ToString().ToLower())},");
code.AppendLine($@"['IsUserReadOnly'] ={(IsUserReadOnly.ToString().ToLower())},");
code.AppendLine($@"['IsMemo'] ={(IsMemo.ToString().ToLower())},");
code.AppendLine($@"['DenyClient'] ={(DenyClient.ToString().ToLower())},");
if (!string.IsNullOrWhiteSpace(Prefix))
{
code.AppendLine($@"['Prefix'] = '{Prefix.ToLuaString()}',");
}
else
{
code.AppendLine($@"['Prefix'] = nil,");
}
if (!string.IsNullOrWhiteSpace(Suffix))
{
code.AppendLine($@"['Suffix'] = '{Suffix.ToLuaString()}',");
}
else
{
code.AppendLine($@"['Suffix'] = nil,");
}
if (!string.IsNullOrWhiteSpace(InputType))
{
code.AppendLine($@"['InputType'] = '{InputType.ToLuaString()}',");
}
else
{
code.AppendLine($@"['InputType'] = nil,");
}
if (!string.IsNullOrWhiteSpace(ComboBoxUrl))
{
code.AppendLine($@"['ComboBoxUrl'] = '{ComboBoxUrl.ToLuaString()}',");
}
else
{
code.AppendLine($@"['ComboBoxUrl'] = nil,");
}
code.AppendLine($@"['IsMoney'] ={(IsMoney.ToString().ToLower())},");
if (!string.IsNullOrWhiteSpace(GridAlign))
{
code.AppendLine($@"['GridAlign'] = '{GridAlign.ToLuaString()}',");
}
else
{
code.AppendLine($@"['GridAlign'] = nil,");
}
if (!string.IsNullOrWhiteSpace(DataFormater))
{
code.AppendLine($@"['DataFormater'] = '{DataFormater.ToLuaString()}',");
}
else
{
code.AppendLine($@"['DataFormater'] = nil,");
}
code.AppendLine($@"['DenyClient'] ={(DenyClient.ToString().ToLower())},");
code.AppendLine($@"['GridDetails'] ={(GridDetails.ToString().ToLower())},");
code.AppendLine($@"['NoneGrid'] ={(NoneGrid.ToString().ToLower())},");
code.AppendLine($@"['NoneDetails'] ={(NoneDetails.ToString().ToLower())},");
if (!string.IsNullOrWhiteSpace(GridDetailsCode))
{
code.AppendLine($@"['GridDetailsCode'] = '{GridDetailsCode.ToLuaString()}',");
}
else
{
code.AppendLine($@"['GridDetailsCode'] = nil,");
}
if (!string.IsNullOrWhiteSpace(CppType))
{
code.AppendLine($@"['CppType'] = '{CppType.ToLuaString()}',");
}
else
{
code.AppendLine($@"['CppType'] = nil,");
}
if (CppTypeObject != null)
{
code.AppendLine($@"['CppTypeObject'] ='{CppTypeObject}',");
}
if (!string.IsNullOrWhiteSpace(CppName))
{
code.AppendLine($@"['CppName'] = '{CppName.ToLuaString()}',");
}
else
{
code.AppendLine($@"['CppName'] = nil,");
}
if (!string.IsNullOrWhiteSpace(CppLastType))
{
code.AppendLine($@"['CppLastType'] = '{CppLastType.ToLuaString()}',");
}
else
{
code.AppendLine($@"['CppLastType'] = nil,");
}
code.AppendLine($@"['IsIntDecimal'] ={(IsIntDecimal.ToString().ToLower())},");
if (!string.IsNullOrWhiteSpace(CsType))
{
code.AppendLine($@"['CsType'] = '{CsType.ToLuaString()}',");
}
else
{
code.AppendLine($@"['CsType'] = nil,");
}
if (!string.IsNullOrWhiteSpace(CustomType))
{
code.AppendLine($@"['CustomType'] = '{CustomType.ToLuaString()}',");
}
else
{
code.AppendLine($@"['CustomType'] = nil,");
}
if (!string.IsNullOrWhiteSpace(LastCsType))
{
code.AppendLine($@"['LastCsType'] = '{LastCsType.ToLuaString()}',");
}
else
{
code.AppendLine($@"['LastCsType'] = nil,");
}
if (EnumConfig != null)
{
code.AppendLine($@"['EnumConfig'] = {EnumConfig.GetLuaStruct()},");
}
code.AppendLine($@"['IsCompute'] ={(IsCompute.ToString().ToLower())},");
if (!string.IsNullOrWhiteSpace(ComputeGetCode))
{
code.AppendLine($@"['ComputeGetCode'] = '{ComputeGetCode.ToLuaString()}',");
}
else
{
code.AppendLine($@"['ComputeGetCode'] = nil,");
}
if (!string.IsNullOrWhiteSpace(ComputeSetCode))
{
code.AppendLine($@"['ComputeSetCode'] = '{ComputeSetCode.ToLuaString()}',");
}
else
{
code.AppendLine($@"['ComputeSetCode'] = nil,");
}
code.AppendLine($@"['IsMiddleField'] ={(IsMiddleField.ToString().ToLower())},");
code.AppendLine($@"['InnerField'] ={(InnerField.ToString().ToLower())},");
code.AppendLine($@"['IsSystemField'] ={(IsSystemField.ToString().ToLower())},");
code.AppendLine($@"['IsInterfaceField'] ={(IsInterfaceField.ToString().ToLower())},");
if (!string.IsNullOrWhiteSpace(Initialization))
{
code.AppendLine($@"['Initialization'] = '{Initialization.ToLuaString()}',");
}
else
{
code.AppendLine($@"['Initialization'] = nil,");
}
if (!string.IsNullOrWhiteSpace(EmptyValue))
{
code.AppendLine($@"['EmptyValue'] = '{EmptyValue.ToLuaString()}',");
}
else
{
code.AppendLine($@"['EmptyValue'] = nil,");
}
code.AppendLine($@"['DenyScope'] ='{DenyScope}',");
code.AppendLine($@"['Nullable'] ={(Nullable.ToString().ToLower())},");
if (!string.IsNullOrWhiteSpace(Max))
{
code.AppendLine($@"['Max'] = '{Max.ToLuaString()}',");
}
else
{
code.AppendLine($@"['Max'] = nil,");
}
if (!string.IsNullOrWhiteSpace(Min))
{
code.AppendLine($@"['Min'] = '{Min.ToLuaString()}',");
}
else
{
code.AppendLine($@"['Min'] = nil,");
}
code.AppendLine($@"['UniqueString'] ={(UniqueString.ToString().ToLower())},");
if (!string.IsNullOrWhiteSpace(ColumnName))
{
code.AppendLine($@"['ColumnName'] = '{ColumnName.ToLuaString()}',");
}
else
{
code.AppendLine($@"['ColumnName'] = nil,");
}
code.AppendLine($@"['DbNullable'] ={(DbNullable.ToString().ToLower())},");
if (!string.IsNullOrWhiteSpace(DbType))
{
code.AppendLine($@"['DbType'] = '{DbType.ToLuaString()}',");
}
else
{
code.AppendLine($@"['DbType'] = nil,");
}
code.AppendLine($@"['Precision'] ={Datalen},");
if (!string.IsNullOrWhiteSpace(ArrayLen))
{
code.AppendLine($@"['ArrayLen'] = '{ArrayLen.ToLuaString()}',");
}
else
{
code.AppendLine($@"['ArrayLen'] = nil,");
}
code.AppendLine($@"['Scale'] ={Scale},");
code.AppendLine($@"['DbIndex'] ={DbIndex},");
code.AppendLine($@"['Unicode'] ={(Unicode.ToString().ToLower())},");
code.AppendLine($@"['FixedLength'] ={(FixedLength.ToString().ToLower())},");
code.AppendLine($@"['IsBlob'] ={(IsBlob.ToString().ToLower())},");
if (!string.IsNullOrWhiteSpace(StorageProperty))
{
code.AppendLine($@"['StorageProperty'] = '{StorageProperty.ToLuaString()}',");
}
else
{
code.AppendLine($@"['StorageProperty'] = nil,");
}
code.AppendLine($@"['DbInnerField'] ={(DbInnerField.ToString().ToLower())},");
code.AppendLine($@"['NoStorage'] ={(NoStorage.ToString().ToLower())},");
code.AppendLine($@"['KeepStorageScreen'] ='{KeepStorageScreen}',");
code.AppendLine($@"['CustomWrite'] ={(CustomWrite.ToString().ToLower())},");
code.AppendLine($@"['IsLinkField'] ={(IsLinkField.ToString().ToLower())},");
if (!string.IsNullOrWhiteSpace(LinkTable))
{
code.AppendLine($@"['LinkTable'] = '{LinkTable.ToLuaString()}',");
}
else
{
code.AppendLine($@"['LinkTable'] = nil,");
}
code.AppendLine($@"['IsLinkKey'] ={(IsLinkKey.ToString().ToLower())},");
code.AppendLine($@"['IsLinkCaption'] ={(IsLinkCaption.ToString().ToLower())},");
code.AppendLine($@"['IsUserId'] ={(IsUserId.ToString().ToLower())},");
if (!string.IsNullOrWhiteSpace(LinkField))
{
code.AppendLine($@"['LinkField'] = '{LinkField.ToLuaString()}',");
}
else
{
code.AppendLine($@"['LinkField'] = nil,");
}
code.AppendLine($@"['IsCustomCompute'] ={(IsCustomCompute.ToString().ToLower())},");
code.AppendLine($@"['CanGet'] ={(CanGet.ToString().ToLower())},");
code.AppendLine($@"['CanSet'] ={(CanSet.ToString().ToLower())},");
if (!string.IsNullOrWhiteSpace(AccessType))
{
code.AppendLine($@"['AccessType'] = '{AccessType.ToLuaString()}',");
}
else
{
code.AppendLine($@"['AccessType'] = nil,");
}
code.AppendLine($@"['ReadOnly'] ={(ReadOnly.ToString().ToLower())},");
code.AppendLine($@"['CanInput'] ={(CanUserInput.ToString().ToLower())},");
if (!string.IsNullOrWhiteSpace(ExtendRole))
{
code.AppendLine($@"['ExtendRole'] = '{ExtendRole.ToLuaString()}',");
}
else
{
code.AppendLine($@"['ExtendRole'] = nil,");
}
if (!string.IsNullOrWhiteSpace(ValueSeparate))
{
code.AppendLine($@"['ValueSeparate'] = '{ValueSeparate.ToLuaString()}',");
}
else
{
code.AppendLine($@"['ValueSeparate'] = nil,");
}
if (!string.IsNullOrWhiteSpace(ArraySeparate))
{
code.AppendLine($@"['ArraySeparate'] = '{ArraySeparate.ToLuaString()}',");
}
else
{
code.AppendLine($@"['ArraySeparate'] = nil,");
}
code.AppendLine($@"['ExtendArray'] ={(ExtendArray.ToString().ToLower())},");
code.AppendLine($@"['IsKeyValueArray'] ={(IsKeyValueArray.ToString().ToLower())},");
code.AppendLine($@"['IsRelation'] ={(IsRelation.ToString().ToLower())},");
if (!string.IsNullOrWhiteSpace(ExtendPropertyName))
{
code.AppendLine($@"['ExtendPropertyName'] = '{ExtendPropertyName.ToLuaString()}',");
}
else
{
code.AppendLine($@"['ExtendPropertyName'] = nil,");
}
if (!string.IsNullOrWhiteSpace(ExtendClassName))
{
code.AppendLine($@"['ExtendClassName'] = '{ExtendClassName.ToLuaString()}',");
}
else
{
code.AppendLine($@"['ExtendClassName'] = nil,");
}
code.AppendLine($@"['ExtendClassIsPredestinate'] ={(ExtendClassIsPredestinate.ToString().ToLower())},");
code.AppendLine($@"['IsRelationField'] ={(IsRelationField.ToString().ToLower())},");
code.AppendLine($@"['IsRelationValue'] ={(IsRelationValue.ToString().ToLower())},");
code.AppendLine($@"['IsRelationArray'] ={(IsRelationArray.ToString().ToLower())},");
code.AppendLine($@"['IsExtendArray'] ={(IsExtendArray.ToString().ToLower())},");
code.AppendLine($@"['IsExtendValue'] ={(IsExtendValue.ToString().ToLower())},");
}
public static DbNullable<decimal> FceGetTotalWeightVyskladneni(DbNullable<int> pKV)
{
DbCache.FunctionKey key = new DbCache.FunctionKey("FceGetTotalWeightVyskladneni");
DbCache.CacheRecord record;
key.Set(pKV);
if (DbCache.Contains(key))
{
record = DbCache.GetRecord(key);
if (!record.IsValid())
{
record.Value = Functions.FceGetTotalWeightVyskladneni(pKV);
record.LastUpdate = DateTime.Now;
record.Valid = true;
}
}
else
{
record = new DbCache.CacheRecord();
record.Value = Functions.FceGetTotalWeightVyskladneni(pKV);
record.LastUpdate = DateTime.Now;
record.Valid = true;
DbCache.SetRecord(key, record);
}
return (DbNullable<decimal>)record.Value;
}
public static void Dt_validateloginparams(DbNullable<string> vchLoginName, DbNullable<string> vchPassword)
{
SqlCommand cmdProcedure = Session.CreateCommand();
cmdProcedure.CommandText = "dbo.dt_validateloginparams";
cmdProcedure.CommandType = CommandType.StoredProcedure;
cmdProcedure.Parameters.AddWithValue("@vchLoginName", DbConverter.FromStringNull(vchLoginName));
cmdProcedure.Parameters.AddWithValue("@vchPassword", DbConverter.FromStringNull(vchPassword));
cmdProcedure.ExecuteNonQuery();
}
public static void Dt_whocheckedout_u(DbNullable<string> chObjectType, DbNullable<string> vchObjectName, DbNullable<string> vchLoginName, DbNullable<string> vchPassword)
{
SqlCommand cmdProcedure = Session.CreateCommand();
cmdProcedure.CommandText = "dbo.dt_whocheckedout_u";
cmdProcedure.CommandType = CommandType.StoredProcedure;
cmdProcedure.Parameters.AddWithValue("@chObjectType", DbConverter.FromStringNull(chObjectType));
cmdProcedure.Parameters.AddWithValue("@vchObjectName", DbConverter.FromStringNull(vchObjectName));
cmdProcedure.Parameters.AddWithValue("@vchLoginName", DbConverter.FromStringNull(vchLoginName));
cmdProcedure.Parameters.AddWithValue("@vchPassword", DbConverter.FromStringNull(vchPassword));
cmdProcedure.ExecuteNonQuery();
}
public static void Dt_setpropertybyid_u(DbNullable<int> id, DbNullable<string> property, DbNullable<string> uvalue, DbNullable<byte[]> lvalue)
{
SqlCommand cmdProcedure = Session.CreateCommand();
cmdProcedure.CommandText = "dbo.dt_setpropertybyid_u";
cmdProcedure.CommandType = CommandType.StoredProcedure;
cmdProcedure.Parameters.AddWithValue("@id", DbConverter.FromIntNull(id));
cmdProcedure.Parameters.AddWithValue("@property", DbConverter.FromStringNull(property));
cmdProcedure.Parameters.AddWithValue("@uvalue", DbConverter.FromStringNull(uvalue));
cmdProcedure.Parameters.AddWithValue("@lvalue", DbConverter.FromArrayNull(lvalue));
cmdProcedure.ExecuteNonQuery();
}
public static void Dt_isundersourcecontrol_u(DbNullable<string> vchLoginName, DbNullable<string> vchPassword, DbNullable<int> iWhoToo)
{
SqlCommand cmdProcedure = Session.CreateCommand();
cmdProcedure.CommandText = "dbo.dt_isundersourcecontrol_u";
cmdProcedure.CommandType = CommandType.StoredProcedure;
cmdProcedure.Parameters.AddWithValue("@vchLoginName", DbConverter.FromStringNull(vchLoginName));
cmdProcedure.Parameters.AddWithValue("@vchPassword", DbConverter.FromStringNull(vchPassword));
cmdProcedure.Parameters.AddWithValue("@iWhoToo", DbConverter.FromIntNull(iWhoToo));
cmdProcedure.ExecuteNonQuery();
}
public static void Dt_getpropertiesbyid(DbNullable<int> id, DbNullable<string> property)
{
SqlCommand cmdProcedure = Session.CreateCommand();
cmdProcedure.CommandText = "dbo.dt_getpropertiesbyid";
cmdProcedure.CommandType = CommandType.StoredProcedure;
cmdProcedure.Parameters.AddWithValue("@id", DbConverter.FromIntNull(id));
cmdProcedure.Parameters.AddWithValue("@property", DbConverter.FromStringNull(property));
cmdProcedure.ExecuteNonQuery();
}
public static void SPUpdateWeightSampleList(DbNullable<int> pKV)
{
SqlCommand cmdProcedure = Session.CreateCommand();
cmdProcedure.CommandText = "dbo.SPUpdateWeightSampleList";
cmdProcedure.CommandType = CommandType.StoredProcedure;
cmdProcedure.Parameters.AddWithValue("@PKV", DbConverter.FromIntNull(pKV));
cmdProcedure.ExecuteNonQuery();
}
public static DbNullable<int> FceWorkDays(DbNullable<DateTime> dateFrom, DbNullable<DateTime> dateTill)
{
DbCache.FunctionKey key = new DbCache.FunctionKey("FceWorkDays");
DbCache.CacheRecord record;
key.Set(dateFrom, dateTill);
if (DbCache.Contains(key))
{
record = DbCache.GetRecord(key);
if (!record.IsValid())
{
record.Value = Functions.FceWorkDays(dateFrom, dateTill);
record.LastUpdate = DateTime.Now;
record.Valid = true;
}
}
else
{
record = new DbCache.CacheRecord();
record.Value = Functions.FceWorkDays(dateFrom, dateTill);
record.LastUpdate = DateTime.Now;
record.Valid = true;
DbCache.SetRecord(key, record);
}
return (DbNullable<int>)record.Value;
}
public static void QComplaintHistory(DbNullable<int> iD)
{
SqlCommand cmdProcedure = Session.CreateCommand();
cmdProcedure.CommandText = "dbo.QComplaintHistory";
cmdProcedure.CommandType = CommandType.StoredProcedure;
cmdProcedure.Parameters.AddWithValue("@ID", DbConverter.FromIntNull(iD));
cmdProcedure.ExecuteNonQuery();
}
public static void Dt_dropuserobjectbyid(DbNullable<int> id)
{
SqlCommand cmdProcedure = Session.CreateCommand();
cmdProcedure.CommandText = "dbo.dt_dropuserobjectbyid";
cmdProcedure.CommandType = CommandType.StoredProcedure;
cmdProcedure.Parameters.AddWithValue("@id", DbConverter.FromIntNull(id));
cmdProcedure.ExecuteNonQuery();
}
public static DbNullable<decimal> FceGetIFU_value(DbNullable<int> iFU_type)
{
DbCache.FunctionKey key = new DbCache.FunctionKey("FceGetIFU_value");
DbCache.CacheRecord record;
key.Set(iFU_type);
if (DbCache.Contains(key))
{
record = DbCache.GetRecord(key);
if (!record.IsValid())
{
record.Value = Functions.FceGetIFU_value(iFU_type);
record.LastUpdate = DateTime.Now;
record.Valid = true;
}
}
else
{
record = new DbCache.CacheRecord();
record.Value = Functions.FceGetIFU_value(iFU_type);
record.LastUpdate = DateTime.Now;
record.Valid = true;
DbCache.SetRecord(key, record);
}
return (DbNullable<decimal>)record.Value;
}
public static DbNullable<string> FceMaterComp(DbNullable<int> iD)
{
SqlCommand cmdFunction = Session.CreateCommand();
cmdFunction.CommandText = "SELECT dbo.FceMaterComp(@ID)";
cmdFunction.Parameters.AddWithValue("@ID", DbConverter.FromIntNull(iD));
object data = cmdFunction.ExecuteScalar();
if (data == null || data == DBNull.Value)
{
return DBNull.Value;
}
else
{
return DbConverter.ToStringNull(data);
}
}
public static DbNullable<string> FceMaterComp(DbNullable<int> iD)
{
DbCache.FunctionKey key = new DbCache.FunctionKey("FceMaterComp");
DbCache.CacheRecord record;
key.Set(iD);
if (DbCache.Contains(key))
{
record = DbCache.GetRecord(key);
if (!record.IsValid())
{
record.Value = Functions.FceMaterComp(iD);
record.LastUpdate = DateTime.Now;
record.Valid = true;
}
}
else
{
record = new DbCache.CacheRecord();
record.Value = Functions.FceMaterComp(iD);
record.LastUpdate = DateTime.Now;
record.Valid = true;
DbCache.SetRecord(key, record);
}
return (DbNullable<string>)record.Value;
}
/// <summary>
/// Some procedure, which should return something like id.
/// </summary>
/// <param name="sQLText"></param>
/// <returns></returns>
public static SqlDataReader SPIdentityNew(DbNullable<string> sQLText)
{
SqlCommand cmdProcedure = Session.CreateCommand();
cmdProcedure.CommandText = "dbo.SPIdentityNew";
cmdProcedure.CommandType = CommandType.StoredProcedure;
cmdProcedure.Parameters.AddWithValue("@SQLText", DbConverter.FromStringNull(sQLText));
SqlDataReader sqlRead = cmdProcedure.ExecuteReader();
return sqlRead;
}
public static DbNullable<decimal> FceGetTotalWeightVyskladneni(DbNullable<int> pKV)
{
SqlCommand cmdFunction = Session.CreateCommand();
cmdFunction.CommandText = "SELECT dbo.FceGetTotalWeightVyskladneni(@PKV)";
cmdFunction.Parameters.AddWithValue("@PKV", DbConverter.FromIntNull(pKV));
object data = cmdFunction.ExecuteScalar();
if (data == null || data == DBNull.Value)
{
return DBNull.Value;
}
else
{
return DbConverter.ToDecimalNull(data);
}
}
public static void SPResyncComponentDetail(DbNullable<int> id)
{
SqlCommand cmdProcedure = Session.CreateCommand();
cmdProcedure.CommandText = "dbo.SPResyncComponentDetail";
cmdProcedure.CommandType = CommandType.StoredProcedure;
cmdProcedure.Parameters.AddWithValue("@id", DbConverter.FromIntNull(id));
cmdProcedure.ExecuteNonQuery();
}
