/// <summary> /// 查询报文列表处理 /// </summary> /// <param name="proxy"></param> private List <CWorkQueueDto> GetFindQueueLst(QueryServiceClient proxy) { List <CWorkQueueDto> lstWorkQueue = null; if (string.IsNullOrEmpty(this.CboWareHouseTask.Text) || string.IsNullOrEmpty(this.CboDeviceCode.Text)) {// 查询所有队列报文 lstWorkQueue = proxy.GetSendTelegramQueue(); } else { int nWareHouse = CStaticClass.ConvertWareHouse(this.CboWareHouseTask.Text); int nDeviceCode = 0; if (this.CboDeviceCode.Text.Contains("ETV")) { nDeviceCode = CStaticClass.ConvertETVDescp(this.CboDeviceCode.Text); } else { nDeviceCode = CStaticClass.ConvertHallDescp(nWareHouse, this.CboDeviceCode.Text); } lstWorkQueue = proxy.GetSendTelegramQueueByEquipID(nWareHouse, nDeviceCode); } this.DgvQueue.DataSource = new BindingList <CWorkQueueDto>(lstWorkQueue); return(lstWorkQueue); }
/// <summary> /// 登陆界面时-绑定数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public void CUserCustomerInfoPanel_Load(object sender, EventArgs e) { if (!CStaticClass.CheckPushService()) {// 检查服务 return; } QueryServiceClient proxy = new QueryServiceClient(); try { // 查询所有车主信息 List <struCustomerInfo> lstStruCUSTInfo = new List <struCustomerInfo>(); proxy.QueryCUSTInfo(ref lstStruCUSTInfo); // 添加列表信息 this.DgvCustomer.DataSource = new BindingList <struCustomerInfo>(lstStruCUSTInfo); } catch (TimeoutException) { MessageBox.Show("The service operation timed out. ", "超时", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (FaultException exception) { MessageBox.Show(CStaticClass.GetExceptionInfo(exception), "SOAP错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (CommunicationException exception) { MessageBox.Show("There was a communication problem. " + CStaticClass.GetExceptionInfo(exception), "通信错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception exception) { MessageBox.Show(CStaticClass.GetExceptionInfo(exception), "应用程序异常", MessageBoxButtons.OK, MessageBoxIcon.Error); } proxy.Close(); }
/// <summary> /// 车厅库区改变值时触发 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void CboHallWareHouse_SelectedIndexChanged(object sender, EventArgs e) { if (!CStaticClass.CheckPushService()) {// 检查服务 return; } QueryServiceClient proxy = new QueryServiceClient(); try { this.CboHallID.Items.Clear(); int nCurWareHouse = CStaticClass.ConvertWareHouse(this.CboHallWareHouse.Text); List <object> lstHall = CStaticClass.ConfigLstHallDeviceIDDescp(nCurWareHouse);// 根据库号获取对应所有车厅设备号 this.CboHallID.Items.AddRange(lstHall.ToArray()); this.CboHallID.SelectedIndex = 0; } catch (TimeoutException) { MessageBox.Show("The service operation timed out. ", "超时", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (FaultException exception) { MessageBox.Show(CStaticClass.GetExceptionInfo(exception), "SOAP错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (CommunicationException exception) { MessageBox.Show("There was a communication problem. " + CStaticClass.GetExceptionInfo(exception), "通信错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception exception) { MessageBox.Show(CStaticClass.GetExceptionInfo(exception), "应用程序异常", MessageBoxButtons.OK, MessageBoxIcon.Error); } proxy.Close(); }
/// <summary> /// 允许厅外刷卡取车否 /// </summary> private void InitGetCarOutStatus() { try { if (!CStaticClass.CheckPushService()) {// 检查服务 return; } QueryServiceClient proxy = new QueryServiceClient(); string status = proxy.GetUserSetFixCardOutLimit(); proxy.Close(); if (status == "1") { lblAllow.Text = "允许"; } else if (status == "0") { lblAllow.Text = "禁止"; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
/// <summary> /// 登陆界面 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public void CUserTariffPanel_Load(object sender, EventArgs e) { if (!CStaticClass.CheckPushService()) {// 检查服务 return; } QueryServiceClient proxy = new QueryServiceClient(); try { // 查询所有标准收费信息 List <CTariffDto> lstTariff = proxy.GetTariffList(); this.CboTariff.Items.Clear(); // 添加列表信息 this.CboTariff.Items.AddRange(lstTariff.ToArray()); } catch (TimeoutException) { MessageBox.Show("The service operation timed out. ", "超时", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (FaultException exception) { MessageBox.Show(CStaticClass.GetExceptionInfo(exception), "SOAP错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (CommunicationException exception) { MessageBox.Show("There was a communication problem. " + CStaticClass.GetExceptionInfo(exception), "通信错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception exception) { MessageBox.Show(CStaticClass.GetExceptionInfo(exception), "应用程序异常", MessageBoxButtons.OK, MessageBoxIcon.Error); } proxy.Close(); }
public static DataSet Paging() { QueryServiceClient client = new QueryServiceClient(); Paging paging = new ValueBasedPaging() { RecordLimit = 20 }; DataSet dataset; int page = 10; int i = 0; do { dataset = client.ExecuteStaticQuery("STMSalesDaily", ref paging); DataRow row = dataset.Tables[0].Rows[0]; i++; if (i == page) { return(dataset); } }while (((ValueBasedPaging)paging).Bookmark != null); return(dataset); }
public static DataSet Get(string tableQuery) { QueryServiceClient client = new QueryServiceClient(); DataSet dataSet = new DataSet(); Paging paging = null; try { if (string.IsNullOrEmpty(Logon.User) && string.IsNullOrEmpty(Logon.Password)) { client.ClientCredentials.Windows.ClientCredential.Domain = Logon.Domain; client.ClientCredentials.Windows.ClientCredential.UserName = Logon.DefaultUser; client.ClientCredentials.Windows.ClientCredential.Password = Logon.DefaultPassword; } else { client.ClientCredentials.Windows.ClientCredential.Domain = Logon.Domain; client.ClientCredentials.Windows.ClientCredential.UserName = Logon.User; client.ClientCredentials.Windows.ClientCredential.Password = Logon.Password; } dataSet = client.ExecuteStaticQuery(tableQuery, ref paging); } catch (Exception ex) { string msg = ex.Message; } return(dataSet); }
private async Task <Dictionary <string, PoolResult> > GetPoolMapAsync(RunRequest request) { using var channel = GrpcChannel.ForAddress(QueryUrl); var client = new QueryServiceClient(channel); var poolMap = new Dictionary <string, PoolResult>(); foreach (var pool in request.Profile.Pools) { var queryTicketRequest = new QueryTicketsRequest() { Pool = pool }; using var stream = client.QueryTickets(queryTicketRequest); var cts = new CancellationTokenSource(TimeSpan.FromSeconds(ApiTimeout)); var poolTickets = new List <Ticket>(); while (await stream.ResponseStream.MoveNext(cts.Token)) { poolTickets.AddRange(stream.ResponseStream.Current.Tickets); } if (0 == poolTickets.Count) { continue; } var result = new PoolResult(); result.Name = pool.Name; result.Tickets = poolTickets.ToList(); poolMap.Add(pool.Name, result); } return(poolMap); }
public IEnumerable <Track> GetTracksByName(string name) { Track[] tracks = new Track[0]; if (!IsLoggedIn()) { return(tracks); } QueryServiceClient query = new QueryServiceClient(); try { QueryResult result = query.Query(name, 0, 150, 0, 0, 0, 0); tracks = result.Tracks .Where(t => t.IsAvailable) .Select(ConvertTrack) .ToArray(); query.Close(); } catch (Exception e) { _logger.Log(e.Message, Category.Exception, Priority.Medium); query.Abort(); } return(tracks); }
// // GET: /Books/ public ActionResult Index() { QueryServiceClient queryService = new QueryServiceClient(); var books = queryService.GetBooks(); queryService.Close(); return(View(books.OrderBy(p => p.Title))); }
public ActionResult Edit(Guid id) { QueryServiceClient queryService = new QueryServiceClient(); var model = queryService.GetUserByGuid(id); queryService.Close(); return(View(model)); }
public override bool ValidateUser(string username, string password) { QueryServiceClient queryService = new QueryServiceClient(); bool ret = queryService.ValidateUser(username, password); queryService.Close(); return(ret); }
public ActionResult Details(Guid id) { QueryServiceClient queryService = new QueryServiceClient(); var book = queryService.GetBookByGuid(id); queryService.Close(); return(View(book)); }
public ActionResult MyAccount() { QueryServiceClient queryService = new QueryServiceClient(); var model = queryService.GetUserByUserName(User.Identity.Name); queryService.Close(); return(View(model)); }
public IEnumerable<TrackContainer> GetAlbumsByArtist(string artist) { List<TrackContainer> containers = new List<TrackContainer>(); if (!IsLoggedIn()) { return containers; } QueryServiceClient query = new QueryServiceClient(); try { var queryResult = query.Query(artist, 0, 0, 0, 0, 0, 10); var result = queryResult.Artists.FirstOrDefault( a => a.Name.Equals(artist, StringComparison.InvariantCultureIgnoreCase)); if (result == null && queryResult.Artists.Any()) { result = queryResult.Artists.FirstOrDefault(); } if (result != null) { var browse = query.ArtistBrowse(result.ID, ArtistBrowsingType.Full); var albumGroups = browse.Tracks.Where(t => t.IsAvailable).GroupBy(t => t.Album.ID); foreach (var albumGroup in albumGroups) { TrackContainer container = new TrackContainer(); container.Owner = new TrackContainerOwner(artist); container.Tracks = albumGroup.Select(SpotifyRadioTrackPlayer.ConvertTrack).ToArray(); var firstOrDefault = container.Tracks.FirstOrDefault(); if (firstOrDefault != null) { container.Name = firstOrDefault.Album; container.Image = container.Image = firstOrDefault.AlbumArt; } containers.Add(container); } } query.Close(); } catch (Exception e) { _logger.Log(e.Message, Category.Exception, Priority.Medium); query.Abort(); } return containers; }
public IEnumerable <TrackContainer> GetAlbumsByArtist(string artist) { List <TrackContainer> containers = new List <TrackContainer>(); if (!IsLoggedIn()) { return(containers); } QueryServiceClient query = new QueryServiceClient(); try { var queryResult = query.Query(artist, 0, 0, 0, 0, 0, 10); var result = queryResult.Artists.FirstOrDefault( a => a.Name.Equals(artist, StringComparison.InvariantCultureIgnoreCase)); if (result == null && queryResult.Artists.Any()) { result = queryResult.Artists.FirstOrDefault(); } if (result != null) { var browse = query.ArtistBrowse(result.ID, ArtistBrowsingType.Full); var albumGroups = browse.Tracks.Where(t => t.IsAvailable).GroupBy(t => t.Album.ID); foreach (var albumGroup in albumGroups) { TrackContainer container = new TrackContainer(); container.Owner = new TrackContainerOwner(artist); container.Tracks = albumGroup.Select(SpotifyRadioTrackPlayer.ConvertTrack).ToArray(); var firstOrDefault = container.Tracks.FirstOrDefault(); if (firstOrDefault != null) { container.Name = firstOrDefault.Album; container.Image = container.Image = firstOrDefault.AlbumArt; } containers.Add(container); } } query.Close(); } catch (Exception e) { _logger.Log(e.Message, Category.Exception, Priority.Medium); query.Abort(); } return(containers); }
public static DataSet Find(string queryName, string tableName, string fieldName, string value, string fieldName2 = "", string value2 = "") { DataSet ds = new DataSet(); QueryServiceClient client = new QueryServiceClient(); //Set up paging so that 1000 records are retrieved at a time Paging paging = new ValueBasedPaging() { RecordLimit = 1000 }; QueryMetadata query; QueryDataSourceMetadata customerDataSource; QueryDataRangeMetadata range, range2; query = new QueryMetadata(); // Set the properties of the query. //query.QueryType = QueryType.Join; query.DataSources = new QueryDataSourceMetadata[1]; // Set the properties of the Customers data source. customerDataSource = new QueryDataSourceMetadata(); customerDataSource.Name = queryName; customerDataSource.Enabled = true; customerDataSource.Table = tableName; //Add the data source to the query. query.DataSources[0] = customerDataSource; // Setting DynamicFieldList property to false so I can specify only a few fields customerDataSource.DynamicFieldList = true; range = new QueryDataRangeMetadata(); range.TableName = tableName; range.FieldName = fieldName; range.Value = value; range.Enabled = true; range2 = new QueryDataRangeMetadata(); range2.TableName = tableName; range2.FieldName = fieldName2; range2.Value = value2; range2.Enabled = true; customerDataSource.Ranges = new QueryDataRangeMetadata[fieldName2 == "" ? 1 : 2]; customerDataSource.Ranges[0] = range; if (fieldName2 != "") { customerDataSource.Ranges[1] = range2; } client.ClientCredentials.Windows.ClientCredential.Domain = UserAccount.Domain; client.ClientCredentials.Windows.ClientCredential.UserName = UserAccount.Username; client.ClientCredentials.Windows.ClientCredential.Password = UserAccount.Password; ds = client.ExecuteQuery(query, ref paging); return(ds); }
/// <summary> /// 移动指令选择改变事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void RbtnMove_CheckedChanged(object sender, EventArgs e) { if (!this.RbtnMove.Checked) { return; } if (!CStaticClass.CheckPushService()) {// 检查服务 return; } btnRdICCard.Enabled = false; QueryServiceClient proxy = new QueryServiceClient(); try { this.LblSrc.Text = "设备"; this.LblDest.Text = "目的地址"; this.CboDeviceID.Visible = true; this.CboHallID.Visible = false; this.CTxtSrcLocAddr.Visible = false; this.CTxtDestLocAddr.Visible = true; // 塔库无挪移 List <object> lstObj = CStaticClass.ConfigLstWareHouseDescp(); this.CboWareHouse.Items.Clear(); foreach (object obj in lstObj) { if (obj.Equals("塔库")) { continue; } this.CboWareHouse.Items.Add(obj); } this.CboWareHouse.SelectedIndex = 0; } catch (TimeoutException) { MessageBox.Show("The service operation timed out. ", "超时", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (FaultException exception) { MessageBox.Show(CStaticClass.GetExceptionInfo(exception), "SOAP错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (CommunicationException exception) { MessageBox.Show("There was a communication problem. " + CStaticClass.GetExceptionInfo(exception), "通信错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception exception) { MessageBox.Show(CStaticClass.GetExceptionInfo(exception), "应用程序异常", MessageBoxButtons.OK, MessageBoxIcon.Error); } proxy.Close(); }
/// <summary> /// 登陆界面 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void CFormTariff_Load(object sender, EventArgs e) { if (!CStaticClass.CheckPushService()) {// 检查服务 return; } QueryServiceClient proxy = new QueryServiceClient(); try { // 查询所有标准收费信息 List <CTariffDto> lstTariff = proxy.GetTariffList(); if (EnmICCardType.Temp == m_currentICCardType) { lstTariff = lstTariff.FindAll(s => s.iccardtype == (int)m_currentICCardType); } else { lstTariff = lstTariff.FindAll(s => s.iccardtype != (int)EnmICCardType.Temp); } this.CboTariffDescp.Items.Clear(); // 添加列表信息 this.CboTariffDescp.Items.AddRange(lstTariff.ToArray()); CTariffDto tariff = lstTariff.Find(s => s.id == m_nTariffID); if (null != tariff) { this.CboTariffDescp.SelectedItem = tariff; } else { this.CutpTariff.Visible = false; } } catch (TimeoutException) { MessageBox.Show("The service operation timed out. ", "超时", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (FaultException exception) { MessageBox.Show(CStaticClass.GetExceptionInfo(exception), "SOAP错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (CommunicationException exception) { MessageBox.Show("There was a communication problem. " + CStaticClass.GetExceptionInfo(exception), "通信错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception exception) { MessageBox.Show(CStaticClass.GetExceptionInfo(exception), "应用程序异常", MessageBoxButtons.OK, MessageBoxIcon.Error); } proxy.Close(); }
public override string GetUserNameByEmail(string email) { QueryServiceClient queryService = new QueryServiceClient(); var userObj = queryService.GetUserByEmail(email); queryService.Close(); if (userObj != null) { return(userObj.UserName); } return(null); }
/// <summary> /// IC卡信息注销 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BtnICCardLogout_Click(object sender, EventArgs e) { if (!CStaticClass.CheckPushService()) {// 检查服务 return; } QueryServiceClient proxy = new QueryServiceClient(); try { if (null == m_icCardDto || string.IsNullOrEmpty(this.TxtICCardID.Text)) { MessageBox.Show("该IC卡为空", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } //// 更新卡状态 m_icCardDto.icstatus = (int)EnmICCardStatus.Disposed; m_icCardDto.iclogouttime = CStaticClass.CurruntDateTime(); bool flag = proxy.UpdateICCardInfo(m_icCardDto); if (flag) { this.TxtICCardStatus.Text = "注销"; this.TxtICCardLogoutTime.Text = CStaticClass.CurruntDateTime().ToString(); this.BtnICCardLoss.Enabled = false; this.BtnICCardCancelLoss.Enabled = false; this.GbxICCardInfo.Enabled = false; MessageBox.Show("注销成功", "成功", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } else { MessageBox.Show("注销失败", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch (TimeoutException) { MessageBox.Show("The service operation timed out. ", "超时", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (FaultException exception) { MessageBox.Show(CStaticClass.GetExceptionInfo(exception), "SOAP错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (CommunicationException exception) { MessageBox.Show("There was a communication problem. " + CStaticClass.GetExceptionInfo(exception), "通信错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception exception) { MessageBox.Show(CStaticClass.GetExceptionInfo(exception), "应用程序异常", MessageBoxButtons.OK, MessageBoxIcon.Error); } proxy.Close(); }
void Application_WorkbookBeforeSave(Microsoft.Office.Interop.Excel.Workbook wb, bool saveAsUi, ref bool cancel) { try { //Comments GenericDocumentService service = new GenericDocumentServiceClient(); GenericDocumentServiceCacheQueryRequest genericDocumentServiceRequest = new GenericDocumentServiceCacheQueryRequest(); AX.AIF.QueryService.QueryServiceClient queryServiceClient = new QueryServiceClient(); //QueryService.QueryDataFieldMetadata queryDataFieldMetaData = new QueryDataSourceMetadata(); QueryMetadata query = new QueryMetadata(); query.AllowCrossCompany = false; query.AllowCheck = false; query.DataSources = new QueryDataSourceMetadata[] { new QueryDataSourceMetadata() { Table = "prodPool", Name = "ProdPool", Company = "CAD", ConcurrencyModelSpecified = false, DynamicFieldList = true, DynamicFieldListSpecified = true, FetchMode = FetchMode.OneToOne, ExpansionType = ExpansionType.Original, HasRelations = false } }; query.Name = "ProdPoolQuery"; genericDocumentServiceRequest._axdQuery = query; //genericDocumentServiceRequest._documentXml = ""; GenericDocumentServiceCacheQueryResponse response = service.cacheQuery(genericDocumentServiceRequest); GenericDocumentServiceCreateUsingCachedQueryRequest cachedQueryRequest = new GenericDocumentServiceCreateUsingCachedQueryRequest(); cachedQueryRequest._cachedAxdQueryId = response.response; GenericDocumentServiceGetSchemasRequest schemasRequest = new GenericDocumentServiceGetSchemasRequest(); schemasRequest._axdQuery = query; var schema = service.getSchemas(schemasRequest); } catch (Exception e) { MessageBox.Show(e.Message); } var activeWorksheet = ((Excel.Worksheet)Application.ActiveSheet); var firstRow = activeWorksheet.Range["A1", missing]; firstRow.EntireRow.Insert(Excel.XlInsertShiftDirection.xlShiftDown, System.Type.Missing); var newFirstRow = activeWorksheet.Range["A1", missing]; newFirstRow.Value2 = "This text was added by using code"; }
public override System.Web.Security.MembershipUser GetUser(string username, bool userIsOnline) { QueryServiceClient queryService = new QueryServiceClient(); var userObj = queryService.GetUserByUserName(username); queryService.Close(); if (userObj != null) { return(ConvertFrom(userObj)); } return(null); }
private static bool CanShow(HtmlHelper htmlHelper, AuthorizationAccountType authAccountType) { IIdentity userIdentity = htmlHelper.ViewContext.HttpContext.User.Identity; if (userIdentity.IsAuthenticated) { QueryServiceClient queryService = new QueryServiceClient(); AccountType? accountType = queryService.GetAccountType(userIdentity.Name); queryService.Close(); if (accountType != null) { bool canShow = false; switch (accountType.Value) { case AccountType.Admin: if ((authAccountType & AuthorizationAccountType.Admin) == AuthorizationAccountType.Admin) { canShow = true; } else { canShow = false; } break; case AccountType.User: if ((authAccountType & AuthorizationAccountType.User) == AuthorizationAccountType.User) { canShow = true; } else { canShow = false; } break; default: break; } return(canShow); } else { return(false); } } else { return(false); } }
/// <summary> /// 设置状态栏值 /// </summary> /// <param name="obj"></param> private void SetStatusStripValue() { int nSum = 0; int nOccupy = 0; int nSpace = 0; int nMaxSpace = 0; string strSumDescp = "("; string strOccupyDescp = "("; string strSpaceDescp = "("; string strMaxSpaceDescp = "("; int i = 1; QueryServiceClient proxy = new QueryServiceClient(); foreach (object obj in CStaticClass.ConfigLstWareHouse()) { if (typeof(int) != obj.GetType()) { continue; } Rectangle rect = new Rectangle(); proxy.GetCarPOSNFreeOccupyCount((int)obj, ref rect); nSum += rect.X; nOccupy += rect.Y; nSpace += rect.Width; nMaxSpace += rect.Height; string strFlag = ";"; if (i++ == m_ltpWareHouse.Count) { strFlag = ")"; } string strWareHouse = CStaticClass.ConvertWareHouse((int)obj); strSumDescp += strWareHouse + ":" + rect.X + strFlag; strOccupyDescp += strWareHouse + ":" + rect.Y + strFlag; strSpaceDescp += strWareHouse + ":" + rect.Width + strFlag; strMaxSpaceDescp += strWareHouse + ":" + rect.Height + strFlag; } if (2 > m_ltpWareHouse.Count) {// 只有一个库时 strSumDescp = string.Empty; strOccupyDescp = string.Empty; strSpaceDescp = string.Empty; strMaxSpaceDescp = string.Empty; } this.TsslSumTxt.Text = nSum.ToString() + strSumDescp; this.TsslOccupyTxt.Text = nOccupy.ToString() + strOccupyDescp; this.TsslSpaceTxt.Text = nSpace.ToString() + strSpaceDescp; this.TsslSpaceMaxTxt.Text = nMaxSpace.ToString() + strMaxSpaceDescp; }
/// <summary> /// 更新某一ETV当前位置 /// </summary> public override void UpdateDeviceStatus(CarLocationPanelLib.PushService.CDeviceStatusDto deviceStatus) { Label lblTV = m_lLblETVEquip.Find(s => s.Name == deviceStatus.devicecode.ToString()); if (null == lblTV) { return; } QueryServiceClient proxy = new QueryServiceClient(); List <CarLocationPanelLib.QueryService.CDeviceFaultDto> lstDeviceFault = proxy.GetDeviceFault(m_wareHouse, deviceStatus.devicecode, string.Empty); lstDeviceFault = lstDeviceFault.FindAll(s => s.color == 1); proxy.Close(); if (0 < lstDeviceFault.Count) { lblTV.BackColor = Color.Red; } else { // 正在作业ETV颜色为蓝色、不可用/不可接受指令为黄色、正常绿色 SetDeviceBackColor(lblTV, deviceStatus); } #region 根据当前库车位信息设置ETV设备位置 // 根据当前库车位信息列表设置车位状态 string strAddr = deviceStatus.deviceaddr; DataGridView dgv = null; DataGridViewCell cell = null; GetDgvcIndexByAddr(strAddr, ref dgv, ref cell); if (null == dgv || null == cell) { return; } // 获取当前单元格相对位置 int nX = dgv.Location.X; int nY = dgv.Location.Y; for (int i = 0; i < cell.ColumnIndex && i < dgv.ColumnCount; i++) { nX += dgv.Columns[i].Width; } for (int i = 0; i < cell.RowIndex && i < dgv.RowCount; i++) { nY += dgv.Rows[i].Height; } // 设置ETV位置 lblTV.BeginInvoke(new beginInvokeDelegate(SetETVLocation), lblTV, nX, nY); #endregion }
/// <summary> /// 更新ETV当前位置 /// </summary> public override void UpdateDeviceStatus() { if (!CStaticClass.GetPushServiceConnectFlag()) {// 服务器通道断开时 return; } QueryServiceClient proxy = new QueryServiceClient(); List <QueryService.CDeviceStatusDto> lstDeviceStatus = proxy.GetDeviceStatusList(m_wareHouse); foreach (QueryService.CDeviceStatusDto deviceStatus in lstDeviceStatus) { Label lblTV = m_lLblETVEquip.Find(s => s.Name == deviceStatus.devicecode.ToString()); if (null == lblTV) { return; } // 正在作业ETV颜色为蓝色、不可用/不可接受指令为黄色、正常绿色 SetDeviceBackColor(lblTV, deviceStatus); #region 根据当前库车位信息设置ETV设备位置 // 根据当前库车位信息列表设置车位状态 string strAddr = deviceStatus.deviceaddr; DataGridView dgv = null; DataGridViewCell cell = null; GetDgvcIndexByAddr(strAddr, ref dgv, ref cell); if (null == cell || null == dgv) { return; } // 获取当前单元格相对位置 int nX = dgv.Location.X; int nY = dgv.Location.Y; for (int i = 0; i < cell.ColumnIndex && i < dgv.ColumnCount; i++) { nX += dgv.Columns[i].Width; } for (int i = 0; i < cell.RowIndex && i < dgv.RowCount; i++) { nY += dgv.Rows[i].Height; } // 设置ETV位置 lblTV.Location = new System.Drawing.Point(nX, lblTV.Location.Y); #endregion } proxy.Close(); }
private T CallQueryService <T>(Func <IQueryService, T> call) { QueryServiceClient client = NewServiceClient(); try { return(call(client)); } finally { try { client.Close(); } catch (Exception) { client.Abort(); } } }
///// <summary> ///// 释放资源 ///// </summary> //public void Dispose() //{ } /// <summary> /// 界面登陆 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void FormMain_Load(object sender, EventArgs e) { try { SetLogout(); DialogResult dr = m_formLogin.ShowDialog(); if (dr == DialogResult.Yes) { // 获取车主信息列表 List <struCustomerInfo> lstStruCUSTInfo = new List <struCustomerInfo>(); QueryServiceClient proxy = new QueryServiceClient(); proxy.QueryCUSTInfo(ref lstStruCUSTInfo); proxy.Close(); CStaticClass.SetLstStruCUSTInfo(lstStruCUSTInfo); this.Visible = true; InitializeInfo(); SetLogin(); this.WindowState = FormWindowState.Maximized; this.Tag = true; this.timer1.Start(); } else if (dr == DialogResult.Cancel) { this.Close(); } } catch (TimeoutException) { MessageBox.Show("The service operation timed out. ", "超时", MessageBoxButtons.OK, MessageBoxIcon.Error); Application.Exit(); } catch (FaultException exception) { MessageBox.Show(CStaticClass.GetExceptionInfo(exception), "SOAP错误", MessageBoxButtons.OK, MessageBoxIcon.Error); Application.Exit(); } catch (CommunicationException exception) { MessageBox.Show("There was a communication problem. " + CStaticClass.GetExceptionInfo(exception), "通信错误", MessageBoxButtons.OK, MessageBoxIcon.Error); Application.Exit(); } catch (Exception exception) { MessageBox.Show(CStaticClass.GetExceptionInfo(exception), "应用程序异常", MessageBoxButtons.OK, MessageBoxIcon.Error); Application.Exit(); } }
/// <summary> /// LED保存修改 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BtnSaveLed_Click(object sender, EventArgs e) { DialogResult dr = MessageBox.Show("确认修改否?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Asterisk); if (dr == DialogResult.Cancel) { return; } if (!CStaticClass.CheckPushService()) {// 检查服务 return; } QueryServiceClient proxy = new QueryServiceClient(); try { List <CLedContentDto> lstSound = ((BindingList <CLedContentDto>) this.DgvLed.DataSource).ToList(); // 修改LED列表 bool flag = proxy.UpdateLEDContentDtoList(lstSound); if (flag) { MessageBox.Show("修改LED成功!", "成功", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } else { MessageBox.Show("修改LED失败!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch (TimeoutException) { MessageBox.Show("The service operation timed out. ", "超时", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (FaultException exception) { MessageBox.Show(CStaticClass.GetExceptionInfo(exception), "SOAP错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (CommunicationException exception) { MessageBox.Show("There was a communication problem. " + CStaticClass.GetExceptionInfo(exception), "通信错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception exception) { MessageBox.Show(CStaticClass.GetExceptionInfo(exception), "应用程序异常", MessageBoxButtons.OK, MessageBoxIcon.Error); } proxy.Close(); }
public ActionResult Return(Guid id) { QueryServiceClient queryService = new QueryServiceClient(); var book = queryService.GetBookByGuid(id); var user = queryService.GetUserByUserName(User.Identity.Name); queryService.Close(); CommandServiceClient commandService = new CommandServiceClient(); commandService.ReturnBookFromUser(book.AggregateRootId, user.AggregateRootId); commandService.Close(); return(RedirectToAction("MyAccount", "Account")); }
private T CallQueryService <T>(Func <IQueryService, T> call) { QueryServiceClient client = ClientFactory.CreateClient <QueryServiceClient, IQueryService>(); try { return(call(client)); } finally { try { client.Close(); } catch (Exception) { client.Abort(); } } }
public static string GetStr() { string menuSTR = string.Empty; menuSTR += "{ \"menus\": ["; string user=HttpContext.Current.Session["LogonUser"].ToString()==String.Empty?"":HttpContext.Current.Session["LogonUser"].ToString(); EDI.Web.QuerySVC.QueryServiceClient qry = new QueryServiceClient(); DataTable dt = qry.SearchData(Query_V_USERPAGES, "LOGINNAME='" + user + "'"); if (dt.Rows.Count > 0) { //DataView dv = dt.DefaultView; //dv.RowFilter = " PARENT_ID IS NULL "; //dv.Sort = " SORTINDEX ASC"; DataRow[] drs = dt.Select(" PARENT_ID IS NULL and ISMENU='1'", " SORTINDEX ASC"); if (drs != null && drs.Length > 0) { //"menuid": "1", "icon": "icon-sys", "menuname": "报文管理", //"menus": [ // { "menuid": "11", "menuname": "报文上传1", "icon": "icon-nav", "url": "../Upload/testupload.aspx" } // , { "menuid": "12", "menuname": "报文上传2", "icon": "icon-nav", "url": "../Upload/UploadFileMgt.aspx" } //// , { "menuid": "13", "menuname": "布局测试-内容页", "icon": "icon-nav", "url": "../Export/Test1.aspx" } // ] foreach (DataRow dr in drs) { menuSTR += "{\"menuid\": " + dr["SORTINDEX"] + "\", \"icon\": \"icon-sys\", \"menuname\": \"" + dr["TITLE"] + "\","; menuSTR += "\"menus\": ["; DataRow[] ddrs = dt.Select("PARENT_ID='"+dr["PK_ID"]+"'", " SORTINDEX ASC"); if (ddrs != null && ddrs.Length > 0) { foreach (DataRow drr in ddrs) { menuSTR += "{ \"menuid\": \"" + drr["SORTINDEX"] + "\", \"menuname\": \"" + drr["TITLE"] + "\", \"icon\": \"icon-nav\", \"url\": \"" + drr["PAGEURL"] + "\" },"; } } menuSTR += "]},"; } } } menuSTR += "]};"; return menuSTR; }
public void Run(string userName, string password) { Thread.Sleep(4000); _loginEvent = new ManualResetEventSlim(); var login = new LoginServiceClient(new InstanceContext(this)); login.Subscribe(); login.Login(userName, password, false); Console.WriteLine("Logging in..."); if (!_loginEvent.Wait(10000)) { Console.WriteLine("Unable to login"); return; } var query = new QueryServiceClient(); Console.WriteLine("Searching"); var result = query.Query("NOFX", 0, 10, 0, 10, 0, 10); foreach (var track in result.Tracks) { Console.WriteLine(track.Name); } foreach (var album in result.Albums) { Console.WriteLine(album.Name); } //var control = new PlayerControlServiceClient(new InstanceContext(new MyPlayerControlCallbacks())); //control.Subscribe(); //var player = new PlaylistPlayerServiceClient(); //player.Initialize(new[] // { // "spotify:track:2lvILTIWBbzFeHF95zSWoF", // "spotify:track:50JVjWk5JwoJsIQLcqHftd" // }); //control.SetVolume(0.4f); Console.ReadLine(); }
public IEnumerable<Track> GetTracksByName(string name) { Track[] tracks = new Track[0]; if (!IsLoggedIn()) { return tracks; } QueryServiceClient query = new QueryServiceClient(); try { QueryResult result = query.Query(name, 0, 150, 0, 0, 0, 0); tracks = result.Tracks .Where(t => t.IsAvailable) .Select(ConvertTrack) .ToArray(); query.Close(); } catch (Exception e) { _logger.Log(e.Message, Category.Exception, Priority.Medium); query.Abort(); } return tracks; }