比较复杂,牵扯到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用以混淆
局部变量 块变量 全局变量 的作用域,以及声明方式