protected void btnOk_Click(object sender, EventArgs e)
{
if (sfz.Text.Trim() == "" || jiguan.Text.Trim() == "" || name.Text.Trim() == "")
{
SDM.DAL.ShowInfo.Alert("身份证号||籍贯||姓名信息必填！！", this.Page);
return;
}
else if (bll.Exists(sfz.Text.Trim()))//防止用户没有检验学号直接添加
{
SDM.DAL.ShowInfo.Alert("对不起，此身份证号已被添加，请更换！！", this.Page);
sfz.Focus();
}
else
{
//执行添加学生信息
model = CreateModel();
int count = bll.Add(model);
SDM.DAL.ShowInfo.Alert("操作成功！", this.Page);
sfz.Text = "";
name.Text = "";
jiguan.Text = "";
zi.Text = "";
TextBox4.Text = "";
TextBox1.Text = "";
TextBox2.Text = "";
TextBox3.Text = "";
}
}
protected void btnEdit_Click(object sender, EventArgs e)
{
model = CreateModel();
model.Bianhao = int.Parse(Request.QueryString["id"]);
bll.Update(model);
SDM.DAL.ShowInfo.AlertAndRedirect("操作成功！", "GerenInfo.aspx", this.Page);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(SDM.Model.GerenInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update GerenInfo set ");
strSql.Append("姓名=@姓名,");
strSql.Append("字=@字,");
strSql.Append("身份证=@身份证,");
strSql.Append("性别=@性别,");
strSql.Append("生日=@生日,");
strSql.Append("籍贯=@籍贯,");
strSql.Append("父家庭编号=@父家庭编号,");
strSql.Append("母家庭编号=@母家庭编号,");
strSql.Append("子家庭编号=@子家庭编号");
strSql.Append(" where 编号=@编号");
SqlParameter[] parameters =
{
new SqlParameter("@姓名", SqlDbType.NVarChar, 50),
new SqlParameter("@字", SqlDbType.NVarChar, 20),
new SqlParameter("@身份证", SqlDbType.NVarChar, 50),
new SqlParameter("@性别", SqlDbType.NVarChar, 20),
new SqlParameter("@生日", SqlDbType.NVarChar, 50),
new SqlParameter("@籍贯", SqlDbType.NVarChar, 50),
new SqlParameter("@父家庭编号", SqlDbType.NVarChar, 50),
new SqlParameter("@母家庭编号", SqlDbType.NVarChar, 50),
new SqlParameter("@子家庭编号", SqlDbType.NVarChar, 50),
new SqlParameter("@编号", SqlDbType.Int, 4),
};
parameters[0].Value = model.Name;
parameters[1].Value = model.Zi;
parameters[2].Value = model.Sfz;
parameters[3].Value = model.Sex;
parameters[4].Value = model.shengri;
parameters[5].Value = model.Jiguan;
parameters[6].Value = model.Ffbianhao;
parameters[7].Value = model.Mfbianhao;
parameters[8].Value = model.Zfbianhao;
parameters[9].Value = model.Bianhao;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public void EditLoadData()
{
int id = int.Parse(Request.QueryString["id"]);
model = bll.GetModel(id);
TextBox1.Text = model.Ffbianhao.ToString();
TextBox2.Text = model.Mfbianhao.ToString();
TextBox3.Text = model.Ffbianhao.ToString();
TextBox4.Text = model.shengri.ToString();
zi.Text = model.Zi.ToString();
name.Text = model.Name.ToString();
jiguan.Text = model.Jiguan.ToString();
sfz.Text = model.Sfz.ToString();
DDLSex.Text = model.Sex.ToString();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SDM.Model.GerenInfo DataRowToModel(DataRow row)
{
SDM.Model.GerenInfo model = new SDM.Model.GerenInfo();
if (row != null)
{
if (row["编号"] != null && row["编号"].ToString() != "")
{
model.Bianhao = int.Parse(row["编号"].ToString());
}
if (row["父家庭编号"] != null)
{
model.Ffbianhao = row["父家庭编号"].ToString();
}
if (row["籍贯"] != null)
{
model.Jiguan = row["籍贯"].ToString();
}
if (row["母家庭编号"] != null)
{
model.Mfbianhao = row["母家庭编号"].ToString();
}
if (row["姓名"] != null)
{
model.Name = row["姓名"].ToString();
}
if (row["性别"] != null)
{
model.Sex = row["性别"].ToString();
}
if (row["身份证"] != null)
{
model.Sfz = row["身份证"].ToString();
}
if (row["生日"] != null)
{
model.shengri = row["生日"].ToString();
}
if (row["子家庭信息"] != null)
{
model.Zfbianhao = row["子家庭信息"].ToString();
}
if (row["字"] != null)
{
model.Zi = row["字"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(SDM.Model.GerenInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into GerenInfo(");
strSql.Append("姓名,字,身份证,性别,生日,籍贯,父家庭编号,母家庭编号,子家庭编号)");
strSql.Append(" values (");
strSql.Append("@姓名,@字,@身份证,@性别,@生日,@籍贯,@父家庭编号,@母家庭编号,@子家庭编号)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@姓名", SqlDbType.NVarChar, 50),
new SqlParameter("@字", SqlDbType.NVarChar, 20),
new SqlParameter("@身份证", SqlDbType.NVarChar, 50),
new SqlParameter("@性别", SqlDbType.NVarChar, 20),
new SqlParameter("@生日", SqlDbType.NVarChar, 50),
new SqlParameter("@籍贯", SqlDbType.NVarChar, 50),
new SqlParameter("@父家庭编号", SqlDbType.NVarChar, 50),
new SqlParameter("@母家庭编号", SqlDbType.NVarChar, 50),
new SqlParameter("@子家庭编号", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.Zi;
parameters[2].Value = model.Sfz;
parameters[3].Value = model.Sex;
parameters[4].Value = model.shengri;
parameters[5].Value = model.Jiguan;
parameters[6].Value = model.Ffbianhao;
parameters[7].Value = model.Mfbianhao;
parameters[8].Value = model.Zfbianhao;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SDM.Model.GerenInfo GetModel(int Bianhao)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 编号,姓名,字,身份证,性别,生日,籍贯,父家庭编号,母家庭编号,子家庭编号 from GerenInfo ");
strSql.Append(" where 编号=@编号");
SqlParameter[] parameters =
{
new SqlParameter("@编号", SqlDbType.Int, 4)
};
parameters[0].Value = Bianhao;
SDM.Model.GerenInfo model = new SDM.Model.GerenInfo();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
