gridviewusage.aspx.cs

有基本信息管理,名片管理,报表等等,这方便基本需求的朋友可以下载,然后再这上面去更改,有全部的源程序.

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class GridViewUsage : System.Web.UI.Page
{


    
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Session["userID"] == null || Session["userID"].ToString() == "")
            {

                Page.Response.Redirect("default.aspx");
            }
            else
            {
                dataBind();

                lblID.Text = Session["userID"].ToString();
                //detailsAllBind();
            }
        }
    }
  
    //private void databind()
    //{
    //    operation op = new operation();
    //    SqlDataReader dr = op.GetAll();
    //    GVUsage.DataSource = dr;
    //    GVUsage.DataBind();
    //    dr.Close();
        
    //}
    private void dataBind()
    {
        string ID = Session["UserID"].ToString();
        string sql1 = "select * from addresslist where userID='" + ID + "'order by id desc";
       DataBase db = new DataBase();
       DataSet ds = db.DataAll(sql1);
       
       GVUsage.DataSource = ds;
       GVUsage.DataKeyField = "id";
       GVUsage.DataBind();
       ShowStatsPage();
       return;
    }

    protected void BtnAdddata_Click(object sender, EventArgs e)
    {
        string fileName = Uploadpri.PostedFile.FileName;
        string fileName2 = Uploadpri.PostedFile.FileName.Substring(fileName.LastIndexOf("\\") + 1);
        string type1 = fileName2.Substring(fileName2.LastIndexOf(".") + 1);
        string typeToLower = type1.ToLower();
        if (typeToLower == "bmp" || typeToLower == "gif" || typeToLower == "jpg"||typeToLower=="")
        {
            
            operation op1 = new operation();
            DateTime time = new DateTime();
            string uploadName = Uploadpri.Value.Trim();
            string pictureName = "";



            if (uploadName != "")
            {
                int idx = uploadName.LastIndexOf(".");
                string suffix = uploadName.Substring(idx);
                pictureName = System.DateTime.Now.Ticks.ToString() + suffix;

            }


            string msg = op1.Add(lblID.Text, textName.Text, textPhone.Text, textMobile.Text, textAddress.Text, TextQQ.Text, textEmail.Text, pictureName, time.ToString(),txtgeneral.Text);
            if (msg == "")
            {
                lblmsg.Text = "好友资料添加成功!";
                lblmsg.Style["color"] = "red";

            }
            else
            {
                lblmsg.Text = "好友添加失败";
                lblmsg.Style["color"] = "red";
            }
            if (uploadName != "")
            {
                string path = Server.MapPath(".\\Pictures\\");
                Uploadpri.PostedFile.SaveAs(path + pictureName);
            }

            }
            else
               {
               Response.Write("<script language=javascirpt type='text/javascript'>");
               Response.Write("window.alert('请上传正确文件格式!')");
               Response.Write("</script>");

               }
               Response.Redirect("GridViewUsage.aspx");
           }
 
       
           
    
 
    

    protected void GVUsage_SelectedIndexChanged(object sender, EventArgs e)
    {

    }
    protected void GVUsage_PageIndexChanged(object sender, EventArgs e)
    {
       
    }

    protected void GVUsage_PageIndexChanged1(object source, DataGridPageChangedEventArgs e)
    {
        GVUsage.CurrentPageIndex = e.NewPageIndex;
        dataBind();
    }
    protected void btnGo_Click(object sender, EventArgs e)
    {

        try
        {
            if (txtGoPage.Text.Trim() != "")
            {
                int PageI = Int32.Parse(txtGoPage.Text.Trim()) - 1;
                if (PageI >= 0 && PageI < (GVUsage.PageCount))
                    GVUsage.CurrentPageIndex = PageI;


            }

        }
        catch 
        {
           
            Response.Write("<script language=javascirpt type='text/javascript'>");
            Response.Write("window.alert('输入非数字字符，请重新输入！')");
            Response.Write("</script>"); 
        }
       
      
        dataBind();
        }
    
    void ShowStatsPage()
    { 
    lblCurrentIndex.Text="当前为第"+((int)GVUsage.CurrentPageIndex+1)+"页";
    lblPageCount.Text="共"+GVUsage.PageCount+"页";
    
    
    }

    protected void PagerButtonClick(object sender, EventArgs e)
    {
        string arg = ((LinkButton)sender).CommandArgument.ToString();
       
        switch (arg)
        { 
            case "next":
                if (GVUsage.CurrentPageIndex < (GVUsage.PageCount - 1))
                {

                    GVUsage.CurrentPageIndex += 1;
                }
                break;
            case"prev":
                if(GVUsage.CurrentPageIndex>0)
                {
                GVUsage.CurrentPageIndex-=1;
                }
                break;
            case "last":
                GVUsage.CurrentPageIndex=(GVUsage.PageCount-1);
                break;
            case "fist":
                GVUsage.CurrentPageIndex = 0;
                break;
            default:
                GVUsage.CurrentPageIndex=System.Convert.ToInt32(arg);
                break;
        
        
        }
        dataBind();
        ShowStatsPage();
    }
    //protected void GVUsage_SelectedIndexChanged1(object sender, EventArgs e)
    //{
    //    ViewState["id"] = GVUsage.DataKeys[GVUsage.SelectedIndex].ToString();

    //    detailsBind();

       
   
    //}
    //private void detailsBind()
    //{
    //    SqlConnection conn1 = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
    //    string detailsID = ViewState["id"].ToString();
    //    string sql2 = "select id,userId,frdName,frdPhone,frdMobilePhone,frdAddress,frdQQ,frdEmail,frdImageUrl from addresslist where id='" + detailsID + "'";
    //    conn1.Open();
    //    SqlCommand cmd = new SqlCommand(sql2, conn1);
    //    SqlDataReader myReader = cmd.ExecuteReader();
    //    DetailsView1.DataSource = myReader;

    //    DetailsView1.DataBind();
    //    myReader.Close();




    //}
    //private void detailsAllBind()
    //{
    //    SqlConnection conn2 = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
    //    string sql3 = "select * from addresslist order by id desc";
    //    conn2.Open();
    //    SqlDataAdapter da = new SqlDataAdapter(sql3, conn2);
    //    DataSet ds=new DataSet();
    //    da.Fill(ds, "detailsTable");
    //    DetailsView1.DataSource = ds;
    //    DetailsView1.DataBind();
    //    conn2.Close();
    
    
    //}
    protected void Button1_Click(object sender, EventArgs e)
    {
        textAddress.Text = "";
        textEmail.Text = "";
        textMobile.Text = "";
        textName.Text = "";
        textPhone.Text = "";
        TextQQ.Text = "";
        this.textName.Focus();
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        Page.Response.Redirect("GridViewUsage.aspx");
    }
    protected void textName_TextChanged(object sender, EventArgs e)
    {
     
    }
    
}