public static bool Update(Works work)
{
SqlCommand cmd =
new SqlCommand(
"Update Works SET WorkName=@WorkName,Description=@Description,WorkMark=@WorkMark WHERE WorkId=@WorkId", cn)
{
CommandType = CommandType.Text
};
cmd.Parameters.Add("@WorkId", SqlDbType.Int).Value = work.WorkId;
cmd.Parameters.Add("@WorkName", SqlDbType.VarChar).Value = work.WorkName;
cmd.Parameters.Add("@Description", SqlDbType.VarChar).Value = work.Description;
cmd.Parameters.Add("@WorkMark", SqlDbType.VarChar).Value = work.WorkMark;
try
{
cn.Open();
return(cmd.ExecuteNonQuery() > 0);
}
catch (Exception)
{
return(false);
}
finally
{
cmd.Dispose();
cn.Close();
}
}
public static bool InsertWork(Works work)
{
SqlCommand cmd =
new SqlCommand(
"INSERT Works(WorkName,WorkProgress,Description,WorkMark,CompletionTime,CreateDate) VALUES(@WorkName,0,@Description,@WorkMark,'1970-01-01',GETDATE())",
cn)
{
CommandType = CommandType.Text
};
cmd.Parameters.Add("@WorkName", SqlDbType.VarChar).Value = work.WorkName;
cmd.Parameters.Add("@Description", SqlDbType.VarChar).Value = work.Description;
cmd.Parameters.Add("@WorkMark", SqlDbType.VarChar).Value = work.WorkMark;
try
{
cn.Open();
return(cmd.ExecuteNonQuery() > 0);
}
catch (Exception)
{
return(false);
}
finally
{
cmd.Dispose();
cn.Close();
}
}
