/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DiDaJiangCheng.Model.tbStudentInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tbStudentInfo set ");
strSql.Append(" StuNo = @StuNo , ");
strSql.Append(" StuName = @StuName , ");
strSql.Append(" StuSex = @StuSex , ");
strSql.Append(" StuNation = @StuNation , ");
strSql.Append(" StuFamilyAddress = @StuFamilyAddress , ");
strSql.Append(" StuContact = @StuContact , ");
strSql.Append(" Stupolitics = @Stupolitics , ");
strSql.Append(" StuPostCode = @StuPostCode , ");
strSql.Append(" ClassId = @ClassId , ");
strSql.Append(" StuPhoto = @StuPhoto ");
strSql.Append(" where StuId=@StuId ");
SqlParameter[] parameters =
{
new SqlParameter("@StuId", SqlDbType.Int, 4),
new SqlParameter("@StuNo", SqlDbType.NVarChar, 50),
new SqlParameter("@StuName", SqlDbType.NVarChar, 50),
new SqlParameter("@StuSex", SqlDbType.NVarChar, 2),
new SqlParameter("@StuNation", SqlDbType.NVarChar, 50),
new SqlParameter("@StuFamilyAddress", SqlDbType.NVarChar, 100),
new SqlParameter("@StuContact", SqlDbType.NVarChar, 50),
new SqlParameter("@Stupolitics", SqlDbType.NVarChar, 50),
new SqlParameter("@StuPostCode", SqlDbType.NVarChar, 50),
new SqlParameter("@ClassId", SqlDbType.Int, 4),
new SqlParameter("@StuPhoto", SqlDbType.Image)
};
parameters[0].Value = model.StuId;
parameters[1].Value = model.StuNo;
parameters[2].Value = model.StuName;
parameters[3].Value = model.StuSex;
parameters[4].Value = model.StuNation;
parameters[5].Value = model.StuFamilyAddress;
parameters[6].Value = model.StuContact;
parameters[7].Value = model.Stupolitics;
parameters[8].Value = model.StuPostCode;
parameters[9].Value = model.ClassId;
parameters[10].Value = model.StuPhoto;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 根据StuNo得到一个对象实体
/// </summary>
public DiDaJiangCheng.Model.tbStudentInfo GetModel(string StuNo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select StuId, StuNo, StuName, StuSex, StuNation, StuFamilyAddress, StuContact, Stupolitics, StuPostCode, ClassId, StuPhoto ");
strSql.Append(" from tbStudentInfo ");
strSql.Append(" where StuNo=@StuNo");
SqlParameter[] parameters =
{
new SqlParameter("@StuNo", SqlDbType.NVarChar)
};
parameters[0].Value = StuNo;
DiDaJiangCheng.Model.tbStudentInfo model = new DiDaJiangCheng.Model.tbStudentInfo();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["StuId"].ToString() != "")
{
model.StuId = int.Parse(ds.Tables[0].Rows[0]["StuId"].ToString());
}
model.StuNo = ds.Tables[0].Rows[0]["StuNo"].ToString();
model.StuName = ds.Tables[0].Rows[0]["StuName"].ToString();
model.StuSex = ds.Tables[0].Rows[0]["StuSex"].ToString();
model.StuNation = ds.Tables[0].Rows[0]["StuNation"].ToString();
model.StuFamilyAddress = ds.Tables[0].Rows[0]["StuFamilyAddress"].ToString();
model.StuContact = ds.Tables[0].Rows[0]["StuContact"].ToString();
model.Stupolitics = ds.Tables[0].Rows[0]["Stupolitics"].ToString();
model.StuPostCode = ds.Tables[0].Rows[0]["StuPostCode"].ToString();
if (ds.Tables[0].Rows[0]["ClassId"].ToString() != "")
{
model.ClassId = int.Parse(ds.Tables[0].Rows[0]["ClassId"].ToString());
}
if (ds.Tables[0].Rows[0]["StuPhoto"].ToString() != "")
{
model.StuPhoto = (byte[])ds.Tables[0].Rows[0]["StuPhoto"];
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DiDaJiangCheng.Model.tbStudentInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tbStudentInfo(");
strSql.Append("StuNo,StuName,StuSex,StuNation,StuFamilyAddress,StuContact,Stupolitics,StuPostCode,ClassId,StuPhoto");
strSql.Append(") values (");
strSql.Append("@StuNo,@StuName,@StuSex,@StuNation,@StuFamilyAddress,@StuContact,@Stupolitics,@StuPostCode,@ClassId,@StuPhoto");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@StuNo", SqlDbType.NVarChar, 50),
new SqlParameter("@StuName", SqlDbType.NVarChar, 50),
new SqlParameter("@StuSex", SqlDbType.NVarChar, 2),
new SqlParameter("@StuNation", SqlDbType.NVarChar, 50),
new SqlParameter("@StuFamilyAddress", SqlDbType.NVarChar, 100),
new SqlParameter("@StuContact", SqlDbType.NVarChar, 50),
new SqlParameter("@Stupolitics", SqlDbType.NVarChar, 50),
new SqlParameter("@StuPostCode", SqlDbType.NVarChar, 50),
new SqlParameter("@ClassId", SqlDbType.Int, 4),
new SqlParameter("@StuPhoto", SqlDbType.Image)
};
parameters[0].Value = model.StuNo;
parameters[1].Value = model.StuName;
parameters[2].Value = model.StuSex;
parameters[3].Value = model.StuNation;
parameters[4].Value = model.StuFamilyAddress;
parameters[5].Value = model.StuContact;
parameters[6].Value = model.Stupolitics;
parameters[7].Value = model.StuPostCode;
parameters[8].Value = model.ClassId;
parameters[9].Value = model.StuPhoto;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
