/// <summary>
/// 修改工作量信息
/// </summary>
/// <param name="workload"></param>
/// <returns></returns>
public static bool ModifyWorkload(ContractRegularload regularload)
{
MySqlConnection con = DBTools.GetMySqlConnection();
MySqlCommand cmd;
int count = -1;
try
{
con.Open();
cmd = con.CreateCommand();
cmd.CommandText = MODIFY_WORKLOAD_STR;
cmd.Parameters.AddWithValue("@Id", regularload.Id);
cmd.Parameters.AddWithValue("@Work", regularload.Work);
cmd.Parameters.AddWithValue("@Expense", regularload.Expense);
count = cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
con.Dispose();
if (count == 1)
{
Console.WriteLine("删除计划任务工作量{0}成功", regularload.Id);
return(true);
}
else
{
Console.WriteLine("删除计划任务工作量{0}失败", regularload.Id);
return(false);
}
}
catch (Exception)
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
public static bool InsertRegularload(ContractRegularload regularload)
{
MySqlConnection con = DBTools.GetMySqlConnection();
MySqlCommand cmd;
int count = -1; // 受影响行数
try
{
con.Open();
cmd = con.CreateCommand();
cmd.CommandText = INSERT_REGULARLOAD_STR;
cmd.Parameters.AddWithValue("@Id", regularload.Id); // 当前工作量所属的会签单信息
cmd.Parameters.AddWithValue("@ItemId", regularload.ItemId); // 当前工作量的工作量信息
cmd.Parameters.AddWithValue("@Year", regularload.Year);
cmd.Parameters.AddWithValue("@Work", regularload.Work); // 当前工作量的工作量大小
cmd.Parameters.AddWithValue("@Expense", regularload.Expense); // 当前工作量的报价
count = cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
con.Dispose();
if (count == 1) // 插入成功后的受影响行数为1
{
Console.WriteLine("计划任务工作量{0}信息插入成功", regularload.Id);
return(true);
}
else
{
Console.WriteLine("计划任务工作量{0}插入失败", regularload.Id);
return(false);
}
}
catch (Exception)
{
throw;
}
finally
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
