📄 dtimeplan.cs
字号:
cmd.Parameters.Add(new SqlParameter("@Saturday_Pm",timePlan.SaturdayPm));
cmd.Parameters.Add(new SqlParameter("@TimePlan_ID", timePlan.TimePlanID));
return cmd.ExecuteNonQuery();
}
/// <summary>
/// 不使用事务的更新方法
/// </summary>
/// <param name="timePlan">实体类对象</param>
/// <returns>影响的记录行数</returns>
public int Update(TimePlan timePlan)
{
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, timePlan);
}
}
return result;
}
/// <summary>
/// 使用事务的更新方法
/// </summary>
/// <param name="connection">实现共享Command的对象</param>
/// <param name="timePlan">实体类对象</param>
/// <returns>影响的记录行数</returns>
public int Update(IConnection connection,TimePlan timePlan)
{
int result = 0;
SqlCommand cmd=connection.Command as SqlCommand;
result = ExcuteUpdateCommand(cmd, timePlan);
return result;
}
/// <summary>
/// 根据查询对象构建过滤条件并不使用事务的更新方法
/// </summary>
/// <param name="searcher">查询对象</param>
/// <param name="newValues">要更新的新值</param>
/// <returns>影响的记录行数</returns>
public int Update(TimePlanSearcher searcher,TimePlanSearcher 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.TimePlanIDIsValid)
{
updateString += ",TimePlan_ID=@TimePlan_ID_V";
cmd.Parameters.Add(new SqlParameter("@TimePlan_ID_V",newValues.TimePlanID));
}
if(newValues.TimePlanNameIsValid)
{
updateString += ",TimePlan_Name=@TimePlan_Name_V";
cmd.Parameters.Add(new SqlParameter("@TimePlan_Name_V",newValues.TimePlanName));
}
if(newValues.SundayAmIsValid)
{
updateString += ",Sunday_Am=@Sunday_Am_V";
cmd.Parameters.Add(new SqlParameter("@Sunday_Am_V",newValues.SundayAm));
}
if(newValues.SundayPmIsValid)
{
updateString += ",Sunday_Pm=@Sunday_Pm_V";
cmd.Parameters.Add(new SqlParameter("@Sunday_Pm_V",newValues.SundayPm));
}
if(newValues.MondayAmIsValid)
{
updateString += ",Monday_Am=@Monday_Am_V";
cmd.Parameters.Add(new SqlParameter("@Monday_Am_V",newValues.MondayAm));
}
if(newValues.MondayPmIsValid)
{
updateString += ",Monday_Pm=@Monday_Pm_V";
cmd.Parameters.Add(new SqlParameter("@Monday_Pm_V",newValues.MondayPm));
}
if(newValues.TuesdayAmIsValid)
{
updateString += ",Tuesday_Am=@Tuesday_Am_V";
cmd.Parameters.Add(new SqlParameter("@Tuesday_Am_V",newValues.TuesdayAm));
}
if(newValues.TuesdayPmIsValid)
{
updateString += ",Tuesday_Pm=@Tuesday_Pm_V";
cmd.Parameters.Add(new SqlParameter("@Tuesday_Pm_V",newValues.TuesdayPm));
}
if(newValues.WednesdayAmIsValid)
{
updateString += ",Wednesday_Am=@Wednesday_Am_V";
cmd.Parameters.Add(new SqlParameter("@Wednesday_Am_V",newValues.WednesdayAm));
}
if(newValues.WednesdayPmIsValid)
{
updateString += ",Wednesday_Pm=@Wednesday_Pm_V";
cmd.Parameters.Add(new SqlParameter("@Wednesday_Pm_V",newValues.WednesdayPm));
}
if(newValues.ThursdayAmIsValid)
{
updateString += ",Thursday_Am=@Thursday_Am_V";
cmd.Parameters.Add(new SqlParameter("@Thursday_Am_V",newValues.ThursdayAm));
}
if(newValues.ThursdayPmIsValid)
{
updateString += ",Thursday_Pm=@Thursday_Pm_V";
cmd.Parameters.Add(new SqlParameter("@Thursday_Pm_V",newValues.ThursdayPm));
}
if(newValues.FridayAmIsValid)
{
updateString += ",Friday_Am=@Friday_Am_V";
cmd.Parameters.Add(new SqlParameter("@Friday_Am_V",newValues.FridayAm));
}
if(newValues.FridayPmIsValid)
{
updateString += ",Friday_Pm=@Friday_Pm_V";
cmd.Parameters.Add(new SqlParameter("@Friday_Pm_V",newValues.FridayPm));
}
if(newValues.SaturdayAmIsValid)
{
updateString += ",Saturday_Am=@Saturday_Am_V";
cmd.Parameters.Add(new SqlParameter("@Saturday_Am_V",newValues.SaturdayAm));
}
if(newValues.SaturdayPmIsValid)
{
updateString += ",Saturday_Pm=@Saturday_Pm_V";
cmd.Parameters.Add(new SqlParameter("@Saturday_Pm_V",newValues.SaturdayPm));
}
if(searcher.TimePlanIDIsValid)
{
condition += " and TimePlan_ID=@TimePlan_ID_C";
cmd.Parameters.Add(new SqlParameter("@TimePlan_ID_C",searcher.TimePlanID));
}
if(searcher.TimePlanNameIsValid)
{
condition += " and TimePlan_Name=@TimePlan_Name_C";
cmd.Parameters.Add(new SqlParameter("@TimePlan_Name_C",searcher.TimePlanName));
}
if(searcher.SundayAmIsValid)
{
condition += " and Sunday_Am=@Sunday_Am_C";
cmd.Parameters.Add(new SqlParameter("@Sunday_Am_C",searcher.SundayAm));
}
if(searcher.SundayPmIsValid)
{
condition += " and Sunday_Pm=@Sunday_Pm_C";
cmd.Parameters.Add(new SqlParameter("@Sunday_Pm_C",searcher.SundayPm));
}
if(searcher.MondayAmIsValid)
{
condition += " and Monday_Am=@Monday_Am_C";
cmd.Parameters.Add(new SqlParameter("@Monday_Am_C",searcher.MondayAm));
}
if(searcher.MondayPmIsValid)
{
condition += " and Monday_Pm=@Monday_Pm_C";
cmd.Parameters.Add(new SqlParameter("@Monday_Pm_C",searcher.MondayPm));
}
if(searcher.TuesdayAmIsValid)
{
condition += " and Tuesday_Am=@Tuesday_Am_C";
cmd.Parameters.Add(new SqlParameter("@Tuesday_Am_C",searcher.TuesdayAm));
}
if(searcher.TuesdayPmIsValid)
{
condition += " and Tuesday_Pm=@Tuesday_Pm_C";
cmd.Parameters.Add(new SqlParameter("@Tuesday_Pm_C",searcher.TuesdayPm));
}
if(searcher.WednesdayAmIsValid)
{
condition += " and Wednesday_Am=@Wednesday_Am_C";
cmd.Parameters.Add(new SqlParameter("@Wednesday_Am_C",searcher.WednesdayAm));
}
if(searcher.WednesdayPmIsValid)
{
condition += " and Wednesday_Pm=@Wednesday_Pm_C";
cmd.Parameters.Add(new SqlParameter("@Wednesday_Pm_C",searcher.WednesdayPm));
}
if(searcher.ThursdayAmIsValid)
{
condition += " and Thursday_Am=@Thursday_Am_C";
cmd.Parameters.Add(new SqlParameter("@Thursday_Am_C",searcher.ThursdayAm));
}
if(searcher.ThursdayPmIsValid)
{
condition += " and Thursday_Pm=@Thursday_Pm_C";
cmd.Parameters.Add(new SqlParameter("@Thursday_Pm_C",searcher.ThursdayPm));
}
if(searcher.FridayAmIsValid)
{
condition += " and Friday_Am=@Friday_Am_C";
cmd.Parameters.Add(new SqlParameter("@Friday_Am_C",searcher.FridayAm));
}
if(searcher.FridayPmIsValid)
{
condition += " and Friday_Pm=@Friday_Pm_C";
cmd.Parameters.Add(new SqlParameter("@Friday_Pm_C",searcher.FridayPm));
}
if(searcher.SaturdayAmIsValid)
{
condition += " and Saturday_Am=@Saturday_Am_C";
cmd.Parameters.Add(new SqlParameter("@Saturday_Am_C",searcher.SaturdayAm));
}
if(searcher.SaturdayPmIsValid)
{
condition += " and Saturday_Pm=@Saturday_Pm_C";
cmd.Parameters.Add(new SqlParameter("@Saturday_Pm_C",searcher.SaturdayPm));
}
if(condition != string.Empty)
{
condition=" where"+condition.Substring(4);
}
cmd.CommandText="update TimePlan 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,TimePlanSearcher searcher,TimePlanSearcher newValues)
{
string updateString = string.Empty;
string condition = string.Empty;
SqlCommand cmd=connection.Command as SqlCommand;
cmd.Parameters.Clear();
if(newValues.TimePlanIDIsValid)
{
updateString += ",TimePlan_ID=@TimePlan_ID_V";
cmd.Parameters.Add(new SqlParameter("@TimePlan_ID_V",newValues.TimePlanID));
}
if(newValues.TimePlanNameIsValid)
{
updateString += ",TimePlan_Name=@TimePlan_Name_V";
cmd.Parameters.Add(new SqlParameter("@TimePlan_Name_V",newValues.TimePlanName));
}
if(newValues.SundayAmIsValid)
{
updateString += ",Sunday_Am=@Sunday_Am_V";
cmd.Parameters.Add(new SqlParameter("@Sunday_Am_V",newValues.SundayAm));
}
if(newValues.SundayPmIsValid)
{
updateString += ",Sunday_Pm=@Sunday_Pm_V";
cmd.Parameters.Add(new SqlParameter("@Sunday_Pm_V",newValues.SundayPm));
}
if(newValues.MondayAmIsValid)
{
updateString += ",Monday_Am=@Monday_Am_V";
cmd.Parameters.Add(new SqlParameter("@Monday_Am_V",newValues.MondayAm));
}
if(newValues.MondayPmIsValid)
{
updateString += ",Monday_Pm=@Monday_Pm_V";
cmd.Parameters.Add(new SqlParameter("@Monday_Pm_V",newValues.MondayPm));
}
if(newValues.TuesdayAmIsValid)
{
updateString += ",Tuesday_Am=@Tuesday_Am_V";
cmd.Parameters.Add(new SqlParameter("@Tuesday_Am_V",newValues.TuesdayAm));
}
if(newValues.TuesdayPmIsValid)
{
updateString += ",Tuesday_Pm=@Tuesday_Pm_V";
cmd.Parameters.Add(new SqlParameter("@Tuesday_Pm_V",newValues.TuesdayPm));
}
if(newValues.WednesdayAmIsValid)
{
updateString += ",Wednesday_Am=@Wednesday_Am_V";
cmd.Parameters.Add(new SqlParameter("@Wednesday_Am_V",newValues.WednesdayAm));
}
if(newValues.WednesdayPmIsValid)
{
updateString += ",Wednesday_Pm=@Wednesday_Pm_V";
cmd.Parameters.Add(new SqlParameter("@Wednesday_Pm_V",newValues.WednesdayPm));
}
if(newValues.ThursdayAmIsValid)
{
updateString += ",Thursday_Am=@Thursday_Am_V";
cmd.Parameters.Add(new SqlParameter("@Thursday_Am_V",newValues.ThursdayAm));
}
if(newValues.ThursdayPmIsValid)
{
updateString += ",Thursday_Pm=@Thursday_Pm_V";
cmd.Parameters.Add(new SqlParameter("@Thursday_Pm_V",newValues.ThursdayPm));
}
if(newValues.FridayAmIsValid)
{
updateString += ",Friday_Am=@Friday_Am_V";
cmd.Parameters.Add(new SqlParameter("@Friday_Am_V",newValues.FridayAm));
}
if(newValues.FridayPmIsValid)
{
updateString += ",Friday_Pm=@Friday_Pm_V";
cmd.Parameters.Add(new SqlParameter("@Friday_Pm_V",newValues.FridayPm));
}
if(newValues.SaturdayAmIsValid)
{
updateString += ",Saturday_Am=@Saturday_Am_V";
cmd.Parameters.Add(new SqlParameter("@Saturday_Am_V",newValues.SaturdayAm));
}
if(newValues.SaturdayPmIsValid)
{
updateString += ",Saturday_Pm=@Saturday_Pm_V";
cmd.Parameters.Add(new SqlParameter("@Saturday_Pm_V",newValues.SaturdayPm));
}
if(searcher.TimePlanIDIsValid)
{
condition += " and TimePlan_ID=@TimePlan_ID_C";
cmd.Parameters.Add(new SqlParameter("@TimePlan_ID_C",searcher.TimePlanID));
}
if(searcher.TimePlanNameIsValid)
{
condition += " and TimePlan_Name=@TimePlan_Name_C";
cmd.Parameters.Add(new SqlParameter("@TimePlan_Name_C",searcher.TimePlanName));
}
if(searcher.SundayAmIsValid)
{
condition += " and Sunday_Am=@Sunday_Am_C";
cmd.Parameters.Add(new SqlParameter("@Sunday_Am_C",searcher.SundayAm));
}
if(searcher.SundayPmIsValid)
{
condition += " and Sunday_Pm=@Sunday_Pm_C";
cmd.Parameters.Add(new SqlParameter("@Sunday_Pm_C",searcher.SundayPm));
}
if(searcher.MondayAmIsValid)
{
condition += " and Monday_Am=@Monday_Am_C";
cmd.Parameters.Add(new SqlParameter("@Monday_Am_C",searcher.MondayAm));
}
if(searcher.MondayPmIsValid)
{
condition += " and Monday_Pm=@Monday_Pm_C";
cmd.Parameters.Add(new SqlParameter("@Monday_Pm_C",searcher.MondayPm));
}
if(searcher.TuesdayAmIsValid)
{
condition += " and Tuesday_Am=@Tuesday_Am_C";
cmd.Parameters.Add(new SqlParameter("@Tuesday_Am_C",searcher.TuesdayAm));
}
if(searcher.TuesdayPmIsValid)
{
condition += " and Tuesday_Pm=@Tuesday_Pm_C";
cmd.Parameters.Add(new SqlParameter("@Tuesday_Pm_C",searcher.TuesdayPm));
}
if(searcher.WednesdayAmIsValid)
{
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -