经典的ajax的连动

页面代码

productadd.aspx

function seltype(obj)
{ //alert(obj);
var type = productadd.TypeBind(obj).value;
document.getElementById("ddltype").outerHTML=type;
// document.getElementById("ddltype").innerHTML=type;
//alert(type);
}
function foc() {
document.Form1.TbName.focus();
var mark = "<!--ar-->";
if(mark.length>0)
{ }
else
{ var lan = document.getElementById("ddlLang").value; seltype(lan); } }
function change()
{ var pic = document.getElementById("FilePic").value;
document.getElementById("picimg").src=pic;
}
function checkNum()
{ var price = document.getElementById("TbPrice").value;
var order = document.getElementById("TbOrder").value;
for(var i=0;i='0'&&price.charAt(i)<='9'||price.charAt(i)==".") { } else { alert("价格不合法!!"); document.getElementById("TbPrice").focus(); return false; } }
for(var i=0;i='0'&&order.charAt(i)<='9') { } else { alert("排序不是纯数字!!!");
document.getElementById("TbOrder").focus(); return false; } } }

puoductadd.aspx.cs 代码

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using aoguan.classes.Db;
using System.IO;
namespace aoguan.admin.product
{
/// <summary>
/// productadd 的摘要说明。
/// </summary>
public class productadd : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DropDownList ddlLang;
protected System.Web.UI.WebControls.DropDownList ddltype;
protected System.Web.UI.WebControls.TextBox TbName;
protected System.Web.UI.WebControls.TextBox TbPrice;
protected System.Web.UI.WebControls.TextBox TbOrder;
protected System.Web.UI.WebControls.TextBox TbContent;
protected System.Web.UI.HtmlControls.HtmlInputFile FilePic;
protected System.Web.UI.WebControls.Button BtAdd;
protected string id ="";
protected string picimg="";
protected System.Web.UI.WebControls.Label LabTitle;
protected string mark="";
private void Page_Load(object sender, System.EventArgs e)
{

#region //下拉
Ajax.Utility.RegisterTypeForAjax(typeof(aoguan.admin.product.productadd));
this.ddlLang.Attributes.Add("onchange","seltype(this.value)");
#endregion
//处理
this.BtAdd.Attributes.Add("onclick","return checkNum()");
// 在此处放置用户代码以初始化页面
if(!Page.IsPostBack)
{
#region 判断是否是修改
try
{
id = Convert.ToString(Request["id"]).Trim();
ViewState["proid"] = id;
}
catch
{
ViewState["proid"] ="";
}
#endregion
DdlBind();
}
}

public void DdlBind()
{
string sql = string.Format("select * from language order by orderid");
DbAccess db = new DbAccess();
DataTable dt = db.GetTable(sql);
this.ddlLang.DataSource=dt;
this.ddlLang.DataTextField="lname";
this.ddlLang.DataValueField="lid";
this.ddlLang.DataBind();
string proid = Convert.ToString(ViewState["proid"]).Trim();
if(proid.Length>0)
{
#region 获取数据
string sqlp = string.Format("select * from product where pro_id='{0}'",proid);
DataTable dtp = db.GetTable(sqlp);
this.ddlLang.SelectedValue=Convert.ToString(dt.Rows[0]["lid"]).Trim();
string typeid = Convert.ToString(dtp.Rows[0]["protype_id"]).Trim();
string typesql = string.Format("select * from protype where protype_id='{0}'",typeid);
DataTable dttp = db.GetTable(typesql);
this.ddltype.DataSource=dttp;
this.ddltype.DataTextField="protype_name";
this.ddltype.DataValueField="protype_id";
this.ddltype.DataBind();
this.TbName.Text=Convert.ToString(dtp.Rows[0]["pro_name"]).Trim();
this.TbPrice.Text=Convert.ToString(dtp.Rows[0]["pro_price"]).Trim();
this.TbOrder.Text=Convert.ToString(dtp.Rows[0]["orderid"]).Trim();
this.TbContent.Text=Convert.ToString(dtp.Rows[0]["pro_intro"]).Trim();
this.picimg=Convert.ToString(dtp.Rows[0]["pro_pic"]).Trim();
this.mark="you";
this.LabTitle.Text="修改产品";
this.BtAdd.Text="修改";
#endregion
}
else
{

}

}
[Ajax.AjaxMethod()]
public string TypeBind(string id)
{
string sql = string.Format("select * from protype where lid={0}",id);
DbAccess db = new DbAccess();
DataTable dt = db.GetTable(sql);
string type="<select id='ddltype' name='ddltype' Width=\"152px\">";
//string type="";
for(int i=0;i<dt.Rows.Count;i++)
{
type+="<option value='"+Convert.ToString(dt.Rows[i]["protype_id"]).Trim()+"'>"+Convert.ToString(dt.Rows[i]["protype_name"]).Trim()+"</option>";
}
type+="</select>";

return type;
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}

/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.BtAdd.Click += new System.EventHandler(this.BtAdd_Click);
this.Load += new System.EventHandler(this.Page_Load);

}
#endregion

private void BtAdd_Click(object sender, System.EventArgs e)
{
#region 上传图片
string pic = Convert.ToString(this.FilePic.PostedFile.FileName);
if(pic.Length>0)
{
string datenow = DateTime.Now.ToString("yyyyMMddHHmmss")+DateTime.Now.Millisecond.ToString();
string ext = pic.Substring(pic.LastIndexOf("."));
string dir = this.Server.MapPath("../../upload/propic");
if(Directory.Exists(dir))
{

}
else
{
Directory.CreateDirectory(dir);
}
pic = datenow+ext;
this.FilePic.PostedFile.SaveAs(dir+"\\"+pic);
}

#endregion
string lang = Convert.ToString(this.ddlLang.SelectedValue.Trim());
string type = Convert.ToString(Request.Form["ddltype"]).Trim();
string proname = Convert.ToString(this.TbName.Text.Trim()).Trim();
string proprice = Convert.ToString(this.TbPrice.Text.Trim());
string order = Convert.ToString(this.TbOrder.Text.Trim());

string intro = Convert.ToString(this.TbContent.Text.Trim());
#region 判断数据
if(lang.Length<1)
{
Response.Write("<script>alert('请选择语言！！')</script>");
return;
}
if(type.Length<1)
{
Response.Write("<script>alert('请选择类型！！')</script>");
return;
}
if(proname.Length<1)
{
Response.Write("<script>alert('产品名非空！！')</script>");
return;
}
if(proprice.Length<1)
{
Response.Write("<script>alert('价格非空！！')</script>");
return;
}
else
{
char[] aa = proprice.ToCharArray();
for(int i=0;i<aa.Length;i++)
{
if(aa[i]>='0'&&aa[i]<='9'||aa[i]=='.')
{

}
else
{
Response.Write("<script>alert('价格不是纯数字!!')</script>");
return;
}
}
}
if(order.Length<1)
{
Response.Write("<script>alert('序号非空！！')</script>");
return;
}
else
{
char[] aa = order.ToCharArray();
for(int i=0;i<aa.Length;i++)
{
if(aa[i]>='0'&&aa[i]<='9')
{

}
else
{
Response.Write("<script>alert('序号不是纯数字!!')</script>");
return;
}
}
}
if(intro.Length<1)
{
Response.Write("<script>alert('产品介绍非空！！')</script>");
return;
}
#endregion
string proid = Convert.ToString(ViewState["proid"]).Trim();
DbAccess db = new DbAccess();
if(proid.Length>0)
{
string sql="";
if(pic.Length>0)
{
sql = string.Format("update product set lid={0},protype_id='{1}',pro_name='{2}',pro_price={3},pro_intro='{4}',pro_pic='{4}',orderid={5} where pro_id='{6}'",lang,type,proname,proprice,intro,pic,order,proid);
}
else
{
sql = string.Format("update product set lid={0},protype_id='{1}',pro_name='{2}',pro_price={3},pro_intro='{4}',orderid={5} where pro_id='{6}'",lang,type,proname,proprice,intro,order,proid);

}

int count = db.GetState(sql);
string str ="";
if(count>0)
{
str ="成功修改!!";
Response.Write("<script>alert('"+str+"');document.location='productlist.aspx'</script>");
}
else
{
str ="含有非法字符!!";
Response.Write("<script>alert('"+str+"');history.go(-1)</script>");
}

}
else
{
string sql = string.Format("insert into product(lid,protype_id,pro_name,pro_price,orderid,pro_pic,pro_intro) values({0},'{1}','{2}',{3},{4},'{5}','{6}')",lang,type,proname,proprice,order,pic,intro);

int count =db.GetState(sql);
if(count>0)
{
Response.Write("<script>function ss(){if(confirm('添加成功！！是否继续!!')){document.location='productadd.aspx'}else{document.location='productlist.aspx'}}ss();</script>");
}
else
{

}
}

//Response.Write("<script>alert('"+type+"')</script>");
}
}
}