using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace FMDAL.Query.AssetType { public class AssetTypeQB { public const string GET_ASSETTYPE = @"SELECT AT.ASSETTYPEID AS AssetTypeId, AT.ASSETTYPECODE AS AssetTypeCode, AT.ASSETTYPENAME AS AssetTypeName, AT.TRACKINGTYPE AS AssetTypeTrackingType, AT.PARAMETERSETID AS ParameterSetId, PS.PARAMETERSETCODE AS ParameterSetCode, PS.PARAMETERSETNAME AS ParameterSetName, AT.NATURE AS AssetTypeNature, AT.MMTRACKINGREQUIRED AS AssetTypeMMTrackingRequired, AT.ISMETER AS AssetTypeIsMeter, AT.ISGENERATOR AS AssetTypeIsGenerator, AT.SORTORDER AS AssetTypeSortOrder, AT.STATUS AS AssetTypeStatus, AT.VERSION AS AssetTypeVersion, AT.CREATEDBYID AS AssetTypeCreatedById, UC.USERNAME AS AssetTypeCreatedByName, AT.CREATEDON AS AssetTypeCreatedOn, AT.MODIFIEDBYID AS AssetTypeModifiedById, UM.USERNAME AS AssetTypeModifiedByName, AT.MODIFIEDON AS AssetTypeModifiedOn, AT.SOURCETYPE AS SourceType, AT.ASSETCODEDEFINEID AS CodeDefineId, CD.CATEGORYCODE AS CodeDefineCategoryCode, CD.CATEGORYNAME AS CodeDefineCategoryName, AT.ACCOUNTINGTYPE AS AssetTypeAccountingType, AT.ASSETWIPACCOUNTID AS AssetWipAccountId, AWA.ACCOUNTCODE AS AssetWipAccountCode, AWA.ACCOUNTNAME AS AssetWipAccountName, AT.ASSETACCOUNTID AS AssetAccountId, AA.ACCOUNTCODE AS AssetAccountCode, AA.ACCOUNTNAME AS AssetAccountName, AT.DEPRECIATIONACCOUNTID AS DepreciationAccountId, DA.ACCOUNTCODE AS DepreciationAccountCode, DA.ACCOUNTNAME AS DepreciationAccountName, AT.ISDEPRECIATIONAPPLICABLE AS AssetTypeIsDepreciationApplicable, AT.DEPRECIATIONID AS DepreciationId, DEP.DEPRECIATIONCODE AS DepreciationCode, DEP.DEPRECIATIONNAME AS DepreciationName, AT.DEPRECIATIONPERCENTAGE AS AssetTypeDepreciationPercentage, AT.LIFE AS AssetTypeLife, AT.ISTAXDEPRECIATIONAPPLICABLE AS AssetTypeIsTaxDepreciationApplicable, AT.TAXDEPRECIATIONID AS TaxDepreciationId, TDEP.DEPRECIATIONCODE AS TaxDepreciationCode, TDEP.DEPRECIATIONNAME AS TaxDepreciationName, AT.TAXDEPRECIATIONPERCENTAGE AS AssetTypeTaxDepreciationPercentage, AT.TAXLIFE AS AssetTypeTaxLife, AT.ISAMC AS AssetTypeIsAMC, AT.ISINSURANCE AS AssetTypeIsInsurance, AT.ISINSTALLATION AS AssetTypeIsInstallation, AT.ISLOCATION AS AssetTypeIsLocation, AT.ISWARRANTY AS AssetTypeIsWarranty, AT.ISMAINTENANCE AS AssetTypeIsMaintenance, AT.ISLICENSE AS AssetTypeIsLicense, AT.ISBARCODE AS AssetTypeIsBarcode, AT.ISREGISTRATION AS AssetTypeIsRegistration, AT.ISLEASE AS AssetTypeIsLease, AT.ISCENVAT AS AssetTypeIsCenvat, AT.ISRESPONSIBLE AS AssetTypeIsResponsible, AT.ISMANUFACTURER AS AssetTypeIsManufacturer, AT.ASSETSCHEDULEID AS AssetScheduleId, ASC1.ASSETSCHEDULECODE AS AssetScheduleCode, ASC1.ASSETSCHEDULENAME AS AssetScheduleName, AT.ACCUMULATEDDEPRECIATIONACCOUNTID AS AccumulatedDepreciationAccountId, ADA.ACCOUNTCODE AS AccumulatedDepreciationAccountCode, ADA.ACCOUNTNAME AS AccumulatedDepreciationAccountName, AT.TENANTID AS TenantId, AT.RESOURCETYPEID AS ResourceTypeId, RT.RESOURCETYPECODE AS ResourceTypeCode, RT.RESOURCETYPENAME AS ResourceTypeName, AT.SLAID AS SLAId, AT.ISSCANTRACKED AS AssetTypeIsScanTracked, AT.ISSTATEMACHINEENABLED AS AssetTypeIsStateMachineEnabled, AT.CLEANINGCYCLETHRESHOLD AS AssetTypeCleaningCycleThreshold, AT.DEEPCYCLETHRESHOLD AS AssetTypeDeepCycleThreshold, AT.DEFAULTDETENTIONDAYS AS AssetTypeDefaultDetentionDays FROM MASSETTYPE AT LEFT JOIN MPARAMETERSET PS ON PS.PARAMETERSETID = AT.PARAMETERSETID LEFT JOIN MRESOURCETYPE RT ON RT.RESOURCETYPEID = AT.RESOURCETYPEID LEFT JOIN MACCOUNT AWA ON AWA.ACCOUNTID = AT.ASSETWIPACCOUNTID LEFT JOIN MACCOUNT AA ON AA.ACCOUNTID = AT.ASSETACCOUNTID LEFT JOIN MACCOUNT DA ON DA.ACCOUNTID = AT.DEPRECIATIONACCOUNTID LEFT JOIN MACCOUNT ADA ON ADA.ACCOUNTID = AT.ACCUMULATEDDEPRECIATIONACCOUNTID LEFT JOIN MDEPRECIATION DEP ON DEP.DEPRECIATIONID = AT.DEPRECIATIONID LEFT JOIN MDEPRECIATION TDEP ON TDEP.DEPRECIATIONID = AT.TAXDEPRECIATIONID LEFT JOIN MASSETSCHEDULE ASC1 ON ASC1.ASSETSCHEDULEID = AT.ASSETSCHEDULEID LEFT JOIN MCODEDEFINE CD ON CD.CODEDEFINEID = AT.ASSETCODEDEFINEID LEFT JOIN MUSER UC ON UC.USERID = AT.CREATEDBYID LEFT JOIN MUSER UM ON UM.USERID = AT.MODIFIEDBYID WHERE AT.ASSETTYPEID= @AssetTypeId;"; public const string SAVE_ASSETTYPE = @"INSERT INTO MASSETTYPE ( ASSETTYPEID, ASSETTYPECODE, ASSETTYPENAME, TRACKINGTYPE, PARAMETERSETID, NATURE, MMTRACKINGREQUIRED, ISMETER, ISGENERATOR, SORTORDER, STATUS, VERSION, CREATEDBYID, CREATEDON, MODIFIEDBYID, MODIFIEDON, SOURCETYPE, ASSETCODEDEFINEID, ACCOUNTINGTYPE, ASSETWIPACCOUNTID, ASSETACCOUNTID, DEPRECIATIONACCOUNTID, ISDEPRECIATIONAPPLICABLE, DEPRECIATIONID, DEPRECIATIONPERCENTAGE, LIFE, ISTAXDEPRECIATIONAPPLICABLE, TAXDEPRECIATIONID, TAXDEPRECIATIONPERCENTAGE, TAXLIFE, ISAMC, ISINSURANCE, ISINSTALLATION, ISLOCATION, ISWARRANTY, ISMAINTENANCE, ISLICENSE, ISBARCODE, ISREGISTRATION, ISLEASE, ISCENVAT, ISRESPONSIBLE, ISMANUFACTURER, ASSETSCHEDULEID, ACCUMULATEDDEPRECIATIONACCOUNTID, TENANTID, RESOURCETYPEID, SLAID, ISSCANTRACKED, ISSTATEMACHINEENABLED, CLEANINGCYCLETHRESHOLD, DEEPCYCLETHRESHOLD, DEFAULTDETENTIONDAYS ) VALUES ( @AssetTypeId, @AssetTypeCode, @AssetTypeName, @AssetTypeTrackingType, @ParameterSetId, @AssetTypeNature, @AssetTypeMMTrackingRequired, @AssetTypeIsMeter, @AssetTypeIsGenerator, @AssetTypeSortOrder, @AssetTypeStatus, @AssetTypeVersion, @AssetTypeCreatedById, @AssetTypeCreatedOn, @AssetTypeModifiedById, @AssetTypeModifiedOn, @SourceType, @CodeDefineId, @AssetTypeAccountingType, @AssetWipAccountId, @AssetAccountId, @DepreciationAccountId, @AssetTypeIsDepreciationApplicable, @DepreciationId, @AssetTypeDepreciationPercentage, @AssetTypeLife, @AssetTypeIsTaxDepreciationApplicable, @TaxDepreciationId, @AssetTypeTaxDepreciationPercentage, @AssetTypeTaxLife, @AssetTypeIsAMC, @AssetTypeIsInsurance, @AssetTypeIsInstallation, @AssetTypeIsLocation, @AssetTypeIsWarranty, @AssetTypeIsMaintenance, @AssetTypeIsLicense, @AssetTypeIsBarcode, @AssetTypeIsRegistration, @AssetTypeIsLease, @AssetTypeIsCenvat, @AssetTypeIsResponsible, @AssetTypeIsManufacturer, @AssetScheduleId, @AccumulatedDepreciationAccountId, @TenantId, @ResourceTypeId, @SLAId, @AssetTypeIsScanTracked, @AssetTypeIsStateMachineEnabled, @AssetTypeCleaningCycleThreshold, @AssetTypeDeepCycleThreshold, @AssetTypeDefaultDetentionDays );"; public const string UPDATE_ASSETTYPE = @"UPDATE MASSETTYPE SET ASSETTYPECODE = @AssetTypeCode, ASSETTYPENAME = @AssetTypeName, TRACKINGTYPE = @AssetTypeTrackingType, PARAMETERSETID = @ParameterSetId, NATURE = @AssetTypeNature, MMTRACKINGREQUIRED = @AssetTypeMMTrackingRequired, ISMETER = @AssetTypeIsMeter, ISGENERATOR = @AssetTypeIsGenerator, SORTORDER = @AssetTypeSortOrder, STATUS = @AssetTypeStatus, VERSION = @AssetTypeVersion, CREATEDBYID = @AssetTypeCreatedById, CREATEDON = @AssetTypeCreatedOn, MODIFIEDBYID = @AssetTypeModifiedById, MODIFIEDON = @AssetTypeModifiedOn, SOURCETYPE = @SourceType, ASSETCODEDEFINEID = @CodeDefineId, ACCOUNTINGTYPE = @AssetTypeAccountingType, ASSETWIPACCOUNTID = @AssetWipAccountId, ASSETACCOUNTID = @AssetAccountId, DEPRECIATIONACCOUNTID = @DepreciationAccountId, ISDEPRECIATIONAPPLICABLE = @AssetTypeIsDepreciationApplicable, DEPRECIATIONID = @DepreciationId, DEPRECIATIONPERCENTAGE = @AssetTypeDepreciationPercentage, LIFE = @AssetTypeLife, ISTAXDEPRECIATIONAPPLICABLE = @AssetTypeIsTaxDepreciationApplicable, TAXDEPRECIATIONID = @TaxDepreciationId, TAXDEPRECIATIONPERCENTAGE = @AssetTypeTaxDepreciationPercentage, TAXLIFE = @AssetTypeTaxLife, ISAMC = @AssetTypeIsAMC, ISINSURANCE = @AssetTypeIsInsurance, ISINSTALLATION = @AssetTypeIsInstallation, ISLOCATION = @AssetTypeIsLocation, ISWARRANTY = @AssetTypeIsWarranty, ISMAINTENANCE = @AssetTypeIsMaintenance, ISLICENSE = @AssetTypeIsLicense, ISBARCODE = @AssetTypeIsBarcode, ISREGISTRATION = @AssetTypeIsRegistration, ISLEASE = @AssetTypeIsLease, ISCENVAT = @AssetTypeIsCenvat, ISRESPONSIBLE = @AssetTypeIsResponsible, ISMANUFACTURER = @AssetTypeIsManufacturer, ASSETSCHEDULEID = @AssetScheduleId, ACCUMULATEDDEPRECIATIONACCOUNTID = @AccumulatedDepreciationAccountId, TENANTID = @TenantId, RESOURCETYPEID = @ResourceTypeId, SLAID = @SLAId, ISSCANTRACKED = @AssetTypeIsScanTracked, ISSTATEMACHINEENABLED = @AssetTypeIsStateMachineEnabled, CLEANINGCYCLETHRESHOLD = @AssetTypeCleaningCycleThreshold, DEEPCYCLETHRESHOLD = @AssetTypeDeepCycleThreshold, DEFAULTDETENTIONDAYS = @AssetTypeDefaultDetentionDays WHERE ASSETTYPEID = @AssetTypeId; "; public const string DELETE_ASSETTYPE = @"DELETE FROM MASSETTYPE WHERE ASSETTYPEID = @AssetTypeId;"; public const string GET_SELECTLIST_ASSETTYPE = @"SELECT AT.ASSETTYPEID AS Id, AT.ASSETTYPECODE AS Code, AT.ASSETTYPENAME AS Name FROM MASSETTYPE AT;"; } }