📄 dclasstempcourse.cs
字号:
cmd.CommandText = "update ClassTempCourse set Class_ID=@Class_ID,TempCourse_ID=@TempCourse_ID,TempCourse_Date=@TempCourse_Date,IsAm=@IsAm,Lesson_Hour=@Lesson_Hour,Is_Front=@Is_Front,Teacher_ID=@Teacher_ID where Class_TempCourse_ID=@Class_TempCourse_ID";
//从实体中取出值放入Command的参数列表
cmd.Parameters.Add(new SqlParameter("@Class_ID",classTempCourse.ClassID));
cmd.Parameters.Add(new SqlParameter("@TempCourse_ID",classTempCourse.TempCourseID));
cmd.Parameters.Add(new SqlParameter("@TempCourse_Date",classTempCourse.TempCourseDate));
cmd.Parameters.Add(new SqlParameter("@IsAm",classTempCourse.IsAm));
cmd.Parameters.Add(new SqlParameter("@Lesson_Hour",classTempCourse.LessonHour));
cmd.Parameters.Add(new SqlParameter("@Is_Front",classTempCourse.IsFront));
cmd.Parameters.Add(new SqlParameter("@Teacher_ID",classTempCourse.TeacherID));
cmd.Parameters.Add(new SqlParameter("@Class_TempCourse_ID", classTempCourse.ClassTempCourseID));
return cmd.ExecuteNonQuery();
}
/// <summary>
/// 不使用事务的更新方法
/// </summary>
/// <param name="classTempCourse">实体类对象</param>
/// <returns>影响的记录行数</returns>
public int Update(ClassTempCourse classTempCourse)
{
int result=0;
string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
using(SqlConnection conn=new SqlConnection(connectionString))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
result=ExcuteUpdateCommand(cmd, classTempCourse);
}
}
return result;
}
/// <summary>
/// 使用事务的更新方法
/// </summary>
/// <param name="connection">实现共享Command的对象</param>
/// <param name="classTempCourse">实体类对象</param>
/// <returns>影响的记录行数</returns>
public int Update(IConnection connection,ClassTempCourse classTempCourse)
{
int result = 0;
SqlCommand cmd=connection.Command as SqlCommand;
result = ExcuteUpdateCommand(cmd, classTempCourse);
return result;
}
/// <summary>
/// 根据查询对象构建过滤条件并不使用事务的更新方法
/// </summary>
/// <param name="searcher">查询对象</param>
/// <param name="newValues">要更新的新值</param>
/// <returns>影响的记录行数</returns>
public int Update(ClassTempCourseSearcher searcher,ClassTempCourseSearcher newValues)
{
int result=0;
string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
using(SqlConnection conn=new SqlConnection(connectionString))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
//string updateString=GetUpdateString(cmd, newValues)+condition;
string updateString = string.Empty;
string condition = string.Empty;
if(newValues.ClassTempCourseIDIsValid)
{
updateString += ",Class_TempCourse_ID=@Class_TempCourse_ID_V";
cmd.Parameters.Add(new SqlParameter("@Class_TempCourse_ID_V",newValues.ClassTempCourseID));
}
if(newValues.ClassIDIsValid)
{
updateString += ",Class_ID=@Class_ID_V";
cmd.Parameters.Add(new SqlParameter("@Class_ID_V",newValues.ClassID));
}
if(newValues.TempCourseIDIsValid)
{
updateString += ",TempCourse_ID=@TempCourse_ID_V";
cmd.Parameters.Add(new SqlParameter("@TempCourse_ID_V",newValues.TempCourseID));
}
if(newValues.TempCourseDateIsValid)
{
updateString += ",TempCourse_Date=@TempCourse_Date_V";
cmd.Parameters.Add(new SqlParameter("@TempCourse_Date_V",newValues.TempCourseDate));
}
if(newValues.IsAmIsValid)
{
updateString += ",IsAm=@IsAm_V";
cmd.Parameters.Add(new SqlParameter("@IsAm_V",newValues.IsAm));
}
if(newValues.LessonHourIsValid)
{
updateString += ",Lesson_Hour=@Lesson_Hour_V";
cmd.Parameters.Add(new SqlParameter("@Lesson_Hour_V",newValues.LessonHour));
}
if(newValues.IsFrontIsValid)
{
updateString += ",Is_Front=@Is_Front_V";
cmd.Parameters.Add(new SqlParameter("@Is_Front_V",newValues.IsFront));
}
if(newValues.TeacherIDIsValid)
{
updateString += ",Teacher_ID=@Teacher_ID_V";
cmd.Parameters.Add(new SqlParameter("@Teacher_ID_V",newValues.TeacherID));
}
if(searcher.ClassTempCourseIDIsValid)
{
condition += " and Class_TempCourse_ID=@Class_TempCourse_ID_C";
cmd.Parameters.Add(new SqlParameter("@Class_TempCourse_ID_C",searcher.ClassTempCourseID));
}
if(searcher.ClassIDIsValid)
{
condition += " and Class_ID=@Class_ID_C";
cmd.Parameters.Add(new SqlParameter("@Class_ID_C",searcher.ClassID));
}
if(searcher.TempCourseIDIsValid)
{
condition += " and TempCourse_ID=@TempCourse_ID_C";
cmd.Parameters.Add(new SqlParameter("@TempCourse_ID_C",searcher.TempCourseID));
}
if(searcher.TempCourseDateIsValid)
{
condition += " and TempCourse_Date=@TempCourse_Date_C";
cmd.Parameters.Add(new SqlParameter("@TempCourse_Date_C",searcher.TempCourseDate));
}
if(searcher.IsAmIsValid)
{
condition += " and IsAm=@IsAm_C";
cmd.Parameters.Add(new SqlParameter("@IsAm_C",searcher.IsAm));
}
if(searcher.LessonHourIsValid)
{
condition += " and Lesson_Hour=@Lesson_Hour_C";
cmd.Parameters.Add(new SqlParameter("@Lesson_Hour_C",searcher.LessonHour));
}
if(searcher.IsFrontIsValid)
{
condition += " and Is_Front=@Is_Front_C";
cmd.Parameters.Add(new SqlParameter("@Is_Front_C",searcher.IsFront));
}
if(searcher.TeacherIDIsValid)
{
condition += " and Teacher_ID=@Teacher_ID_C";
cmd.Parameters.Add(new SqlParameter("@Teacher_ID_C",searcher.TeacherID));
}
if(condition != string.Empty)
{
condition=" where"+condition.Substring(4);
}
cmd.CommandText="update ClassTempCourse set "+updateString.Substring(1)+condition;
result=cmd.ExecuteNonQuery();
}
}
return result;
}
/// <summary>
/// 根据查询对象构建过滤条件并使用事务的更新方法
/// </summary>
/// <param name="connection">实现共享Command的对象</param>
/// <param name="searcher">查询对象</param>
/// <param name="newValues">要更新的新值</param>
/// <returns>影响的记录行数</returns>
public int Update(IConnection connection,ClassTempCourseSearcher searcher,ClassTempCourseSearcher newValues)
{
string updateString = string.Empty;
string condition = string.Empty;
SqlCommand cmd=connection.Command as SqlCommand;
cmd.Parameters.Clear();
if(newValues.ClassTempCourseIDIsValid)
{
updateString += ",Class_TempCourse_ID=@Class_TempCourse_ID_V";
cmd.Parameters.Add(new SqlParameter("@Class_TempCourse_ID_V",newValues.ClassTempCourseID));
}
if(newValues.ClassIDIsValid)
{
updateString += ",Class_ID=@Class_ID_V";
cmd.Parameters.Add(new SqlParameter("@Class_ID_V",newValues.ClassID));
}
if(newValues.TempCourseIDIsValid)
{
updateString += ",TempCourse_ID=@TempCourse_ID_V";
cmd.Parameters.Add(new SqlParameter("@TempCourse_ID_V",newValues.TempCourseID));
}
if(newValues.TempCourseDateIsValid)
{
updateString += ",TempCourse_Date=@TempCourse_Date_V";
cmd.Parameters.Add(new SqlParameter("@TempCourse_Date_V",newValues.TempCourseDate));
}
if(newValues.IsAmIsValid)
{
updateString += ",IsAm=@IsAm_V";
cmd.Parameters.Add(new SqlParameter("@IsAm_V",newValues.IsAm));
}
if(newValues.LessonHourIsValid)
{
updateString += ",Lesson_Hour=@Lesson_Hour_V";
cmd.Parameters.Add(new SqlParameter("@Lesson_Hour_V",newValues.LessonHour));
}
if(newValues.IsFrontIsValid)
{
updateString += ",Is_Front=@Is_Front_V";
cmd.Parameters.Add(new SqlParameter("@Is_Front_V",newValues.IsFront));
}
if(newValues.TeacherIDIsValid)
{
updateString += ",Teacher_ID=@Teacher_ID_V";
cmd.Parameters.Add(new SqlParameter("@Teacher_ID_V",newValues.TeacherID));
}
if(searcher.ClassTempCourseIDIsValid)
{
condition += " and Class_TempCourse_ID=@Class_TempCourse_ID_C";
cmd.Parameters.Add(new SqlParameter("@Class_TempCourse_ID_C",searcher.ClassTempCourseID));
}
if(searcher.ClassIDIsValid)
{
condition += " and Class_ID=@Class_ID_C";
cmd.Parameters.Add(new SqlParameter("@Class_ID_C",searcher.ClassID));
}
if(searcher.TempCourseIDIsValid)
{
condition += " and TempCourse_ID=@TempCourse_ID_C";
cmd.Parameters.Add(new SqlParameter("@TempCourse_ID_C",searcher.TempCourseID));
}
if(searcher.TempCourseDateIsValid)
{
condition += " and TempCourse_Date=@TempCourse_Date_C";
cmd.Parameters.Add(new SqlParameter("@TempCourse_Date_C",searcher.TempCourseDate));
}
if(searcher.IsAmIsValid)
{
condition += " and IsAm=@IsAm_C";
cmd.Parameters.Add(new SqlParameter("@IsAm_C",searcher.IsAm));
}
if(searcher.LessonHourIsValid)
{
condition += " and Lesson_Hour=@Lesson_Hour_C";
cmd.Parameters.Add(new SqlParameter("@Lesson_Hour_C",searcher.LessonHour));
}
if(searcher.IsFrontIsValid)
{
condition += " and Is_Front=@Is_Front_C";
cmd.Parameters.Add(new SqlParameter("@Is_Front_C",searcher.IsFront));
}
if(searcher.TeacherIDIsValid)
{
condition += " and Teacher_ID=@Teacher_ID_C";
cmd.Parameters.Add(new SqlParameter("@Teacher_ID_C",searcher.TeacherID));
}
if(condition != string.Empty)
{
condition=" where"+condition.Substring(4);
}
cmd.CommandText="update ClassTempCourse set "+updateString.Substring(1)+condition;
return cmd.ExecuteNonQuery();
}
#endregion
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -