62,047
社区成员
发帖
与我相关
我的任务
分享
using (SqlConnection cn = db.conn())
{
SqlCommand cmd = cn.CreateCommand();
cmd.CommandText = @"INSERT INTO jc_WrongPaper ([userName],[libraryID],[mainPID],[lowerPID],[userAnswer])
VALUES
(@userName,@libraryID,@mainPID,@lowerPID,@userAnswer)";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("@userName", wpM.userName));
cmd.Parameters.Add(new SqlParameter("@libraryID",SqlDbType.Int));
cmd.Parameters["@libraryID"].Value = wpM.libraryID;
cmd.Parameters.Add(new SqlParameter("@mainPID", SqlDbType.Int));
cmd.Parameters["@mainPID"].Value = wpM.mainPID;
if (wpM.lowerPID != 0)//请注意这里
{
cmd.Parameters.Add(new SqlParameter("@lowerPID", SqlDbType.Int));
cmd.Parameters["@lowerPID"].Value = wpM.lowerPID;
}
cmd.Parameters.Add(new SqlParameter("@userAnswer", wpM.userAnswer));
cn.Open();
cmd.ExecuteNonQuery();
}
using (SqlConnection cn = db.conn())
{
SqlCommand cmd = cn.CreateCommand();
cmd.CommandText = @"INSERT INTO jc_WrongPaper ([userName],[libraryID],[mainPID],[lowerPID],[userAnswer])
VALUES
(@userName,@libraryID,@mainPID,@lowerPID,@userAnswer)";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("@userName", wpM.userName));
cmd.Parameters.Add(new SqlParameter("@libraryID",SqlDbType.Int));
cmd.Parameters["@libraryID"].Value = wpM.libraryID;
cmd.Parameters.Add(new SqlParameter("@mainPID", SqlDbType.Int));
cmd.Parameters["@mainPID"].Value = wpM.mainPID;
if (wpM.lowerPID != 0)//请注意这里
{
cmd.Parameters.Add(new SqlParameter("@lowerPID", SqlDbType.Int));
cmd.Parameters["@lowerPID"].Value = wpM.lowerPID;
}
else
{
cmd.Parameters.Add(new SqlParameter("@lowerPID", DBNull.Value));
}
cmd.Parameters.Add(new SqlParameter("@userAnswer", wpM.userAnswer));
cn.Open();
cmd.ExecuteNonQuery();
}
if (wpM.lowerPID == 0)
{
cmd.Parameters.Add(new SqlParameter("@lowerPID", DBNull.Value));
}
else
{
cmd.Parameters.Add(new SqlParameter("@lowerPID", SqlDbType.Int));
cmd.Parameters["@lowerPID"].Value = Int32.Parse(wpM.lowerPID);
}
using (SqlConnection cn = db.conn())
{
SqlCommand cmd = cn.CreateCommand();
cmd.CommandText = @"INSERT INTO jc_WrongPaper ([userName],[libraryID],[mainPID],[lowerPID],[userAnswer])
VALUES
(@userName,@libraryID,@mainPID,@lowerPID,@userAnswer)";
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("@userName", wpM.userName));
cmd.Parameters.Add(new SqlParameter("@libraryID",SqlDbType.Int));
cmd.Parameters["@libraryID"].Value = wpM.libraryID;
cmd.Parameters.Add(new SqlParameter("@mainPID", SqlDbType.Int));
cmd.Parameters["@mainPID"].Value = wpM.mainPID;
if (wpM.lowerPID != 0)//请注意这里 按照你的意思你这个东西是0的时候就不走这里啊
{ //但是你Sql语句中又有这个变量 不是很变态么 也就是说你的这个值不
//是0的时候就不报错吧?
cmd.Parameters.Add(new SqlParameter("@lowerPID", SqlDbType.Int));
cmd.Parameters["@lowerPID"].Value = wpM.lowerPID;
}
cmd.Parameters.Add(new SqlParameter("@userAnswer", wpM.userAnswer));
cn.Open();
cmd.ExecuteNonQuery();
}
if (wpM.lowerPID != 0)//请注意这里
{
cmd.Parameters.Add(new SqlParameter("@lowerPID", SqlDbType.Int));
cmd.Parameters["@lowerPID"].Value = wpM.lowerPID;
}
cmd.Parameters.Add(new SqlParameter("@lowerPID", SqlDbType.Int));
cmd.Parameters["@lowerPID"].Value = wpM.lowerPID==0 ? DBNull.Value : wpM.lowerPID;