Ejemplo n.º 1
0
 protected void ImgSrs_Click3(object sender, EventArgs e)
 {
     getUser1(uID);
     getUser2(uID);
     GridBind(getUser3(uID));
     Pagination1.Refresh();
 }
Ejemplo n.º 2
0
    /// <summary>
    /// 发送给全部用户
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void btnSendAll_Click(object sender, EventArgs e)
    {
        string    sql = string.Format(@"select * from dbo.ML_Member a 
                                           left join
                                           (
                                             select * from ML_NewsClassMain 
                                             where sid0={0}
                                           ) b
                                           on a.nID=b.sid1
                                           where b.sid1 is null", _ID);
        DataTable dt  = her.ExecuteDataTable(sql);

        if (dt.Rows.Count > 0)
        {
            U_ShowDivPic(this.Page, "正在导入中…");
            foreach (DataRow dr in dt.Rows)
            {
                XueYuan_Add(dr["nID"].ToString());
            }

            GridBind();
            Pagination1.Refresh();

            this.Page.Response.Write("<script language=javascript>;HideWait();</script>");
        }
        else
        {
            AjaxAlert.AlertMsgAndNoFlush(this, "无未发送学员");
            //ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('无未发送学员')</script>");
        }
    }
Ejemplo n.º 3
0
    public DataTable News_sel()
    {
        //分頁用
        int           currentPage = Request["page"] == null ? 1 : int.Parse(Request["page"]);
        SqlConnection Conn        = new SqlConnection();

        Conn.ConnectionString = ConfigurationManager.ConnectionStrings["sqlString"].ConnectionString;
        DataTable dt = new DataTable();

        try
        {
            string CmdString = @"";
            CmdString = @"with tstation as (
                              select row_number() over(order by inday desc) as rownumber,
                              * 
                              from News 
                              )select *from tstation where rownumber>=@start  and rownumber <=@end ";

            SqlCommand cmd = new SqlCommand(CmdString, Conn);
            cmd.Parameters.Add("@start", SqlDbType.Int);
            cmd.Parameters["@start"].Value = ((currentPage - 1) * PageSize) + 1;
            cmd.Parameters.Add("@end", SqlDbType.Int);
            cmd.Parameters["@end"].Value = currentPage * PageSize;
            Conn.Open();
            SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            dt.Load(dr);

            //分頁
            SqlCommand totalcommand;
            totalcommand = new SqlCommand(@"select count('x') from News ", Conn);

            SqlDataAdapter totalAdapter = new SqlDataAdapter(totalcommand);
            DataTable      totalTable   = new DataTable();
            totalAdapter.Fill((totalTable));
            int total = Convert.ToInt32(totalTable.Rows[0][0]);
            Pagination1.totalitems = total;
            Pagination1.limit      = PageSize;
            Pagination1.targetpage = "News.aspx";
            //技巧:利用這種方式才可以呼叫usercontrol裡的public method
            Pagination1.showPageControls();

            return(dt);
        }
        catch (Exception ex)
        {
            DB_string.log("News:", ex.ToString());
            return(null);
        }
        finally
        {
            Conn.Close();
        }
    }
Ejemplo n.º 4
0
        private void show(string keyword)
        {
            int currentPage = Request["page"] == null ? 1 : int.Parse(Request["page"]);

            string search = "";

            if (!string.IsNullOrEmpty(keyword))
            {
                search            = " and 地址 like '%'+@keyword+'%' ";//參數sql語法
                Session["search"] = keyword;
            }

            string commandstring = $@"with tstation as (select row_number() over(order by id asc) as rownumber,* from test$ where 1 =1 {search})select *from tstation where rownumber>=@start and rownumber <=@end";

            string        connectstring = WebConfigurationManager.ConnectionStrings["PoliceConnectionString"].ToString();
            SqlConnection connect       = new SqlConnection(connectstring);
            SqlCommand    sqlCommand    = new SqlCommand(commandstring, connect);


            sqlCommand.Parameters.Add("@start", SqlDbType.Int);
            sqlCommand.Parameters["@start"].Value = ((currentPage - 1) * PageSize) + 1;
            sqlCommand.Parameters.Add("@end", SqlDbType.Int);
            sqlCommand.Parameters["@end"].Value = currentPage * PageSize;

            sqlCommand.Parameters.AddWithValue("@keyword", keyword);


            SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
            DataTable      dataTable      = new DataTable();

            sqlDataAdapter.Fill((dataTable));
            GridView1.DataSource = dataTable;
            GridView1.DataBind();

            SqlCommand totalcommand = new SqlCommand($@"select count(*) from [dbo].[test$] where 1=1 {search}", connect);

            totalcommand.Parameters.AddWithValue("@keyword", keyword);
            SqlDataAdapter totalAdapter = new SqlDataAdapter(totalcommand);
            DataTable      totalTable   = new DataTable();

            totalAdapter.Fill((totalTable));
            int total = Convert.ToInt32(totalTable.Rows[0][0]);

            Pagination1.totalitems = total;
            Pagination1.limit      = PageSize;
            Pagination1.targetpage = "WebForm1.aspx";
            //技巧:利用這種方式才可以呼叫usercontrol裡的public method
            Pagination1.showPageControls();
        }
Ejemplo n.º 5
0
 protected void imgdelete_Click(object sender, EventArgs e)
 {
     for (int i = 0; i < gridField.Rows.Count; i++)
     {
         CheckBox ckb = (CheckBox)gridField.Rows[i].FindControl("CheckSel");
         if (ckb.Checked)
         {
             //bool success = Menber.MemberDelete(gridField.DataKeys[i].Value.ToString());
             //if (!success)
             //{
             //    ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('发生未知错误!请重试')</script>");
             //}
         }
     }
     GridBind();
     Pagination1.Refresh();
 }
Ejemplo n.º 6
0
 /// <summary>
 /// 选中发送
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 protected void imgdelete_Click(object sender, EventArgs e)
 {
     for (int i = 0; i < gridField.Rows.Count; i++)
     {
         CheckBox ckb = (CheckBox)gridField.Rows[i].FindControl("CheckSel");
         if (ckb.Checked)
         {
             bool success = XueYuan_Add(gridField.DataKeys[i].Value.ToString());
             //if (!success)
             //{
             //    ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('发生未知错误!请重试')</script>");
             //}
             //else
             //{
             //    ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('添加成功')</script>");
             //}
         }
     }
     GridBind();
     Pagination1.Refresh();
     AjaxAlert.AlertMsgAndNoFlush(this, "发送成功");
     //ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('发送成功')</script>");
 }
Ejemplo n.º 7
0
 protected void ImgSrs_Click(object sender, EventArgs e)
 {
     GridBind();
     Pagination1.Refresh();
 }
Ejemplo n.º 8
0
    public DataTable Detail(string id)
    {
        //分頁用
        int currentPage = Request["page"] == null ? 1 : int.Parse(Request["page"]);

        SqlConnection Conn = new SqlConnection();

        Conn.ConnectionString = ConfigurationManager.ConnectionStrings["sqlString"].ConnectionString;
        DataTable dt = new DataTable();

        try
        {
            string CmdString = @"";
            if (id == "")
            {
                //CmdString = @"select * from DealersD d
                //              join DealersR r on d.R_no = r.R_no
                //              join DealersC c on c.R_no = r.R_no and c.C_no = d.C_no
                //              where d.R_no=(select top 1 R_no from DealersR) ";
                CmdString = @"with tstation as (
                              select row_number() over(order by d.R_no asc) as rownumber,
                              d.R_no,d.C_no,d.D_no,D.Info,D.Img,
							  c.Country,
							  r.Region 
                              from DealersD d 
                              join DealersR r on d.R_no = r.R_no 
                              join DealersC c on c.R_no = r.R_no and c.C_no = d.C_no
                              where d.R_no=(select top 1 R_no from DealersR))select *from tstation where rownumber>=@start and rownumber <=@end";
            }
            else
            {
                //CmdString = @"select * from DealersD d
                //              join DealersR r on d.R_no = r.R_no
                //              join DealersC c on c.R_no = r.R_no and c.C_no = d.C_no
                //              where d.R_no=@id ";
                CmdString = @"with tstation as (
                              select row_number() over(order by d.R_no asc) as rownumber,
                              d.R_no,d.C_no,d.D_no,D.Info,D.Img,
							  c.Country,
							  r.Region 
                              from DealersD d 
                              join DealersR r on d.R_no = r.R_no 
                              join DealersC c on c.R_no = r.R_no and c.C_no = d.C_no
                              where d.R_no=@id)select *from tstation where rownumber>=@start and rownumber <=@end";
            }
            SqlCommand cmd = new SqlCommand(CmdString, Conn);
            cmd.Parameters.AddWithValue("id", id);
            //分頁
            cmd.Parameters.Add("@start", SqlDbType.Int);
            cmd.Parameters["@start"].Value = ((currentPage - 1) * PageSize) + 1;
            cmd.Parameters.Add("@end", SqlDbType.Int);
            cmd.Parameters["@end"].Value = currentPage * PageSize;


            Conn.Open();
            SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            dt.Load(dr);
            title.InnerText     = dt.Rows[0]["Region"].ToString(); //title
            title_nav.InnerText = dt.Rows[0]["Region"].ToString(); //title
            //分頁
            SqlCommand totalcommand;
            if (id == "")
            {
                totalcommand = new SqlCommand(@"select count('x') from DealersD d 
                                                       join DealersR r on d.R_no = r.R_no 
                                                       join DealersC c on c.R_no = r.R_no and c.C_no = d.C_no
                                                       where d.R_no=(select top 1 R_no from DealersR) ", Conn);
            }
            else
            {
                totalcommand = new SqlCommand(@"select count('x') from DealersD d 
                                                       join DealersR r on d.R_no = r.R_no 
                                                       join DealersC c on c.R_no = r.R_no and c.C_no = d.C_no
                                                       where d.R_no=@id ", Conn);
            }
            totalcommand.Parameters.AddWithValue("id", id);
            SqlDataAdapter totalAdapter = new SqlDataAdapter(totalcommand);
            DataTable      totalTable   = new DataTable();
            totalAdapter.Fill((totalTable));
            int total = Convert.ToInt32(totalTable.Rows[0][0]);
            Pagination1.totalitems = total;
            Pagination1.limit      = PageSize;
            Pagination1.targetpage = "Dealers.aspx?id=" + id;
            //技巧:利用這種方式才可以呼叫usercontrol裡的public method
            Pagination1.showPageControls();

            return(dt);
        }
        catch (Exception ex)
        {
            DB_string.log("Dealers_Detail:", ex.ToString());
            return(null);
        }
        finally
        {
            Conn.Close();
        }
    }