//gv绑定 public void ListViewBind4() { string Str1 = " where ui_status='正常' and ui_lx='企业'"; if (!string.IsNullOrEmpty(bm3.SelectedItem.Value)) { if (bm3.SelectedItem.Value == "1000000") { Str1 = Str1 + " and yn_bmglz='是'"; } else { Str1 = Str1 + " and ui_ssbm= '" + bm3.SelectedItem.Value + "' "; } } if (!string.IsNullOrEmpty(cxtj3.Text)) { Str1 = Str1 + " AND (UI_ID LIKE '%" + hkdb.GetStr(cxtj3.Text) + "%' OR UI_DESC LIKE '%" + hkdb.GetStr(cxtj3.Text) + "%')"; } AspNetPager4.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", AspNetPager4.PageSize * (AspNetPager4.CurrentPageIndex - 1), AspNetPager4.PageSize); ListView4.DataSource = ds; ListView4.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 Button5_Click(object sender, EventArgs e) { System.Web.UI.HtmlControls.HtmlTextArea textArea = (System.Web.UI.HtmlControls.HtmlTextArea)(form1.FindControl("experience")); String experiences = textArea.Value; int user = Convert.ToInt32(Session["id"]); DateTime start_date = Convert.ToDateTime(startDate.Text).Date; DateTime end_date = Convert.ToDateTime(endDate.Text).Date; if (experience.Equals("")) { experiencesError.Text = "Ju lutem plotesoni fushen!"; } else { if (start_date > end_date) { experiencesError.Text = "Ju lutem jepni inputin e duhur"; } else { NormalUserDB.addExperience(experiences, start_date, end_date, user); textArea.Value = ""; ListView4.DataBind(); } } //DateTime start_date = DateTime.ParseExact(startDate.Text,"dd-MM-yyyy", null); //DateTime end_date = DateTime.ParseExact(endDate.Text, "dd-MM-yyyy", null); }
protected void lnkbtn1_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 MobileWallpaper 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 MobileWallpaper where id='" + filepath + "'"; cmd = new SqlCommand(gg, cn); cmd.ExecuteNonQuery(); cn.Close(); Response.Write("<script>alert('Image Deleted Successfully')</script>"); ListView4.DataBind(); }
public void fill_review() { int cnid = Convert.ToInt32(Request.QueryString["id"]); cmd.CommandText = "select * from tblreview rw, tblcarver cv where cv.cn_id=rw.cn_id and cv.vr_id='" + cnid + "' order by rw_id desc limit 2 "; dt = da.GetRecords(cmd); ListView4.DataSource = dt; ListView4.DataBind(); }
private void BindProduct4() { DataTable dt = ProductService.SelectWoManLeft(); if (dt != null && dt.Rows.Count != 0) { ListView4.DataSource = dt; ListView4.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 BindFosterTime() { DataTable dt = Bll.FosterService.SelectTopOne(); if (dt != null && dt.Rows.Count > 0) { ListView4.DataSource = dt; ListView4.DataBind(); } }
private void Bindhuju() { DataTable dt = BLL.CommodityManager.SelecthujuTop4(); if (dt != null && dt.Rows.Count != 0) { ListView4.DataSource = dt; ListView4.DataBind(); } }
private void GetReportData() { Database db = new Database(); Lang lang = new Lang(); string sqlSearch = "select * from Report where lang=@lang Order by id desc"; db.AddParameter("@lang", lang.getCurrentLang()); DataTable dt = db.ExecuteDataTable(sqlSearch); ListView4.DataSource = dt; ListView4.DataBind(); }
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) { string Info_Id = GridView1.SelectedRow.Cells[0].Text; SqlDataAdapter da = new SqlDataAdapter(@"select * from sellers_price where good_id = '" + Info_Id + "' ", con); DataTable dt = new DataTable(); da.Fill(dt); Div2.Attributes.Add("style", "display:block;"); Div3.Attributes.Add("style", "display:block;"); ListView4.DataSource = dt; ListView4.DataBind(); }
//评论 protected void Button1_Click(object sender, EventArgs e) { if (Session["user"] != null) { if (TextBox1.Text.Trim() != "") { String str = "insert into discuss(comment,publishdate,userid,fileid) values('" + TextBox1.Text + "','" + DateTime.Now + "','" + userid + "'," + Request.QueryString["fileid"] + ")"; try { con.Open(); SqlCommand com = new SqlCommand(str, con); if (com.ExecuteNonQuery() > 0) { Response.Write("<script>alert('评论成功')</script>"); ListView2.DataBind(); ListView4.DataBind(); } else { Response.Write("<script>alert('评论失败')</script>"); } } catch (Exception ez) { Response.Write("<script>alert('评论失败2')</script>"); } finally { con.Close(); } } else { Response.Write("<script>alert('评论不能为空,请输入评论!!!')</script>"); } } else { Response.Write("<script>alert('请登录后再评论!!!')</script>"); } }
//绑定用户帖子下的评论 protected void Bindnbc() { ListView4.DataSource = UserIndexBLL.BBScomt_ALL(Session["username"].ToString()); ListView4.DataBind(); }
protected void BtnMWdelete_Click(object sender, EventArgs e) { PanelMWinsert.Visible = false; PanelMWdelete.Visible = true; ListView4.DataBind(); }
protected void shige() { ListView4.DataSource = BookManager.shige(); ListView4.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"; }