/// <summary> /// 调用存储过程修改一个 /// </summary> /// <param name="info">实体对象</param> /// <returns>更新成功返回ture,否则返回false</returns> public static bool Join_MbtiResultsEdit(Entity.Join_MbtiResults info) { SqlParameter[] prams = { SqlDB.MakeInParam("@Id", SqlDbType.Int, 4, info.Id), SqlDB.MakeInParam("@StudentId", SqlDbType.Int, 4, info.StudentId), SqlDB.MakeInParam("@E", SqlDbType.Int, 4, info.E), SqlDB.MakeInParam("@I", SqlDbType.Int, 4, info.I), SqlDB.MakeInParam("@S", SqlDbType.Int, 4, info.S), SqlDB.MakeInParam("@N", SqlDbType.Int, 4, info.N), SqlDB.MakeInParam("@T", SqlDbType.Int, 4, info.T), SqlDB.MakeInParam("@F", SqlDbType.Int, 4, info.F), SqlDB.MakeInParam("@J", SqlDbType.Int, 4, info.J), SqlDB.MakeInParam("@P", SqlDbType.Int, 4, info.P), SqlDB.MakeInParam("@AddTime", SqlDbType.DateTime, 8, info.AddTime), }; int intReturnValue = 0; intReturnValue = SqlDB.ExecuteNonQuery(strCon, CommandType.StoredProcedure, "Join_MbtiResultsEdit", prams); if (intReturnValue == 1) { return(true); } return(false); }
public static Entity.Join_MbtiResults Join_MbtiResultsEntityGetByStudentId(int StudentId) { Entity.Join_MbtiResults info = new Entity.Join_MbtiResults(); DataTable dt = SqlDB.ExecuteDataset(strCon, CommandType.Text, "SELECT top 1 * FROM [Join_MbtiResults] WHERE StudentId = " + StudentId + " 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.E = Basic.Utils.StrToInt(dt.Rows[0]["E"].ToString(), 0); info.I = Basic.Utils.StrToInt(dt.Rows[0]["I"].ToString(), 0); info.S = Basic.Utils.StrToInt(dt.Rows[0]["S"].ToString(), 0); info.N = Basic.Utils.StrToInt(dt.Rows[0]["N"].ToString(), 0); info.T = Basic.Utils.StrToInt(dt.Rows[0]["T"].ToString(), 0); info.F = Basic.Utils.StrToInt(dt.Rows[0]["F"].ToString(), 0); info.J = Basic.Utils.StrToInt(dt.Rows[0]["J"].ToString(), 0); info.P = Basic.Utils.StrToInt(dt.Rows[0]["P"].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 Join_MbtiResultsAdd(Entity.Join_MbtiResults info) { SqlParameter[] prams = { SqlDB.MakeInParam("@StudentId", SqlDbType.Int, 4, info.StudentId), SqlDB.MakeInParam("@E", SqlDbType.Int, 4, info.E), SqlDB.MakeInParam("@I", SqlDbType.Int, 4, info.I), SqlDB.MakeInParam("@S", SqlDbType.Int, 4, info.S), SqlDB.MakeInParam("@N", SqlDbType.Int, 4, info.N), SqlDB.MakeInParam("@T", SqlDbType.Int, 4, info.T), SqlDB.MakeInParam("@F", SqlDbType.Int, 4, info.F), SqlDB.MakeInParam("@J", SqlDbType.Int, 4, info.J), SqlDB.MakeInParam("@P", SqlDbType.Int, 4, info.P), }; return(Basic.Utils.StrToInt(SqlDB.ExecuteScalar(strCon, CommandType.StoredProcedure, "Join_MbtiResultsAdd", prams).ToString(), -1)); }