private void BindRepeat2() { WX.Main.CurUser.LoadUserModel(false); DateTime dtime = Convert.ToDateTime(DropDownList1.SelectedValue + "-1"); System.Data.DataTable dt = ULCode.QDA.XSql.GetDataTable("select RealName,isnull((select sum(Count) from WorkOrder_Orders where State=8 and year(StopTime)=" + dtime.Year.ToString() + " and month(StopTime)=" + dtime.Month.ToString() + " and ExecUserID=TU_Users.UserID),0) WorkCount from TU_Users where DepartmentID=" + WX.Main.CurUser.UserModel.DepartmentID.ToString()); Repeater2.DataSource = dt; Repeater2.DataBind(); }
protected void reset(object sender, EventArgs e) { Session["SERVICES"] = null; Selected_lbx.Items.Clear(); total_lbl.Text = "0"; Repeater1.DataBind(); Repeater2.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(@"Data Source=DESKTOP-B1PJQ57\HIEUHOAI;Initial Catalog=Repeater;Integrated Security=True"); conn.Open(); string query = "select * from sp"; if (Request["key"] != null) { query = "select * from sp where name like '%" + Request["key"].ToString() + "%'"; } SqlDataAdapter da = new SqlDataAdapter(query, conn); DataTable dt = new DataTable(); da.Fill(dt); int so_item_1_trang = 3; int so_trang = (dt.Rows.Count / so_item_1_trang) + (dt.Rows.Count % so_item_1_trang == 0 ? 0 : 1); int page = Request["page"] == null ? 1 : Convert.ToInt32(Request["page"].ToString()); int from = (page - 1) * 3; int to = page * 3 - 1; for (int i = dt.Rows.Count - 1; i >= 0; i--) { if (i < from || i > to) { dt.Rows.RemoveAt(i); } } Repeater1.DataSource = dt; Repeater1.DataBind(); conn.Close(); if (Request["id"] != null) { query = "select * from sp where id = '" + Request["id"] + "'"; SqlDataAdapter list = new SqlDataAdapter(query, conn); DataTable dtlist = new DataTable(); list.Fill(dtlist); TextBox1.Text = dtlist.Rows[0]["name"].ToString(); Image1.Visible = true; Image1.ImageUrl = "~/img/" + dtlist.Rows[0]["img"].ToString(); DropDownList1.SelectedValue = dtlist.Rows[0]["stt"].ToString(); } DataTable dtPage = new DataTable(); dtPage.Columns.Add("index"); dtPage.Columns.Add("active"); for (int i = 1; i <= so_trang; i++) { DataRow dr = dtPage.NewRow(); dr["index"] = i; dtPage.Rows.Add(dr); } Repeater2.DataSource = dtPage; Repeater2.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { #region 获取页面参数 string[] strIDs = Request.QueryString["ID"] != null ? Request.QueryString["ID"].ToString().Split(new char[] { ',' }, System.StringSplitOptions.None) : new string[] { "" }; int[] ids = new int[strIDs.Length]; bool flag = false;//为true标识转换出错退回列表界面 int classify = 0; if (strIDs == null || strIDs.Length == 0 || (strIDs.Length == 1 && string.IsNullOrEmpty(strIDs[0]))) { flag = true; } else { for (int i = 0; i < strIDs.Length; i++) { try { int _id = int.Parse(strIDs[i]); PBM_DeliveryBLL _bllDelivery = new PBM_DeliveryBLL(_id); if (_bllDelivery == null || _bllDelivery.Model.ID == 0) { flag = true; break; } if (classify == 0) { classify = _bllDelivery.Model.Classify; //初始化分类 } else if (classify != _bllDelivery.Model.Classify) { flag = true; break; } //分类不一致也退回列表界面 ids[i] = _id; } catch { flag = true; break; } } } if (flag) { if (classify > 0) { Response.Redirect("PurchaseList.aspx?Classify=" + classify.ToString()); } else { Response.Redirect("PurchaseList.aspx"); } } ViewState["ids"] = ids; #endregion Repeater2.DataSource = ids; Repeater2.DataBind(); //BindData(); } }
///<summary> /// 帮定分页数据 ///</summary> /// void BindData(string key = null) { IEnumerable <书名表> ListSource = new List <书名表>(); ListSource = Tygdb.书名表.Where(p => p.包含有效章节 != null && p.包含有效章节 > 0).OrderByDescending(p => p.最后更新时间); //ShowNews.DataSource = ListSource; //ShowNews.DataBind(); //每一个分类取最新的一条记录 var docs = Tygdb.ExecuteStoreQuery <NewDocItem>(@" select d.ID,d.本记录GUID,d.GUID,d.书名 into #doc from ( select top 100 [GUID] from 书名表 where 包含有效章节 > 0 order by 最后更新时间 desc ) as doctype left join ( SELECT * from 文章表 ) d on d.[GUID]=doctype.[GUID] select * from (select *,row=row_number()over(partition by [GUID] order by ID desc) from #doc)t where row=1 and t.id>0 drop table #doc "); decimal[] ids = docs.Select(p => p.ID).ToArray(); //使用了in var topDocs = Tygdb.文章表.Where(p => ids.Contains(p.ID)).OrderByDescending(p => p.ID).ToList().Where( //确保章节是有效的 p => string.Join("", System.Text.RegularExpressions.Regex.Matches(p.内容, @"[\u4e00-\u9fa5\d\w123456789~!!·#¥%……—*()——+/”》“‘’,;。、?,:…《]+[\u4e00-\u9fa5123456789~!!·#¥%……—*(!)——+/”》“‘,’\r\n;。、?,:…《]", System.Text.RegularExpressions.RegexOptions.Multiline) .Cast <System.Text.RegularExpressions.Match>().Select(x => x.Value).ToArray() ).Length > 200 ); topDocs = topDocs.ToList().Where(p => System.IO.File.Exists(AppDomain.CurrentDomain.BaseDirectory + p.GetHTMLFilePath())).ToList(); Docs1.DataSource = topDocs.Take(6); Docs1.DataBind(); Repeater1.DataSource = topDocs.Skip(6 * 1).Take(6); Repeater1.DataBind(); Repeater2.DataSource = topDocs.Skip(6 * 2).Take(6); Repeater2.DataBind(); Repeater3.DataSource = topDocs.Skip(6 * 3).Take(6); Repeater3.DataBind(); Repeater4.DataSource = topDocs.Skip(6 * 4).Take(6); Repeater4.DataBind(); Repeater5.DataSource = topDocs.Skip(6 * 5).Take(6); Repeater5.DataBind(); BindTopBook(); }
private void BindSinger() { DataTable dt = SingerManager.selectTop5(); if (dt != null && dt.Rows.Count != 0) { Repeater2.DataSource = dt; Repeater2.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { DataSet1TableAdapters.TBLBILGITableAdapter dt = new DataSet1TableAdapters.TBLBILGITableAdapter(); Repeater1.DataSource = dt.BilgiGetir(); Repeater1.DataBind(); DataSet1TableAdapters.TBLURUNLERTableAdapter dt2 = new DataSet1TableAdapters.TBLURUNLERTableAdapter(); Repeater2.DataSource = dt2.UrunGetir(); Repeater2.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { CustomerLogic CL = new CustomerLogic(); Repeater1.DataSource = CL.SelectForReport1(); Repeater1.DataBind(); Repeater2.DataSource = CL.SelectForReport1(); Repeater2.DataBind(); }
protected void Show1() { con.getConnection(); cmd1.CommandText = "select CategoryName,Cid from Category"; cmd1.Connection = con.getConnection(); sdr1.SelectCommand = cmd1; sdr1.Fill(ds1, "Category"); Repeater2.DataSource = ds1; Repeater2.DataBind(); }
protected void Repeater2_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "g" && list != null) { YapilacakDuyurular a = list.Where(p => p.DuyuruID == Convert.ToInt32(e.CommandArgument.ToString())).FirstOrDefault(); list.Remove(a); Repeater2.DataSource = list; Repeater2.DataBind(); } }
private void GetList() { SOSOshop.BLL.Integral.MemberIntegralTemplate bll = new SOSOshop.BLL.Integral.MemberIntegralTemplate(); Repeater1.DataSource = bll.GetList(); Repeater1.DataBind(); bll = null; Repeater2.DataSource = bllo.GetList(); Repeater2.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { int c = Convert.ToInt32(Session["custid"]); var product = db.Product.ToList(); //Müşteri Listesinde Bulunulan Firmaları listeleme if (Page.IsPostBack == false) { var sorgu = (from x in db.Customer where x.Companies1.Id == c select new { x.CompanyId, x.Companies.CompanyName }).ToList(); DropDownList1.DataTextField = "CompanyName"; DropDownList1.DataValueField = "CompanyId"; DropDownList1.DataSource = sorgu; DropDownList1.DataBind(); } // Seçilen Firmanın Ürünlerini Listeleme int a = Convert.ToInt32(DropDownList1.SelectedValue); var sorgu1 = (from x in db.Product where x.CompanyId == a select new { x.Id, x.ProductName, x.Price, x.Stock, x.Code, x.Category.CategoryName }).ToList(); Repeater1.DataSource = sorgu1; Repeater1.DataBind(); //Sepet var cart = (from x in db.Orders where x.Customer.CustomerId == c && x.IsBasket == true select new { x.Id, x.ProductId, x.Product.ProductName, x.Product.Price, x.Count, }).ToList(); Repeater2.DataSource = cart; Repeater2.DataBind(); }
protected void BtnGet_Click(object sender, EventArgs e) { string url = txtUrl.Text; //string url = "https://news.google.com/rss?hl=pl&gl=PL&ceid=PL"; if (string.IsNullOrWhiteSpace(url)) { url = "https://news.google.com/rss?hl=pl&gl=PL&ceid=PL"; } XElement rss = XElement.Load(url); /* * var query = from item in rss.Descendants("item") * select new RssItem * { * Title = item.Element("title").Value, * pubDate = item.Element("pubDate").Value, * Description = item.Element("description").Value * }; * */ var queryLambda = rss.Descendants("item").Select(item => new RssItem { Title = item.Element("title").Value, pubDate = item.Element("pubDate").Value, Description = item.Element("description").Value }); var items = queryLambda.ToList(); var items2 = new List <RssItem>(); var items3 = new List <RssItem>(); int kk = 0; foreach (RssItem r in items) { if (kk % 2 == 0) { items2.Add(r); } else { items3.Add(r); } kk++; } Repeater1.DataSource = items2; Repeater1.DataBind(); Repeater2.DataSource = items3; Repeater2.DataBind(); }
public void PageBind1() { PageBase pb = new PageBase(); pb.TblName = "Tunnel_InfoXJB"; pb.FldName = "id"; pb.ProcedureName = "pagination"; pb.PageSize = pageSize; if (cuttentPage == 0) { cuttentPage = pb.PageIndex; } pb.PageIndex = cuttentPage; int count = 0; pb.DoCount = 1; string where = " typeid =" + typeId + " and sectype=" + sectype; string key = ""; if (where.Length > 0) { key += " and Title like '%" + TextBox1.Text + "%'"; } else { key += " 1=1 and Title like '%" + TextBox1.Text + "%'"; } //key += " and bum_bz= " + Request.QueryString["bum_id"].ToString(); where += key; pb.StrWhere = where + " and del=0"; mbll.GetList(pb, ref count); //获取总条数 pb.DoCount = 0; List <Tunnel.Model.Tunnel_InfoXJB> modelList = new List <Tunnel.Model.Tunnel_InfoXJB>(); mbll.GetList(pb, ref count);//获取分页结果 modelList = mbll.GetList3(pb, ref count); //数据绑定 Repeater2.DataSource = modelList; Repeater2.DataBind(); //数据分页 MTCPager1.PageSize = pageSize; MTCPager1.RecordCount = count; MTCPager1.PageIndex = cuttentPage; if (count <= pb.PageSize) { MTCPager1.Visible = false; } else { MTCPager1.Visible = true; } }
protected void addSubCat_Click(object sender, EventArgs e) { if (subcatName.Text == "") { errSubCatName.ForeColor = System.Drawing.Color.Red; errSubCatName.Text = "Please enter Category name"; } else { errSubCatName.Text = ""; } if (FileUpload2.HasFile) { lbl_status1.Text = ""; string[] validFileTypes = { "png", "jpg", "jpeg" }; string ext = System.IO.Path.GetExtension(FileUpload2.PostedFile.FileName); bool isValidFile = false; for (int i = 0; i < validFileTypes.Length; i++) { if (ext == "." + validFileTypes[i]) { isValidFile = true; break; } } if (isValidFile && subcatName.Text != "") { lbl_status1.Text = ""; string strname = FileUpload2.FileName.ToString(); FileUpload2.PostedFile.SaveAs(Server.MapPath("~/Images/subCategory/" + strname)); con.Open(); SqlCommand cmd = new SqlCommand("addSubCategory", con);; cmd.Parameters.Add("@name", SqlDbType.VarChar).Value = subcatName.Text; cmd.Parameters.Add("@path", SqlDbType.VarChar).Value = strname; cmd.Parameters.Add("@catId", SqlDbType.Int).Value = ddl_SubCat.SelectedValue; cmd.CommandType = CommandType.StoredProcedure; cmd.ExecuteNonQuery(); con.Close(); lbl_status1.ForeColor = System.Drawing.Color.Green; lbl_status1.Text = "Sub-Category Added Successfully"; Repeater2.DataSource = BindRepeater("SELECT", 0); Repeater2.DataBind(); } else { lbl_status1.ForeColor = System.Drawing.Color.Red; lbl_status1.Text = "Invalid Image type.<br> Please upload an Image with extension " + string.Join(", ", validFileTypes); } } else { lbl_status1.ForeColor = System.Drawing.Color.Red; lbl_status1.Text = "Please Upload an Image !!!"; } }
private void BindShopList() { ShopListBLL shopListBLL = new ShopListBLL(); Repeater1.DataSource = shopListBLL.GetInvests(); Repeater1.DataBind(); HomeBLL bLL = new HomeBLL(); Repeater2.DataSource = bLL.Homeinvestment(); Repeater2.DataBind(); }
private void LoadImages() { clsMySQLCoreApp ObjDAL = new clsMySQLCoreApp(); DataTable dtProductImages = ObjDAL.ExecuteSelectStatement("select * from ztech.tblImages where ProductID=" + ProductID); if (dtProductImages != null && dtProductImages.Rows.Count > 0) { Repeater2.DataSource = dtProductImages; Repeater2.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { Permissions.ComRedirect(Page, Permissions.redirUrl); Response.Cache.SetExpires(DateTime.Now); Permissions.CheckManagePermission(6313); if (!IsPostBack && Request.QueryString["action"] == null) { Repeater1.DataSource = WTreeBLL.GetWLTField("1", "0"); Repeater1.DataBind(); Repeater4.DataSource = WTreeBLL.GetWLTField("1", "1"); Repeater4.DataBind(); Repeater2.DataSource = WTreeBLL.GetWLTField("2", "0"); Repeater2.DataBind(); Repeater5.DataSource = WTreeBLL.GetWLTField("2", "1"); Repeater5.DataBind(); Repeater3.DataSource = WTreeBLL.GetWLTField("3", "0"); Repeater3.DataBind(); Repeater6.DataSource = WTreeBLL.GetWLTField("3", "1"); Repeater6.DataBind(); } if (Request.QueryString["action"] == "save") { string f = Request.QueryString["field"]; string v = Request.QueryString["visible"]; string id = Request.QueryString["id"]; //if (id == "1") //{ // if (f.IndexOf("|") == -1) // { // Response.Write(GetTran("007953", "修改失败,必须要有“|”符号!")); // Response.End(); // return; // } //} int hs = WTreeBLL.UpdWLTField(f, v, id); if (hs == 2) { Response.Write(GetTran("000222", "修改成功!")); } else { Response.Write(GetTran("000225", "修改失败!")); } Response.End(); } }
/// <summary> /// 查询已上传的文件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void LinkButton1_Click(object sender, EventArgs e) { int id = Convert.ToInt32(Request.QueryString["id"]); int personid = Convert.ToInt32(Request.Cookies["login"]["ID"]); DataTable dt = BLL.Homework.BLLGetstudentHomework(id, personid); Repeater2.DataSource = dt; Repeater2.DataBind(); Repeater2.Visible = true; }
public void Repeater1List() { JoinTheManagementBLL joinThe = new JoinTheManagementBLL(); Repeater1.DataSource = joinThe.joininfors(); Repeater1.DataBind(); HomeBLL bLL = new HomeBLL(); Repeater2.DataSource = bLL.HomeTojoinin(); Repeater2.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { UserInfo user = (UserInfo)Session["User"]; string author = user.Name.Trim(); string sql = string.Format("select * from WorksList where Type='绘画作品' and Author='{0}' ", author); Repeater2.DataSource = SQLServices.GetDataSet(sql).Tables[0]; Repeater2.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { FilmContext ctx = new FilmContext(); Repeater1.DataSource = ctx.Filmler.OrderBy(x => x.FilmID).Take(6).ToList(); Repeater1.DataBind(); //Bu komutla aktarım başlıyor. //Repeater2, Repeater1'ın aynı sırada olması gerekiyor. Repeater2.DataSource = ctx.Filmler.OrderBy(x => x.FilmID).Take(6).ToList(); Repeater2.DataBind(); //Bu komutla aktarım başlıyor. }
/// <summary> /// 绑定用户列表 /// </summary> private void BindUserList() { int rInt = 0; QueryParam qp = new QueryParam(); qp.Where = " Where R_RoleID=" + RoleID; ArrayList lst = BusinessFacade.sys_UserRolesList(qp, out rInt); Repeater2.DataSource = lst; Repeater2.DataBind(); }
public void FetchingInvitationRequestDetails() { SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@userid", SqlDbType.Int); param[0].Value = Session["id"]; ds = objdf.FillDsParam("usp_FetchInvitationDetails", param); Repeater2.DataSource = ds; Repeater2.DataBind(); Count_2(); }
protected void Page_Load(object sender, EventArgs e) { string checklogin = new AdminBll().CheckLogin("2"); if (checklogin != "true") { BasePage.Alertback(checklogin); Response.End(); } if (!Page.IsPostBack) { ((Literal)Master.FindControl("breadcrumbs")).Text = "<a href=\"Seoall.aspx\" class=\"home\">SEO批量设置</a><a class=\"add\" href=\"?action=class\">栏目批量设置</a><a href=\"?action=diypage\" class=\"add\">单页批量设置</a>"; DataSet ds = new DataSet(); int PageSize = 20; int PageIndex = BasePage.GetRequestId(Request.QueryString["Page"]); //当前第几页 string ac = Request.QueryString["action"]; if (ac == "class") { string strwhere = "ClassType=0"; ds = new CommonBll().GetListPage("", "GL_Class", strwhere, "ModelId asc,px desc,id desc", PageSize, PageIndex); Repeater1.DataSource = ds; Repeater1.DataBind(); int totalrecord = new CommonBll().GetRecordCount("GL_Class", strwhere);//总记录数 txtpage.Text = GL.Utility.GetPage.GetAspxPager(totalrecord, PageSize, PageIndex); if (totalrecord > PageSize) { txtpage.Text = GL.Utility.GetPage.GetAspxPager(totalrecord, PageSize, PageIndex); } else { txtpage.Text = ""; } } if (Request.QueryString["action"] == "diypage") { string strwhere = "PageType=0"; ds = new CommonBll().GetListPage("", "GL_DIYPage", strwhere, "id desc", PageSize, PageIndex); Repeater2.DataSource = ds; Repeater2.DataBind(); int totalrecord = new CommonBll().GetRecordCount("GL_DIYPage", strwhere);//总记录数 txtpage.Text = GL.Utility.GetPage.GetAspxPager(totalrecord, PageSize, PageIndex); if (totalrecord > PageSize) { txtpage.Text = GL.Utility.GetPage.GetAspxPager(totalrecord, PageSize, PageIndex); } else { txtpage.Text = ""; } } } }
protected void Page_Load(object sender, EventArgs e) { Repeater1.DataSource = db.TBLHAKKIMDA.ToList(); Repeater1.DataBind(); Repeater2.DataSource = db.TBLHAKKIMDA.ToList(); Repeater2.DataBind(); Repeater3.DataSource = db.TBLHAKKIMDA.ToList(); Repeater3.DataBind(); Repeater4.DataSource = db.TBLYETENEKLER.ToList(); Repeater4.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { Repeater1.DataSource = db.TblHakkimda.ToList(); Repeater1.DataBind(); Repeater2.DataSource = db.TblHakkimda.ToList(); Repeater2.DataBind(); Repeater3.DataSource = db.TblHakkimda.ToList(); Repeater3.DataBind(); Repeater4.DataSource = db.TblYetenekler.ToList(); Repeater4.DataBind(); }
public void ApprovedList() { The_capitalBLL the = new The_capitalBLL(); Repeater1.DataSource = the.the_CapitalsList(); Repeater1.DataBind(); HomeBLL bLL = new HomeBLL(); Repeater2.DataSource = bLL.HomeThe_capital(); Repeater2.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Repeater1.DataSource = Bll_Book.DOrderBy_BSaleCount(); Repeater1.DataBind(); Repeater2.DataSource = Bll_Book.DOrderBy_BDate(); Repeater2.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { //显示价格 set_guige(Request.QueryString["chanpinbianhao"].ToString()); // if (!Page.IsPostBack) { Repeater1.DataSource = my_c.GetTable("select * from sl_yanse where chanpinbianhao=" + Request.QueryString["chanpinbianhao"].ToString() + ""); Repeater1.DataBind(); Repeater2.DataSource = my_c.GetTable("select * from sl_chicun where chanpinbianhao=" + Request.QueryString["chanpinbianhao"].ToString() + ""); Repeater2.DataBind(); Repeater3.DataSource = my_c.GetTable("select * from sl_product where id=" + Request.QueryString["chanpinbianhao"].ToString() + ""); Repeater3.DataBind(); try { type = Request.QueryString["type"].ToString(); } catch { } if (type == "yanseedit") { DataTable dt = my_c.GetTable("select * from sl_yanse where id=" + Request.QueryString["id"].ToString() + ""); this.TextBox1.Text = dt.Rows[0]["yanseming"].ToString(); this.TextBox2.Text = dt.Rows[0]["yansezhi"].ToString(); this.TextBox3.Text = dt.Rows[0]["duiyingtupian"].ToString(); for (i = 0; i < RadioButtonList1.Items.Count; i++) { if (RadioButtonList1.Items[i].Value == dt.Rows[0]["yansezhileixing"].ToString()) { RadioButtonList1.Items[i].Selected = true; } } } else if (type == "yansedel") { my_c.genxin("delete from sl_yanse where id=" + Request.QueryString["id"].ToString() + ""); Response.Redirect("products_canshu.aspx?chanpinbianhao=" + Request.QueryString["chanpinbianhao"].ToString() + ""); } else if (type == "chicunedit") { DataTable dt = my_c.GetTable("select * from sl_chicun where id=" + Request.QueryString["id"].ToString() + ""); this.TextBox4.Text = dt.Rows[0]["chicunming"].ToString(); } else if (type == "chicundel") { my_c.genxin("delete from sl_chicun where id=" + Request.QueryString["id"].ToString() + ""); Response.Redirect("products_canshu.aspx?chanpinbianhao=" + Request.QueryString["chanpinbianhao"].ToString() + ""); } } }