/*更新专业信息实现*/
public static bool EditSpecialFieldInfo(ENTITY.SpecialFieldInfo specialFieldInfo)
{
string sql = "update SpecialFieldInfo set specialFieldName=@specialFieldName,specialCollegeNumber=@specialCollegeNumber,specialBirthDate=@specialBirthDate,specialMan=@specialMan,specialTelephone=@specialTelephone,specialMemo=@specialMemo where specialFieldNumber=@specialFieldNumber";
/*构建sql参数信息*/
SqlParameter[] parm = new SqlParameter[] {
new SqlParameter("@specialFieldName", SqlDbType.VarChar),
new SqlParameter("@specialCollegeNumber", SqlDbType.VarChar),
new SqlParameter("@specialBirthDate", SqlDbType.DateTime),
new SqlParameter("@specialMan", SqlDbType.VarChar),
new SqlParameter("@specialTelephone", SqlDbType.VarChar),
new SqlParameter("@specialMemo", SqlDbType.VarChar),
new SqlParameter("@specialFieldNumber", SqlDbType.VarChar)
};
/*为参数赋值*/
parm[0].Value = specialFieldInfo.specialFieldName;
parm[1].Value = specialFieldInfo.specialCollegeNumber;
parm[2].Value = specialFieldInfo.specialBirthDate;
parm[3].Value = specialFieldInfo.specialMan;
parm[4].Value = specialFieldInfo.specialTelephone;
parm[5].Value = specialFieldInfo.specialMemo;
parm[6].Value = specialFieldInfo.specialFieldNumber;
/*执行更新*/
return((DBHelp.ExecuteNonQuery(sql, parm) > 0) ? true : false);
}
/*添加专业信息实现*/
public static bool AddSpecialFieldInfo(ENTITY.SpecialFieldInfo specialFieldInfo)
{
string sql = "insert into SpecialFieldInfo(specialFieldNumber,specialFieldName,specialCollegeNumber,specialBirthDate,specialMan,specialTelephone,specialMemo) values(@specialFieldNumber,@specialFieldName,@specialCollegeNumber,@specialBirthDate,@specialMan,@specialTelephone,@specialMemo)";
/*构建sql参数*/
SqlParameter[] parm = new SqlParameter[] {
new SqlParameter("@specialFieldNumber", SqlDbType.VarChar),
new SqlParameter("@specialFieldName", SqlDbType.VarChar),
new SqlParameter("@specialCollegeNumber", SqlDbType.VarChar),
new SqlParameter("@specialBirthDate", SqlDbType.DateTime),
new SqlParameter("@specialMan", SqlDbType.VarChar),
new SqlParameter("@specialTelephone", SqlDbType.VarChar),
new SqlParameter("@specialMemo", SqlDbType.VarChar)
};
/*给参数赋值*/
parm[0].Value = specialFieldInfo.specialFieldNumber; //专业编号
parm[1].Value = specialFieldInfo.specialFieldName; //专业名称
parm[2].Value = specialFieldInfo.specialCollegeNumber; //所在学院
parm[3].Value = specialFieldInfo.specialBirthDate; //成立日期
parm[4].Value = specialFieldInfo.specialMan; //联系人
parm[5].Value = specialFieldInfo.specialTelephone; //联系电话
parm[6].Value = specialFieldInfo.specialMemo; //附加信息
/*执行sql进行添加*/
return((DBHelp.ExecuteNonQuery(sql, parm) > 0) ? true : false);
}
/*根据specialFieldNumber获取某条专业信息记录*/
public static ENTITY.SpecialFieldInfo getSomeSpecialFieldInfo(string specialFieldNumber)
{
/*构建查询sql*/
string sql = "select * from SpecialFieldInfo where specialFieldNumber='" + specialFieldNumber + "'";
SqlDataReader DataRead = DBHelp.ExecuteReader(sql, null);
ENTITY.SpecialFieldInfo specialFieldInfo = new ENTITY.SpecialFieldInfo();
/*如果查询存在记录，就包装到对象中返回*/
if (DataRead.Read())
{
specialFieldInfo.specialFieldNumber = DataRead["specialFieldNumber"].ToString();
specialFieldInfo.specialFieldName = DataRead["specialFieldName"].ToString();
specialFieldInfo.specialCollegeNumber = DataRead["specialCollegeNumber"].ToString();
specialFieldInfo.specialBirthDate = Convert.ToDateTime(DataRead["specialBirthDate"].ToString());
specialFieldInfo.specialMan = DataRead["specialMan"].ToString();
specialFieldInfo.specialTelephone = DataRead["specialTelephone"].ToString();
specialFieldInfo.specialMemo = DataRead["specialMemo"].ToString();
}
return(specialFieldInfo);
}
