/// <summary>
/// 獲得當前規則最大的ct碼
/// </summary>
/// <param name="ctCode"></param>
/// <returns></returns>
public string queryCodeNo(string ctCode)
{
string maxCtCode = "";
StringBuilder strSql = new StringBuilder();
strSql.Append("select MAX(ct_code) from t_code_info where ct_code like @ctCode");
MySqlParameter[] parameters =
{
new MySqlParameter("@ctCode", MySqlDbType.VarChar, 900)
};
parameters[0].Value = "%" + ctCode + "%";;
Object maxCode = SQLHelper.ExecuteScalar(SQLHelper.ConnectionString, CommandType.Text, strSql.ToString(), parameters);
if (maxCode != null && maxCode != DBNull.Value)
{
maxCtCode = maxCode.ToString();
}
return(maxCtCode);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int AddTran(Model.tbAnswerOfPaper model, SqlTransaction transaction)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tbAnswerOfPaper(");
strSql.Append("arrangeid,answerid,userid,useranswer,getscore,allscore");
strSql.Append(") values (");
strSql.Append("@arrangeid,@answerid,@userid,@useranswer,@getscore,@allscore");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@arrangeid", SqlDbType.Int, 4),
new SqlParameter("@answerid", SqlDbType.Int, 4),
new SqlParameter("@userid", SqlDbType.Int, 4),
new SqlParameter("@useranswer", SqlDbType.NVarChar, 2000),
new SqlParameter("@getscore", SqlDbType.Float, 8),
new SqlParameter("@allscore", SqlDbType.Float, 8)
};
parameters[0].Value = model.arrangeid;
parameters[1].Value = model.answerid;
parameters[2].Value = model.userid;
parameters[3].Value = model.useranswer;
parameters[4].Value = model.getscore;
parameters[5].Value = model.allscore;
object obj = SQLHelper.ExecuteScalar(transaction, CommandType.Text, strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
Util.MyUtil.PrintSql(strSql.ToString());
}
