public int Insert(WorkTaskTableRow row) { #region sql const string sql = @" insert into worktasks ( title , taskcategory , productid , clientId , processId , tasksource ) values ( @title , @taskcategory , @productId , @clientId , @processId , @tasksource ) "; #endregion Connection.Execute(sql, row, Transaction); return((int)Connection.LastInsertRowId); }
public void Update(WorkTaskTableRow row) { #region SQL const string sql = @" update worktasks set title = @title , taskcategory = @taskcategory , productId = @productId , clientId = @clientId , processId = @processId where id = @id "; #endregion Connection.Execute(sql, row, Transaction); }
public int Insert(WorkTaskTableRow row) { #region sql const string sql = @" insert into worktasks ( title , taskcategory , productid , clientId , processId , remarks , planedStartDateTime , planedEndDateTime , actualStartDateTime , actualEndDateTime , source , importkey , istemporary ) values ( @title , @taskcategory , @productId , @clientId , @processId , @remarks , @planedStartDateTime , @planedEndDateTime , @actualStartDateTime , @actualEndDateTime , @source , @importkey , @istemporary ) "; #endregion Connection.Execute(sql, row, Transaction); return((int)Connection.LastInsertRowId); }
public void Update(WorkTaskTableRow row) { #region SQL const string sql = @" update worktasks set title = @title , taskcategory = @taskcategory , productId = @productId , clientId = @clientId , processId = @processId , remarks = @remarks , planedStartDateTime = @planedStartDateTime , planedEndDateTime = @planedEndDateTime , actualStartDateTime = @actualStartDateTime , actualEndDateTime = @actualEndDateTime where id = @id "; #endregion Connection.Execute(sql, row, Transaction); }