public int UpdateAll(examtotalcount_withoutTable entity, string updateFields = null)
{
if (updateFields == null)
{
updateFields = "[exam_id]=@exam_id,[grade_class]=@grade_class,[exam_subject]=@exam_subject,[exam_avg]=@exam_avg,[exam_stdevp]=@exam_stdevp,[exam_max]=@exam_max,[exam_allpassnum]=@exam_allpassnum,[exam_onepassnum]=@exam_onepassnum,[exam_twopassnum]=@exam_twopassnum,[exam_threepassnum]=@exam_threepassnum,[exam_greatnum]=@exam_greatnum,[exam_passnum]=@exam_passnum,[exam_allrank]=@exam_allrank,[exam_onerank]=@exam_onerank,[exam_tworank]=@exam_tworank,[exam_threerank]=@exam_threerank";
}
else
{
updateFields = StringHelper.SqlUpdateFields(updateFields);
}
string sql = "UPDATE [examtotalcount_without] SET " + updateFields;
return(SqlDapperHelper.Execute(sql, entity));
}
public int UpdateFieldsByWhere(examtotalcount_withoutTable entity, string whereFields, string updateFields = null)
{
if (updateFields == null)
{
updateFields = "[exam_id]=@exam_id,[grade_class]=@grade_class,[exam_subject]=@exam_subject,[exam_avg]=@exam_avg,[exam_stdevp]=@exam_stdevp,[exam_max]=@exam_max,[exam_allpassnum]=@exam_allpassnum,[exam_onepassnum]=@exam_onepassnum,[exam_twopassnum]=@exam_twopassnum,[exam_threepassnum]=@exam_threepassnum,[exam_greatnum]=@exam_greatnum,[exam_passnum]=@exam_passnum,[exam_allrank]=@exam_allrank,[exam_onerank]=@exam_onerank,[exam_tworank]=@exam_tworank,[exam_threerank]=@exam_threerank";
}
else
{
updateFields = StringHelper.SqlUpdateFields(updateFields);
}
string where = "WHERE " + StringHelper.SqlWhereFields(whereFields);
string sql = string.Format("UPDATE [examtotalcount_without] SET {0} " + where, updateFields);
return(SqlDapperHelper.Execute(sql, entity));
}
public int InsertIdentity(examtotalcount_withoutTable entity)
{
string sql = "SET IDENTITY_INSERT [examtotalcount_without] ON;INSERT INTO [examtotalcount_without] ([id],[exam_id],[grade_class],[exam_subject],[exam_avg],[exam_stdevp],[exam_max],[exam_allpassnum],[exam_onepassnum],[exam_twopassnum],[exam_threepassnum],[exam_greatnum],[exam_passnum],[exam_allrank],[exam_onerank],[exam_tworank],[exam_threerank]) VALUES (@id,@exam_id,@grade_class,@exam_subject,@exam_avg,@exam_stdevp,@exam_max,@exam_allpassnum,@exam_onepassnum,@exam_twopassnum,@exam_threepassnum,@exam_greatnum,@exam_passnum,@exam_allrank,@exam_onerank,@exam_tworank,@exam_threerank);SET IDENTITY_INSERT [examtotalcount_without] OFF";
return(SqlDapperHelper.Execute(sql, entity));
}
public long Insert(examtotalcount_withoutTable entity)
{
string sql = "INSERT INTO [examtotalcount_without] ([exam_id],[grade_class],[exam_subject],[exam_avg],[exam_stdevp],[exam_max],[exam_allpassnum],[exam_onepassnum],[exam_twopassnum],[exam_threepassnum],[exam_greatnum],[exam_passnum],[exam_allrank],[exam_onerank],[exam_tworank],[exam_threerank]) VALUES (@exam_id,@grade_class,@exam_subject,@exam_avg,@exam_stdevp,@exam_max,@exam_allpassnum,@exam_onepassnum,@exam_twopassnum,@exam_threepassnum,@exam_greatnum,@exam_passnum,@exam_allrank,@exam_onerank,@exam_tworank,@exam_threerank);SELECT @@IDENTITY";
return(SqlDapperHelper.ExecuteScalar <long>(sql, entity));
}
