/// <summary>
/// 更新一条数据
/// </summary>
public static bool Update(Model.H_Student model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update H_Student set ");
strSql.Append("name=@name,");
strSql.Append("username=@username,");
strSql.Append("email=@email,");
strSql.Append("telphone=@telphone,");
strSql.Append("zhifubao=@zhifubao,");
strSql.Append("bank=@bank,");
strSql.Append("bank_name=@bank_name,");
strSql.Append("bank_num=@bank_num,");
strSql.Append("region_province=@region_province,");
strSql.Append("region_city=@region_city,");
strSql.Append("region_county=@region_county");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@name", SqlDbType.NVarChar, 50),
new SqlParameter("@username", SqlDbType.NVarChar, 50),
new SqlParameter("@email", SqlDbType.NVarChar, 50),
new SqlParameter("@telphone", SqlDbType.NVarChar, 50),
new SqlParameter("@zhifubao", SqlDbType.NVarChar, 50),
new SqlParameter("@bank", SqlDbType.NVarChar, 50),
new SqlParameter("@bank_name", SqlDbType.NVarChar, 50),
new SqlParameter("@bank_num", SqlDbType.NVarChar, 50),
new SqlParameter("@region_province", SqlDbType.NVarChar, 50),
new SqlParameter("@region_city", SqlDbType.NVarChar, 50),
new SqlParameter("@region_county", SqlDbType.NVarChar, 50),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.name;
parameters[1].Value = model.username;
parameters[2].Value = model.email;
parameters[3].Value = model.telphone;
parameters[4].Value = model.zhifubao;
parameters[5].Value = model.bank;
parameters[6].Value = model.bank_name;
parameters[7].Value = model.bank_num;
parameters[8].Value = model.region_province;
parameters[9].Value = model.region_city;
parameters[10].Value = model.region_county;
parameters[11].Value = model.id;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), parameters) > 0);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public static Model.H_Student GetModel(string id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,name,username,email,telphone,zhifubao,bank,bank_name,bank_num,region_province,region_city,region_county from H_Student ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Model.H_Student model = new Model.H_Student();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
model.name = ds.Tables[0].Rows[0]["name"].ToString();
model.username = ds.Tables[0].Rows[0]["username"].ToString();
model.email = ds.Tables[0].Rows[0]["email"].ToString();
model.telphone = ds.Tables[0].Rows[0]["telphone"].ToString();
model.zhifubao = ds.Tables[0].Rows[0]["zhifubao"].ToString();
model.bank = ds.Tables[0].Rows[0]["bank"].ToString();
model.bank_name = ds.Tables[0].Rows[0]["bank_name"].ToString();
model.bank_num = ds.Tables[0].Rows[0]["bank_num"].ToString();
model.region_province = ds.Tables[0].Rows[0]["region_province"].ToString();
model.region_city = ds.Tables[0].Rows[0]["region_city"].ToString();
model.region_county = ds.Tables[0].Rows[0]["region_county"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public static bool Add(Model.H_Student model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into H_Student(");
strSql.Append("name,username,email,telphone,zhifubao,bank,bank_name,bank_num,region_province,region_city,region_county)");
strSql.Append(" values (");
strSql.Append("@name,@username,@email,@telphone,@zhifubao,@bank,@bank_name,@bank_num,@region_province,@region_city,@region_county)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@name", SqlDbType.NVarChar, 50),
new SqlParameter("@username", SqlDbType.NVarChar, 50),
new SqlParameter("@email", SqlDbType.NVarChar, 50),
new SqlParameter("@telphone", SqlDbType.NVarChar, 50),
new SqlParameter("@zhifubao", SqlDbType.NVarChar, 50),
new SqlParameter("@bank", SqlDbType.NVarChar, 50),
new SqlParameter("@bank_name", SqlDbType.NVarChar, 50),
new SqlParameter("@bank_num", SqlDbType.NVarChar, 50),
new SqlParameter("@region_province", SqlDbType.NVarChar, 50),
new SqlParameter("@region_city", SqlDbType.NVarChar, 50),
new SqlParameter("@region_county", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.name;
parameters[1].Value = model.username;
parameters[2].Value = model.email;
parameters[3].Value = model.telphone;
parameters[4].Value = model.zhifubao;
parameters[5].Value = model.bank;
parameters[6].Value = model.bank_name;
parameters[7].Value = model.bank_num;
parameters[8].Value = model.region_province;
parameters[9].Value = model.region_city;
parameters[10].Value = model.region_county;
return(DbHelperSQL.ExecuteSql(strSql.ToString(), parameters) > 0);
}
protected void Button1_Click(object sender, EventArgs e)
{
Model.H_Student student = new Model.H_Student();
student.id = int.Parse(Request.QueryString["pid"]);
student.name = this.TextName.Value.Trim();
student.username = H_StudentClass.GetModel(Request.QueryString["pid"].ToString()).username;
student.email = this.TextEmail.Value.Trim();
student.telphone = this.TextTel.Value.Trim();
student.zhifubao = this.TextZhifubao.Value.Trim();
student.bank = this.TextBank.Value.Trim();
student.bank_name = this.TextBank_name.Value.Trim();
student.bank_num = this.TextBank_number.Value.Trim();
student.region_province = H_StudentClass.GetModel(Request.QueryString["pid"].ToString()).region_province;
student.region_city = H_StudentClass.GetModel(Request.QueryString["pid"].ToString()).region_city;
student.region_county = H_StudentClass.GetModel(Request.QueryString["pid"].ToString()).region_county;
if (H_StudentClass.Update(student))
{
JScript.AlertAndRedirect("操作成功！", "StudentList.aspx", this);
}
else
{
JScript.AlertAndRedirect("操作失败！", "a2", this);
}
}
