public List <TiKuResultModel> GetList(string StudentsName, string TrainingBaseCode, string SubjectCode)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 10 * from GP_TiKuResult ");
strSql.Append(" where StudentsName=@StudentsName and TrainingBaseCode like @TrainingBaseCode and SubjectCode=@SubjectCode order by RegisterDate desc");
SqlParameter[] parameters =
{
new SqlParameter("@StudentsName", SqlDbType.NVarChar, 50),
new SqlParameter("@TrainingBaseCode", SqlDbType.NVarChar, 50),
new SqlParameter("@SubjectCode", SqlDbType.NVarChar, 50)
};
parameters[0].Value = StudentsName;
parameters[1].Value = '%' + TrainingBaseCode + '%';
parameters[2].Value = SubjectCode;
DataTable dt = db.RunDataTable(strSql.ToString(), parameters);
List <TiKuResultModel> list = null;
if (dt.Rows.Count > 0)
{
list = new List <TiKuResultModel>();
TiKuResultModel model = null;
foreach (DataRow row in dt.Rows)
{
model = new TiKuResultModel();
model = DataRowToModel(row);
list.Add(model);
}
}
return(list);
}
public bool Add(TiKuResultModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into GP_TiKuResult(");
strSql.Append("Id,StudentsName,StudentsRealName,TrainingBaseCode,TrainingBaseName,SubjectName,SubjectCode,TotalScore,TotalNum,UndoNum,CorrectNum,ErrorNum,RegisterDate,Tag1,Tag2,Tag3)");
strSql.Append(" values (");
strSql.Append("@Id,@StudentsName,@StudentsRealName,@TrainingBaseCode,@TrainingBaseName,@SubjectName,@SubjectCode,@TotalScore,@TotalNum,@UndoNum,@CorrectNum,@ErrorNum,@RegisterDate,@Tag1,@Tag2,@Tag3)");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.NVarChar, 50),
new SqlParameter("@StudentsName", SqlDbType.NVarChar, 50),
new SqlParameter("@StudentsRealName", SqlDbType.NVarChar, 50),
new SqlParameter("@TrainingBaseCode", SqlDbType.NVarChar, 50),
new SqlParameter("@TrainingBaseName", SqlDbType.NVarChar, 50),
new SqlParameter("@SubjectName", SqlDbType.NVarChar, 50),
new SqlParameter("@SubjectCode", SqlDbType.NVarChar, 50),
new SqlParameter("@TotalScore", SqlDbType.NVarChar, 50),
new SqlParameter("@TotalNum", SqlDbType.NVarChar, 50),
new SqlParameter("@UndoNum", SqlDbType.NVarChar, 50),
new SqlParameter("@CorrectNum", SqlDbType.NVarChar, 50),
new SqlParameter("@ErrorNum", SqlDbType.NVarChar, 50),
new SqlParameter("@RegisterDate", SqlDbType.NVarChar, 50),
new SqlParameter("@Tag1", SqlDbType.NVarChar, 50),
new SqlParameter("@Tag2", SqlDbType.NVarChar, 50),
new SqlParameter("@Tag3", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.Id;
parameters[1].Value = model.StudentsName;
parameters[2].Value = model.StudentsRealName;
parameters[3].Value = model.TrainingBaseCode;
parameters[4].Value = model.TrainingBaseName;
parameters[5].Value = model.SubjectName;
parameters[6].Value = model.SubjectCode;
parameters[7].Value = model.TotalScore;
parameters[8].Value = model.TotalNum;
parameters[9].Value = model.UndoNum;
parameters[10].Value = model.CorrectNum;
parameters[11].Value = model.ErrorNum;
parameters[12].Value = model.RegisterDate;
parameters[13].Value = model.Tag1;
parameters[14].Value = model.Tag2;
parameters[15].Value = model.Tag3;
int rows = db.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public TiKuResultModel DataRowToModel(DataRow row)
{
TiKuResultModel model = new TiKuResultModel();
if (row != null)
{
if (row["Id"] != null)
{
model.Id = row["Id"].ToString();
}
if (row["StudentsName"] != null)
{
model.StudentsName = row["StudentsName"].ToString();
}
if (row["StudentsRealName"] != null)
{
model.StudentsRealName = row["StudentsRealName"].ToString();
}
if (row["TrainingBaseCode"] != null)
{
model.TrainingBaseCode = row["TrainingBaseCode"].ToString();
}
if (row["TrainingBaseName"] != null)
{
model.TrainingBaseName = row["TrainingBaseName"].ToString();
}
if (row["SubjectName"] != null)
{
model.SubjectName = row["SubjectName"].ToString();
}
if (row["SubjectCode"] != null)
{
model.SubjectCode = row["SubjectCode"].ToString();
}
if (row["TotalScore"] != null)
{
model.TotalScore = row["TotalScore"].ToString();
}
if (row["TotalNum"] != null)
{
model.TotalNum = row["TotalNum"].ToString();
}
if (row["UndoNum"] != null)
{
model.UndoNum = row["UndoNum"].ToString();
}
if (row["CorrectNum"] != null)
{
model.CorrectNum = row["CorrectNum"].ToString();
}
if (row["ErrorNum"] != null)
{
model.ErrorNum = row["ErrorNum"].ToString();
}
if (row["RegisterDate"] != null)
{
model.RegisterDate = row["RegisterDate"].ToString();
}
if (row["Tag1"] != null)
{
model.Tag1 = row["Tag1"].ToString();
}
if (row["Tag2"] != null)
{
model.Tag2 = row["Tag2"].ToString();
}
if (row["Tag3"] != null)
{
model.Tag3 = row["Tag3"].ToString();
}
}
return(model);
}
public bool Add(TiKuResultModel model)
{
return(dal.Add(model));
}
