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(); } }