/// <summary>
/// 新增
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
private static bool InsertUser(User user)
{
var sql = @"INSERT INTO User
(Account,RealName,Password,CreationTime)
VALUES(?,?,?,?)";
var parameters = new OleDbParameter[4];
parameters[0] = new OleDbParameter("@Account", OleDbType.VarChar, 50)
{
Value = user.RealName
};
parameters[1] = new OleDbParameter("@RealName", OleDbType.Integer)
{
Value = user.RealName
};
parameters[2] = new OleDbParameter("@Password", OleDbType.Integer)
{
Value = Encrypt.Md5By32(user.Password)
};
parameters[3] = new OleDbParameter("@CreationTime", OleDbType.Date)
{
Value = DateTime.Now
};
return(AccessDbUtil.ExecuteInsert(sql, parameters) == 1);
}
/// <summary>
/// 新增学生信息
/// </summary>
/// <param name="student"></param>
/// <returns></returns>
private static bool InsertStudent(Student student)
{
var sql =
@"INSERT INTO Student (RealName,Age,Sex,Class,Grade,ParentsName,ContantNumber,DanceGradeId) VALUES(?,?,?,?,?,?,?,?)";
var parameters = new OleDbParameter[8];
parameters[0] = new OleDbParameter("@RealName", OleDbType.VarChar, 50)
{
Value = student.RealName.Trim()
};
parameters[1] = new OleDbParameter("@Age", OleDbType.Integer)
{
Value = student.Age
};
parameters[2] = new OleDbParameter("@Sex", OleDbType.Integer)
{
Value = student.Sex.Value()
};
parameters[3] = new OleDbParameter("@Class", OleDbType.VarChar, 25)
{
Value = student.Class.Trim()
};
parameters[4] = new OleDbParameter("@Grade", OleDbType.VarChar, 50)
{
Value = student.Grade.Trim()
};
parameters[5] = new OleDbParameter("@ParentsName", OleDbType.VarChar, 50)
{
Value = student.ParentsName.Trim()
};
parameters[6] = new OleDbParameter("@ContantNumber", OleDbType.VarChar, 150)
{
Value = student.ContantNumber.Trim()
};
parameters[7] = new OleDbParameter("@DanceGradeId", OleDbType.Integer)
{
Value = student.DanceGradeId
};
return(AccessDbUtil.ExecuteInsert(sql, parameters) == 1);
}
