合同详细信息页面设计

比较复杂，牵扯到2个表

  private void Page_Load(object sender, System.EventArgs e)
  {
   // 在此处放置用户代码以初始化页面
   try
   {
    if(Session["user_power"].ToString()!="3");
   }
   catch
   {
    Response.Redirect("index.aspx");
    Response.End();
   }
   ty=new tongyong();
   conn1=ty.cn();

   if(!Page.IsPostBack)
   {
    if(Request.QueryString["action"]=="" && Request.QueryString["id"]=="")
    {
     Response.Write("请勿直接输入地址访问本页面");
     Response.End();
    }
    TABLE1.Visible=false;
    Table2.Visible=false;
    if(Request.QueryString["action"]=="add")
     TABLE1.Visible=true;
    if(Request.QueryString["id"]!="")
    {
                    Table2.Visible=true;
     hetongid=Request.QueryString["id"].ToString();
     showinfo();
     //填充客户列表

    }
   }
  }

  private void showinfo()
  {
   string name,chanpin,zhuangtai,start,fuzeren,jine,shuliang,send,finish,price,sended;
   int itemid;
   itemid=0;
   string cmdstr="Select * from cms_hetong where id='"+hetongid+"'";
   SqlCommand cmd=new SqlCommand(cmdstr,conn1);
   SqlDataReader rd=cmd.ExecuteReader();
   if(rd.Read())
   {
    Label1.Text=rd["id"].ToString();;
    name=rd["kehuid"].ToString();
    //chanpin=rd["chanpin"].ToString();
    zhuangtai=rd["state"].ToString();
    start=rd["start"].ToString();
    send=rd["send"].ToString();
    finish=rd["finish"].ToString();
    fuzeren=rd["fuzeren"].ToString();
    jine=rd["price"].ToString();
    //shuliang=rd[""];
    rd.Close();
    //填充内容
    kehulist.Items.Clear();
    SqlCommand cmd0=new SqlCommand("Select * from cms_kehu",conn1);
    SqlDataReader dr=cmd0.ExecuteReader();
    string listvalue;
    while(dr.Read())
    {
     listvalue=dr["id"].ToString();
     kehulist.Items.Add(new ListItem(dr["name"].ToString(),listvalue));
     if (listvalue==name.Trim())
     {
       kehulist.SelectedIndex=itemid;
     }
     itemid++;
    }
    dr.Close();
    for(int i=0;i<zhuangtailist.Items.Count;i++)
    {
     if(zhuangtai.Trim()==zhuangtailist.Items[i].Value)
      zhuangtailist.SelectedIndex=i;
    }
    start_tbl.Text=start;
    send_tbl.Text=send;
    end_tbl.Text=finish;
    fuzeren_tbl.Text=fuzeren;
    zongjin_tbl.Text=jine;
    //读合同详细数据表信息
    SqlCommand cmd2=new SqlCommand("Select * from cms_hetongmingxi where id='"+Session["id"]+"'",conn1);
    SqlDataReader dr2=cmd2.ExecuteReader();
    if(dr2.Read())
    {
     chanpin=dr2["chanpinid"].ToString();
     shuliang=dr2["book"].ToString();
     price=dr2["price"].ToString();
     sended=dr2["send"].ToString();
    }else{
     chanpin="";
     shuliang="";
     price="";
     sended="";
     Response.Write("<script>alert('该合同详细信息不存在');</script>");
    }
    dr2.Close();
    SqlCommand cmd1=new SqlCommand("Select * from cms_chanpin",conn1);
    SqlDataReader dr1=cmd1.ExecuteReader();
    itemid=0;
    while(dr1.Read())
    {
     chanpinlist.Items.Add(new ListItem(dr1["name"].ToString(),dr1["id"].ToString()));
     if(chanpin.Trim()==dr1["id"].ToString())
     {
      chanpinlist.SelectedIndex=itemid;
     }
     itemid++;
    }
    dr1.Close();
    book.Text=shuliang;
    yifa.Text=sended;
    price_tbl.Text=price;
   }
   else
   {
    Response.Write("<script>alert('合同号:"+hetongid+"  不存在');window.close();</script>");
   }
   
  }

重点难点

使用DropDownList的默认选择
在使用多个DataReader用以混淆
局部变量 块变量 全局变量 的作用域，以及声明方式