private AuthorizedNetworksWindow(DatabaseInstance instance) : base(GoogleCloudExtension.Resources.AuthorizedNetworksWindowCaption) { Content = new AuthorizedNetworksWindowContent { DataContext = new AuthorizedNetworksViewModel(this, instance) }; }
public int CloseTask(TaskEntity entity) { IMapper map = DatabaseInstance.Instance(); DynamicParameters p = new DynamicParameters(); p.Add("@V_TASK_ID", entity.TaskID); p.AddOut("@V_RESULT", DbType.Int32); map.Execute("P_SO_CLOSE_PICK_TASK_HAND", p, CommandType.StoredProcedure); return(p.Get <Int32>("@V_RESULT")); }
public InstanceViewModel(CloudSQLSourceRootViewModel owner, DatabaseInstance instance) { _owner = owner; _instance = instance; Caption = Instance.Name; UpdateMenu(); UpdateIcon(); }
/// <summary> /// 查询未关闭的采购单 /// </summary> /// <param name="orgCode"></param> /// <returns></returns> public List <POBodyEntity> QueryNotClosedBills(string orgCode) { IMapper map = DatabaseInstance.Instance(); return(map.Query <POBodyEntity>(string.Format("{0} WHERE H.ORG_CODE = @OrgCode AND H.BILL_STATE < '{1}'", PO_HEADER_FIELD, BillStateConst.PO_STATE_CODE_COMPLETE), new { OrgCode = orgCode })); }
/// <summary> /// 获取任务池当前状态信息 /// </summary> /// <returns></returns> public static List <TaskEntity> GetCurrentTask() { IMapper map = DatabaseInstance.Instance(); string sql = "SELECT A.ID, A.TASK_TYPE, C.ITEM_DESC, A.BILL_ID, A.USER_CODE, U.USER_NAME, A.QTY, A.CREATE_DATE, A.TASK_DESC " + "FROM TASKS A " + "LEFT JOIN USERS U ON A.USER_CODE = U.USER_CODE " + "INNER JOIN WM_BASE_CODE C ON A.TASK_TYPE = C.ITEM_VALUE "; return(map.Query <TaskEntity>(sql)); }
/// <summary> /// 查询当前装车编号所有的订单的托盘(不含托盘自重)[重载] /// </summary> /// <param name="vhTrainNo"></param> /// <param name="loadingOrder"></param> /// <param name="isIncludeWLX"></param> /// <param name="isBulkToCase">只为了函数重载</param> /// <returns></returns> public DataTable GetCurrentVhNoAllContainers(string vhTrainNo, string loadingOrder, bool isIncludeWLX, bool isBulkToCase) { string sql = @"SELECT wld.VH_TRAIN_NO, wld.IN_VH_SORT, wcs.CT_CODE, wsh.BILL_ID, wsh.BILL_NO, wc.CT_TYPE, wcs.CT_STATE, ((IFNULL(SUM( (CASE WHEN wc.CT_TYPE='50' AND wsd.IS_CASE=2 THEN (wspr.PICK_QTY/(SELECT t.QTY FROM wm_um_sku t WHERE t.SKU_CODE = wsd.SKU_CODE ORDER BY t.SKU_LEVEL DESC LIMIT 1)) ELSE wspr.PICK_QTY END) * (CASE WHEN wc.CT_TYPE='50' AND wsd.IS_CASE=2 THEN (SELECT t.WEIGHT FROM wm_um_sku t WHERE t.SKU_CODE = wsd.SKU_CODE ORDER BY t.SKU_LEVEL DESC LIMIT 1) ELSE wus.WEIGHT/wus.QTY END) ), 0))/1000) CALC_WEIGHT, (wcs.GROSS_WEIGHT/1000) GROSS_WEIGHT, (CASE wc.CT_TYPE WHEN '51' THEN 1 WHEN '50' THEN SUM( CASE wsd.IS_CASE WHEN 2 THEN ROUND((wspr.PICK_QTY/(SELECT t.QTY FROM wm_um_sku t WHERE t.SKU_CODE = wsd.SKU_CODE ORDER BY t.SKU_LEVEL DESC LIMIT 1)),0) ELSE ROUND(wspr.PICK_QTY/wus.QTY,0) END ) END ) SAILQTY FROM wm_container_state wcs INNER JOIN wm_container wc ON wc.CT_CODE = wcs.CT_CODE AND wc.CT_TYPE = '50' INNER JOIN wm_so_header wsh ON wsh.BILL_ID = wcs.BILL_HEAD_ID INNER JOIN wm_loading_detail wld ON wld.BILL_NO = wsh.BILL_NO LEFT JOIN wm_so_pick_record wspr ON wspr.BILL_ID = wsh.BILL_ID AND wspr.CT_CODE = wcs.CT_CODE LEFT JOIN wm_so_pick wsp ON wsp.ID = wspr.PICK_ID LEFT JOIN wm_so_detail wsd ON wsd.ID = wsp.DETAIL_ID LEFT JOIN wm_um_sku wus ON wus.UM_CODE = wsd.UM_CODE AND wus.SKU_CODE = wsd.SKU_CODE WHERE wld.VH_TRAIN_NO = @VH_TRAIN_NO GROUP BY wspr.BILL_ID, wspr.CT_CODE ORDER BY wld.IN_VH_SORT ASC, wld.BILL_NO ASC, wcs.CT_CODE ASC;"; if (loadingOrder == "1") { sql = sql.Replace("wld.IN_VH_SORT ASC", "wld.IN_VH_SORT DESC"); } if (isIncludeWLX) { sql = sql.Replace("AND wc.CT_TYPE = '50'", ""); } IMapper map = DatabaseInstance.Instance(); return(map.LoadTable(sql, new { VH_TRAIN_NO = vhTrainNo })); }
public List <SoContainerLocation> QeryCTL() { string sql = string.Format("SELECT wcl.CTL_NAME,wbc.ITEM_DESC ITEM_DESC1,wbc1.ITEM_DESC ITEM_DESC2 FROM wm_container_location wcl " + " INNER JOIN wm_base_code wbc ON wcl.CTL_STATE=wbc.ITEM_VALUE" + " INNER JOIN wm_base_code wbc1 ON wcl.CTL_TYPE=wbc1.ITEM_VALUE" + " WHERE wcl.IS_DELETE = 1" + " ORDER BY wcl.CTL_TYPE DESC"); IMapper map = DatabaseInstance.Instance(); return(map.Query <SoContainerLocation>(sql)); }
///<summary> ///查询所有客户及默认地址 ///</summary> ///<returns></returns> public List <CustomerEntity> GetAllCustomer(string warehouseCode) { IMapper map = DatabaseInstance.Instance(); string sql = string.Format("SELECT C.C_CODE, C.C_NAME, C.NAME_S, C.AREA_ID, A.AR_NAME, C.IS_ACTIVE, " + "C.SORT_ORDER, C.REMARK, C.UPDATE_BY, C.UPDATE_DATE, C.IS_OWN, C.WH_CODE, C.RT_CODE, R.RT_NAME, " + "C.ADDRESS, C.CONTACT, C.PHONE, C.POSTCODE,C.DISTANCE FROM CUSTOMERS C " + "LEFT JOIN WM_ROUTE R ON R.RT_CODE = C.RT_CODE " + "LEFT JOIN AREA A ON C.AREA_ID = A.ID "); return(map.Query <CustomerEntity>(sql)); }
/// <summary> /// 检查编码是否已存在 /// </summary> /// <param name="unit"></param> /// <returns></returns> private bool IsCodeExists(VehicleEntity unit) { IMapper map = DatabaseInstance.Instance(); string id = map.ExecuteScalar <string>("select VH_CODE from WM_VEHICLE where VH_CODE = @COD OR VH_NO = @VehicleNo", new { COD = unit.VehicleCode, VehicleNo = unit.VehicleNO }); return(!string.IsNullOrEmpty(id)); }
/// <summary> /// 获取所有有关联的托盘 /// </summary> /// <param name="warehouseCode"></param> /// <returns></returns> public static List <ContainerEntity> GetContainerListByBillID() { string sql = string.Format( "SELECT C.CT_CODE, C.CT_NAME, C.CT_TYPE, T.ITEM_DESC CT_TYPE_DESC, C.CT_WEIGHT, CS.BILL_HEAD_ID, C.IS_DELETED " + "FROM WM_CONTAINER C INNER JOIN WM_BASE_CODE T ON C.CT_TYPE = T.ITEM_VALUE " + "LEFT JOIN WM_CONTAINER_STATE CS ON CS.CT_CODE = C.CT_CODE " + "WHERE IFNULL(CS.BILL_HEAD_ID, 0) <> 0 AND C.CT_TYPE = '51' AND IFNULL(C.IS_DELETED, 0) <> 1 "); IMapper map = DatabaseInstance.Instance(); return(map.Query <ContainerEntity>(sql)); }
/// <summary> /// 退货单位及其数量维护 /// </summary> /// <param name="billID">退货单ID</param> /// <returns></returns> public static string Tools_Return_Modify(int billID) { DynamicParameters pram = new DynamicParameters(); pram.Add("V_BILL_ID", billID); pram.AddOut("V_MSG", DbType.String, 100); IMapper map = DatabaseInstance.Instance(); map.Execute("P_TOOL_MODIFY_RETURN_BILL", pram, CommandType.StoredProcedure); return(pram.Get <string>("V_MSG")); }
public void ImportLocation(DataTable tHeader, string userName) { string LocationCode, LocationDesc, ZoneCode = string.Empty; IMapper map = DatabaseInstance.Instance(); IDbTransaction trans = map.BeginTransaction(); DynamicParameters parmsHeader = new DynamicParameters(); parmsHeader.Add("LOCATION_CODE"); parmsHeader.Add("LOCATION_DESC"); parmsHeader.Add("ZONE_CODE"); parmsHeader.AddOut("RET", DbType.Int32); try { foreach (DataRow row in tHeader.Rows) { LocationCode = ConvertUtil.ToString(row["货位编号"]); LocationDesc = ConvertUtil.ToString(row["货位描述"]); ZoneCode = ConvertUtil.ToString(row["所属货区"]); if (string.IsNullOrEmpty(LocationCode)) { throw new Exception("货位编号不能为空。"); } if (string.IsNullOrEmpty(ZoneCode)) { throw new Exception("所属货区不能为空。"); } parmsHeader.Set("LOCATION_CODE", LocationCode); parmsHeader.Set("LOCATION_DESC", LocationDesc); parmsHeader.Set("ZONE_CODE", ZoneCode); map.Execute("P_LOCATION_IMPORT", parmsHeader, trans, CommandType.StoredProcedure); int billID = parmsHeader.Get <int>("RET"); if (billID == -1) { row["导入结果"] = "略过"; } else { row["导入结果"] = "成功"; } } trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw ex; } }
public List <RecLocationEntity> GetAllRecLocation() { string sql = "SELECT wz.ZN_NAME,wl.LC_CODE,wsl.SKU_CODE,ws.SKU_NAME,ws.SPEC,ifnull(wsl.LC_CODE,'') RECLOC FROM wm_location wl " + "JOIN wm_zone wz ON wl.ZN_CODE=wz.ZN_CODE " + "LEFT JOIN wm_sku_location wsl ON wl.LC_CODE=wsl.LC_CODE " + "LEFT JOIN wm_sku ws ON wsl.SKU_CODE=ws.SKU_CODE "; IMapper map = DatabaseInstance.Instance(); return(map.Query <RecLocationEntity>(sql)); }
public static bool HasThisRight(string userCode, short moduleId) { IMapper map = DatabaseInstance.Instance(); string sql = "select ru.USER_CODE from USER_ROLE as ru " + "inner join MODULE_ROLE as mr on ru.ROLE_ID = mr.ROLE_ID " + "where ru.USER_CODE = @UserCode and mr.MODULE_ID = @ModuleId AND IFNULL(RU.IS_DELETED, 0) <> 1"; string _UserCode = map.ExecuteScalar <string>(sql, new { UserCode = userCode, ModuleId = moduleId }); return(!string.IsNullOrEmpty(_UserCode)); }
public static string CreateLoadingTask(string billIDs, string shipNo) { IMapper map = DatabaseInstance.Instance(); DynamicParameters parm = new DynamicParameters(); parm.Add("V_BILL_IDS", billIDs); parm.Add("V_SHIP_NO", shipNo); parm.AddOut("V_ERR_MSG", DbType.String, 500); map.ExecuteScalar <string>("P_SO_CREATE_LOADING_TASK", parm, null, CommandType.StoredProcedure); return(parm.Get <string>("V_ERR_MSG")); }
public static string CreateTask(int billID, string taskType) { IMapper map = DatabaseInstance.Instance(); DynamicParameters parm = new DynamicParameters(); parm.Add("v_bill_id", billID); parm.Add("v_task_type", taskType); parm.AddOut("v_msg", DbType.String, 30); map.ExecuteScalar <string>("P_SO_AUTO_TASK_CREATE", parm, null, CommandType.StoredProcedure); return(parm.Get <string>("v_msg")); }
public static DataTable GetASNCount() { IMapper map = DatabaseInstance.Instance(); string sql = @"SELECT wbc.ITEM_DESC,wbc.ITEM_VALUE,COUNT(wah.BILL_NO) QTY,'查看' 'OPERATION','收货单状态' AS T FROM wm_base_code wbc LEFT JOIN wm_asn_header wah ON wbc.ITEM_VALUE=wah.BILL_STATE WHERE wbc.REMARK='ASN状态' AND wbc.ITEM_VALUE IN ('20','21','22','23','24') GROUP BY wbc.ITEM_DESC ORDER BY wbc.ITEM_VALUE ASC; "; return(map.LoadTable(sql)); }
protected FolderContainerTreeNode(DatabaseConnection databaseConnection, DatabaseInstance databaseInstance, string displayText = "", string imageName = "folder-horizontal.png", string expandedImageName = "folder-horizontal-open.png") : base(displayText, databaseConnection, databaseInstance) { //LeftImages.Add(DatabaseExplorerImageList.Instance.ImageList.Images[imageName]); this.Override.NodeAppearance.Image = DatabaseExplorerImageList.Instance.ImageList.Images[imageName]; if (expandedImageName != null) { this.Override.ExpandedNodeAppearance.Image = DatabaseExplorerImageList.Instance.ImageList.Images[expandedImageName]; } }
/// <summary> /// 根据角色找人员 /// </summary> /// <param name="roleName"></param> /// <returns></returns> public static List <UserEntity> GetUserByRole(string roleName) { IMapper map = DatabaseInstance.Instance(); string sql = String.Format("SELECT C.USER_CODE,C.USER_NAME FROM roles A " + "JOIN user_role B ON A.ROLE_ID=B.ROLE_ID " + "JOIN users C ON B.USER_CODE=C.USER_CODE " + "JOIN user_online D ON C.USER_CODE=D.USER_CODE " + "WHERE D.IS_ONLINE='Y' AND C.IS_DELETED IS NULL AND A.ROLE_NAME='{0}';", roleName); return(map.Query <UserEntity>(sql)); }
public DataTable GetGronpingTask(string user_code) { string sql = ""; IMapper map = DatabaseInstance.Instance(); DynamicParameters parms = new DynamicParameters(); parms.Add("V_USER_CODE", user_code); return(map.LoadTable("P_FIlTER_ORDER_WHILE_GROUPING_TASKS", parms, CommandType.StoredProcedure)); }
/// <summary> /// 查询单据日志 /// </summary> /// <param name="billID"></param> /// <returns></returns> public DataTable GetBillLog(int billID) { string sql = string.Format(@"SELECT L.EVT, L.CREATE_DATE, (CASE WHEN U.USER_NAME IS NULL THEN L.CREATOR ELSE U.USER_NAME END) CREATOR FROM WM_ASN_LOG L LEFT JOIN USERS U ON U.USER_CODE = L.CREATOR WHERE L.BILL_ID = {0}", billID); IMapper map = DatabaseInstance.Instance(); return(map.LoadTable(sql)); }
public DatabaseInstanceTreeNode(DatabaseInstance databaseInstance, DatabaseConnection databaseConnection) : base(databaseConnection, databaseInstance) { if (databaseInstance == null) { throw new ArgumentNullException("databaseInstance"); } DatabaseInstance = databaseInstance; Text = databaseInstance.DisplayName; Override.NodeAppearance.Image = DatabaseExplorerImageList.Instance.ImageList.Images["database_yellow.png"]; }
public void Open(Action <DatabaseInter> callBack) { _tables = new Dictionary <string, TableInter>(); DatabaseInstance.Open(Name, (database) => { _data = database; callBack(this); }); }
/// <summary> /// 根据时间查询入库单量和总件数 /// </summary> /// <param name="startTime"></param> /// <param name="endTime"></param> /// <returns></returns> public static DataTable GetAsnBillCountAndTotalPiece(DateTime startTime, DateTime endTime) { string sql = "SELECT H.BILL_NO 订单编号, IFNULL(SUM(D.PUT_QTY), 0) 总件数 " + "FROM WM_ASN_HEADER H " + "LEFT JOIN WM_ASN_DETAIL D ON D.BILL_ID = H.BILL_ID " + "WHERE H.BILL_STATE = 27 AND H.CLOSE_DATE >= @StartTime AND H.CLOSE_DATE < @EndTime " + "GROUP BY D.BILL_ID "; IMapper map = DatabaseInstance.Instance(); return(map.LoadTable(sql, new { StartTime = startTime, EndTime = endTime })); }
/// <summary> /// 根据时间查询发货率 /// </summary> /// <param name="startTime"></param> /// <param name="endTime"></param> /// <returns></returns> public static DataTable GetDelivery(DateTime startTime, DateTime endTime) { string sql = "SELECT wsh.BILL_NO AS '出库单号', CASE when (UNIX_TIMESTAMP(IFNULL(wsh.CLOSE_DATE, wsh.LAST_UPDATETIME)) " + "- UNIX_TIMESTAMP(wsh.CONFIRM_DATE) < 86400) THEN '是' ELSE '否' END AS '发货是否及时' " + "FROM wm_so_header wsh " + "WHERE wsh.BILL_STATE = '68' AND wsh.BILL_TYPE = '120' AND IFNULL(wsh.CLOSE_DATE, wsh.LAST_UPDATETIME) >= @StartTime " + "AND IFNULL(wsh.CLOSE_DATE, wsh.LAST_UPDATETIME) <= @EndTime"; IMapper map = DatabaseInstance.Instance(); return(map.LoadTable(sql, new { StartTime = startTime, EndTime = endTime })); }
/// <summary> /// 查询当前扫描容器所在的车次 /// </summary> /// <param name="containerCode"></param> /// <returns></returns> public string GetVehicleTripByCurrentContainer(string containerCode) { string sql = "SELECT wos.VEHICLE_NO, wos.BILL_NO, wcs.CT_CODE " + "FROM wm_container_state wcs " + "INNER JOIN wm_so_header wsh ON wsh.BILL_ID = wcs.BILL_HEAD_ID " + "INNER JOIN wm_order_sort wos ON wos.BILL_NO = wsh.BILL_NO " + "WHERE wcs.CT_CODE = @CT_CODE;"; IMapper map = DatabaseInstance.Instance(); return(map.ExecuteScalar <string>(sql, new { CT_CODE = containerCode })); }
public decimal GetWLXsGrossWeight(List <string> wlxList) { string test = string.Join(",", wlxList.ToArray()); string sql = @"SELECT SUM(wcs.GROSS_WEIGHT) FROM wm_container_state wcs WHERE wcs.CT_CODE IN ({0});"; IMapper map = DatabaseInstance.Instance(); object obj = map.ExecuteScalar <object>(string.Format(sql, test)); return(Convert.ToDecimal(obj)); }
public string GetBillNOS(int vhID) { string sql = @"SELECT GROUP_CONCAT(wsh.BILL_NO) BILLNOS FROM wm_so_header wsh JOIN tasks t ON wsh.BILL_ID =t.BILL_ID AND t.TASK_TYPE=143 JOIN wm_loading_detail wld ON wsh.BILL_NO =wld.BILL_NO JOIN wm_loading_header wlh ON wld.VH_TRAIN_NO=wlh.VH_TRAIN_NO WHERE wlh.VH_ID=@VH_ID"; IMapper map = DatabaseInstance.Instance(); return(map.ExecuteScalar <string>(sql, new { VH_ID = vhID })); }
/// <summary> /// /// </summary> /// <param name="id"></param> /// <param name="warehouse"></param> /// <returns>1表示成功,-1表示未找到最小单位</returns> public int ExecuteStock(int id, string warehouse) { IMapper map = DatabaseInstance.Instance(); DynamicParameters dyna = new DynamicParameters(); dyna.Add("V_ID", id); dyna.Add("V_WAREHOUSE", warehouse); dyna.AddOut("V_RESULT", DbType.Int32); map.Execute("P_COUNT_STOCK", dyna, CommandType.StoredProcedure); return(dyna.Get <int>("V_RESULT")); }
///<summary> ///查询所有货区 ///</summary> ///<returns></returns> public List <ZoneEntity> GetAllZone() { IMapper map = DatabaseInstance.Instance(); string sql = "SELECT P.ZN_CODE, P.ZN_NAME, P.WH_CODE, W.WH_NAME, " + "P.TEMP_CODE, T.TEMP_NAME, P.ZT_CODE, B.ITEM_DESC ZT_NAME, P.IS_ACTIVE FROM WM_ZONE P " + "INNER JOIN WM_WAREHOUSE W ON W.WH_CODE = P.WH_CODE " + "INNER JOIN WM_TEMPERATURE T ON P.TEMP_CODE = T.TEMP_CODE " + "INNER JOIN WM_BASE_CODE B ON B.GROUP_CODE = '101' AND B.ITEM_VALUE = P.ZT_CODE"; return(map.Query <ZoneEntity>(sql)); }
/// <summary> /// 根据时间获取配货件数平均值(D类库) /// </summary> /// <param name="startTime"></param> /// <param name="endTime"></param> /// <returns></returns> public static DataTable GetCountAvg(DateTime startTime, DateTime endTime) { string sql = "SELECT SUM(R.PICK_QTY)/ COUNT(DISTINCT R.USER_CODE) AS '配货平均件数'" + "FROM WM_SO_PICK_RECORD R INNER JOIN WM_SO_PICK P ON R.PICK_ID = P.ID " + "INNER JOIN WM_SO_DETAIL D ON P.DETAIL_ID = D.ID " + "INNER JOIN WM_SO_HEADER H ON D.BILL_ID = H.BILL_ID " + "WHERE H.BILL_STATE = '68' AND R.PICK_DATE BETWEEN @StartTime AND @EndTime "; IMapper map = DatabaseInstance.Instance(); return(map.LoadTable(sql, new { StartTime = startTime, EndTime = endTime })); }
/// <summary> /// Ensure the Authorized Networks field and all of its parents are initialized for an instance. /// </summary> private static void EnsureAuthorizedNetworksInitialized(DatabaseInstance instance) { // Ensure that all nested objects are initilaized. if (instance.Settings == null) { instance.Settings = new Settings(); } if (instance.Settings.IpConfiguration == null) { instance.Settings.IpConfiguration = new IpConfiguration(); } if (instance.Settings.IpConfiguration.AuthorizedNetworks == null) { instance.Settings.IpConfiguration.AuthorizedNetworks = new List<AclEntry>(); } }
public void Load(string clusterName) { using (Context context = ContextManager.Instance.CreateContext(ConnectionMode.AutoOpen, TransactionMode.AutoCommit)) { var ef = new EntityFactory(context); var cluster = ef.LoadEntity<Jhu.Graywulf.Registry.Cluster>(clusterName); machines = new Dictionary<Guid, Machine>(); serverInstances = new Dictionary<Guid, ServerInstance>(); databaseInstances = new Dictionary<Guid, DatabaseInstance>(); databaseDefinitions = new Dictionary<Guid, DatabaseDefinition>(); queues = new Dictionary<Guid, Queue>(); cluster.LoadMachineRoles(true); // *** TODO: handle machines that are down foreach (var mr in cluster.MachineRoles.Values) { mr.LoadMachines(true); foreach (var mm in mr.Machines.Values) { var mmi = new Machine(mm); machines.Add(mm.Guid, mmi); mm.LoadServerInstances(true); foreach (var si in mm.ServerInstances.Values) { var ssi = new ServerInstance(si); ssi.Machine = mmi; serverInstances.Add(si.Guid, ssi); } mm.LoadQueueInstances(true); foreach (var qi in mm.QueueInstances.Values) { var q = new Queue(); q.Update(qi); queues.Add(qi.Guid, q); } } } cluster.LoadDomains(true); foreach (var dom in cluster.Domains.Values) { dom.LoadFederations(true); foreach (var ff in dom.Federations.Values) { ff.LoadDatabaseDefinitions(true); foreach (var dd in ff.DatabaseDefinitions.Values) { databaseDefinitions.Add(dd.Guid, new DatabaseDefinition(dd)); dd.LoadDatabaseInstances(true); foreach (var di in dd.DatabaseInstances.Values) { var ddi = new DatabaseInstance(di); // add to global list databaseInstances.Add(di.Guid, ddi); // add to database definition lists Dictionary<Guid, DatabaseInstance> databaseinstances; if (databaseDefinitions[dd.Guid].DatabaseInstances.ContainsKey((di.DatabaseVersion.Name))) { databaseinstances = databaseDefinitions[dd.Guid].DatabaseInstances[di.DatabaseVersion.Name]; } else { databaseinstances = new Dictionary<Guid, DatabaseInstance>(); databaseDefinitions[dd.Guid].DatabaseInstances.Add(di.DatabaseVersion.Name, databaseinstances); } databaseinstances.Add(di.Guid, ddi); ddi.ServerInstance = serverInstances[di.ServerInstanceReference.Guid]; ddi.DatabaseDefinition = databaseDefinitions[dd.Guid]; } } } } } }
/// <summary> /// Shows the dialog to the user. /// </summary> /// <param name="instance">The instance on which to managed authorized networks.</param> /// <returns>The authorized network changes or null if the user canceled the dialog.</returns> public static AuthorizedNetworkChange PromptUser(DatabaseInstance instance) { AuthorizedNetworksWindow dialog = new AuthorizedNetworksWindow(instance); dialog.ShowModal(); return dialog.ViewModel.Result; }
/// <summary> /// Update the authorized networks of a instance. This completely replaces the current /// list of networks with the new list. /// </summary> public static void UpdateAuthorizedNetworks(DatabaseInstance instance, IList<AclEntry> acls) { EnsureAuthorizedNetworksInitialized(instance); instance.Settings.IpConfiguration.AuthorizedNetworks = acls; }
public InstanceItem(DatabaseInstance instance) : base(className: Resources.CloudExplorerSqlInstanceCategory, componentName: instance.Name) { _instance = instance; }