/// <summary>
/// 调用存储过程修改一个
/// </summary>
/// <param name="info">实体对象</param>
/// <returns>更新成功返回ture，否则返回false</returns>
public static bool StudentGaoKaoHistory_ZheJiangEdit(Entity.StudentGaoKaoHistory_ZheJiang info)
{
SqlParameter[] prams =
{
SqlDB.MakeInParam("@Id", SqlDbType.Int, 4, info.Id),
SqlDB.MakeInParam("@StudentId", SqlDbType.Int, 4, info.StudentId),
SqlDB.MakeInParam("@YuWen", SqlDbType.Int, 4, info.YuWen),
SqlDB.MakeInParam("@ShuXue", SqlDbType.Int, 4, info.ShuXue),
SqlDB.MakeInParam("@YingYu", SqlDbType.Int, 4, info.YingYu),
SqlDB.MakeInParam("@ZongHe", SqlDbType.Int, 4, info.ZongHe),
SqlDB.MakeInParam("@ZiXuan", SqlDbType.Int, 4, info.ZiXuan),
SqlDB.MakeInParam("@JiShu", SqlDbType.Int, 4, info.JiShu),
SqlDB.MakeInParam("@ZongFen1", SqlDbType.Int, 4, info.ZongFen1),
SqlDB.MakeInParam("@ZongFen2", SqlDbType.Int, 4, info.ZongFen2),
SqlDB.MakeInParam("@ZongFen3", SqlDbType.Int, 4, info.ZongFen3),
SqlDB.MakeInParam("@IsGaoKao", SqlDbType.Int, 4, info.IsGaoKao),
SqlDB.MakeInParam("@IsLatest", SqlDbType.Int, 4, info.IsLatest),
SqlDB.MakeInParam("@AddTime", SqlDbType.DateTime, 8, info.AddTime),
};
int intReturnValue = 0;
intReturnValue = SqlDB.ExecuteNonQuery(CommandType.StoredProcedure, "StudentGaoKaoHistory_ZheJiangEdit", prams);
if (intReturnValue == 1)
{
return(true);
}
return(false);
}
/// <summary>
/// 获取某一个实体
/// </summary>
/// <param name="Id">标识</param>
/// <returns>返回Entity</returns>
public static Entity.StudentGaoKaoHistory_ZheJiang StudentGaoKaoHistory_ZheJiangEntityGetByStudentId(int StudentId)
{
Entity.StudentGaoKaoHistory_ZheJiang info = new Entity.StudentGaoKaoHistory_ZheJiang();
DataTable dt = SqlDB.ExecuteDataset(CommandType.Text, "SELECT top 1 * FROM [StudentGaoKaoHistory_ZheJiang] WHERE StudentId = " + StudentId + " and IsLatest = 1 order by Id desc").Tables[0];
if (dt.Rows.Count > 0)
{
info.Id = Basic.Utils.StrToInt(dt.Rows[0]["Id"].ToString(), 0);
info.StudentId = Basic.Utils.StrToInt(dt.Rows[0]["StudentId"].ToString(), 0);
info.YuWen = Basic.Utils.StrToInt(dt.Rows[0]["YuWen"].ToString(), 0);
info.ShuXue = Basic.Utils.StrToInt(dt.Rows[0]["ShuXue"].ToString(), 0);
info.YingYu = Basic.Utils.StrToInt(dt.Rows[0]["YingYu"].ToString(), 0);
info.ZongHe = Basic.Utils.StrToInt(dt.Rows[0]["ZongHe"].ToString(), 0);
info.ZiXuan = Basic.Utils.StrToInt(dt.Rows[0]["ZiXuan"].ToString(), 0);
info.JiShu = Basic.Utils.StrToInt(dt.Rows[0]["JiShu"].ToString(), 0);
info.ZongFen1 = Basic.Utils.StrToInt(dt.Rows[0]["ZongFen1"].ToString(), 0);
info.ZongFen2 = Basic.Utils.StrToInt(dt.Rows[0]["ZongFen2"].ToString(), 0);
info.ZongFen3 = Basic.Utils.StrToInt(dt.Rows[0]["ZongFen3"].ToString(), 0);
info.IsGaoKao = Basic.Utils.StrToInt(dt.Rows[0]["IsGaoKao"].ToString(), 0);
info.IsLatest = Basic.Utils.StrToInt(dt.Rows[0]["IsLatest"].ToString(), 0);
info.AddTime = Basic.Utils.StrToDateTime(dt.Rows[0]["AddTime"].ToString());
return(info);
}
else
{
return(null);
}
}
/// <summary>
/// 调用存储过程增加一个
/// </summary>
/// <param name="info">实体对象</param>
/// <returns>正常返回大于 0 的自增id, 0代表重复，否则返回-1</returns>
public static int StudentGaoKaoHistory_ZheJiangAdd(Entity.StudentGaoKaoHistory_ZheJiang info)
{
SqlParameter[] prams =
{
SqlDB.MakeInParam("@StudentId", SqlDbType.Int, 4, info.StudentId),
SqlDB.MakeInParam("@YuWen", SqlDbType.Int, 4, info.YuWen),
SqlDB.MakeInParam("@ShuXue", SqlDbType.Int, 4, info.ShuXue),
SqlDB.MakeInParam("@YingYu", SqlDbType.Int, 4, info.YingYu),
SqlDB.MakeInParam("@ZongHe", SqlDbType.Int, 4, info.ZongHe),
SqlDB.MakeInParam("@ZiXuan", SqlDbType.Int, 4, info.ZiXuan),
SqlDB.MakeInParam("@JiShu", SqlDbType.Int, 4, info.JiShu),
SqlDB.MakeInParam("@ZongFen1", SqlDbType.Int, 4, info.ZongFen1),
SqlDB.MakeInParam("@ZongFen2", SqlDbType.Int, 4, info.ZongFen2),
SqlDB.MakeInParam("@ZongFen3", SqlDbType.Int, 4, info.ZongFen3),
SqlDB.MakeInParam("@IsGaoKao", SqlDbType.Int, 4, info.IsGaoKao),
SqlDB.MakeInParam("@IsLatest", SqlDbType.Int, 4, info.IsLatest),
SqlDB.MakeInParam("@AddTime", SqlDbType.DateTime, 8, info.AddTime),
};
return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(CommandType.StoredProcedure, "StudentGaoKaoHistory_ZheJiangAdd", prams).ToString(), -1));
}