/// <summary> /// get configuration column name for configuration tables /// </summary> /// <param name="configType"></param> /// <param name="isLogGet">is get from log table</param> /// <returns>table name</returns> public static string ConfigurationIDColNameGet(ConfigSettingType configType, bool isLogGet) { string colName = string.Empty; switch (configType) { case ConfigSettingType.POS: colName = (isLogGet) ? "PoSConfigurationLogID" : "PoSConfigurationID"; break; case ConfigSettingType.Client: colName = (isLogGet) ? "ClientConfigurationLogID" : "ClientConfigurationID"; break; case ConfigSettingType.Supplier: colName = (isLogGet) ? "SupplierConfigurationLogID" : "SupplierConfigurationID"; break; case ConfigSettingType.ErrorMap: colName = (isLogGet) ? "ErrorMapLogID" : "ErrorMapID"; break; } if (string.IsNullOrEmpty(colName)) { Assert.Fail(string.Format("no mapping column Name in DB for {0}!", configType.ToString())); } return(colName); }
/// <summary> /// get query script /// </summary> /// <param name="config"></param> /// <param name="configType"></param> /// <param name="isLogGet"></param> /// <param name="topCount"></param> /// <param name="sortdirection"></param> /// <returns></returns> public static string TBLQueryGet(ConfigurationSettingDataTbl config , ConfigSettingType configType , bool isLogGet , int topCount = 0 , CommonEnum.SortDirection sortdirection = CommonEnum.SortDirection.None) { string topStr = string.Empty; if (topCount > 0) { topStr = "top " + topCount; } string orderBy = string.Empty; if (sortdirection == CommonEnum.SortDirection.ASC) { orderBy = "order by 1 asc"; } else if (sortdirection == CommonEnum.SortDirection.DESC) { orderBy = "order by 1 desc"; } string tblName = (isLogGet) ? ConfigSettingHelper.ConfigLogTableNameGet(configType) : ConfigSettingHelper.ConfigTableNameGet(configType); string where = TBLQueryGetWhere(config, configType); return(string.Format("select {0} * from {1} {2} {3} ", topStr, tblName, where, orderBy)); }
protected void SetSettingValue(ConfigSettingType type, string value) { var source = (this.TableView.Source as UserConfigTableViewSource); if (source != null) { source.SetSettingValue(this.TableView, type, value); } }
/// <summary> /// get where script /// </summary> /// <param name="config"></param> /// <param name="configType"></param> /// <returns></returns> public static string TBLQueryGetWhere(ConfigurationSettingDataTbl config, ConfigSettingType configType) { string where = string.Empty; switch (configType) { case ConfigSettingType.POS: where = string.Format("where 1=1 {0} {1} {2} {3} {4}" , CarSCSCommonHelper.SubConditionQueryGet <string>(config.jurisdictionCode, "and JurisdictionCode") , CarSCSCommonHelper.SubConditionQueryGet <string>(config.companyCode, "and CompanyCode") , CarSCSCommonHelper.SubConditionQueryGet <string>(config.managementUnitCode, "and ManagementUnitCode") , CarSCSCommonHelper.SubConditionQueryGet <string>(config.settingName, "and SettingName") , CarSCSCommonHelper.SubConditionQueryGet <string>(config.environment, "and EnvironmentName")); break; case ConfigSettingType.PoSToWorldspanDefaultSegmentMap: where = string.Format("where 1=1 {0} {1} {2}" , CarSCSCommonHelper.SubConditionQueryGet <string>(config.jurisdictionCode, "and JurisdictionCode") , CarSCSCommonHelper.SubConditionQueryGet <string>(config.companyCode, "and CompanyCode") , CarSCSCommonHelper.SubConditionQueryGet <string>(config.managementUnitCode, "and ManagementUnitCode") ); break; case ConfigSettingType.Client: where = string.Format("where 1=1 {0} {1} {2}" , CarSCSCommonHelper.SubConditionQueryGet <string>(config.clientID, "and ClientID") //clientID='config.clientID' , CarSCSCommonHelper.SubConditionQueryGet <string>(config.settingName, "and SettingName") , CarSCSCommonHelper.SubConditionQueryGet <string>(config.environment, "and EnvironmentName")); break; case ConfigSettingType.Supplier: string updatedBy = ""; if (config.LastUpdatedBy != null) { if (config.UpdateType == supplierUpdateType.Add) { updatedBy = CarSCSCommonHelper.SubConditionQueryGet <string>(config.LastUpdatedBy, "and CreatedBy"); } if (config.UpdateType == supplierUpdateType.Update) { updatedBy = CarSCSCommonHelper.SubConditionQueryGet <string>(config.LastUpdatedBy, "and LastUpdatedBy"); } } where = string.Format("where 1=1 {0} {1} {2} {3}" , CarSCSCommonHelper.SubConditionQueryGet <string>(config.supplierID, "and SupplierID") //SupplierID='config.supplierID' , CarSCSCommonHelper.SubConditionQueryGet <string>(config.settingName, "and SettingName") , CarSCSCommonHelper.SubConditionQueryGet <string>(config.environment, "and EnvironmentName") , updatedBy); break; } return(where); }
public void SetSettingValue(UITableView tableView, ConfigSettingType type, string value) { for (int n = 0; n < this.Values.Count; n++) { if (this.Values[n].Type == type) { this.Values[n].CurrentValue = value; MainThreadUtility.InvokeOnMain(() => { this.GetCellInternal(tableView, NSIndexPath.FromRowSection(n, 0)); }); break; } } }
/// <summary> /// 現在の設定オブジェクトの位置を設定 /// </summary> /// <param name="type">設定種別</param> /// <param name="setVal">設定値</param> private void SetIsSetObjectPosition(ConfigSettingType type, float setVal) { var objectName = "IsSet"; switch (type) { case ConfigSettingType.Bgm: objectName += nameof(ConfigSettingType.Bgm); break; case ConfigSettingType.Se: objectName += nameof(ConfigSettingType.Se); break; case ConfigSettingType.Voice: objectName += nameof(ConfigSettingType.Voice); break; case ConfigSettingType.MessageSpeed: objectName += nameof(ConfigSettingType.MessageSpeed); break; default: return; } // 設定値の箇所にカーソルを持ってくる var cursorObject = GameObject.Find(objectName); var pos = cursorObject.transform.localPosition; float index = (setVal - 0.2f) / 0.2f; float offsetX = -38.0f; float dx = 51.0f * index; pos.x = offsetX + dx; cursorObject.transform.localPosition = pos; }
public ConfigurationDBHelper(string connectionString, ConfigSettingType configType) { this.ConnectionString = connectionString; this.ConfigurationType = configType; }
public ConfigurationDBHelper(CommonEnum.ServiceName service, ConfigSettingType configType) { this.ConnectionString = CarSCSCommonHelper.DBConnectionStringGet(service); this.ConfigurationType = configType; }
public ConfigurationDBHelper(CommonEnum.ServieProvider serviceProvider, ConfigSettingType configType) { this.ConnectionString = CarSCSCommonHelper.DBConnectionStringGet(ConfigSettingHelper.ServiceNameGet(serviceProvider)); this.ConfigurationType = configType; }
public static string GetConfigFeature(string configSettingName, TestDataReserve testData, string hostNameKey = "CarBSUri", ConfigSettingType configType = ConfigSettingType.POS) { //create a configuration request data instance ConfigSettingRequestData configSettingRequestData = new ConfigSettingRequestData(hostNameKey, configType); configSettingRequestData.TUID = testData.tuid; string enableValue = null; // get the feature turned value from DB string envKey = ServiceConfigUtil.EnvNameGet(); ///1. mach as EnviromentName and POS's 3 values enableValue = CarBSDB.GetServiceConfig(configSettingName, envKey, testData.JurisdictionCountryCode, testData.CompanyCode, testData.ManagementUnitCode); if (enableValue == null) { ///2. if 1 is null, mach only with EnviromentName enableValue = CarBSDB.GetServiceConfig(configSettingName, envKey); if (enableValue == null) { ///3. if 2 is null, mach as EnviromentName is null enableValue = CarBSDB.GetServiceConfig(configSettingName); if (enableValue == null) { Assert.Fail("No enable feature value for " + configSettingName + "in DB,please check the DB."); } } } return(enableValue); }