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();
        }
예제 #2
0
    protected void reset(object sender, EventArgs e)
    {
        Session["SERVICES"] = null;
        Selected_lbx.Items.Clear();
        total_lbl.Text = "0";

        Repeater1.DataBind();
        Repeater2.DataBind();
    }
예제 #3
0
        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();
     }
 }
예제 #5
0
파일: App.aspx.cs 프로젝트: daonidedie/-
    ///<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();
    }
예제 #6
0
    private void BindSinger()
    {
        DataTable dt = SingerManager.selectTop5();

        if (dt != null && dt.Rows.Count != 0)
        {
            Repeater2.DataSource = dt;
            Repeater2.DataBind();
        }
    }
예제 #7
0
        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();
        }
예제 #8
0
    protected void Page_Load(object sender, EventArgs e)
    {
        CustomerLogic CL = new CustomerLogic();

        Repeater1.DataSource = CL.SelectForReport1();
        Repeater1.DataBind();

        Repeater2.DataSource = CL.SelectForReport1();
        Repeater2.DataBind();
    }
예제 #9
0
 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();
 }
예제 #10
0
 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();
     }
 }
예제 #11
0
        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();
        }
예제 #12
0
        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();
        }
예제 #13
0
        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();
        }
예제 #14
0
    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;
        }
    }
예제 #15
0
 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 !!!";
     }
 }
예제 #16
0
        private void BindShopList()
        {
            ShopListBLL shopListBLL = new ShopListBLL();

            Repeater1.DataSource = shopListBLL.GetInvests();
            Repeater1.DataBind();
            HomeBLL bLL = new HomeBLL();

            Repeater2.DataSource = bLL.Homeinvestment();
            Repeater2.DataBind();
        }
예제 #17
0
    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();
        }
    }
예제 #18
0
    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();
        }
    }
예제 #19
0
        /// <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;
        }
예제 #20
0
        public void Repeater1List()
        {
            JoinTheManagementBLL joinThe = new JoinTheManagementBLL();

            Repeater1.DataSource = joinThe.joininfors();
            Repeater1.DataBind();
            HomeBLL bLL = new HomeBLL();

            Repeater2.DataSource = bLL.HomeTojoinin();
            Repeater2.DataBind();
        }
예제 #21
0
 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();
     }
 }
예제 #22
0
        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.
        }
예제 #23
0
        /// <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();
        }
예제 #24
0
    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();
    }
예제 #25
0
    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 = "";
                }
            }
        }
    }
예제 #26
0
 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();
 }
예제 #27
0
 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();
 }
예제 #28
0
        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();
        }
예제 #29
0
        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();
            }
        }
예제 #30
0
    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() + "");
            }
        }
    }