Exemplo n.º 1
0
        protected void LinkButton1_Click(object sender, EventArgs e)
        {
            string strqu  = Request.Form["seldq"];
            string strtxt = Request.Form["txthzs"];
            //MessageBox.Show(this, strqu+"<br>"+strtxt);
            DataTable dt = new DataTable();

            string strwhere = " 1=1 and zuobiaox!='' ";

            if (!string.IsNullOrEmpty(strtxt))
            {
                strwhere += " and mingcheng like '%" + strtxt + "%'";
            }
            if (!string.IsNullOrEmpty(strqu))
            {
                if (strqu != "威海市")
                {
                    strwhere += " and quyu='" + strqu + "'";
                }
            }
            if (!string.IsNullOrEmpty(this.sellb.SelectedValue))
            {
                if (this.sellb.SelectedValue == "合作社")
                {
                    NCPEP.Bll.T_hzs bll = new NCPEP.Bll.T_hzs();
                    dt = bll.GetList(strwhere).Tables[0];
                }
                else
                {
                    NCPEP.Bll.T_jtnc bll = new NCPEP.Bll.T_jtnc();
                    dt = bll.GetList(strwhere).Tables[0];
                }
            }

            jieguo = dt.Rows.Count.ToString();
            this.repjg.DataSource = dt;
            this.repjg.DataBind();
            string strzuobiao = "";
            string strneirong = "";

            foreach (DataRow dr in dt.Rows)
            {
                if (!string.IsNullOrEmpty(dr["zuobiaox"].ToString()))
                {
                    strzuobiao += dr["zuobiaox"] + "," + dr["zuobiaoy"] + "|";
                    strneirong += dr["mingcheng"] + "," + dr["dizhi"] + "," + dr["lishizhang"] + "," + dr["lianxidianhua"] + "|";
                }
            }
            hdzuobiao.Value = strzuobiao.TrimEnd('|');
            hdneirong.Value = strneirong.TrimEnd('|');
        }
Exemplo n.º 2
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         if (Request.QueryString["st"] != null)
         {
             string             strid = Request.QueryString["st"];
             NCPEP.Model.T_jtnc model = new NCPEP.Model.T_jtnc();
             NCPEP.Bll.T_jtnc   bll   = new NCPEP.Bll.T_jtnc();
             model           = bll.GetModel(int.Parse(strid));
             this.hdzb.Value = model.dizhi;
             strname         = model.mingcheng;
             txtx.Text       = model.zuobiaox;
             txty.Text       = model.zuobiaoy;
         }
     }
 }
Exemplo n.º 3
0
 protected void Button1_Click(object sender, EventArgs e)
 {
     if (Request.QueryString["st"] != null)
     {
         string             strid = Request.QueryString["st"];
         NCPEP.Model.T_jtnc model = new NCPEP.Model.T_jtnc();
         NCPEP.Bll.T_jtnc   bll   = new NCPEP.Bll.T_jtnc();
         model = bll.GetModel(int.Parse(strid));
         if (!string.IsNullOrEmpty(txtx.Text))
         {
             model.zuobiaox = txtx.Text;
         }
         if (!string.IsNullOrEmpty(txty.Text))
         {
             model.zuobiaoy = txty.Text;
         }
         bll.Update(model);
         MessageBox.ShowAndRedirect(this, "设置成功!", "listnc.aspx?pg=" + Request.QueryString["pg"] + "");
     }
 }
Exemplo n.º 4
0
        /// <summary>
        /// 初始绑定数据
        /// </summary>
        private void BindDate()
        {
            StringBuilder sb = new StringBuilder();

            sb.Append(" 1=1");
            //if (this.ddlxwlx.SelectedValue != "请选择")
            //{
            //    sb.Append(" and NewsTypeId='" + this.ddlxwlx.SelectedValue + "'");
            //}
            //if (!string.IsNullOrEmpty(this.TextBox1.Text))
            //{
            //    sb.Append(" and NewsTitle like '%" + this.TextBox1.Text + "%'");
            //}
            //if (this.DropDownList2.SelectedValue != "全部")
            //{
            //    sb.Append(" and IsCheck='" + this.DropDownList2.SelectedValue + "'");
            //}
            NCPEP.Bll.T_jtnc bll = new NCPEP.Bll.T_jtnc();
            this.pg.RecordCount      = bll.GetRecordCount(sb.ToString());
            this.pg.PageSize         = 10;
            this.pg.UrlPageIndexName = "pg";
            if (!string.IsNullOrEmpty(hdpage.Value) && hdpage.Value == "1")
            {
                if (Request.QueryString["pg"] != null)
                {
                    pg.CurrentPageIndex = int.Parse(Request.QueryString["pg"]);
                }
            }
            int sindex = (this.pg.CurrentPageIndex - 1) * this.pg.PageSize + 1;
            int eindex = this.pg.CurrentPageIndex * this.pg.PageSize;

            DataSet ds = bll.GetListByPage(sb.ToString(), "id asc", sindex, eindex);

            //DataSet ds = bll.GetList(this.AspNetPager1.PageSize, this.AspNetPager1.CurrentPageIndex, sb.ToString());
            this.rep.DataSource = ds;
            this.rep.DataBind();
        }