//gv绑定 public void ListViewBind3() { string Str1 = " where ui_status='正常' and ui_lx='企业'"; if (!string.IsNullOrEmpty(bm2.SelectedItem.Value)) { if (bm2.SelectedItem.Value == "1000000") { Str1 = Str1 + " and yn_bmglz='是'"; } else { Str1 = Str1 + " and ui_ssbm= '" + bm2.SelectedItem.Value + "' "; } } if (!string.IsNullOrEmpty(cxtj2.Text)) { Str1 = Str1 + " AND (UI_ID LIKE '%" + hkdb.GetStr(cxtj2.Text) + "%' OR UI_DESC LIKE '%" + hkdb.GetStr(cxtj2.Text) + "%')"; } AspNetPager3.RecordCount = (int)SqlHelper.ExecuteScalar("select count(*) from yh" + Str1); DataSet ds = SqlHelper.ExecuteDs("select ui_id,ui_desc,ui_sex,ui_lx,(case when yn_bmglz='是' then 'ch' else 'noch' end)as yn_bmglz,b.bm_mc,c.zwmc from yh a left outer JOIN BM b on (a.ui_ssbm=b.bm_id)left outer JOIN ZW c on (a.ui_zw=c.zwid)" + Str1 + "order by a.number", AspNetPager3.PageSize * (AspNetPager3.CurrentPageIndex - 1), AspNetPager3.PageSize); ListView3.DataSource = ds; ListView3.DataBind(); }
private void FoodmenuShow() { // ListView1.DataSource = uc.ShowFoodMenu(); // ListView1.DataBind(); try { ListView1.DataSource = uc.GetfoodmenuSunday(); ListView1.DataBind(); ListView2.DataSource = uc.GetfoodmenuMonday(); ListView2.DataBind(); ListView3.DataSource = uc.GetfoodmenuTuesday(); ListView3.DataBind(); ListView4.DataSource = uc.GetfoodmenuWednesday(); ListView4.DataBind(); ListView5.DataSource = uc.GetfoodmenuThursday(); ListView5.DataBind(); ListView6.DataSource = uc.GetfoodmenuFriday(); ListView6.DataBind(); ListView7.DataSource = uc.GetfoodmenuSaturday(); ListView7.DataBind(); } catch (Exception ex) { string text = ex.Message.ToString(); ScriptManager.RegisterStartupScript(this, typeof(Page), "Warning", "<script>showpoperror('" + text + "')</script>", false); } }
protected void txtSearch_TextChanged(object sender, EventArgs e) { try { if (Session["propertyvalue"] != null) { string tc_PropertyVal = Session["propertyvalue"].ToString(); ListView1.DataSource = uc.GetNewComplaintsbySearch(tc_PropertyVal, txtSearch.Text); ListView1.DataBind(); ListView2.DataSource = uc.GetOngoingComplaintsbySearch(tc_PropertyVal, txtSearch.Text); ListView2.DataBind(); ListView3.DataSource = uc.GetResolvedComplaintsbySearch(tc_PropertyVal, txtSearch.Text); ListView3.DataBind(); } else { Session["propertyvalue"] = "0"; } } catch (Exception ex) { string text = ex.Message.ToString(); ScriptManager.RegisterStartupScript(this, typeof(Page), "Warning", "<script>showpoperror('" + text + "')</script>", false); } }
protected void getdata() { SqlDataAdapter top4 = new SqlDataAdapter("IUD_BaiViet", cnn); top4.SelectCommand.CommandType = CommandType.StoredProcedure; top4.SelectCommand.Parameters.AddWithValue("@action", "select_new"); DataTable dt4 = new DataTable(); top4.Fill(dt4); ListView1.DataSource = dt4; ListView1.DataBind(); SqlDataAdapter topTT4 = new SqlDataAdapter("IUD_BaiViet", cnn); topTT4.SelectCommand.CommandType = CommandType.StoredProcedure; topTT4.SelectCommand.Parameters.AddWithValue("@action", "select_new"); DataTable dtTT4 = new DataTable(); topTT4.Fill(dtTT4); ListView2.DataSource = dtTT4; ListView2.DataBind(); SqlDataAdapter topDA4 = new SqlDataAdapter("IUD_DuAn", cnn); topDA4.SelectCommand.CommandType = CommandType.StoredProcedure; topDA4.SelectCommand.Parameters.AddWithValue("@action", "select_top4"); DataTable dtDA4 = new DataTable(); topDA4.Fill(dtDA4); ListView3.DataSource = dtDA4; ListView3.DataBind(); }
public void fill_list2() { cmd.CommandText = "select * from tblcardetails cd , tblcarname cn where cn.cn_status = 'Enabled' and cd.cn_id=cn.cn_id"; dt = da.GetRecords(cmd); ListView3.DataSource = dt; ListView3.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { SqlDataSource1.SelectCommand = "select Utente, count(Utente) as 'Preghiere' From FedPreg group by Utente order By Preghiere Desc"; SqlDataSource2.SelectCommand = "select Data, count(Data) as 'Preghiere' From FedPreg group by Data order By Data Desc"; SqlDataSource3.SelectCommand = "select count(id) as tot from FedPreg"; ListView3.DataSourceID = "SqlDataSource3"; ListView3.DataBind(); }
private void BindFoundLostTime() { DataTable dt = Bll.FoundService.SelectTopOne(); if (dt != null && dt.Rows.Count > 0) { ListView3.DataSource = dt; ListView3.DataBind(); } }
private void Bindlanqiu() { DataTable dt = BLL.CommodityManager.SelectlanqiuTop4(); if (dt != null && dt.Rows.Count != 0) { ListView3.DataSource = dt; ListView3.DataBind(); } }
private void BindProduct3() { DataTable dt = ProductService.SelectManRight(); if (dt != null && dt.Rows.Count != 0) { ListView3.DataSource = dt; ListView3.DataBind(); } }
protected void ListView3_ItemCommand(object sender, ListViewCommandEventArgs e) { if (e.CommandName == "fahuo") { string orderid = e.CommandArgument.ToString(); Oorder.updatestate(orderid, 2); ListView3.DataBind(); ListView4.DataBind(); } }
private void BindIS() { DataTable dt = InterestService.SelectTop2(); if (dt != null && dt.Rows.Count != 0) { ListView3.DataSource = dt; ListView3.DataBind(); } }
private void refresh(String user_id) { DataTable dt = TaskSystem.tools.GetData("SELECT top 10 issue.issueIndex, project.short, issue.title FROM [issue] JOIN project on issue.project_id=project.id join users on users.id=issue.assigne_id where issue.assigne_id=" + user_id + " order by issue.id desc "); ListView2.DataSource = dt; ListView2.DataBind(); DataTable dt2 = TaskSystem.tools.GetData("SELECT top 10 issue.issueIndex, project.short, issue.title FROM [issue] JOIN project on issue.project_id=project.id join users on users.id=issue.assigne_id order by issue.id desc "); ListView3.DataSource = dt2; ListView3.DataBind(); }
private void GetImagesData() { Database db = new Database(); Lang lang = new Lang(); string sqlSearch = "select * from albums where lang=@lang Order by id desc"; db.AddParameter("@lang", lang.getCurrentLang()); DataTable dt = db.ExecuteDataTable(sqlSearch); ListView3.DataSource = dt; ListView3.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { SqlDataAdapter sqlDataAdapter = new SqlDataAdapter("select * from Books", cons); DataTable dt = new DataTable(); sqlDataAdapter.Fill(dt); ListView1.DataSource = dt; ListView1.DataBind(); ListView2.DataSource = dt; ListView2.DataBind(); ListView3.DataSource = dt; ListView3.DataBind(); }
protected void Button4_Click(object sender, EventArgs e) { System.Web.UI.HtmlControls.HtmlTextArea textArea = (System.Web.UI.HtmlControls.HtmlTextArea)(form1.FindControl("otherSkills")); String otherSkill = textArea.Value; if (otherSkill.Equals("")) { otherSkillsError.Text = "Ju lutem plotesoni fushen!"; } else { int user = Convert.ToInt32(Session["id"]); NormalUserDB.addOtherSkill(otherSkill, user); textArea.Value = ""; ListView3.DataBind(); } }
private void ShowResolvedcomplaints() { try { if (Session["propertyvalue"] != null) { string tc_PropertyVal = Session["propertyvalue"].ToString(); ListView3.DataSource = uc.GetResolvedComplaints(tc_PropertyVal); ListView3.DataBind(); } else { Session["propertyvalue"] = "0"; } } catch (Exception ex) { string text = ex.Message.ToString(); ScriptManager.RegisterStartupScript(this, typeof(Page), "Warning", "<script>showpoperror('" + text + "')</script>", false); } }
protected void lnkbtn_Command(object sender, CommandEventArgs e) { double filepath = double.Parse(e.CommandName.ToString()); cn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True"); cn.Open(); string g = "select * from DeskWallpaper where id='" + filepath + "'"; cmd = new SqlCommand(g, cn); // dr = cmd.ExecuteReader(); da = new SqlDataAdapter(cmd); ds = new DataSet(); da.Fill(ds); string path = ds.Tables[0].Rows[0][1].ToString(); //string path = dr["image"].ToString(); // Response.Write(path); string path1 = Server.MapPath(path); FileInfo file = new FileInfo(path1); if (file.Exists) { file.Delete(); } string gg = "delete from DeskWallpaper where id='" + filepath + "'"; cmd = new SqlCommand(gg, cn); cmd.ExecuteNonQuery(); cn.Close(); Response.Write("<script>alert('Image Deleted Successfully')</script>"); ListView3.DataBind(); }
//绑定作品被评论 protected void BindReplyComments() { ListView3.DataSource = CommentService.Select(int.Parse(Session["User_ID"].ToString())); ListView3.DataBind(); }
public void getSource() { List <ListItems> columnList = new List <ListItems>(); if (auth.CompleteAuthorization(Request.Url) == true) { dict = new DictionaryDB(); var twitterCtx = new LinqToTwitter.TwitterContext(auth); var tweets = from t in twitterCtx.Status where t.Type == StatusType.User && t.ScreenName == DropDownList1.SelectedValue && t.Count == Int32.Parse(tweetnum.SelectedValue) select t; foreach (var tweetStatus in tweets) { var listItem = new ListItems(); List <UrlEntity> Urle = tweetStatus.Entities.UrlEntities; foreach (var url in Urle) { if (!string.IsNullOrWhiteSpace(url.ExpandedUrl)) { listItem.url = url.ExpandedUrl; } } listItem.tweet = tweetStatus.Text; listItem.date = tweetStatus.CreatedAt; if (!string.IsNullOrEmpty(dict.getTweetCategory(tweetStatus.Text))) { listItem.category = dict.getTweetCategory(tweetStatus.Text); } else { listItem.category = "Others"; } columnList.Add(listItem); } ListView1.DataSource = columnList.AsQueryable().ToArray(); ListView1.DataBind(); if (tweets != null) { var dictionaryword = dict.getDictionaryWords(); foreach (var tweetStatus in tweets) { foreach (string word in dictionaryword) { if (tweetStatus.Text.Contains(word) == true) { string category = dict.getWordCategory(word); break; } } } #region Pie Charts (Home, Network, Desktop, Mobile, Others) foreach (var tweetStatus in tweets) { if (!string.IsNullOrEmpty(dict.getTweetCategory(tweetStatus.Text))) { if (dict.getTweetCategory(tweetStatus.Text) == "Network") { NetworkList.Add(tweetStatus); networkCategory++; #region Network Pie Chart if (dict.getSecTweetCategory(tweetStatus.Text) == "Emails") { emailCategory++; } else if (dict.getSecTweetCategory(tweetStatus.Text) == "Online Game") { OnlineCategory++; } else if (dict.getSecTweetCategory(tweetStatus.Text) == "Social Media") { SocialCategory++; } else if (dict.getSecTweetCategory(tweetStatus.Text) == "Server") { ServerCategory++; } else if (dict.getSecTweetCategory(tweetStatus.Text) == "Website") { WebsiteCategory++; } else { netotherCategory++; } #endregion } else if (dict.getTweetCategory(tweetStatus.Text) == "Desktop") { desktopCategory++; DesktopList.Add(tweetStatus); #region Desktop Pie Chart if (dict.getSecTweetCategory(tweetStatus.Text) == "Com Hardware") { DHCategory++; } else if (dict.getSecTweetCategory(tweetStatus.Text) == "Com Software") { DSCategory++; } else if (dict.getSecTweetCategory(tweetStatus.Text) == "Operating System") { OperatingCategory++; } else { DeskOtherCategory++; } #endregion } else if (dict.getTweetCategory(tweetStatus.Text) == "Mobile") { mobileCategory++; MobileList.Add(tweetStatus); #region Mobile Pie Chart if (dict.getSecTweetCategory(tweetStatus.Text) == "Telecommunication") { telecomCategory++; } else if (dict.getSecTweetCategory(tweetStatus.Text) == "Hardware") { MHCategory++; } else if (dict.getSecTweetCategory(tweetStatus.Text) == "Software") { MSCategory++; } else if (dict.getSecTweetCategory(tweetStatus.Text) == "Platform") { PlatformCategory++; } else { MobOtherCategory++; } #endregion } } else { otherCategory++; OthersList.Add(tweetStatus); } } #endregion #region Home Categories (Segment) if (networkCategory != 0) { DataPoint network = new DataPoint(); network.SetValueXY("Network", networkCategory); Chart1.Series[0].Points.Add(network); Chart1.Series["Series1"]["PieLabelStyle"] = "outside"; columnList.Clear(); foreach (var tweetStatus in NetworkList) { var listItem = new ListItems(); List <UrlEntity> Urle = tweetStatus.Entities.UrlEntities; foreach (var url in Urle) { if (!string.IsNullOrWhiteSpace(url.ExpandedUrl)) { listItem.url = url.ExpandedUrl; } } listItem.tweet = tweetStatus.Text; listItem.date = tweetStatus.CreatedAt; if (!string.IsNullOrEmpty(dict.getSecTweetCategory(tweetStatus.Text))) { listItem.category = dict.getSecTweetCategory(tweetStatus.Text); } else { listItem.category = "Others"; } columnList.Add(listItem); } ListView2.DataSource = columnList.AsQueryable().ToArray(); ListView2.DataBind(); } if (desktopCategory != 0) { DataPoint desktop = new DataPoint(); desktop.SetValueXY("Desktop", desktopCategory); Chart1.Series[0].Points.Add(desktop); Chart1.Series["Series1"]["PieLabelStyle"] = "outside"; columnList.Clear(); foreach (var tweetStatus in DesktopList) { var listItem = new ListItems(); List <UrlEntity> Urle = tweetStatus.Entities.UrlEntities; foreach (var url in Urle) { if (!string.IsNullOrWhiteSpace(url.ExpandedUrl)) { listItem.url = url.ExpandedUrl; } } listItem.tweet = tweetStatus.Text; listItem.date = tweetStatus.CreatedAt; if (!string.IsNullOrEmpty(dict.getSecTweetCategory(tweetStatus.Text))) { listItem.category = dict.getSecTweetCategory(tweetStatus.Text); } else { listItem.category = "Others"; } columnList.Add(listItem); } ListView4.DataSource = columnList.AsQueryable().ToArray(); ListView4.DataBind(); } if (mobileCategory != 0) { DataPoint mobile = new DataPoint(); mobile.SetValueXY("Mobile", mobileCategory); Chart1.Series[0].Points.Add(mobile); Chart1.Series["Series1"]["PieLabelStyle"] = "outside"; columnList.Clear(); foreach (var tweetStatus in MobileList) { var listItem = new ListItems(); List <UrlEntity> Urle = tweetStatus.Entities.UrlEntities; foreach (var url in Urle) { if (!string.IsNullOrWhiteSpace(url.ExpandedUrl)) { listItem.url = url.ExpandedUrl; } } listItem.tweet = tweetStatus.Text; listItem.date = tweetStatus.CreatedAt; if (!string.IsNullOrEmpty(dict.getSecTweetCategory(tweetStatus.Text))) { listItem.category = dict.getSecTweetCategory(tweetStatus.Text); } else { listItem.category = "Others"; } columnList.Add(listItem); } ListView3.DataSource = columnList.AsQueryable().ToArray(); ListView3.DataBind(); } if (otherCategory != 0) { DataPoint others = new DataPoint(); others.SetValueXY("Others", otherCategory); Chart1.Series["Series1"]["PieLabelStyle"] = "outside"; Chart1.Series[0].Points.Add(others); columnList.Clear(); foreach (var tweetStatus in OthersList) { var listItem = new ListItems(); List <UrlEntity> Urle = tweetStatus.Entities.UrlEntities; foreach (var url in Urle) { if (!string.IsNullOrWhiteSpace(url.ExpandedUrl)) { listItem.url = url.ExpandedUrl; } } listItem.tweet = tweetStatus.Text; listItem.date = tweetStatus.CreatedAt; if (!string.IsNullOrEmpty(dict.getSecTweetCategory(tweetStatus.Text))) { listItem.category = dict.getSecTweetCategory(tweetStatus.Text); } else { listItem.category = "Others"; } columnList.Add(listItem); } ListView5.DataSource = columnList.AsQueryable().ToArray(); ListView5.DataBind(); } #endregion #region Network Categories (Segment) if (emailCategory != 0) { DataPoint email = new DataPoint(); email.SetValueXY("Email", emailCategory); Chart2.Series[0].Points.Add(email); Chart2.Series["Series1"]["PieLabelStyle"] = "outside"; } if (OnlineCategory != 0) { DataPoint onlinegame = new DataPoint(); onlinegame.SetValueXY("Online Game", OnlineCategory); Chart2.Series[0].Points.Add(onlinegame); Chart2.Series["Series1"]["PieLabelStyle"] = "outside"; } if (SocialCategory != 0) { DataPoint social = new DataPoint(); social.SetValueXY("Social Media", SocialCategory); Chart2.Series[0].Points.Add(social); Chart2.Series["Series1"]["PieLabelStyle"] = "outside"; } if (WebsiteCategory != 0) { DataPoint website = new DataPoint(); website.SetValueXY("Website", WebsiteCategory); Chart2.Series[0].Points.Add(website); Chart2.Series["Series1"]["PieLabelStyle"] = "outside"; } if (ServerCategory != 0) { DataPoint server = new DataPoint(); server.SetValueXY("Server", ServerCategory); Chart2.Series[0].Points.Add(server); Chart2.Series["Series1"]["PieLabelStyle"] = "outside"; } if (netotherCategory != 0) { DataPoint netother = new DataPoint(); netother.SetValueXY("Others", netotherCategory); Chart2.Series[0].Points.Add(netother); Chart2.Series["Series1"]["PieLabelStyle"] = "outside"; } if (emailCategory == 0 && OnlineCategory == 0 && SocialCategory == 0 && WebsiteCategory == 0 && ServerCategory == 0 && netotherCategory == 0) { Chart2.Visible = false; } #endregion #region Mobile Category (Segment) if (telecomCategory != 0) { DataPoint telecom = new DataPoint(); telecom.SetValueXY("Telecom", telecomCategory); Chart3.Series[0].Points.Add(telecom); Chart3.Series["Series1"]["PieLabelStyle"] = "outside"; } if (MHCategory != 0) { DataPoint mobhardware = new DataPoint(); mobhardware.SetValueXY("Hardware", MHCategory); Chart3.Series[0].Points.Add(mobhardware); Chart3.Series["Series1"]["PieLabelStyle"] = "outside"; } if (MSCategory != 0) { DataPoint mobsoftware = new DataPoint(); mobsoftware.SetValueXY("Software", MSCategory); Chart3.Series[0].Points.Add(mobsoftware); Chart3.Series["Series1"]["PieLabelStyle"] = "outside"; } if (PlatformCategory != 0) { DataPoint platform = new DataPoint(); platform.SetValueXY("Platform", PlatformCategory); Chart3.Series[0].Points.Add(platform); Chart3.Series["Series1"]["PieLabelStyle"] = "outside"; } if (MobOtherCategory != 0) { DataPoint mobothers = new DataPoint(); mobothers.SetValueXY("Others", MobOtherCategory); Chart3.Series[0].Points.Add(mobothers); Chart3.Series["Series1"]["PieLabelStyle"] = "outside"; } if (telecomCategory == 0 && MHCategory == 0 && MSCategory == 0 && PlatformCategory == 0 && MobOtherCategory == 0) { Chart3.Visible = false; } #endregion #region Desktop Categories (Segment) if (DHCategory != 0) { DataPoint DeskHardware = new DataPoint(); DeskHardware.SetValueXY("Hardware", DHCategory); Chart4.Series[0].Points.Add(DeskHardware); Chart4.Series["Series1"]["PieLabelStyle"] = "outside"; } if (DSCategory != 0) { DataPoint DeskSoftware = new DataPoint(); DeskSoftware.SetValueXY("Software", DSCategory); Chart4.Series[0].Points.Add(DeskSoftware); Chart4.Series["Series1"]["PieLabelStyle"] = "outside"; } if (OperatingCategory != 0) { DataPoint OS = new DataPoint(); OS.SetValueXY("Operating System", OperatingCategory); Chart4.Series[0].Points.Add(OS); Chart4.Series["Series1"]["PieLabelStyle"] = "outside"; } if (DeskOtherCategory != 0) { DataPoint DeskOther = new DataPoint(); DeskOther.SetValueXY("Others", DeskOtherCategory); Chart4.Series[0].Points.Add(DeskOther); Chart4.Series["Series1"]["PieLabelStyle"] = "outside"; } if (DHCategory == 0 && DSCategory == 0 && OperatingCategory == 0 && DeskOtherCategory == 0) { Chart4.Visible = false; } #endregion } } activate = "activated"; }
//绑定用户发表的帖子 protected void Bindbbs() { ListView3.DataSource = UserIndexBLL.BBS_All(Session["username"].ToString()); ListView3.DataBind(); }
protected void BtnDWdelete_Click(object sender, EventArgs e) { PanelDWinsert.Visible = false; PanelDWdelete.Visible = true; ListView3.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) {// Buscar try { DataTable dt = new DataTable(); SqlConnection sqlConn = new SqlConnection(connStr); SqlCommand sqlCommand; SqlDataAdapter sqlDA; sqlConn.Open(); sqlCommand = sqlConn.CreateCommand(); Boolean con2 = false; if (TipoBusqueda == 0) // canciones { sqlCommand.CommandText = "SELECT Canciones.* FROM Canciones WHERE Canciones.Cancion LIKE '%" + txt_Busqueda.Text + "%'"; } else if (TipoBusqueda == 1)// Artistas { sqlCommand.CommandText = "SELECT Canciones.* FROM Canciones WHERE Canciones.Artista LIKE '%" + txt_Busqueda.Text + "%'"; con2 = true; } else if (TipoBusqueda == 2) // Albunes y Artistas { sqlCommand.CommandText = "SELECT Canciones.Artista,Canciones.Album,Canciones.Cancion,Canciones.Genero,Canciones.Compositor,Canciones.Colaboradores,Canciones.Link,Canciones.ImageUrl,Albums.Año FROM Canciones,Albums WHERE Albums.Album = Canciones.Album AND Albums.Album LIKE '%" + txt_Busqueda.Text + "%' AND Canciones.Artista LIKE '%" + txt_Busqueda2.Text + "%'"; } sqlDA = new SqlDataAdapter(sqlCommand); sqlDA.Fill(dt); SqlDataReader reader = sqlCommand.ExecuteReader(); sqlConn.Close(); ListView1.Visible = false; ListView3.Visible = false; ListView2.Visible = true; ListView2.DataSource = dt; ListView2.DataBind(); if (ListView2.Items.Count == 0 && con2 == false) { Response.Write("<script>alert('No se encontraron Canciones con este criterio de Busqueda!');</script>"); } if (con2 == true) { DataTable dt2 = new DataTable(); SqlConnection sqlConn2 = new SqlConnection(connStr); SqlCommand sqlCommand2; SqlDataAdapter sqlDA2; sqlConn2.Open(); sqlCommand2 = sqlConn2.CreateCommand(); sqlCommand2.CommandText = "SELECT Albums.* FROM Albums WHERE Albums.Artista LIKE '%" + txt_Busqueda.Text + "%'"; sqlDA2 = new SqlDataAdapter(sqlCommand2); sqlDA2.Fill(dt2); sqlConn2.Close(); ListView3.Visible = true; ListView3.DataSource = dt2; ListView3.DataBind(); if (ListView3.Items.Count == 0 && ListView2.Items.Count == 0) { Response.Write("<script>alert('No se encontraron Álbums y/o Canciones con base al Artista buscado!');</script>"); } else if (ListView3.Items.Count == 0) { Response.Write("<script>alert('No se encontraron Álbums con base al Artista buscado!');</script>"); } else if (ListView2.Items.Count == 0) { Response.Write("<script>alert('No se encontraron Canciones con base al Artista buscado!');</script>"); } } } catch (Exception ex) { Response.Write(ex.Message); } }
protected void waiguo() { ListView3.DataSource = BookManager.waiguo(); ListView3.DataBind(); }
private void FFT_Click(object sender, EventArgs e) { int chanCount = comboBox_chanCount.SelectedIndex + 1; for (int i = 0; i < chanCount; ++i) { double[] values = (double[])xreal[i].ToArray(typeof(double)); double[] ivalues = new double[values.Length]; num = values.Length; for (int j = 0; j < values.Length; j++) { ivalues[j] = 0; } TWFFT.FFT(values, ivalues); //TWFFT.IFFT(values, ivalues); for (int j = 0; j < values.Length; j++) { value[i].Add(values[j]); ivalue[i].Add(ivalues[j]); } } string result = fname.Insert(fname.LastIndexOf('.'), " FFT"); using (FileStream fs = File.Open(result, FileMode.OpenOrCreate)) { StreamWriter w = new StreamWriter(fs); w.BaseStream.Seek(0, SeekOrigin.End); w.Write("\r\nFFT:\r\n"); for (int i = 0; i < chanCount; i++) { w.BaseStream.Seek(0, SeekOrigin.End); w.Write("channel " + i.ToString() + "\r\n"); for (int j = 0; j < num; j++) { //写文件 w.Write(value[i][j].ToString() + " "); w.Write(ivalue[i][j].ToString() + " "); w.Write("\r\n"); } } w.Flush(); w.Close(); } chart1.ChartAreas[0].AxisY.Maximum = trackBar2.Value; // chart1.ChartAreas[0].AxisX.Maximum = trackBar1.Value; double[] Power = { 0, 0, 0, 0, 0, 0, 0, 0 }; double[] Freq = { 0, 0, 0, 0, 0, 0, 0, 0 }; for (int i = 0; i < chanCount; i++) { double power = 0; int frequency = 0; double[] values = (double[])value[i].ToArray(typeof(double)); double[] ivalues = (double[])ivalue[i].ToArray(typeof(double)); for (int j = 0; j < num; j++) { if (power < values[j] * values[j] + ivalues[j] * ivalues[j]) { power = (values[j] * values[j] + ivalues[j] * ivalues[j]); frequency = j; } } Power[i] = power; Freq[i] = frequency * 1000 / time; } ; //control list view ,one grid indicates a channel which specials with color and value. ListView2.Clear(); ListView2.FullRowSelect = false; ListView2.Width = 480; ListView2.Height = 21; ListView2.View = View.Details;// Set the view to show details. ListView2.HeaderStyle = ColumnHeaderStyle.None; ListView2.GridLines = true; // there are 8 columns for every item. for (int k = 0; k < 8; k++) { ListView2.Columns.Add("", 60); } // modify the grid's height with image Indirectly. ImageList imgList2 = new ImageList(); imgList2.ImageSize = new Size(1, 21); //width and height. ListView2.SmallImageList = imgList2; //use imgList to modify the height of listView grids. // create two ListViewItem objects,so there are 16 grids for listView. m_firstItem2 = new ListViewItem(); m_firstItem2.SubItems.Clear(); m_firstItem2.UseItemStyleForSubItems = false; m_firstItem2.Font = new Font("SimSun", 10); m_firstItem2.SubItems[0].Text = String.Format("{0:0}", Power[0]); m_firstItem2.SubItems[0].BackColor = m_simpleGraph.Pens[0].Color; for (int k = 1; k < 8; k++) { if (k < chanCountSet) { m_firstItem2.SubItems.Add((String.Format("{0:0}", Power[k])), Color.Black, Color.Honeydew, new Font("SimSun", 10)); m_firstItem2.SubItems[k].BackColor = m_simpleGraph.Pens[k].Color; } else { m_firstItem2.SubItems.Add(""); m_firstItem2.SubItems[k].BackColor = Color.White; } } ListViewItem[] list2 = new ListViewItem[] { m_firstItem2 }; ListView2.Items.AddRange(list2); ListView3.Clear(); ListView3.FullRowSelect = false; ListView3.Width = 480; ListView3.Height = 21; ListView3.View = View.Details;// Set the view to show details. ListView3.HeaderStyle = ColumnHeaderStyle.None; ListView3.GridLines = true; // there are 8 columns for every item. for (int k = 0; k < 8; k++) { ListView3.Columns.Add("", 60); } // modify the grid's height with image Indirectly. ImageList imgList3 = new ImageList(); imgList3.ImageSize = new Size(1, 21); //width and height. ListView3.SmallImageList = imgList3; //use imgList to modify the height of listView grids. // create two ListViewItem objects,so there are 16 grids for listView. m_firstItem3 = new ListViewItem(); m_firstItem3.SubItems.Clear(); m_firstItem3.UseItemStyleForSubItems = false; m_firstItem3.Font = new Font("SimSun", 10); m_firstItem3.SubItems[0].Text = String.Format("{0:0}", Freq[0]); m_firstItem3.SubItems[0].BackColor = m_simpleGraph.Pens[0].Color; for (int k = 1; k < 8; k++) { if (k < chanCountSet) { m_firstItem3.SubItems.Add((String.Format("{0:0}", Freq[k])), Color.Black, Color.Honeydew, new Font("SimSun", 10)); m_firstItem3.SubItems[k].BackColor = m_simpleGraph.Pens[k].Color; } else { m_firstItem3.SubItems.Add(""); m_firstItem3.SubItems[k].BackColor = Color.White; } } ListViewItem[] list3 = new ListViewItem[] { m_firstItem3 }; ListView3.Items.AddRange(list3); FFT.Enabled = false; }